Question: Please help me to solve this question with Excel ( This class mainly uses Solver function to solve ) Cob produces handcarts that are used
Please help me to solve this question with Excel This class mainly uses Solver function to solveCob produces handcarts that are used by customers for moving stuff
around and wants to optimize production so as to maximize his
profitability. His forecasted demand is listed to the right.
He has the following information available to him:
He can produce up to carts per month with labor costs of $ and
material costs of $ each.
He can hire additional workers to producer up to additional carts
with labors costs of $ and material costs of $ each.
The carts sell for $ each.
Holding costs are $ per cart per month
He would like to maintain safety stocks of units in months May
through September and units in all other months.
Cob has a starting inventory of carts in January.
Create a model to solve for the optimum production schedule to
maximize total profit.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
