Question

Assume that Stillwater Designs produces two automotive subwoofers:

S12L7 S12L5.
First quarter 2014 800 1300
Second quarter 2014 2200 1400
Third quarter 2014 5600 5300
Fourth quarter 2014 4600 3900
First quarter 2015 900 1200
The vice president of sales believes that the projected sales are realistic and can be achieved by the company.
Required:
Prepare a sales budget for each quarter of 2014 and for the year in total. Show sales by product and in total for each time period. Do not include a multiplication symbol as part of your answer.

Answer 1

Stillwater Designs

Sales Budget 2014

Year 2014

Product First Second Third Fourth Total

quarter quarter quarter quarter

S12L7 800 2,200 5,600 4,600 13,200

S12L5 1,300 1,400 5,300 3,900 11,900

A sales budget gives us an estimate of how many units (and $) the company will sell in the following months, quarters or even years.