Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SPU, Ltd., has just received its sales expense report for January, which follows. Item Amount Sales commissions $ 440,500 Sales staff salaries 88,400 Telephone and

SPU, Ltd., has just received its sales expense report for January, which follows.

Item Amount
Sales commissions $ 440,500
Sales staff salaries 88,400
Telephone and mailing 49,000
Building lease payment 60,000
Utilities 22,100
Packaging and delivery 83,000
Depreciation 37,750
Marketing consultants 60,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 8 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 3 percent regardless of sales volume.
  • Depreciation includes furniture and fixtures used by the sales staff. The company has just acquired an additional $51,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.)

Item Budgeted Typical Month
Sales commissions
Sales staff salaries
Telephone and mailing
Building lease payment
Utilities
Packaging and delivery
Depreciation
Marketing consultants
Total budgeted costs

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

5th edition

978-1259728877, 1259728870, 978-1259565403

More Books

Students also viewed these Accounting questions

Question

What does the coefficient of determination measure?

Answered: 1 week ago