Use this information to answer the following questions.
A beer distributor wants to prepare an aggregate plan for the next 6 weeks.Demand can be met using regular time production,overtime production,or a combination of both as illustrated below:

-Refer to the table above.Assume that beginning inventory is zero.Use Excel to formulate and solve this multiperiod production problem to minimize total costs.

Question

Use this information to answer the following questions.
A beer distributor wants to prepare an aggregate plan for the next 6 weeks.Demand can be met using regular time production,overtime production,or a combination of both as illustrated below:
 
-Refer to the table above.Assume that beginning inventory is zero.Use Excel to formulate and solve this multiperiod production problem to minimize total costs.

Quizplus · Accepted Answer

The Answer of Use this information to answer the following questions.
A beer distributor wants to prepare an aggregate plan for the next 6 weeks.Demand can be met using regular time production,overtime production,or a combination of both as illustrated below:
 
-Refer to the table above.Assume that beginning inventory is zero.Use Excel to formulate and solve this multiperiod production problem to minimize total costs.

Use This Information to Answer the Following Questions