PLEASE DO THE WORK IN EXCEL AND SHOW THE FORMULAS THAT WERE USED

three 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$)$

a$.$ Given this information, suggest a revised production plan for the next three months $($January$,$ February, and March$)$ that will hit the five days of inventory supply target if you accept the sales Plan.

b$.$ What are the implications of your plan, considering the qualitative factors?