Hi! We’ve currently got a workforce of 80 workers. I’m wondering what the ideal workforce level will be throughout January-June? To: You Cc: Onion Team From: Al Subject: Onion Cola Here’s the linear programming I’ve done so far. Link to Course File Scenario Assignment Worksheet: cf_scenario_assignment_worksheet.xlsx [Excel] To: You Cc: Onion Team From: Charles Subject: Onion Cola Hi! I created a demand forecast based on the Salmon Vanilla product launch last year. Month Demand Forecast January 1,200 February 2,400 March 3,600 April 4,800 May 2,200 June 200 To: You Cc: Onion Team From: Luis Subject: Onion Cola I put together that summary of managerial levers you asked me for. Item Cost Materials cost/unit $10 Inventory holding cost/unit/month $2 Marginal cost of stockout/unit/month $5 Hiring and training cost/worker $300 Layoff cost/worker $500 Labor hours required/unit 4 Regular time cost/hour $4 Overtime cost/hour $6 Beginning inventory equals 1000 Ending inventory greater than 500 Marginal subcontracting cost/unit $30 What is the ideal workforce level throughout January-June? 80 workers. 57 workers. 84 workers. Production, even with 80 workers, vastly exceeds demands. You’ll want fewer workers. 53 workers.