1. Cellular Solutions Inc. had a very successful year in 2013. Based on a $125 a
ID: 2504375 • Letter: 1
Question
1. Cellular Solutions Inc. had a very successful year in 2013. Based on a $125 average unit selling price, monthly sales during 2013 were as follows:
January
$ 75,000
February
60,000
March
100,000
April
150,000
May
60,000
June
50,000
July
40,000
August
85,000
September
65,000
October
95,000
November
35,000
December
50,000
Total
$865,000
Mr. James, vice president of sales, is preparing the sales budget for 2014. Increased manufacturing costs will make it necessary to increase the selling price by 12 percent. Even with this price increase, the unit volume of sales is expected to increase by 25 percent. The seasonal sales pattern shown for 2013 is expected to continue in 2014.
a. Prepare the monthly sales unit and dollar budgets for the first quarter of 2014.
b. Mr. Serene is considering the possibility of raising the average selling price by 20 percent in 2014. If this action is taken, he projects that the sales volume for the year will increase by only 10 percent. What would forecasted sales in units and dollars be in 2014 if his projection is correct?
January
$ 75,000
February
60,000
March
100,000
April
150,000
May
60,000
June
50,000
July
40,000
August
85,000
September
65,000
October
95,000
November
35,000
December
50,000
Total
$865,000
Explanation / Answer
Month
Sales of 2013
Units sold in 2013 = SALES/125
ALTERNATIVE-(a)
Sales dollars
= New sales price* Sales units under ALTERNATIVE-(a)
ALTERNATIVE-(a)
Sales units = Units sold in 2013(1.25)
New sales price
125*1.12 = $140 p.u.
January
$ 75,000
600
140*750
= $105000
(600*1.25)
= 750 units
February
60,000
480
140*600
=$84000
(480*1.25)
= 600 units
March
100,000
800
140*1000
= $140000
(800*1.25)
= 1000 units
April
150,000
1200
140*1500
= $140000
(1200*1.25)
= 1500 units
Month
Sales of 2013
Units sold in 2013 = SALES/125
ALTERNATIVE-(a)
Sales dollars
= New sales price* Sales units under ALTERNATIVE-(a)
ALTERNATIVE-(a)
Sales units = Units sold in 2013(1.25)
New sales price
125*1.12 = $140 p.u.
January
$ 75,000
600
140*750
= $105000
(600*1.25)
= 750 units
February
60,000
480
140*600
=$84000
(480*1.25)
= 600 units
March
100,000
800
140*1000
= $140000
(800*1.25)
= 1000 units
April
150,000
1200
140*1500
= $140000
(1200*1.25)
= 1500 units
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.