C D F G H 1 E9.2 Prepare a sales budget for 2 quarters 2 3 Edington Electronics Inc. produces and sells two models of calculators, XQ-103 and XQ-104. The calculators sell for $15 and 4 $25, respectively. Because of the intense competition Edington faces, management budgets sales semiannually. Its projections 5 for the first 2 quarters of 2022 are as follows. 8 9 10 11 Unit Sales Product Quarter 1 XQ-103 20,000 XQ-104 12,000 Quarter 2 22,000 15,000 12 No changes in selling prices are anticipated. 13 4 Instructions S Prepare a sales budget for the 2 quarters ending June 30, 2022. List the products and show units, selling price, and total sales by 6 product and in total for each quarter and for the 6 months. 7 8 NOTE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), into the yellow shaded input cells. 9 0 21 2 3 4 5 6 7 8 9 Product XQ-103 1 XQ-104 2 Totals 3 EDINGTON ELECTRONICS INC. Sales Budget For the Six Months Ending June 30, 2022 Quarter 1 Quarter 2 Selling Total Selling Total Six Months Selling Total Units Price Sales Units Price Sales Units Price Sales $ 15 $ 15 $ 15 25 25 25 E9.2 E9.4 E9.11 P9.5 Ready M