Function: SUM; Formulas: Multiply, Subtract; Cell ReferencingSome cells are merged.E$5\mathrm{.}10-$ Using Excel to Prepare a Production BudgetStudent Work AreaPROBLEM$$Required: Provide input into cells shaded in yellow in this template. Input$$ mathematical formulas with cell references to the Problem area as indicated. Use the SUM function with cell references to add amounts.$$Rossano$,$ Inc., makes and sells drum sets. Nick Ross, controller, is responsible for preparing the master budget. The sales manager has given Nick the following sales forecast for the coming months.AprilMayJuneJulyPrepare Rossano$$s production budget for the second quarter.Forecasted unit sales $12,00015,00010,00011,000$AprilMayJuneQuarterRossano provided the following additional information.$$Budgeted unit sales $12,00015,00010,00037,000$Budgeted ending inventory $4,5003,0003,30010,800$Estimated drum sets in inventory, March $316,000$Total units required $16,50018,00013,30047,800$Expected inventory at each month end based on the$$Beginning inventory $6,0004,5003,00013,500$ following month's projected sales$30\%$Budgeted production $10,50013,50010,30034,300$