Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows. Quarter HD-240 5,000 7,000 8,000 10,000 3 The January 1, 2017, inventory of HD-240 is 2,000 units. Management desires an ending inventory each quarter equal to 40% of the next quarter sales. Sales in the first quarter of 2018 are expected to be 25% higher than sales in the same quarter in 2017. Instructions 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 "?". TURNEY COMPANY Production Budget For the Year Ending December 31, 2017 Year Product HD-240 Quarter 1 2 3 Value Value Value Value Value Value ? ? 4 Value Value Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production units Value Value Value Value 1 1 1 ] ]