please answer the whole questions in the spot and explain it

File no Home Insert Page Layout Formulas Data c Review D View Automate Help C] Comments g Sh 6.3 - Using Excel to Create a Production Budget 3 PROBLEM S Iling in for his supervisor, who suddenly left the company, Harvey 6 ickly evaluated the situation to wrap up his department's production 7 dget. The department currently holds enough inventory to be in 8 )mpliance with its standard which is based on the following month's 9 dgeted sales. From the sales and previous budgets, he learned the 10 dgeted unit sales for the next 4 months and the standard for holding 11 ventory at month end which are both presented here. Student Work Area 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 next quarter. Month I Month 2 Month 3 Quarter 12 13 14 15 16 17 18 Unit sales per month Month I 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 4,500 6,000 6,500