a. Depreciation on the office equipment belongs to the office management activity. b. Of the $23,300 for office supplies and other expenses, $4,800 can be assigned to telephone costs which can be split evenly between the shipping and jobbers' activities. Am additional $3,000 per year is attributable to Internet connections and fees, and the bulk of these costs (85 percent) are assignable to research. The remainder is a cost of c management. All other office supplies and costs are assigned to the office management activity. Required: 1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity. If required, round answers to the nearest dollar. Olympus, Inc. Activity-Based Budget For Next Year Research: Salaries Internet connections Shipping: Salaries Telephone Ship Sleepeze

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
Activity-Based Budget
Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,030 for the Sleepeze, 12,080 for the
Plushette, and 4,560 for the Ultima. Gene Dixon, vice president of sales, has provided the following information:
a. Salaries for his office (including himself at $65,450, a marketing research assistant at $45,000, and an administrative assistant at $24,800) are budgeted for $135,250 next
year.
b. Depreciation on the offices and equipment is $17,450 per year.
c. Office supplies and other expenses total $23,300 per year.
d. Advertising has been steady at $17,850 per year. However, the Ultima is a new product and will require extensive advertising to educate consumers on the unique features of
this high-end mattress. Gene believes the company should spend 15 percent of first-year Ultima sales for a print and television campaign.
e. Commissions on the Sleepeze and Plushette lines are 5 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores.
f. Last year, shipping for the Sleepeze and Plushette lines averaged $45 per unit sold. Gene expects the Ultima line to ship for $70 per unit sold since this model features a larger
mattress.
Suppose that Gene is considering three sales scenarios as follows:
Pessimistic
Expected
Optimistic
Price Quantity Price Quantity Price Quantity
Sleepeze
$184
12,560
$201
15,030
$201
18,090
Plushette
306
9,720
355
12,080
365
14,030
Ultima
880
1,910
950
4,560
1,140
4,560
Suppose Gene determines that next year's Sales Division activities include the following:
Research-researching current and future conditions in the industry
Shipping-arranging for shipping of mattresses and handling calls from purchasing agents at retail stores to trace shipments and correct errors
Jobbers-coordinating the efforts of the independent jobbers who sell the mattresses
Basic ads-placing print and television ads for the Sleepeze and Plushette lines
Ultima ads-choosing and working with the advertising agency on the Ultima account
Office management-operating the Sales Division office
The percentage of time spent by each employee of the Sales Division on each of the above activities is given in the following table:
Research
Administrative
Gene
Assistant
Assistant
Research
75%
Shipping
25%
20%
Jobbers
15
10
20
Basic ads
15
40
Ultima ads
35
10
Office management
25
10
Additional information is as follows:
a. Depreciation on the office equipment belongs to the office management activity.
b. Of the $23,300 for office supplies and other expenses, $4,800 can be assigned to telephone costs which can be split evenly between the shipping and jobbers' activities. An
additional $3,000 per year is attributable to Internet connections and fees, and the bulk of these costs (85 percent) are assignable to research. The remainder is a cost of office
mananemant All other office sunnlies and costs are assioned to the office mananement actisit
Transcribed Image Text:Activity-Based Budget Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,030 for the Sleepeze, 12,080 for the Plushette, and 4,560 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: a. Salaries for his office (including himself at $65,450, a marketing research assistant at $45,000, and an administrative assistant at $24,800) are budgeted for $135,250 next year. b. Depreciation on the offices and equipment is $17,450 per year. c. Office supplies and other expenses total $23,300 per year. d. Advertising has been steady at $17,850 per year. However, the Ultima is a new product and will require extensive advertising to educate consumers on the unique features of this high-end mattress. Gene believes the company should spend 15 percent of first-year Ultima sales for a print and television campaign. e. Commissions on the Sleepeze and Plushette lines are 5 percent of sales. These commissions are paid to independent jobbers who sell the mattresses to retail stores. f. Last year, shipping for the Sleepeze and Plushette lines averaged $45 per unit sold. Gene expects the Ultima line to ship for $70 per unit sold since this model features a larger mattress. Suppose that Gene is considering three sales scenarios as follows: Pessimistic Expected Optimistic Price Quantity Price Quantity Price Quantity Sleepeze $184 12,560 $201 15,030 $201 18,090 Plushette 306 9,720 355 12,080 365 14,030 Ultima 880 1,910 950 4,560 1,140 4,560 Suppose Gene determines that next year's Sales Division activities include the following: Research-researching current and future conditions in the industry Shipping-arranging for shipping of mattresses and handling calls from purchasing agents at retail stores to trace shipments and correct errors Jobbers-coordinating the efforts of the independent jobbers who sell the mattresses Basic ads-placing print and television ads for the Sleepeze and Plushette lines Ultima ads-choosing and working with the advertising agency on the Ultima account Office management-operating the Sales Division office The percentage of time spent by each employee of the Sales Division on each of the above activities is given in the following table: Research Administrative Gene Assistant Assistant Research 75% Shipping 25% 20% Jobbers 15 10 20 Basic ads 15 40 Ultima ads 35 10 Office management 25 10 Additional information is as follows: a. Depreciation on the office equipment belongs to the office management activity. b. Of the $23,300 for office supplies and other expenses, $4,800 can be assigned to telephone costs which can be split evenly between the shipping and jobbers' activities. An additional $3,000 per year is attributable to Internet connections and fees, and the bulk of these costs (85 percent) are assignable to research. The remainder is a cost of office mananemant All other office sunnlies and costs are assioned to the office mananement actisit
8: Problems for Budgeting Part 2
a. Depreciation on the office equipment belongs to the office management activity.
b. Of the $23,300 for office supplies and other expenses, $4800 can be assigned to telephone costs which can be split evenly betvween the shipping and jobbers' activities. An
additional $3,000 per year is attributable to Internet connections and fees, and the bulk of these costs (85 percent) are assignable to research. The remainder is a cost of offic
management. All other office supplies and costs are assigned to the office management activity.
Required:
1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity. If required, round answers to the nearest dollar.
Olympus, Inc.
Activity-Based Budget
For Next Year
Research:
Salaries
Internet connections
Shipping:
Salaries
Telephone
Ship Sleepeze
Ship Plushette
Ship Ultima
Jobbers:
Salaries
Telephone
Commissions
Basic ads:
Salaries
Advertising
Ultima ads:
Salaries
Advertising
Office management:
Salaries
Depreciation
office Supplies
Total
2. On the basis of the budget prepared in Requirement 1, advise Gene regarding actions that might be taken to reduce expenses.
Gene should focus on the most costly activities: shipping, Ultima advertising and commissions to jobbers.
Transcribed Image Text:8: Problems for Budgeting Part 2 a. Depreciation on the office equipment belongs to the office management activity. b. Of the $23,300 for office supplies and other expenses, $4800 can be assigned to telephone costs which can be split evenly betvween the shipping and jobbers' activities. An additional $3,000 per year is attributable to Internet connections and fees, and the bulk of these costs (85 percent) are assignable to research. The remainder is a cost of offic management. All other office supplies and costs are assigned to the office management activity. Required: 1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity. If required, round answers to the nearest dollar. Olympus, Inc. Activity-Based Budget For Next Year Research: Salaries Internet connections Shipping: Salaries Telephone Ship Sleepeze Ship Plushette Ship Ultima Jobbers: Salaries Telephone Commissions Basic ads: Salaries Advertising Ultima ads: Salaries Advertising Office management: Salaries Depreciation office Supplies Total 2. On the basis of the budget prepared in Requirement 1, advise Gene regarding actions that might be taken to reduce expenses. Gene should focus on the most costly activities: shipping, Ultima advertising and commissions to jobbers.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Depletion Accounting
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
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