please complete all parts and number 1

1 E9-2 Prepare a sales budget for 2 quarters 2 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-103 20,000 22,000 XQ-104 12,000 15,000 11 No changes in seling 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 15 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 "?". Sales Budget For the Six Months Ending June 30, 2017 Quarter 1 Selling Price $15 25 Total Sales Total Sales 26 Product Units 27 XQ-103 Value 28 XQ-104 Value 29 Totals ? Quarter 2 Selling Price $15 26 Units Units Value Value Six Months Selling Total Price Sales $15 25 E9- 2 094 09-11 P9-1A | P9-5A CO9 @ AutoSave OD 2 0 Excel TemplateAssignment_cho9 (1) Excel O Search Filo Home Insert Page Layout Formulas Data Review View HelpDYMO Label QuickBooks 20 . 1 X fi A B C D E F G H I J K L 3 Instructions Prepare a sales budget for the 2 quarters ending June 30, 2017. List the products and show for each 5 quarter and for the 6 months, units, selling price, and total sales by product and in total. 6 NOTE: Enter a number in cells requesting a value; enter either a number or a formula in cells with a "?". Sales Budget For the Six Months Ending June 30, 2017 Quarter 1 Selling Price $15 Total Sales Units Value Units Quarter 2 Selling Price $15 25 26 Product Units 27 XQ-103 Value 28 XQ-104 Value 29 Totals 30 Total Sales ? ? Six Months Selling Total Price Sales $15 25 ? 12 31 Assume that the number of XQ-103 units sold in Quarter 2 and XQ-104 in Quarter 1 changed to 30,000 and 17,000 respectively. Revise the flexible budget report for the two quarters ending June 30, 2017