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 2020 are as follows.
Unit Sales |
||||
---|---|---|---|---|
Product |
Quarter 1 |
Quarter 2 |
||
XQ-103 | 22,140 | 26,850 | ||
XQ-104 | 13,300 | 17,860 |
No changes in selling prices are anticipated.
Prepare a sales budget for the 2 quarters ending June 30, 2020.
List the products and show for each quarter and for the 6 months,
units, selling price, and total sales by product and in total.
EDINGTON ELECTRONICS INC. |
|||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Quarter 1 |
Quarter 2 |
Six Months |
|||||||||||||||
Product |
Units |
Selling Price |
Total Sales |
Units |
Selling Price |
Total Sales |
Units |
Selling Price |
Total Sales |
||||||||
XQ-103 |
enter a number of units |
$enter a dollar amount |
$enter a dollar amount |
enter a number of units |
$enter a dollar amount |
$enter a dollar amount |
enter a number of units |
$enter a dollar amount |
$enter a dollar amount |
||||||||
XQ-104 |
enter a number of units | enter a dollar amount | enter a dollar amount | enter a number of units | enter a dollar amount | enter a dollar amount | enter a number of units | enter a dollar amount | enter a dollar amount | ||||||||
Totals |
enter a total number of units | $enter a total dollar amount | enter a total number of units | $enter a total dollar amount | enter a total number of units | $enter a total dollar amount |
Ans. | EDINGTON ELECTRONICS INC. | |||||||
Sales Budget | ||||||||
For the Six Month Ending June 30, 2020 | ||||||||
QUARTER 1 | QUARTER 2 | |||||||
Product | Units (a) | Unit Selling Price (b) | Total Sales (a*b) | Units (a) | Unit Selling Price (b) | Total Sales (a*b) | ||
XQ - 103 | 22140 | $15 | $332,100 | 26850 | $15 | $402,750 | ||
XQ - 104 | 13300 | $25 | $332,500 | 17860 | $25 | $446,500 | ||
Totals | 35440 | $664,600 | 44710 | $849,250 | ||||
*Total sales = Units sold * Selling price per unit | ||||||||
Get Answers For Free
Most questions answered within 1 hours.