The Trapper Lawn Equipment Company manufactures a line of riding mowers. The company currently uses a chase strategy in its sales and operations planning. Management attempts to maintain a line fill rate of at least 99 percent and hold inventory of five days. Employees can pro- duce three units a day on average. The historical records for the last three months and the plan for the next six months are given as follows:

I am looking for the formulas for the highlighted area.

Trapper Lawn Equipment Co. Sales and Operations Planning Spreadsheet: Riding Mowers Product Group (Make-To-Stock)