Question

In: Accounting

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

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

Solutions

Expert Solution

Item

Budgeted typical month

Sales commissions

$451,953

Sales staff salaries

$91,936

Telephone and mailing

$60,329

Building lease payment

$60,000

Utilities

$22,763

Packaging and delivery

$94,620

Depreciation

$38,175

Marketing consultant

$64,500

Total budgeted cost

$884,276

Explanation:

Items

January

Adjustments

Budgeted typical month

Sales commissions

$440,500

$440,500 × 1.14×0.9

$451,953

Sales staff salaries

$88,400

$88,400 × 1.04

$91,936

Telephone and mailing

$49,000

$49,000 ×1.08 ×1.14

$60,329

Building lease payment

$60,000

unchanged

$60,000

Utilities

$22,100

22,100 × 1.03

$22,763

Packaging and delivery

$83,000

$83,000 ×1.14

$94,620

Depreciation

$37,750

($51,000 ÷120 months) =425 + 37,750 = 34,192

$38,175

Marketing consultant

$64,500

$64,500

Total budgeted cost

$884,276

I hope it is useful to u if u have any doubt pls comment give me up thumb


Related Solutions

Masters Ltd has just realised that it has a problem with sales data as its sales...
Masters Ltd has just realised that it has a problem with sales data as its sales order system records sales to customers that subsequently fail a credit check. a) What decisions made during the revenue cycle would be affected by this data problem? How can the problem be corrected? __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ b) How would this data problem affect the performance of the revenue cycle? __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ __________________________________________________________________________________ Question 3 continued next page Practice...
Sefam Ltd owns an item of plant which has a carrying amount of Rs. 2,480,000 as...
Sefam Ltd owns an item of plant which has a carrying amount of Rs. 2,480,000 as at 1 April 2014. It is being depreciated at 12½% per annum on a reducing balance basis. The plant is used to manufacture a line of fabric which has been suffering a slow decline in sales. Sefam has estimated that the plant will be retired from use on 31 March 2018. The estimated net cash flows from the use of the plant and their...
Which line item is not an expense? A. Sales and Marketing B. General and Administrative C....
Which line item is not an expense? A. Sales and Marketing B. General and Administrative C. Property, Plant, and Equipment D. Training and Professional Development Which financial report most used by nonfinancial managers. A. Balance Sheet B. Cash Flow Statement C. Income Statement D. Statement of Retained Earnings What are the different names for the income statement? Select all that apply: A. Profit and Loss Statement B. Gross Profit and Loss Statement C. Net Margin Statement D. Statement of income...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: January...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales for Item CZ83 are as follows: January 1 Inventory 96 units @ $16 5 Sale 77 units 11 Purchase 107 units @ $20 21 Sale 90 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on January 21 and (b) the inventory on January 31. a. Cost of merchandise sold on January 21 $ b. Inventory on January 31 $
ABC Ltd. is a computer manufacturer and has just received the results of a market research...
ABC Ltd. is a computer manufacturer and has just received the results of a market research study to determine if the company should introduce a new product line. The expected duration of the project is 6 years. The cost for market research study is $150,000. Sue is the project manager and she has gathered the following information: • Annual cash sale is $600,000 in the first two years, and starts to increase by 4% per year thereafter Expected costs is...
The Milwaukee Theatre Guild has just received an anonymous $250,000 donation to be used as follows:...
The Milwaukee Theatre Guild has just received an anonymous $250,000 donation to be used as follows: $7500 block grants to children’s theatre groups, $6000 grants for new playwrights, and $5000 grants for theatre scholarships. The donor has stipulated that at least eight children’s theatre groups must be funded. Other than that, the Guild may award the donation any way it sees fit. The Guild has determined the following goals: Award at least 40 block grants (children’s theatre). Give at least...
The Ace Battery Company has forecast its sales in units as follows:   January 1,900 May 2,450...
The Ace Battery Company has forecast its sales in units as follows:   January 1,900 May 2,450   February 1,750 June 2,600   March 1,700 July 2,300   April 2,200 Ace always keeps an ending inventory equal to 130 percent of the next month's expected sales. The ending inventory for December (January's beginning inventory) is 2,470 units, which is consistent with this policy. Materials cost $14 per unit and are paid for in the month after production. Labour cost is $7 per unit and...
The Volt Battery Company has forecast its sales in units as follows: January 3,200 May 3,750...
The Volt Battery Company has forecast its sales in units as follows: January 3,200 May 3,750 February 3,050 June 3,900 March 3,000 July 3,600 April 3,500 Volt Battery always keeps an ending inventory equal to 140% of the next month’s expected sales. The ending inventory for December (January’s beginning inventory) is 4,480 units, which is consistent with this policy.    Materials cost $15 per unit and are paid for in the month after purchase. Labor cost is $8 per unit...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance...
Churros Ltd received its bank statement for the month of January 2020 showing a credit balance of $4,188.30 as at 31 January 2020. The cash balance on the company’s books at 1 January 2020 was $176.00 (debit). The progressive totals of the Cash Receipts Journal and the Cash Payments Journal before considering items 1 to 5 below were $21,475.40 and $17,622.10 respectively. The following reconciling items were identified: (1) Un-presented cheques amounted to $501.25. (2) Debits included in the bank...
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019,...
Balance Sheet & Income Statement Coast Ltd., which has just started trading on 1 January 2019, has the following account balances prior to the recording of the final month of the year: Account Balances as at 30 November 2019 Account $ Cash $3 000 Accounts receivable $3 400 Stock of Supplies $17 600 Rent $3 300 Property, Plant & Equipment - cost $36 000 Accounts payable $4 700 Bank Loan $9 000 Contributed capital (16 600 shares) $26 600 Sales...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT