W14 E H 1E13-2 Prepare a sales budget for 2 quarters Edington Electronics Inc. produces and sels two models of pocket calculators, X0-103 and X0-104 The calculators sell for 515 and 525 respectively. Because of the intense competition Edington faces 4 management budgets sales semiannually. The projections for the first quarters of 2017 are as follows Unit Sales 7 Product Quarter 1 Quarter 2 X0-103 20.000 22 000 X0-104 12.000 15.000 10 11 No changes in saling 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 seling 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 "?" 1 10 2 EDINGTON ELECTRONICS INC Sales Budget For the Six Months Ending Line 30, 2017 Total Sales Quarter 2 Seling Total 5 Mars Total Price 515 26 Product 21 X0-103 Value 20 X0-104 Value Pile 515 25 Units Value S15 25 EDINGTON ELECTRONICS INC Sales Budget For the Six Months Ending June 30, 2017 Sir Months Selling Total Price Sales $15 25 $15 Units 2 2 2 24 Quarter 1 Quarter 2 Seling Total Selling Total 26 Product Units Price Sales Units Price Sales 27 XQ-103 Value $15 ? Value 2 28 X0-104 Value 25 2 Value 25 2 29 Totals 2 2 2 30 3 3 33 After you have completed E13-2 consider the following additional question 341 Assume that the number of XQ-103 units sold in Quarter 2 and X0-104 in Quarter changed to 30,000 and 17.000 respectively Revise the flexible budget report for the two quarters ending June 30 2017 2 WER . S B Z