Ch 22 Review View AutoSaver S580. Home Insert Draw Page Layout Formulas Callbri (Body) 12 A A BIUTOA F35 x fx Value Data = X 1 2 Wrap Text Merge & Center 4 E22-4 Prepare quarterly production budgets 6 Turney Company produces and sells automobile batteries, the heavy duty HD-240. 7 The 2017 sales forecast is as follows. Quarter HD-240 5,000 7,000 8,000 10,000 15 The January 1, 2017, Inventory of HD-240 is 2,000 units. Management desires an ending 16 Inventory each quarter equal to 40% of the next quarter sales. Sales in the first quarter of 17 2018 are expected to be 25% higher than sales in the same quarter in 2017. 19 Instructions 20 Prepare quarterly production budgets for each quarter and in total for 2017, 22 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 32 Expected unit sales 33 Add: Desired ending finished goods units 34 Total required units 35 Less: Beginning finished goods units 36 Required production units Product HD-240 Quarter 1 2 3 5,000 7 ,000 8,000 2.8003 ,200 4.000 7,800 10.200 12,000 2,000 Value Value 5,8007 4 10,000 2.500 12.500 Value