Debs - Using Excel to Greate a Froduction Dudzet Student Work Area PROBLEM Filling in for his supenisor, who suddenly left the company, Harvey quickly evaluated the situation to wrap up his department's production budget. The department currently holds enough inventory to be in compliance with its standard which is based on the following month's budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding inventory at month end which are both presented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending imventory standard Materiais held at month end Required: Provde input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harwy would assemble for the next quarter. Budgeted sales volume Target ending FG inventory Total units needed beginning FG inventory Budeeted units to be produced Debs - Using Excel to Greate a Froduction Dudzet Student Work Area PROBLEM Filling in for his supenisor, who suddenly left the company, Harvey quickly evaluated the situation to wrap up his department's production budget. The department currently holds enough inventory to be in compliance with its standard which is based on the following month's budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding inventory at month end which are both presented here. Unit sales per month Month 1 Month 2 Month 3 Month 4 Ending imventory standard Materiais held at month end Required: Provde input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Show the production budget that Harwy would assemble for the next quarter. Budgeted sales volume Target ending FG inventory Total units needed beginning FG inventory Budeeted units to be produced