Can you help make this mix aggregate plan sheet and show where and what formulas you used thank!

MIX AGGREGATE PLAN 1 2 3 4 5 6 7 8 Period Forecast Production Regular Time Overtime Subcontract Total Production Number of Workers Inventory Beginning Ending Average Backlog Labor Costs Regular Overtime Subcontract Hire Fire Total Labor Cost Inventory Costs Holding Cost Back Order Total Production Cost Aggregate Demand 3 4 1 2 5 7 00 8 9905 12225 Quarter Casual Athletic Running Total 9510 8875 8825 12085 12615 10505 12165 9250 8585 8810 8750 26145 6 17195 17670 16150 51015 14255 14480 16850 16900 48230 13175 9355 28510 11990 36690 13525 40005 27210 35845 1 7 8 Week Forecast Orders Casual Shoe Forecast and Customer Orders 2 3 4 5 6 673 747 913 654 715 555 284 88 45 612 999 859 952 600 0 0 1 7 8 Week Forecast Orders Athletic Shoe Forecast and Customer Orders 2 3 4 5 6 1220 605 607 1011 1019 1154 641 330 175 118 1160 833 1083 0 1184 82 1 7 8 Week Forecast Orders Running Shoe Forecast and Customer Orders 2 3 4 5 6 649 898 424 285 451 629 484 306 123 79 768 464 498 702 0 0 Current Inventory Order Policy Lead Time Finished Goods Inventory Records Casual Athletic 2258 2546 FOQ = 2000 FOQ = 2000 1 Week 2 Weeks Running 1557 FOQ = 1500 2 Weeks Value 450 100 85 55 1600 Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wage Overtime wage Subcontract Cost Back order cost Holding cost per pair of shoes per quarter Ending Inventory Period o 1000 20 30 55 25 3 3000 Aggregate Planning A chase and level plan must be created for the project. The planning horizon is for two years, starting one year out. Each period in the aggregate plans represent one quarter. Aggregate by product for each quarter. The marketing department is planning to attend a series of fairs and conventions during periods 5 and 6, resulting in a projected spike in forecasted demand. Chase Plan Rules: The forecast demand must be met each quarter o Overtime and subcontracting is authorized o No backorders are permitted Level Plan Rules: o Regular production will be calculated and rounded up to the nearest whole number using the level production equation (do not just hide decimal places) o No overtime or subcontracting may be used A mixed plan is an optional assignment for 20 bonus points. To score the bonus points, the plan must meet the conditions for the Mix Aggregate Plan listed below. O Mix Aggregate Plan Rules: o Plan must be free of errors The cost of the plan must beat the cost provided (target cost to be provided on Canvas) At the end of the last period, all backlog must be cleared o Employment level cannot ever go above the maximum number of workers as stated in the Aggregate Planning spreadsheet o Sneakernet is an internet-based company that produces three types of shoes: Casual, Athletic and Running. These shoes are sold directly to consumers and to retail stores. Your task is to plan out their production needs in the given time periods using aggregate planning, master production scheduling and material requirements planning. The aggregate plan will combine all three types of shoe for each quarter. A master production plan for each shoe needs to be created and material requirements planning needs to be done for the casual shoe