Ros prer fore

E5.10 - Using Excel to Prepare a Production Budget PROBLEM 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. Forecasted unit sales April 12,000 May 15,000 June 10,000 Student Work Area 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. Prepare Rossano' s production budget for the second quarter July 11,000 6,000 30% June 10,000 Quarter Budgeted unit sales April 12,000 May 15,000 Rossano provided the following additional information. Estimated drum sets in inventory, March 31 Expected inventory at each month end based on the following month's projected sales