SPU, Ltd., has just received its sales expense report for January, which follows. Item Amount Sales commissions $ 430,500 Sales staff salaries 88,400 Telephone and mailing 51,000 Building lease payment 50,000 Utilities 16,100 Packaging and delivery 74,000 Depreciation 38,750 Marketing consultants 61,190 You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data: Sales volume is expected to increase by 14 percent. Sales prices are expected to decrease by 10 percent. Commissions are based on a percentage of sales revenue. Sales staff salaries will increase 4 percent next year regardless of sales volume. Building rent is based on a five-year lease that expires in three years. Telephone and mailing expenses are scheduled to increase by 10 percent even with no change in sales volume. However, these costs are variable with the number of units sold, as are packaging and delivery costs. Utilities costs are scheduled to increase by 5 percent regardless of sales volume. Depreciation includes furniture and fixtures used by the sales staff. The company has just acquired an additional $54,000 in furniture that will be received at the start of next year and will be depreciated over a 10-year life using the straight-line method. Marketing consultant expenses were for a special advertising campaign that runs from time to time. During the coming year, these costs are expected to average $64,500 per month. Required: Prepare a budget for sales expenses for a typical month in the coming year. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.)
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.
SPU, Ltd., has just received its sales expense report for January, which follows.
Item | Amount | |
Sales commissions | $ | 430,500 |
Sales staff salaries | 88,400 | |
Telephone and mailing | 51,000 | |
Building lease payment | 50,000 | |
Utilities | 16,100 | |
Packaging and delivery | 74,000 | |
Depreciation | 38,750 | |
Marketing consultants | 61,190 | |
You have been asked to develop budgeted costs for the coming year. Because this month is typical, you decide to prepare an estimated budget for a typical month in the coming year and you uncover the following additional data:
- Sales volume is expected to increase by 14 percent.
- Sales prices are expected to decrease by 10 percent.
- Commissions are based on a percentage of sales revenue.
- Sales staff salaries will increase 4 percent next year regardless of sales volume.
- Building rent is based on a five-year lease that expires in three years.
- Telephone and mailing expenses are scheduled to increase by 10 percent even with no change in sales volume. However, these costs are variable with the number of units sold, as are packaging and delivery costs.
- Utilities costs are scheduled to increase by 5 percent regardless of sales volume.
- Depreciation includes furniture and fixtures used by the sales staff. The company has just acquired an additional $54,000 in furniture that will be received at the start of next year and will be
depreciated over a 10-year life using the straight-line method. - Marketing consultant expenses were for a special advertising campaign that runs from time to time. During the coming year, these costs are expected to average $64,500 per month.
Required:
Prepare a budget for sales expenses for a typical month in the coming year. (Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps