Refer to Exercise 8.29. 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:
Additional information is as follows:
- a. Depreciation on the office equipment belongs to the office management activity.
- b. Of the $21,000 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,400 per year is attributable to Internet connections and fees, and the bulk of these costs (80 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:
- 1. Prepare an activity-based budget for next year by activity. Use the expected level of sales activity.
- 2. On the basis of the budget prepared in Requirement 1, advise Gene regarding actions that might be taken to reduce expenses.
Olympus, Inc., manufactures three models of mattresses: the Sleepeze, the Plushette, and the Ultima.
- a. Salaries for his office (including himself at $65,000, a
marketing research assistant at $40,000, and an administrative assistant at $25,000) are budgeted for $130,000 next year. - b. Depreciation on the offices and equipment is $20,000 per year.
- c. Office supplies and other expenses total $21,000 per year.
- d. Advertising has been steady at $20,000 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 $50 per unit sold. Gene expects the Ultima line to ship for $75 per unit sold since this model features a larger mattress.
Required:
- 1. Suppose that Gene is considering three sales scenarios as follows:
Prepare a revenue budget for the Sales Division for the coming year for each scenario.
- 2. Prepare a flexible expense budget for the Sales Division for the three scenarios above.
Trending nowThis is a popular solution!
Chapter 8 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Assume you are the manager for the semi-trucks division at the Speedy Delivery Company. The semi-truck division is a cost center and you are reviewing the driver overtime costs for the previous year, shown here: A. Microsoft Excel or another spreadsheet application, create a line chart with markers showing the driver overtime expense. Describe your observations. B. Knowing that safety is important in your industry and weather plays a significant role in the safety of drivers, you decide to talk with the safety manager and obtained the following information: Using Microsoft Excel or another spreadsheet application, create individual line charts with markers showing the average snowfall and non-company highway accidents. Describe your observations and actions you might consider.arrow_forwardOhio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deliver their customers material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous years. a. Sort the carriers in descending order by their current years percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excels conditional formatting to highlight the carriers whose on-time percentage decreased from the previous year to the current year. c. Use Excels conditional formatting tool to create data bars for the change in percentage of on-time deliveries from the previous year to the current year for each carrier calculated in part b. d. Which carriers should Ohio Logistics try to use in the future? Why?arrow_forwardVentana Window and Wall Treatments Company provides draperies, shades, and various window treatments. Ventana works with the customer to design the appropriate window treatment, places the order, and installs the finished product. Direct materials and direct labor costs are easy to trace to the jobs. Ventanas income statement for last year is as follows: Ventana wants to find a markup on cost of goods sold that will allow them to earn about the same amount of profit on each job as was earned last year. Required: 1. What is the markup on cost of goods sold (COGS) that will maintain the same profit as last year? (Round the percentage to two significant digits.) 2. A customer orders draperies and shades for a remodeling job. The job will have the following costs: What is the price that Ventana will quote given the markup percentage calculated in Requirement 1? (Round the price to the nearest dollar.) 3. What if Ventana wants to calculate a markup on direct materials cost, since it is the largest cost of doing business? What is the markup on direct materials cost that will maintain the same profit as last year? (Round the percentage to two significant digits.) What is the bid price Ventana will use for the job given in Requirement 2 if the markup percentage is calculated on the basis of direct materials cost? (Round to the nearest dollar.)arrow_forward
- Assign the customer-related activity costs to each customer type using activity rates. Now calculate the profitability of each customer category. As a manager, how would you use this information? Emery Company sells small machine parts to heavy equipment manufacturers for an average price of 1.05 per part. There are two types of customers: those who place small, frequent orders and those who place larger, less frequent orders. Each time an order is placed and processed, a setup is required. Scheduling is also needed to coordinate the many different orders that come in and place demands on the plants manufacturing resources. Emery also inspects a sample of the products each time a batch is produced to ensure that the customers specifications have been met Inspection takes essentially the same time regardless of the type of part being produced. Emerys Cost Accounting Department has provided the following budgeted data for customer-related activities and costs (the amounts expected for the coming year): Required: 1. Assign the customer-related activity costs to each category of customers in proportion to the sales revenue earned by each customer type. Calculate the profitability of each customer type. Discuss the problems with this measure of customer profitability.arrow_forwardIn today's fast-paced business environment, decision making is a critical task for managers. Making the right decisions is vital to the success of a company, and it requires access to relevant information. Cari Pump (CP) Company manufactures water pumps. An important part of the pump is its electronic component (EC). Cari Pump collects data with the following cost information about the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020) Fixed manufacturing cost Fixed manufacturing overhead costs that can be avoided if ECs are not made 360,000 360,000 Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if ECs are not made 850,000 850,000 Variable manufacturing costs Direct material cost per EC…arrow_forwardIn today's fast-paced business environment, decision making is a critical task for managers. Making the right decisions is vital to the success of a company, and it requires access to relevant information. Cari Pump (CP) Company manufactures water pumps. An important part of the pump is its electronic component (EC). Cari Pump collects data with the following cost information about the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020) Fixed manufacturing cost Fixed manufacturing overhead costs that can be avoided if ECs are not made Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if ECs are not made Variable manufacturing costs Direct material cost per EC Direct manufacturing labor cost per EC Variable manufacturing cost per batch for setups, Materials handling, and quality control 360,000 850,000 $ 200 60 2,000 360,000 850,000 $ 190 55 1,800arrow_forward
- In today's fast-paced business environment, decision making is a critical task for managers. Making the right decisions is vital to the success of a company, and it requires access to relevant information. Cari Pump (CP) Company manufactures water pumps. An important part of the pump is its electronic component (EC). Cari Pump collects data with the following cost information about the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020) Fixed manufacturing cost Fixed manufacturing overhead costs that can be avoided if ECs are not made 360,000 360,000 Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if ECs are not made 850,000 850,000 Variable manufacturing costs Direct material cost per EC…arrow_forwardIn today's fast-paced business environment, decision making is a critical task for managers. Making the right decisions is vital to the success of a company, and it requires access to relevant information. Cari Pump (CP) Company manufactures water pumps. An important part of the pump is its electronic component (EC). Cari Pump collects data with the following cost information about the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020) Fixed manufacturing cost Fixed manufacturing overhead costs that can be avoided if ECs are not made 360,000 360,000 Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if ECs are not made 850,000 850,000 Variable manufacturing costs Direct material cost per EC…arrow_forwardCase Study- please show the full workings.In today's fast-paced business environment, decision-making is a critical task for managers.Making the right decisions is vital to a company's success, and it requires access torelevant information.Cari Pump (CP) Company manufactures water pumps. An important part of the pump is itsthe electronic component (EC). Cari Pump collects data with the following cost informationabout the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020)Fixed manufacturing costFixed manufacturing overhead costs thatcan be avoided if ECs are not made 360,000 360,000Fixed manufacturing overhead costs of the plantDepreciation, insurance, and administration thatcannot be avoided even if ECs are not made 850,000 850,000Variable manufacturing costsDirect material cost per EC $ 200 $ 190Direct manufacturing labor cost per EC 60 55Variable manufacturing cost per batch for setups,Materials handling, and quality control 2,000…arrow_forward
- Strategic decisions and management accounting. Consider the following series of independent situations in which a firm is about to make a strategic decision. Decisions A running shoe manufacturer is weighing whether to purchase leather from a cheaper supplier in order to compete with lower priced competitors. An office supply store is considering adding a delivery service that its competitors do not have. A regional retailer is deciding whether to install self-check-out counters. This technology will reduce the number of check-out clerks required in the store. A local florist is considering hiring a horticulture specialist to help customers with gardening questions. For each decision, state whether the company is following a cost leadership or a product differentiation strategy. 2. For each decision, discuss what information the managerial accountant can provide about the source of competitive advantage for these firms.arrow_forwardIn today's fast-paced business environment, decision making is a critical task for managers. Making the right decisions is vital to the success of a company, and it requires access to relevant information. Cari Pump (CP) Company manufactures water pumps. An important part of the pump is its electronic component (EC). Cari Pump collects data with the following cost information about the costs of making ECs in 2019 and the expected costs in 2020: Current Costs (2019) Expected Costs (2020) Fixed manufacturing cost Fixed manufacturing overhead costs that can be avoided if ECs are not made 360,000 360,000 Fixed manufacturing overhead costs of plant depreciation, insurance, and administration that cannot be avoided even if ECs are not made 850,000 850,000 Variable manufacturing costs Direct material cost per EC…arrow_forwardPlanning and control decisions. Gregor Company makes and sells brooms and mops. It takes the following actions, not necessarily in the order given. For each action, state whether it is a planning decision or a control decision. Gregor asks its advertising team to develop fresh advertisements to market its newest product. Gregor calculates customer satisfaction scores after introducing its newest product. Gregor compares costs it actually incurred with costs it expected to incur for the production of the new product. Gregor’s design team proposes a new product to compete directly with the Swiffer. Gregor estimates the costs it will incur to distribute 30,000 units of the new product in the first quarter of next fiscal year.arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning