This case puts you in the driver seat (as a production planner). Open the attached xls workbook.. Your job is to prepare production schedule (considering the constraints and rules of this case in Chp 19), and to determine the operating budget for such a plan. There are 3 worksheets available to execute this plan – the 1st Aggregate Plan is where you determine your production plan/schedule (by indicating the number of lines and any overtime hrs per day – (yellow highlights), and then budget costs (blue highlights) associated with your plan. You can use the defaulted number of production lines and overtime hours as a first try; Once you’ve determined your budgeted plan, then there is the Simulation Worksheet where you need to indicate the Actual Production Rate and the Actual Demand columns cells (in reality the actual data would be getting filled in each week as time progresses), but you need to fill all 52 weeks with numbers into the blue cells (simply enter 450 into the Actual Production Rate column (each cell) and then copy the Forecast column into the Actual Demand column) – which will end up simulating how much your plan will actually cost onto the 3rd sheet; 3rd is the Actual Cost worksheet, which will fill in automatically, based on data from the Simulation Worksheet. The main idea here is to do your plan (sheet 1), estimate your budget (sheet 1), enter in the production rate and demand (sheet 2), which will automatically generate numbers showing the actual costs (sheet 3) – lastly, you should compare your budget (sheet 1) to what it actually costs to execute (sheet 3). Lastly, you should make an attempt to reconcile any differences between your budget and the actual costs that are simulated. Make adjustments to your plan/budget, and rerun again, till you get the budget and actual costs to align.
I need some help to slove this excel file.
