In: Accounting
Eckert Company has budgeted the following unit sales:
2016 Units
April 25,000
May 50,000
June 75,000
July 45,000
Of the units budgeted, 40% are sold by the Southern Division at an average price of $15 per unit and the remainder are sold by the Eastern Division at an average price of $12 per unit. Instructions Prepare separate sales budgets for each division and for the company in total for the second quarter of 2017 by completing the chart. Do NOT use dollar signs.
Eckert Company Sales Budget for the second quarter of 2017 |
||||
Eastern Division | April | May | June | Total |
Expected unit sales |
15,000 (25,000 x 60%) |
30,000 (50,000 x 60%) |
45,000 (75,000 x 60%) |
90,000 |
Unit selling price | 12 | 12 | 12 | 12 |
Total sales (A) | 180,000 | 360,000 | 540,000 | 1,080,000 |
Southern Division | April | May | June | Total |
Budgeted Unit sales |
10,000 (25,000 x 40%) |
20,000 (50,000 x 40%) |
30,000 (75,000 x 40%) |
60,000 |
Unit selling price | 15 | 15 | 15 | 15 |
Total sales (B) | 150,000 | 300,000 | 450,000 | 900,000 |
Total company sales (A +B) |
330,000 | 660,000 | 990,000 | 1,980,000 |