Student Work Area Required: Provide input into cells shaded in yelow 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 Cell Referencing 5.10 - Using Excel to Prepare a Production Budget PROBLEM ossano, Inc., makes and sells drum sets. Nick Ross, controller, is esponsible for preparing the master budget. The sales manager has iven Nick the following sales forecast for the coming months April May June July Forecasted unit sales 12,000 15,000 10,000 11,000 Rossano provided the following additional information Estimated drum sets in inventory, March 31 6,000 Expected inventory at each month end based on the 30% following month's projected sales Prepare Rossano's production budget for the second quarter April 12,000 May 15,000 June 10,000 Quarter 37,000 Budgeted unit sales Budgeted ending inventory Total units required Beginning inventory Budgeted production