Q1 (12 Marks) You may type it or write it. Solution can be found by doing calculation conceptually using calculator. Or you may make Excel file. Partial marks will be given for less than perfect solution, as long as some parts are right. M.C. Inc. is a disk manufacturer is need of an aggregate plan for July through December. The company has gathered the following data: Holding cost Subcontracting Regular time labour Overtime labour Hiring cost Layoff cost Costs $8/disk/month $80/disk $12/hour $18/hour for hours above 8 hours/ worker/day $40/worker $80/worker Demand* 400 500 550 July August September October November December *no cost is incurred for unmet demand 700 800 700 Current workforce Labour-hour/disk Workdays/month Beginning inventory Ending inventory ** Note that there is no holding cost for June Other data 8 people 4 hours 20 days 150 disks ** O disks What will the following strategy cost? Vary the workforce so that production meets demand. MC has eight workers on board in June