Question: Load the Excel workbook Aggregate Planning Chase Demand.xlsx . This is one of the two Excel workbooks examined in class. You will use this as

Load the Excel workbook Aggregate Planning Chase Demand.xlsx. This is one of the two Excel workbooks examined in class. You will use this as the starting point for this exercise. Your task is to use some combination of workload leveling and/or capacity adjustment to find a minimum cost, feasible solution to the production and capacity planning problem. You will be changing the production schedule in rows 12-15 of the Calculations worksheet. You may also change the number of shifts running. (The number of shifts running in the first three months of the planning horizon is frozen and cannot be changed.)

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!