Exam#2 Erel Spring2019 (T-Excel utoSave Help Tell me what you want to do e Home Insert Page Layout Formulas Data Review View from Sales Department Projected sales in units -qtr. 1 Projected sales in units-qtr. 2 Projected sales in units-qtr. 3 Projected sales in units-qtr. 4 Projected sales price per unit 60,000 58,000 40 NOTES: 1. Your completed problem must meet the n 2. OUTPUT section should refer back to INPU 3. Be sure to label each item in column A(e-g 4.Be sure to check that your unit of measure i from Production Department Desired ending inventory-each quarter 10% of the next quarter's sales in units OUTPUT Qtr. 3 Toal. Adjust spacing as needed. Sales budget Qtr. 2 5 Production budeet 30 32 3 REQUIRED 34 1. Prepare a sales budget for quarters 1, 2, and 3 in UNITS and DOLLARS Provide a TOTAL columns for the three quarters for UNITS and DOLLARS 35 36 2. Prepare a production budget for quarters 1, 2 and 3 in UNITS ONLY.Provide a total colum for the three quarters 37 Use Excel formulas and be sure (1) to use cell references to refer back to INPUT and (2) to link the production budget to the sales budget. 39 3. Why is it so important for a company to prepare a production budget? 41 4 What are two of the assumptions that are "built into" the production budget? NOTES: 44 1. Your completed problem must meet the requirements below 2 OUTPUT section should refer back to INPUT data using cell refernces Be sure to label each item in column A (e-g- sales in units) Be sure to check that your unit of measure is correct (e.g.units, dollars, etc) S. Adjust spacing as needed. 0 roblem 1 Problens 2