Question

Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators sell for $15 and $25, respectively. Because of the intense competition Edington faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2014 are as follows.

	Unit Sales
Product	Quarter 1	Quarter 2
XQ-103	20,000	22,000
XQ-104	12,000	15,000

No changes in selling prices are anticipated.

Prepare a sales budget for the 2 quarters ending June 30, 2014. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total.

Answer 1

Sales Budget
	Product XQ-103			Product XQ-104
	Quarter 1	Quarter 2	Six Month	Quarter 1	Quarter 2	Six Month	Total
Expected Unit Sale	20000	22000	42000	12000	15000	27000	69000
Unit Selling Price	15	15	15	25	25	25
Total Sale	300000	330000	630000	300000	375000	675000	1305000

Answer 2

Sales Budget for the 2 quarters ending 30th June 2014
Particulars	Quarter-1 ending 31st Mar 2014 (I)	Quarter-2 ending 30th June 2014 (II)	For 1st Half Year ending 30th June (I+II) (6 Months)
Selling Price (per unit) (A)	$ 15 for XQ-103 and $ 25 for XQ-104	$ 15 for XQ-103 and $ 25 for XQ-104	-
XQ-103 (units) (B)	20,000 units	22,000 units	42,000 Units
XQ-104 (units) ( C )	12,000 units	15,000 units	27,000 Units
Budgeted Sales:
Model - XQ-103 ($) (A

Answer 3

Here is what I solved before, please modify the figures as per your question. Please let me know if you have further questions. Ifthis helps then kindly rate 5-stars.

Edington Electronics Inc. produces and sells two models of pocket calculators, XQ-103 and XQ-104. The calculators sell for $15 and $25, respectively. Because of the intense competition Edington faces, management budgets sales semiannually. Its projections for the first 2 quarters of 2012 are as follows.

		Unit Sales
Product		Quarter 1		Quarter 2
XQ-103		22,480		27,590
XQ-104		14,410		17,710

No changes in selling prices are anticipated.

Prepare a sales budget for the 2 quarters ending June 30, 2012. List the products and show for each quarter and for the 6 months, units, selling price, and total sales by product and in total.

Answer

Sales budget:

ZELLER ELECTRONICS INC.
Sales Budget
For the Six Months Ending June 30, 2010
Quarter 1
Product	Units	Selling price $	Total sales $
XQ-103	20,000	12	240,000
XQ-104	12,000	25	300000
Total	32,000		540,000
Quarter 2
XQ-103	25,000	12	300,000
XQ-104	15,000	25	375,000
Total	40,000		675,000
Six months
XQ-103	45,000	12	540,000
XQ-104	27,000	25	675000
Total	72,000		1,215,000