SPU, Ltd., has just received its sales expense report for January, which follows
ID: 2585420 • Letter: S
Question
SPU, Ltd., has just received its sales expense report for January, which follows.
SPU, Ltd., has just received its sales expense report for January, which follows. Item Sales commissions Sales staff salaries Telephone and mailing Building lease payment Utilitics Packaging and delivery Amount $440,500 90,400 47,000 50,000 11,100 82,000 37,750 54,190 Marketing consultants 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 4 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 4 percent regardless of sales volume. Depreciation includes furniture and fixtures used by the sales staff. The company has just acquired an additional $52,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.) Budge Item Month Sales commissions Sales staff salaries Telephone and mailing Building lease payment Utilities Packaging and delivery Depreciation Marketing consultants Total budgeted costsExplanation / Answer
Answer:
Budgeted
Item
Sales commissions
451953
Sales staff salaries
94016
Telephone & mailing
55723.2
Building lease payment
50,000
Utilities
11544
Packaging & delivery
93480
Depreciation
38,183
Marketing consultants
$64,500
Total budgeted costs
859399.5
Working notes for the answer
Budgeted
Item
Current
Adjustments
Sales commissions
440,500
x
1.14 x 0.90
451953
Sales staff salaries
90,400
x
1.04
94016
Telephone & mailing
47,000
x
1.14 x 1.04
55723.2
Building lease payment
50,000
x
Unchange
50,000
Utilities
11,100
x
1.04
11544
Packaging & delivery
82,000
x
1.14
93480
Depreciation
37,750
+
,+($52,000 ÷ 120 months)
38,183
Marketing consultants
0
+
$64,500
$64,500
Total budgeted costs
859399.5
Budgeted
Item
Sales commissions
451953
Sales staff salaries
94016
Telephone & mailing
55723.2
Building lease payment
50,000
Utilities
11544
Packaging & delivery
93480
Depreciation
38,183
Marketing consultants
$64,500
Total budgeted costs
859399.5
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.