E9-2 Prepare a sales budget for 2 quarters Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and The calculators sell for $15 and $25 respectively. Because of the intense competition Eding management budgets sales semiannually. The projections for the first 2 quarters of 2017 ar Product Quarter1 Quarter 2 XQ-103 20,000 22,000 XQ-104 12,000 15,000 No changes in selling prices are anticipated. Instructions Prepare a sales budget for the 2 quarters ending June 30, 2017. List the products and shov quarter and for the 6 months, units, selling price, and total sales by product and in total. NOTE: Enter a number in cells requesting a value; enter either a number or a formula EDINGTON ELECTRONICS INC Sales Budget For the Six Months Ending June 30, 2017 Quarter 1 Selling Price Quarter 2 Total Sales Selling Total Product Units Units Price Sales XQ-103 Value $15 XQ1 04 Value Value $15 ? Value 25 25 Totals? roduction budgets Turney Company produces and sells automobile batteries, the heavy-duty HD-240. The 2017 sales forecast is as follows Quarter HD-240 2 3 5,000 7,000 8,000 4 10,000 The January 1, 2017, inventory of HD-240 is 2,000 units. Management inventory each quarter equal to 40% of the next quarter's sales. Sales in the first quarter o 2018 are expected to be 25% higher than sales in the same quarter in 2017 desires an ending 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 formul TURNEY COMPANY Production Budget For the Year Ending December 31, 2017 Product HD-240 Quarter 4 Yea Value Value Value Value Expected unit sales Add: Desired ending finished goods units Total required units Value Value Value Value ess: Beginning finished goods units equired production units