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.)

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
100%

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.)

 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education