please solve it within 30 minutes template v3 is also attached with the question

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 Inventory Holding cost Marginal cost of stockout Hiring and training cost Layoff cost Labor hours required Shift Regular time cost Overtime cost Subcontracting cost Beginning workforce $10 per case $2/case/quarter $5/case/quarter $300/worker $500/worker 4 hours/case 8 hours/day $7/hour $9/hour $30 per case 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 1 3 # of Working Days Demand Forecast Beginning Inventory Required Production Units Regular Production Urits Overtime Production Units Subcontracting Total Production during Period Ending Inventory / (Backordersi Workers Needed Previous Porod's Workforce Worters Hired Workers Laid off Current Period's Workforce Costs Period 1 3 4 Total Material Cost Regular Wages Overtime Labour Cost Carrying Cos: 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 Inventory Holding cost Marginal cost of stockout Hiring and training cost Layoff cost Labor hours required Shift Regular time cost Overtime cost Subcontracting cost Beginning workforce $10 per case $2/case/quarter $5/case/quarter $300/worker $500/worker 4 hours/case 8 hours/day $7/hour $9/hour $30 per case 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 1 3 # of Working Days Demand Forecast Beginning Inventory Required Production Units Regular Production Urits Overtime Production Units Subcontracting Total Production during Period Ending Inventory / (Backordersi Workers Needed Previous Porod's Workforce Worters Hired Workers Laid off Current Period's Workforce Costs Period 1 3 4 Total Material Cost Regular Wages Overtime Labour Cost Carrying Cos: Backorder Cost Subcontracting Cost Hiring Cost Layoff Cost Total Cost over Planning Horizon