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 solve)Cob 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 100 carts per month with labor costs of $75 and
material costs of $50 each.
-He can hire additional workers to producer up to 25 additional carts
with labors costs of $125 and material costs of $50 each.
-The carts sell for $200 each.
-Holding costs are $5 per cart per month
-He would like to maintain safety stocks of 10 units in months May
through September and 5 units in all other months.
-Cob has a starting inventory of 10 carts in January.
Create a model to solve for the optimum production schedule to
maximize total profit.
 Please help me to solve this question with Excel (This class

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!