NOTES 1. Your completed problem must meet the requirements below. See rows 38-50
ID: 2517393 • Letter: N
Question
NOTES 1. Your completed problem must meet the requirements below. See rows 38-50. 2. There must be an INPUT section and an OUTPUT section. 3. You may use the format from the text or create a format of your own. NAME: Problem #3 DATA for current year 2016 Company Product Better Incorporated A450 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 60,000 58 40,000 $40.00 sales unit NOTES 1. Your completed problem must meet the requirements below 2. OUTPUT section should refer back to INPUT data using cell refernces. 3. Be sure to label each item in column A (e.g. sales in units) 4.Be sure to check that your unit of measure is correct (e.g. units, dollars, etc. 5. Adjust spacing as needed. from Production Departmenit Desired ending inventory-each quarter 10% of the next quarter's sales in units OUTPUT: Sales budget Qtr. 1 Qtr. 2 Qtr. 3 Total Production budget REQUIRED: 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. 2. Prepare a production budget for quarters 1, 2, and 3 in UNITS ONLY. Provide a total colum for the three quarters. 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. 3. Why is it so important for a company to prepare a production budget? 4 What are two of the assumptions that are "built into" the production budget?Explanation / Answer
1) Sales Budget (Amounts in $)
2) Production budget (Amounts in $)
3) A production budget estimates the costs of manufacturing a product. It permits the company to track costs. A production budget is prepared in units and prepared with the help of inventory and units sold.
Particulars Qtr 1 Qtr 2 Qtr 3 Total Units sold (A) 60,000 55,000 58,000 173,000 Sale Price per unit (B) $40.00 $40.00 $40.00 $40.00 Total Sales (A*B) 2,400,000 2,200,000 2,320,000 6,920,000Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.