Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,260 for the Sleepeze, 11,840 for the Plushette, and 4,950 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: a. Salaries for his office (including himself at $64,750, a marketing research assistant at $35,800, and an administrative assistant at $27,150) are budgeted for $127,700 next year. b. Depreciation on the offices and equipment is $17,650 per year. c. Office supplies and other expenses total $22,400 per year. d. Advertising has been steady at $22,250 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 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 $55 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 Sleepeze $189 12,320 Price Quantity Price Quantity $210 15,260 $210 17,730 295 10,080 337 11,840 350 13,730 900 2,260 1,000 4,950 1,190 4,950 Plushette Ultima 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 Gene Assistant Administrative Assistant

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

Activity-Based Budget

 

Activity-Based Budget
Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima. Forecast sales for next year are 15,260 for the Sleepeze, 11,840 for the Plushette, and 4,950 for the Ultima. Gene Dixon, vice president of
sales, has provided the following information:
a. Salaries for his office (including himself at $64,750, a marketing research assistant at $35,800, and an administrative assistant at $27,150) are budgeted for $127,700 next year.
b. Depreciation on the offices and equipment is $17,650 per year.
c. Office supplies and other expenses total $22,400 per year.
d. Advertising has been steady at $22,250 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 20
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 $55 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
Sleepeze $189 12,320 $210 15,260 $210
Plushette 295 10,080 337 11,840 350
900 2,260 1,000 4,950 1,190
Quantity Price Quantity
17,730
13,730
4,950
Ultima
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
Assistant
70%
Research
Shipping
Jobbers
Gene
30%
10
10
Administrative
Assistant
25%
15
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,260 for the Sleepeze, 11,840 for the Plushette, and 4,950 for the Ultima. Gene Dixon, vice president of sales, has provided the following information: a. Salaries for his office (including himself at $64,750, a marketing research assistant at $35,800, and an administrative assistant at $27,150) are budgeted for $127,700 next year. b. Depreciation on the offices and equipment is $17,650 per year. c. Office supplies and other expenses total $22,400 per year. d. Advertising has been steady at $22,250 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 20 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 $55 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 Sleepeze $189 12,320 $210 15,260 $210 Plushette 295 10,080 337 11,840 350 900 2,260 1,000 4,950 1,190 Quantity Price Quantity 17,730 13,730 4,950 Ultima 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 Assistant 70% Research Shipping Jobbers Gene 30% 10 10 Administrative Assistant 25% 15
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
Assistant
70%
Research
Shipping
Jobbers
Basic ads.
Research:
Gene
Shipping:
30%
10
Jobbers:
-
Ultima ads
30
Office management
30
Additional information is as follows:
a. Depreciation on the office equipment belongs to the office management activity.
b. Of the $22,400 for office supplies and other expenses, $5,000 can be assigned to telephone costs which can be split evenly between the shipping and jobbers' activities. An additional $2,900 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 management. All other office supplies and costs are assigned to the office management activity.
Required:
10
20
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
Administrative
Assistant
QO000 QO
25%
15
30
10
20
Transcribed Image Text: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 Assistant 70% Research Shipping Jobbers Basic ads. Research: Gene Shipping: 30% 10 Jobbers: - Ultima ads 30 Office management 30 Additional information is as follows: a. Depreciation on the office equipment belongs to the office management activity. b. Of the $22,400 for office supplies and other expenses, $5,000 can be assigned to telephone costs which can be split evenly between the shipping and jobbers' activities. An additional $2,900 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 management. All other office supplies and costs are assigned to the office management activity. Required: 10 20 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 Administrative Assistant QO000 QO 25% 15 30 10 20
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

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