please explain. Thanks.

AutoSave@ File Home 117 Chapter6ExcelMasteryAssignment_QuestlonI.xlsx Saved to this PC v Page Layout For mulas P Student Work Area Nguyen, Mytrang Insert Review View Automate Data c Help Comments If? Share Function: SUM; Formulas: Subtract, Multiply; Cell Referencing 1 2 BE63 - Using Excel to Create a Production Budget 3 PROBLEM S Filling in for his supervisor, who suddenly left the company, Harvey 6 quickly evaluated the situation to wrap up his department's production 7 1 budget. The department currently holds enough inventory to be in 8 ucompliance with its standard which is based on the following month's 9 budgeted sales. From the sales and previous budgets, he learned the budgeted unit sales for the next 4 months and the standard for holding 11 inventory at month end which are both presented here. Required: Provide 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 Harvey would assemble for the neqt quarter. Month 1 Month 2 Month 3 12 13 14 15 16 17 18 19 20 21 23 unit sales per month Month 1 Month 2 Month 3 Month 4 Ending inventory standard Materials held at month end 5,000 4,500 6,000 6,500 10% Budgeted sales volume Target ending FG Inventory Total units needed Beginning FG Inventory Budgeted units to be produced 5,000 5,500 10,500 5,500 5,000 4,500 4,950 9,450 4,950 4,500 6,000 6,600 12,600 6,600 6,000 Quarter 6,500 7,150 13,650 7,150 6,500