please complete all parts and number 1
AutoSave On File Home Excel TemplateAssignment cho9 (1) - Excel Search Formulas Data Review View HelpDYMO Label QuickBooks Insert Page Layout K R11 4 A B C D E F G H J 1 E9.4 Prepare quarterly production budgets 2 Turney Company produces and sells automobile batteries, the heavy-duty HD-240. 3 The 2017 sales forecast is as follows. 1 Quarter HD-240 5,000 2 7 ,000 8,000 10,000 11 The January 1, 2017, inventory of HD-240 is 2,000 units. Management desires an ending 12 inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter of 13 2018 are expected to be 25% higher than sales in the same quarter in 2017. 14 15 Instructions 16 Prepare quarterly production budgets for each quarter and in total for 2017 17 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". TURNEY COMPANY Production Budget For the Year Ending December 31, 2017 Year Value Product HD-240 Quarter 123 28 Expected unit sales Value Value Value 29 Add: Desired ending finished goods unit ? 30 Total required units 31 Less: Beginning finished goods units Value Value Value 32 Required production units T09:2 E9-4 09-11 P9-1A P9-5A CD Ready Value 2 AutoSave ONR 2 File Home Insert Excel TemplateAssignment_cho9 (1) Formulas Data Review View Excel Search HelpDYMO Label QuickBooks Page Layout 1 ABCD 3 2018 are expected to be 25% higher than sales in the same quarter in 2017. 5 Instructions 6 Prepare quarterly production budgets for each quarter and in total for 2017 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a ow-OU TURNEY COMPANY Production Budget For the Year Ending December 31, 2017 Product HD-240 Quarter 2 3 8 Expected unit sales Value Value Value 9 Add: Desired ending finished goods unit ? ? ? - Total required units ? ? ? 1 Less: Beginning finished goods units Value Value Value #2 Required production units 7 7 4 Value ? Value 371 Assume that sales for quarter 2, 3, and 4 changed to 7,500, 9,000 and 12,000 units. In addition, the desired ending Inventory each quarter changed to 45% of the next quarter sales. Revise the quarterly production budgets for each quarter and in total for 2017 19- 209- 49311P9-1A P9-5AC3 Ready Type here to search @eleme