- - - - - E muy J K L 0252 x v fx ABC E F G H I 1 E21-2 Prepare a sales budget for 2 quarters Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. 3 The calculators sell for $15 and $25 respectively. Because of the intense competition Edington faces, 4 management budgets sales semiannually. The projections for the first 2 quarters of 2017 are as follows. Unit Sales Product Quarter 1 Quarter 2 XQ-10320,000 22,000 XQ-104 12,000 15,000 11 No changes in selling prices are anticipated. 12 13 Instructions 14 Prepare a sales budget for the 2 quarters ending June 30, 2017. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total. 16 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". EDINGTON ELECTRONICS INC. Sales Budget For the Six Months Ending June 30, 2017 Total Sales Quarter 1 Selling Price $15 25 Total Sales Six Months Selling Price Quarter 2 Selling Price $15 25 Total Sales 26 Product 27 XQ-103 28 XQ-104 29 Totals Units Units Value Value ? Units Value Value $15 ? 25