Answered step by step
Verified Expert Solution
Question
1 Approved Answer
DA 4 - 2 Utilization of Constrained Resources Backyard Helpers, Inc. is a small manufacturing company with 1 8 different gardening tools in its product
DA Utilization of Constrained Resources
Backyard Helpers, Inc. is a small manufacturing company with different gardening tools in its product line. All of
the products are fabricated using the same equipment.
Recently, sales demand has increased. Unfortunately, Backyard Helpers cannot produce enough products with
existing equipment to meet that demand. Facilities can be expanded, and new equipment purchased, but it will be at
least two years before that happens. The production manager needs to make production scheduling decisions now.
The data to the right includes assumed information about demand, sales price, cost, and fabrication time on the
shared equipment for each of Backyard Helpers' products.
Maximum machine time is minutes per month. The demand for all products is spread equally throughout the
month. Fixed costs manufacturing selling, and administrative total $ per month. Backyard Helpers
maintains no inventory of finished goods: all units produced are sold during the month.
Required
a Ignore machine time limits in answering the following:
Which product has the highest contribution margin per unit? How many units of that product should be produced
each month?
If Backyard could meet demand, what would be the total net operating income per month?
b If demand was unlimited for all products, which products should Backyard Helpers produce?
c Given the maximum number of machine minutes per month and the expected demand per month, use Solver in
Excel to answer the four questions that follow. To prepare your worksheet to use the Solver tool, add columns with
formulas for contribution margin per unit, total quantity in units, total machine minutes, and total
contribution margin. In the Solver tool window, enter the cell that you would like to maximize Hint: It is a single cell
identify the variables Hint: Use quantity in units column and enter the constraints Hint: There are two constraints
relating to demand and machine minutes
How many of the following products should be produced each month?
i R
ii JK
Which products would be temporarily eliminated from Backyard Helpers product line under the Excel solution?
What is the total net operating income per month given the machine time constraints and the quantities
determined
by Solver?
What is the maximum amount Backyard Helpers should be willing to pay to rent fabrication time from another
company? Assume transportation and other costs would total $
d In Questions c you identified products that would be temporarily eliminated if Backyard followed the Excel
solution. What reasons, if any, might management have for continuing to produce some of those products even if it
DA Data Sets
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started