1. Using the data input provided (Exhibit 1), prepare LAF's master budgets in Excel. Do not hard-code numbers into the spreadsheet, except in the financing section of the cash budget.

(1) sales budget

(2) production budget

(3) direct materials budget

(4) direct labor budget

(5) manufacturing overhead budget

(6) selling and administrative expenses budget

(7) cash collections budget

(8) cash disbursements budget

(9) cash budget with financing needs

(10) pro forma income statement,

and (11) pro forma statement of financial position.

2. Conduct a sensitivity analysis, decreasing sales 2%, 5%, and 10% for April through August. New sales levels are provided in Exhibit 2. Adjust the financing and cash needs at these new sales levels.

Need help with #2, #1 is completed

Excel File- Cash Is King.xlsx