Purchase Solution

Production under resource constraint

Not what you're looking for?

Ask Custom Question

5. Gloddy Company makes three products in a single facility. These products have the following unit product costs:

Products
A B C
Direct material $24.90 $25.70 $26.60
Direct labor (variable) $13.30 $17.10 $15.70
Variable manufacturing overhead $2.50 $2.80 $3.10
Fixed manufacturing overhead $19.80 $27.70 $21.00
Unit product cost $60.50 $73.30 $66.40
Additional data concerning these products are listed below:
Mixing minutes per unit 2.50 1.70 1.60
Selling price per unit $71.50 $87.90 $83.00
Variable selling cost per unit $2.30 $1.90 $3.80
Monthly maximum demand in units 1,000 3,000 3,000

The mixing machines are potentially the constraint in the production facility. A total of 10,800
minutes are available per month on these machines. Direct labor is a variable cost in this company.

Required - use linear programing with excel solver to find the solutions as to how many units of each project
can be produced given the constraints in demand for each product and the limited monthly machine minutes.
Save the three reports available in the solver.

a. How many minutes of mixing machine time would be required to satisfy demand for all three products?

b. How much of each product (rounded) should be produced to maximize net operating income?

c. Up to how much should the company be willing to pay for one additional hour of mixing
machine time if the company has made the best use of the existing mixing machine capacity?

Attachments
Purchase this Solution
Solution Summary

The solution explains the use of excel solver to determine production under situation of resource constraint.

Purchase this Solution
Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Introduction to Finance

This quiz test introductory finance topics.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

View More Free Quizzes
Related BrainMass Solutions

  • Operations research and Linear programming

    An order for the next production period has already been placed under a continuing vendor contract to arrive at the end of the current production period. That order will require all but 300 linear feet of available lumber storage space.

  • Production with resource constraint

    of resource constraint.

  • Applications of Linear Programming

    Which resources will be fully used in producing the optimal number of tables and chairs during the initial production cycle? (Note: A given resource is fully consumed only if all of the resource has been used.

  • Formulate objective function, constraint, optimal solution

    277621 Formulate objective function, constraint, optimal solution A firm has two fixed resources that impose limits on its production activities. For a particular period of time it has 30 hours of resource 1 available and 80 hours of resource 2.

  • Constraint for a resource that is binding in optimum

    165753 Constraint for a resource that is binding in optimum Suppose we have a constraint for a resource that is binding in optimum. Find a scenario under which the optimal profit will remain unchanged even if we have more of that resource.

  • Production under resource constraint

    The solution explains how to decide the production mix given a resource constraint.

  • Quantitative method :MCQ

    If the original amount of a resource is 4 lb, and the range of feasibility (sensitivity range) for this constraint is from 3 lb to 6 lb, increasing the amount of this resource by 1 lb will result in the A) same product mix, different total profit.

  • LINEAR PROGRAMMING: COMPUTER SOLUTION AND SENSITIVITY ANALYS

    If the original amount of a resource is 4 lbs., and the range of feasibility (sensitivity range) for this constraint is from 3 lbs. to 6 lbs., increasing the amount of this resource by 1 lb. will result in the: a. same product mix, different

  • Efficient utilization of a scarce resource

    For this reason, management team must maximize the production of women's dresses. This solution discusses the efficient utilization of a scarce resource.

View More Related Solutions