Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

New Town Foods sells a variety of packaged foods through supermarkets and other outlets using a dedicated sales team. The budget planning group has just

New Town Foods sells a variety of packaged foods through supermarkets and other outlets using a dedicated sales team. The budget planning group has just received the sales team expense summary for the third quarter, which follows:

Item Amount
Sales commissions $ 520,000
Sales staff salaries 122,000
Building lease payment 76,000
Telephone and mailing 61,000
Packaging and delivery 104,000
Utilities 16,000
Depreciation 47,600
Marketing consultants 75,000

You have been asked to develop budgeted costs for the coming year. Because the third quarter is typical, the budget team develops the annual budget by starting with the budget for a "typical" quarter, based on the current experience adjusted for expected changes in the coming period. These expected changes include the following:

  • Sales volume is expected to increase by 10 percent.
  • Sales prices are expected to increase by 5 percent.
  • Commissions are based on a percentage of sales revenue.
  • Sales staff salaries will increase 3 percent next year regardless of sales volume.
  • Building lease cost is based on a five-year lease that expires this year. Based on the local real estate market, the cost of the lease is expected to increase by 6 percent.
  • Telephone and mailing expenses are variable with the number of units sold. In addition, the unit costs for these expenses are expected to decrease by 8 percent even with no change in sales volume.
  • Packaging and delivery costs are variable with unit sales volume. Unit packaging and delivery costs are expected to increase by 5 percent next year.
  • Utilities costs are scheduled to decrease by 6 percent regardless of sales volume.
  • Depreciation includes furniture and fixtures used by the sales staff. The company has just acquired an additional $76,800 in furniture that will be received at the start of next year and will be depreciated over an 8-year life using the straight-line method. At the same time, fixtures with a quarterly depreciation of $6,300 will be scrapped.
  • 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 $93,000 per quarter.

Required:

Prepare a budget for sales expenses for a typical quarter in the coming year.

Note: Do not round intermediate calculations. Round your final answers to nearest whole dollar amount.

image text in transcribed

\begin{tabular}{|l|l|} \hline \multicolumn{1}{|c|}{ Item } & BudgetedTypicalQuarter \\ \hline Sales commissions & \\ \hline Sales staff salaries & \\ \hline Building lease payment & \\ \hline Telephone \& mailing & \\ \hline Packaging \& delivery & \\ \hline Utilities & \\ \hline Depreciation & $ \\ \hline Marketing consultants & \\ \hline \multicolumn{1}{|c|}{ Total budgeted costs } & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions