Sales Budget Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $627, and the S12L5 sells for $396. Projected sales (number of speakers) for the coming five quarters are as follows: S12L7 S12L5 First quarter, 20Y1 800 1,300 Second quarter, 20Y1 2,200 1,400 Third quarter, 20Y1 5,600 5,300 Fourth quarter, 20Y1 4,600 3,900 First quarter, 20Y2 900 1,200 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 20Y1 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. 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Year S12L7: Units fill in the blank 2f6b2604ff91fe0_1 fill in the blank 2f6b2604ff91fe0_2 fill in the blank 2f6b2604ff91fe0_3 fill in the blank 2f6b2604ff91fe0_4 fill in the blank 2f6b2604ff91fe0_5 Price $fill in the blank 2f6b2604ff91fe0_6 $fill in the blank 2f6b2604ff91fe0_7 $fill in the blank 2f6b2604ff91fe0_8 $fill in the blank 2f6b2604ff91fe0_9 $fill in the blank 2f6b2604ff91fe0_10 Sales $fill in the blank 2f6b2604ff91fe0_11 $fill in the blank 2f6b2604ff91fe0_12 $fill in the blank 2f6b2604ff91fe0_13 $fill in the blank 2f6b2604ff91fe0_14 $fill in the blank 2f6b2604ff91fe0_15 S12L5: Units fill in the blank 2f6b2604ff91fe0_16 fill in the blank 2f6b2604ff91fe0_17 fill in the blank 2f6b2604ff91fe0_18 fill in the blank 2f6b2604ff91fe0_19 fill in the blank 2f6b2604ff91fe0_20 Price $fill in the blank 2f6b2604ff91fe0_21 $fill in the blank 2f6b2604ff91fe0_22 $fill in the blank 2f6b2604ff91fe0_23 $fill in the blank 2f6b2604ff91fe0_24 $fill in the blank 2f6b2604ff91fe0_25 Sales $fill in the blank 2f6b2604ff91fe0_26 $fill in the blank 2f6b2604ff91fe0_27 $fill in the blank 2f6b2604ff91fe0_28 $fill in the blank 2f6b2604ff91fe0_29 $fill in the blank 2f6b2604ff91fe0_30 Total sales $fill in the blank 2f6b2604ff91fe0_31 $fill in the blank 2f6b2604ff91fe0_32 $fill in the blank 2f6b2604ff91fe0_33 $fill in the blank 2f6b2604ff91fe0_34 $fill in the blank 2f6b2604ff91fe0_35 How will Stillwater Designs use this sales budget? Stillwater Designs will use the sales budget in planning as the basis for the production budget. The company can also compare actual sales against the budget to see if expectations were achieved. Both 1 and 2 None of the above
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Sales Budget
Assume that Stillwater Designs produces two automotive subwoofers: S12L7 and S12L5. The S12L7 sells for $627, and the S12L5 sells for $396. Projected sales (number of speakers) for the coming five quarters are as follows:
S12L7 | S12L5 | |
First quarter, 20Y1 | 800 | 1,300 |
Second quarter, 20Y1 | 2,200 | 1,400 |
Third quarter, 20Y1 | 5,600 | 5,300 |
Fourth quarter, 20Y1 | 4,600 | 3,900 |
First quarter, 20Y2 | 900 | 1,200 |
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 20Y1 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.
1st Qtr. | 2nd Qtr. | 3rd Qtr. | 4th Qtr. | Year | |
S12L7: | |||||
Units | fill in the blank 2f6b2604ff91fe0_1 | fill in the blank 2f6b2604ff91fe0_2 | fill in the blank 2f6b2604ff91fe0_3 | fill in the blank 2f6b2604ff91fe0_4 | fill in the blank 2f6b2604ff91fe0_5 |
Price | $fill in the blank 2f6b2604ff91fe0_6 | $fill in the blank 2f6b2604ff91fe0_7 | $fill in the blank 2f6b2604ff91fe0_8 | $fill in the blank 2f6b2604ff91fe0_9 | $fill in the blank 2f6b2604ff91fe0_10 |
Sales | $fill in the blank 2f6b2604ff91fe0_11 | $fill in the blank 2f6b2604ff91fe0_12 | $fill in the blank 2f6b2604ff91fe0_13 | $fill in the blank 2f6b2604ff91fe0_14 | $fill in the blank 2f6b2604ff91fe0_15 |
S12L5: | |||||
Units | fill in the blank 2f6b2604ff91fe0_16 | fill in the blank 2f6b2604ff91fe0_17 | fill in the blank 2f6b2604ff91fe0_18 | fill in the blank 2f6b2604ff91fe0_19 | fill in the blank 2f6b2604ff91fe0_20 |
Price | $fill in the blank 2f6b2604ff91fe0_21 | $fill in the blank 2f6b2604ff91fe0_22 | $fill in the blank 2f6b2604ff91fe0_23 | $fill in the blank 2f6b2604ff91fe0_24 | $fill in the blank 2f6b2604ff91fe0_25 |
Sales | $fill in the blank 2f6b2604ff91fe0_26 | $fill in the blank 2f6b2604ff91fe0_27 | $fill in the blank 2f6b2604ff91fe0_28 | $fill in the blank 2f6b2604ff91fe0_29 | $fill in the blank 2f6b2604ff91fe0_30 |
Total sales | $fill in the blank 2f6b2604ff91fe0_31 | $fill in the blank 2f6b2604ff91fe0_32 | $fill in the blank 2f6b2604ff91fe0_33 | $fill in the blank 2f6b2604ff91fe0_34 | $fill in the blank 2f6b2604ff91fe0_35 |
How will Stillwater Designs use this sales budget?
- Stillwater Designs will use the sales budget in planning as the basis for the production budget.
- The company can also compare actual sales against the budget to see if expectations were achieved.
- Both 1 and 2
- None of the above
Trending now
This is a popular solution!
Step by step
Solved in 2 steps