Please show how to do on Excel or microsoft word thanks

 

Days of supply 2. The Trapper Lawn Equipment Company manufactures a line of riding mowers. The company currently uses a chase strategy in its SOP. Management attempts to main- can produce three units a day on average. The historical records for the last three tain a line fill rate of at least 99 percent and hold inventory of five days. Employees months and the plan for the next six months are given as follows: Trapper Lawn Equipment Company Sales and Operations Planning Spreadsheet: Riding Mowers Product Group (Make-to-Stock) Plan History Oct Nov Dec Jan Feb Mar Apr May Jun Sales Plan (in millions $) (in units) Actual (in units) 12.50 10.00 5,000 4,000 6,500 4,384 3,626 6,065 16.25 5.00 5.00 7.50 10.00 2,000 2,000 3,000 4,000 12.50 17.50 5,000 7,000 Diff. month -616-374 -435 Diff. cumulative -990 -1,425