aggregate planning table is also attached please solve it within 30 minutes

A small company produces soda drinks. The salesperson has developed the following aggregate forecast for demand in cases) for the next four quarters. Quarter 1 2 3 4 Demand Forecast 4,000 4,800 7,900 5,100 # of Working Days 62 58 62 58 Material Cost $10 per case Inventory Holding cost $2/case/quarter Marginal cost of stockout $5/case/quarter Hiring and training cost $300/worker Layoff cost $500/worker Labor hours required 4 hours/case Shift 8 hours/day Regular time cost $7/hour Overtime cost $9/hour Subcontracting cost $30 per case Beginning workforce 40 workers Develop aggregate production plans using the following strategies. State which approach should be preferred based on cost. Please use the whole numbers for this question (e.g., 1.5 and above = 2 and 1.49 and less = 1). A) Produce to meet expected average demand over the next four quarters by maintaining a stable workforce of 42 workers. Manage the demand variations only by using backorders or carrying inventory. Assume a beginning inventory of 1,000 cases at the start of the planning horizon, but that there is no requirement for any specified number of cases in the ending inventory in any period of the plan. B) Suppose on the other hand, that we only want to use a constant workforce of 35 workers. Devise a plan that uses regular time and overtime production combined with outsourcing Inventory and backorders are not allowed except for a beginning inventory of 1000 cases at the start of the planning horizon and a planned ending inventory of 500 cases in quarter 4. Each worker is allowed a maximum of 2 hours of overtime per day. You must apply all available overtime hours before outsourcing any production. NOTE: Table required for this question is available on eClass, under document name "Aggregate Planning Template v3.pdf". Prior instruction posted to keep copies of those table. You are only allowed to fill by Hand. Typed work will not be accepted, hence will not be marked. Use separate table for part(a) and part (b). Name Student Number Period 3 #of Working Days Demand Forecast Beginning Inventory Required Production Units Regular Production Units Overtime Production Units Suboontracting Total Production during Period Ending Inventory /(Backorders) Workers Needed Previous Period's Workforce Workers Hired Workers Land off Current Period's Workforce Costs Total Material Cost Regular Wages Overtime Labour Cost Carrying Cost Backorder Cost Subcontracting Cost Hiring Cost Layoff Cost Total Cost over Planning Horizon A small company produces soda drinks. The salesperson has developed the following aggregate forecast for demand in cases) for the next four quarters. Quarter 1 2 3 4 Demand Forecast 4,000 4,800 7,900 5,100 # of Working Days 62 58 62 58 Material Cost $10 per case Inventory Holding cost $2/case/quarter Marginal cost of stockout $5/case/quarter Hiring and training cost $300/worker Layoff cost $500/worker Labor hours required 4 hours/case Shift 8 hours/day Regular time cost $7/hour Overtime cost $9/hour Subcontracting cost $30 per case Beginning workforce 40 workers Develop aggregate production plans using the following strategies. State which approach should be preferred based on cost. Please use the whole numbers for this question (e.g., 1.5 and above = 2 and 1.49 and less = 1). A) Produce to meet expected average demand over the next four quarters by maintaining a stable workforce of 42 workers. Manage the demand variations only by using backorders or carrying inventory. Assume a beginning inventory of 1,000 cases at the start of the planning horizon, but that there is no requirement for any specified number of cases in the ending inventory in any period of the plan. B) Suppose on the other hand, that we only want to use a constant workforce of 35 workers. Devise a plan that uses regular time and overtime production combined with outsourcing Inventory and backorders are not allowed except for a beginning inventory of 1000 cases at the start of the planning horizon and a planned ending inventory of 500 cases in quarter 4. Each worker is allowed a maximum of 2 hours of overtime per day. You must apply all available overtime hours before outsourcing any production. NOTE: Table required for this question is available on eClass, under document name "Aggregate Planning Template v3.pdf". Prior instruction posted to keep copies of those table. You are only allowed to fill by Hand. Typed work will not be accepted, hence will not be marked. Use separate table for part(a) and part (b). Name Student Number Period 3 #of Working Days Demand Forecast Beginning Inventory Required Production Units Regular Production Units Overtime Production Units Suboontracting Total Production during Period Ending Inventory /(Backorders) Workers Needed Previous Period's Workforce Workers Hired Workers Land off Current Period's Workforce Costs Total Material Cost Regular Wages Overtime Labour Cost Carrying Cost Backorder Cost Subcontracting Cost Hiring Cost Layoff Cost Total Cost over Planning Horizon