Assignment Material

Questions

  1. 15-1. “I’m going to focus on the customers of my business and leave cost-allocation issues to my accountant.” Do you agree with this comment by a division president? Explain.
  2. 15-2. Why is customer-profitability analysis an important topic for managers?
  3. 15-3. How can a company track the extent of price discounting on a customer-by-customer basis?
  4. 15-4. “A customer-profitability profile highlights those customers a company should drop to improve profitability.” Do you agree? Explain.
  5. 15-5. Give examples of three different levels of costs in a customer-cost hierarchy.
  6. 15-6. What information does the whale curve provide?
  7. 15-7. “A company should not allocate all of its corporate costs to its divisions.” Do you agree? Explain.
  8. 15-8. What criteria might managers use to guide cost-allocation decisions? Which are the dominant criteria?
  9. 15-9. “Once a company allocates corporate costs to divisions, these costs should not be reallocated to the indirect-cost pools of the division.” Do you agree? Explain.
  10. 15-10. “A company should not allocate costs that are fixed in the short run to customers.” Do you agree? Explain briefly.
  11. 15-11. How should a company decide on the number of cost pools it should use to allocate costs to divisions, channels, and customers?
  12. 15-12. Show how managers can gain insight into the causes of a sales-volume variance by subdividing the components of this variance.
  13. 15-13. How can the concept of a composite unit be used to explain why an unfavorable total sales-mix variance of contribution margin occurs?
  14. 15-14. Explain why a favorable sales-quantity variance occurs.
  15. 15-15. How can the sales-quantity variance be decomposed further?

Multiple-Choice Questions

In partnership with Becker professional education
  1. 15-16. FLEXIBLE-BUDGET VARIANCE, SALES-QUANTITY, MARKET-SIZE, AND MARKET-SHARE VARIANCE. The actual contribution margin per unit will impact the following sales variance:
    1. a. Flexible-budget variance
    2. b. Market-size variance
    3. c. Market-share variance
    4. d. Sales-quantity variance
  2. 15-17. SALES-VOLUME, SALES-MIX, AND SALES-QUANTITY VARIANCE. Lexota, Inc., an auto manufacturer, reported the following budgeted and actual sales of its vehicles during September, Year 2: 
<p>A table shows budgeted and actual vehicle sales for Lexota, Inc.</p>

The table depicts budgeted units, budgeted sales, actual units, and actual sales for Power Lex 500 and Ota Gas Sipper. The details of the table are as follows:

1. Power Lex 500

2. Ota Gas Sipper

  1. The budgeted contribution margin is 20% for both vehicle types. Which of the following statements is true concerning the sales variances for Lexota, Inc. for September, Year 2?
    1. a. The sales-volume variance for the company is favorable.
    2. b. The sales-quantity variance for the company is unfavorable.
    3. c. The budgeted variable cost for each vehicle type is the same.
    4. d. The sales-mix variance for the company is unfavorable.

©2016 DeVry/Becker Educational Development Corp. All Rights Reserved.

Exercises

  1. 15-18. COST ALLOCATION IN HOSPITALS, ALTERNATIVE ALLOCATION CRITERIA. Dave McKnight vacationed at Lake Tahoe last winter. Unfortunately, he broke his ankle while skiing and spent 2 days at the Sierra University Hospital. McKnight’s insurance company received a $4,850 bill for his 2-day stay. One item that caught McKnight’s attention was a $11.75 charge for a roll of cotton. McKnight is a salesman for Johnson & Johnson and knows that the cost to the hospital of the roll of cotton is between $2.15 and $2.95. He asked for a breakdown of the $11.75 charge. The accounting office of the hospital sent him the following information:
<p>A table shows a breakdown of a line item on a hospital bill</p>

The table depicts a breakdown of a line item on a hospital bill. The details of the table are as follows:

1. Invoiced cost of cotton roll: 2.55 dollars

2. Cost of processing of paperwork for purchase: 0.56 dollar

3. Supplies-room management fee: 0.68 dollar

4. Operating-room and patient-room handling costs: 1.57 dollars

5. Administrative hospital costs: 1.01 dollars

6. University teaching-related costs: 0.58 dollar

7. Malpractice insurance costs: 1.23 dollars

8. Cost of treating uninsured patients: 3.00 dollars

9. Profit component: 0.57 dollar

10. Total: 11.75 dollars

  1. McKnight believes the overhead charge is outrageous. He comments, “There was nothing I could do about it. When they come in and dab your stitches, it’s not as if you can say, ‘Keep your cotton roll. I brought my own.’”
    1. Required
    2. 1. Compute the overhead rate Sierra University Hospital charged on the cotton roll.
    3. 2. What criteria might Sierra use to justify allocation of the overhead items b–i in the preceding list? Examine each item separately and use the allocation criteria listed in Exhibit 15-8 in your answer.
    4. 3. What should McKnight do about the $11.75 charge for the cotton roll?
  2. 15-19. CUSTOMER PROFITABILITY, CUSTOMER-COST HIERARCHY. Enviro-Tech has only two retail and two wholesale customers. Information relating to each customer for 2020 follows (in thousands):
Wholesale CustomersRetail Customers
North America WholesalerSouth America WholesalerGreen EnergyGlobal Power
Revenues at list prices$375,000$590,000$175,000$130,000
Discounts from list prices25,80047,2008,400590
Cost of goods sold285,000510,000144,00095,000
Delivery costs4,5506,7102,2302,145
Order processing costs3,8205,9802,1801,130
Costs of sales visits6,3002,6202,6201,575
  1. Enviro-Tech’s annual distribution-channel costs are $33 million for wholesale customers and $12 million for retail customers. The company’s annual corporate-sustaining costs, such as salary for top management and general-administration costs are $48 million. There is no cause-and-effect or benefits-received relationship between any cost-allocation base and corporate-sustaining costs. That is, Enviro-Tech could save corporate-sustaining costs only if the company completely shuts down.
    1. Required
    2. 1. Calculate customer-level operating income using the format in Exhibit 15-3.
    3. 2. Prepare a customer-cost hierarchy report, using the format in Exhibit 15-6.
    4. 3. Enviro-Tech’s management decides to allocate all corporate-sustaining costs to distribution channels: $38 million to the wholesale channel and $10 million to the retail channel. As a result, distribution channel costs are now $71 million ($33 million + $38 million) for the wholesale channel and $22 million ($12 million + $10 million) for the retail channel. Calculate the distribution-channel-level operating income. On the basis of these calculations, what actions, if any, should Enviro-Tech’s managers take? Explain.
    5. 4. How might Enviro-Tech use the new cost information from its activity-based costing system to better manage its business?
  2. 15-20. CUSTOMER PROFITABILITY, SERVICE COMPANY. Instant Service (IS) repairs printers and photocopiers for five multisite companies in a tristate area. IS’s costs consist of the cost of technicians and equipment that are directly traceable to the customer site and a pool of office overhead. Until recently, IS estimated customer profitability by allocating the office overhead to each customer based on share of revenues. For 2020, IS reported the following results:
Spreadsheet screenshot shows the various costs of Instant Service for its customers.

Details of the cost for five multisite companies are as follows:

(A) Avery

&bull; Revenues: $390,000

&bull; Technician and equipment cost: 273,000

&bull; Office overhead allocated: 47,789

&bull; Operating income: $69,211

(B) Okie

&bull; Revenues: $300,000

&bull; Technician and equipment cost: 262,500

&bull; Office overhead allocated: 36,760

&bull; Operating income: $740

(C) Wizard

&bull; Revenues: $483,000 

&bull; Technician and equipment cost: 337,500

&bull; Office overhead allocated: 59,186

&bull; Operating income: $86,314

(D) Grainger

&bull; Revenues: $183,000

&bull; Technician and equipment cost: 160,500

&bull; Office overhead allocated: 22,423

&bull; Operating income: $77

(E) Duran

&bull; Revenues: $318,000

&bull; Technician and equipment cost: 267,500

&bull; Office overhead allocated: 38,967

&bull; Operating income: $12,033

(F) Total

&bull; Revenues: $1,674,000

&bull; Technician and equipment cost: 1,300,500

&bull; Office overhead allocated: 205,125

&bull; Operating income: $168,375

  1. Abby Costa, IS’s new controller, notes that office overhead is more than 10% of total costs, so she spends a couple of weeks analyzing the consumption of office overhead resources by customers. She collects the following information:
Spreadsheet screenshot shows the activity area and cost driver rate of IS.

Details of the cost driver rate for each activity area are as follows:

  1. Activity area: Service call handling

    • Cost driver rate: $85 per service call

  2. Activity area: Parts ordering

    • Cost driver rate: $80 per Web-based parts order

  3. Activity area: Billing and collection

    • Cost driver rate: $50 per bill (or reminder)

Spreadsheet screenshot shows the number of service calls, web-based parts orders, bill or reminders for five companies.

Avery

Okie

Wizard

Grainger

Duran

    1. Required
    2. 1. Compute customer-level operating income using the new information that Costa has gathered.
    3. 2. Prepare exhibits for IS similar to Exhibits 15-4 and 15-5. Comment on the results.
    4. 3. What options should IS consider, with regard to individual customers, in light of the new data and analysis of office overhead?
  1. 15-21. CUSTOMER PROFITABILITY, DISTRIBUTION. HQ Drugs is a distributor of pharmaceutical products. Its ABC system has five activities:
<p>A table shows five activities and their cost driver rates in 2017 for HQ drugs</p>

The table depicts five activities and their cost driver rates in 2017 for HQ Drugs. The details of the table are as follows:

1. Order processing: 44 dollars per order

2. Line-item ordering: 2 dollars per line item

3. Store deliveries: 50 dollars per store delivery

4. Carton deliveries: 5 dollars per carton

5. Shelf-stocking: 12 dollars per stocking-hour

  1. Rick Flair, the controller of HQ Drugs, wants to use this ABC system to examine individual customer profitability within each distribution market. He focuses first on the Ma and Pa single-store distribution market. Using only two customers helps highlight the insights available with the ABC approach. Data pertaining to these two customers in August 2020 are as follows:
<p>A table shows data for two customers of HQ Drugs for August 2020</p>

The table depicts data for two customers of HQ Drugs for August 2020. The details of the table are as follows:

1. Total orders

2. Average line items per order

3. Total store deliveries

4. Average cartons shipped per store delivery

5. Average hours of shelf-stocking per store delivery

6. Average revenue per delivery

7. Average cost of goods sold per delivery

  1. Required
  2. 1. Use the ABC information to compute the operating income of each customer in August 2020. Comment on the results and what, if anything, Flair should do.
  3. 2. Flair ranks the individual customers in the Ma and Pa single-store distribution market on the basis of monthly operating income. The cumulative operating income of the top 20% of customers is $55,680. HQ Drugs reports operating losses of $18,290 for the bottom 40% of its customers. Make four recommendations that you think HQ Drugs should consider in light of this new customer-profitability information.
  1. 15-22. COST ALLOCATION AND DECISION MAKING. Travel Ready has three divisions: United States, Europe, and Caribbean. Corporate headquarters is in Boston. Travel Ready corporate headquarters incurs costs of $34,000,000 annually, which is an indirect cost of the divisions. Corporate headquarters currently allocates this cost to the divisions based on the revenues of each division. The president has asked each division manager to suggest an allocation base for the corporate headquarters costs from among revenues, division margin, direct costs, and number of employees. The following is relevant information about each division:
<p>A table shows relevant information about the three divisions of Travel Ready</p>

The table depicts revenues, direct costs, division margin, division margin percentage, and number of employees for the United States, Europe, and Caribbean divisions. The details of the table are as follows:

1. Revenues

2. Direct costs

3. Division margin

4. Division margin percentage

5. Number of employees

  1. Required
  2. 1. Allocate the corporate headquarters costs of Travel Ready to each of the three divisions using revenues, direct costs, division margin, and number of employees as the allocation bases. Calculate operating margins for each division after allocating headquarters costs.
  3. 2. Which method of allocation would you expect each manager to recommend? Explain.
  4. 3. What factors would you consider in deciding which allocation base Travel Ready should use? 
  5. 4. Suppose Travel Ready decides to use number of employees as the allocation base. Should theEuropean division be closed? Why or why not?
  1. 15-23. COST ALLOCATION TO DIVISIONS. Martini Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant. As Martini’s new controller, your manager asks you to recommend the basis the hotel should use for allocating fixed overhead costs to the three divisions in 2020. You are presented with the following income statement information for 2019:
<p>A table shows a 2019 income statement for Martini Hotel and Casino</p>

The table depicts revenues, direct costs, and segment margin for the hotel, restaurant, and casino divisions. The details of the table are as follows:

1. Revenues

2. Direct costs

3. Segment margin

  1. You are also given the following data on the three divisions:
HotelRestaurantCasino
Floor space (square feet)115,00023,00092,000
Number of employees36090450
  1. You are told that you may choose to allocate indirect costs based on one of the following: direct costs, floor space, or the number of employees. Total fixed overhead costs for 2019 were $14,660,000.
    1. Required
    2. 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs.
    3. 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a percentage of revenues.
    4. 3. Discuss the results. How would you decide how to allocate indirect costs to the divisions? Why?
    5. 4. Would you recommend closing any of the three divisions in the short run (and possibly reallocating resources to other divisions) as a result of your analysis? If so, which division would you close and why?
  2. 15-24. COST ALLOCATION TO DIVISIONS. Holbrook Corporation has three divisions: pulp, paper, and fibers. Holbrook’s new controller, Paul Mayer, is reviewing the allocation of fixed corporate-overhead costs to the three divisions. He is presented with the following information for each division for 2020:
<p>A table shows information for the three divisions of Holbrook Corporation</p>

The table depicts revenues, direct manufacturing costs, division administrative costs, division margin, number of employees, and floor space in square feet for the pulp, paper, and fibers divisions. The details of the table are as follows:

1. Revenues

2. Direct manufacturing costs

3. Division administrative costs

4. Division margin

5. Number of employees

6. Floor space in square feet

  1. Until now, Holbrook Corporation has allocated fixed corporate-overhead costs to the divisions on the basis of division margins. Mayer asks for a list of costs that comprise fixed corporate overhead and suggests the following new allocation bases:
<p>A table shows allocation bases for Holbrook Corporation</p>

The table depicts human resource management, facility, and corporate administration fixed corporate-overhead costs and their suggested allocation bases, as well as the total costs. The details of the table are as follows:

1. Human resource management

2. Facility

3. Corporate administration

4. Total: 10,300,000 dollars

  1. Required
  2. 1. Allocate 2020 fixed corporate-overhead costs to the three divisions using division margin as the allocation base. What is each division’s operating margin percentage (division margin minus allocated fixed corporate-overhead costs as a percentage of revenues)?
  3. 2. Allocate 2020 fixed costs using the allocation bases suggested by Mayer. What is each division’s operating margin percentage under the new allocation scheme?
  4. 3. Compare and discuss the results of requirements 1 and 2. If division performance incentives arebased on operating margin percentage, which division would be most receptive to the new allocationscheme? Which division would be the least receptive? Why?
  5. 4. Which allocation scheme should Holbrook Corporation use? Why? How might Mayer overcome anyobjections that may arise from the divisions?
  1. 15-25. VARIANCE ANALYSIS, MULTIPLE PRODUCTS. The Chicago Tigers play in the American Ice Hockey League. The Tigers play in the Downtown Arena, which is owned and managed by the City of Chicago. The arena has a capacity of 15,000 seats (5,500 lower-tier seats and 9,500 upper-tier seats). The arena charges the Tigers a per-ticket charge for use of its facility. All tickets are sold by the Reservation Network, which charges the Tigers a reservation fee per ticket. The Tigers’ budgeted contribution margin for each type of ticket in 2020 is computed as follows:
<p>A table shows budgeted contribution margin for lower-tier and upper-tier tickets for the Chicago Tigers</p>

The table depicts selling price, Downtown Arena fee, Reservation Network fee, and contribution margin per ticket for lower-tier and upper-tier tickets. The details of the table are as follows:

1. Selling price

2. Downtown Arena fee

3. Reservation Network fee

4. Contribution margin per ticket

  1. The budgeted and actual average attendance figures per game in the 2020 season are as follows:
<p>A table shows budgeted and actual seats sold for the Chicago Tigers</p>

The table depicts budgeted and actual seats sold for the lower tier and the upper tier, as well as the totals. The details of the table are as follows:

1. Lower tier

2. Upper tier

3. Total

  1. There was no difference between the budgeted and actual contribution margin for lower-tier or upper-tier seats.
  2. The manager of the Tigers was delighted that actual attendance was 10% above budgeted attendance per game, especially given the depressed state of the local economy in the past 6 months.
    1. Required
    2. 1. Compute the sales-volume variance for each type of ticket and in total for the Chicago Tigers in 2020. (Calculate all variances in terms of contribution margins.)
    3. 2. Compute the sales-quantity and sales-mix variances for each type of ticket and in total in 2020.
    4. 3. Present a summary of the variances in requirements 1 and 2. Comment on the results.
  3. 15-26. VARIANCE ANALYSIS, WORKING BACKWARD. The Hiro Corporation sells two brands of wine glasses: Plain and Chic. Hiro provides the following information for sales in the month of June 2020:
<p>A table shows sales information for June 2020 for Hiro Corporation</p>

The table depicts sales information for June 2020 for Hiro Corporation. The details of the table are as follows:

1. Static-budget total contribution margin: 15,525 dollars

2. Budgeted units to be sold of all glasses: 2,300 units

3. Budgeted contribution margin per unit of Plain: 5 dollars per unit

4. Budgeted contribution margin per unit of Chic: 12 dollars per unit

5. Total sales-quantity variance: 2,700 dollars U

6. Actual sales-mix percentage of Plain: 60 percent

  1. All variances are computed in contribution-margin terms.
    1. Required
    2. 1. Calculate the sales-quantity variances for each product for June 2020.
    3. 2. Calculate the individual-product and total sales-mix variances for June 2020. Calculate the individual-product and total sales-volume variances for June 2020.
    4. 3. Briefly describe the conclusions you can draw from the variances.
  2. 15-27. VARIANCE ANALYSIS, MULTIPLE PRODUCTS. Emcee Inc. manufactures and sells two fruit drinks: Kostor and Limba. Budgeted and actual results for 2020 are as follows:
Budget for 2020Actual for 2020
ProductSelling  PriceVariable Cost per CartonCartons SoldSelling PriceVariable Cost per CartonCartons Sold
Kostor$12.00$7.20130,000$12.50$8.00132,000
Limba$15.00$8.25120,000$16.00$7.75108,000
  1. Required
  2. 1. Compute the total sales-volume variance, the total sales-mix variance, and the total sales-quantity variance. (Calculate all variances in terms of contribution margin.) Show results for each product in your computations.
  3. 2. What inferences can you draw from the variances computed in requirement 1?
  1. 15-28. [Required] MARKET-SHARE AND MARKET-SIZE VARIANCES (CONTINUATION OF 15-27). Emcee Inc. prepared the budget for 2020 assuming a 20% market share based on total sales in the Midwest region of the United States. The total fruit drinks market was estimated to reach sales of 1.25 million cartons in the region. However, actual total sales volume in the Midwest region was 1.5 million cartons.
  2. Required
  3. Calculate the market-share and market-size variances for Emcee Inc. in 2020. (Calculate all variances in terms of contribution margin.) Comment on the results.

Problems

  1. 15-29. PURPOSES OF COST ALLOCATION. Ashley Miller recently started a job as an administrative assistant in the cost accounting department of Norton Manufacturing. New to the area of cost accounting, Ashley is puzzled by the fact that one of Norton’s manufactured products, SR670, has a different cost depending on who asks for it. When the marketing department requested the cost of SR670 in order to determine pricing for the new catalog, Ashley was told to report one amount, but when a request came in the very next day from the financial-reporting department for the cost of SR670, she was told to report a very different cost. Ashley runs a report using Norton’s cost accounting system, which produces the following cost elements for one unit of SR670:
Direct materials$118.00
Direct manufacturing labor62.20
Variable manufacturing overhead33.65
Allocated fixed manufacturing overhead133.20
Research and development costs specific to SR670a25.50
Marketing costsa21.20
Sales commissionsa40.60
Allocated administrative costs of corporate headquarters70.25
Customer service costsa12.49
Distribution costsa30.52
aThese costs are specific to SR670, but would not be eliminated if SR670 were purchased from an outside supplier. Allocated costs would be reallocated elsewhere in the company should the company cease production of SR670.
  1. Required
  2. 1. Explain to Ashley why the cost given to the marketing and financial-reporting departments would be different.
  3. 2. Calculate the cost of one unit of SR670 to determine the following:
    1. a. The selling price of SR670
    2. b. The cost of inventory for financial reporting
    3. c. Whether to continue manufacturing SR670 or to purchase it from an outside source (Assume that SR670 is used as a component in one of Norton’s other products.)
  1. 15-30. CUSTOMER PROFITABILITY. Bracelet Delights is a new company that manufactures custom jewelry. Bracelet Delights currently has six customers referenced by customer number: 01, 02, 03, 04, 05, and 06. Besides the costs of making the jewelry, the company has the following activities:
    1. 1. Customer orders. The salespeople, designers, and jewelry makers spend time with the customer. The cost-driver rate is $42 per hour spent with a customer.
    2. 2. Customer fittings. Before the jewelry piece is completed, the customer may come in to make sure it looks right and fits properly. Cost-driver rate is $30 per hour.
    3. 3. Rush orders. Some customers want their jewelry quickly. The cost-driver rate is $90 per rush order.
    4. 4. Number of customer return visits. Customers visit to return jewelry up to 30 days after the pickup of the jewelry to have something refitted or repaired at no charge. The cost-driver rate is $40 per return visit.
  2. Information about the six customers follows. Some customers purchase multiple items. The cost of the jewelry is 60% of the selling price.
Customer number010203040506
Sales revenue$850$4,500$280$2,200$5,500$650
Cost of item(s)$510$2,700$168$1,320$3,300$390
Hours spent on customer order31018175
Hours on fittings160040
Number of rush orders021230
Number of return visits000001
  1. Required
  2. 1. Calculate the customer-level operating income for each customer. Rank the customers in order of most to least profitable and prepare a customer-profitability analysis, as in Exhibits 15-3 and 15-4.
  3. 2. Are any customers unprofitable? What is causing this? What should Bracelet Delights do about these customers?
  1. 15-31. CUSTOMER PROFITABILITY, DISTRIBUTION. Green Paper Delivery has decided to analyze the profitability of five new customers. It buys recycled paper at $20 per case and sells to retail customers at a list price of $26 per case. Data pertaining to the five customers are as follows:
<p>A table shows data for five new customers for Green Paper Delivery</p>

The table depicts cases sold, list selling price, actual selling price, number of purchase orders, number of customer visits, number of deliveries, miles traveled per delivery, and number of expedited deliveries for customers 1 through 5. The details of the table are as follows:

1. Cases sold

2. List selling price

3. Actual selling price

4. Number of purchase orders

5. Number of customer visits

6. Number of deliveries

7. Miles traveled per delivery

8. Number of expedited deliveries

  1. Green Paper Delivery’s five activities and their cost drivers are as follows:
<p>A table shows five activities and their cost drivers for Green Paper Delivery</p>

The table depicts five activities and their cost drivers for Green Paper Delivery. The details of the table are as follows:

1. Order taking: 90 dollars per purchase order

2. Customer visits: 75 dollars per customer visit

3. Deliveries: 3 dollars per delivery mile traveled

4. Product handling: 1.20 dollars per case sold

5. Expedited deliveries: 250 dollars per expedited delivery

  1. Required
  2. 1. Compute the customer-level operating income of each of the five retail customers now being examined (1, 2, 3, 4, and 5). Comment on the results.
  3. 2. What insights do managers gain by reporting both the list selling price and the actual selling price for each customer?
  4. 3. What factors should managers consider in deciding whether to drop one or more of the five customers?
  1. 15-32. CUSTOMER PROFITABILITY IN A MANUFACTURING FIRM. Mississippi Manufacturing makes a component called B2040. This component is manufactured only when ordered by a customer, so Mississippi keeps no inventory of B2040. The list price is $112 per unit, but customers who place “large” orders receive a 10% discount on price. The customers are manufacturing firms. Currently, the salespeople decide whether an order is large enough to qualify for the discount. When the product is finished, it is packed in cases of 10. If the component needs to be exchanged or repaired, customers can come back within 14 days for free exchange or repair.
  2. The full cost of manufacturing a unit of B2040 is $95. In addition, Mississippi incurs customer-level costs. Customer-level cost-driver rates are shown below:
Order taking$360 per order
Product handling$15 per case
Rush-order processing$560 per rush order
Exchange and repair costs$50 per unit
  1. Information about Mississippi’s five biggest customers follows:
<p>A table shows information about Mississippi Manufacturing’s five biggest customers</p>

The table depicts number of units purchased, discounts given, number of orders, number of cases, number of rush orders, and number of units exchanged/repaired for Customers A through E. The details of the table are as follows:

1. Number of units purchased

2. Discounts given

3. Number of orders

4. Number of cases

5. Number of rush orders

6. Number of units exchanged/repaired

  1. All customers except E ordered units in the same order size. Customer E’s order quantity varied, so E got a discount part of the time but not all the time.
    1. Required
    2. 1. Calculate the customer-level operating income for these five customers. Use the format in Exhibit 15-3. Prepare a customer-profitability analysis by ranking the customers from most to least profitable, as in Exhibit 15-4.
    3. 2. Discuss the results of your customer-profitability analysis. Does Mississippi have unprofitable customers? Is there anything Mississippi should do differently with its five customers?
  2. 15-33. CUSTOMER-COST HIERARCHY, CUSTOMER PROFITABILITY. Louise Adam Inc. operates two divisions: Architectural Designs, which provides architecture services for homes, and Commercial Interior, which provides interior design service for commercial customers. Architecture Designs serves two customers, Adair and Arsdale, and Commercial Interiors serves two customers, Caleigh and Comet. Louise would like to evaluate the profitability of her four customers, as well as evaluate the profitability of each of the two divisions and the business as a whole. Information about her most recent quarter follow:
                             Architecture DesignsCommercial Interiors
AdairArsdaleCaleighComet
Gross revenue$480,000$290,000$320,000$310,000
Customer-level costs225,000145,000170,000130,000
  1. Overhead costs total $750,000. Louise has determined that 45% of her overhead costs relate directly to Architectural Designs, 35% relate directly to Commercial Interiors, and the remaining 20% are corporate overhead costs.
    1. Required
    2. 1. Prepare a customer-cost hierarchy report for Louise Adam Inc., using the format in Exhibit 15-6.
    3. 2. Prepare a customer-profitability analysis for the four customers, using the format in Exhibit 15-4.
    4. 3. Comment on the results of the preceding reports. What recommendations would you give Louise Adam?
  2. 15-34. ALLOCATION OF CORPORATE COSTS TO DIVISIONS. Cathy Carpenter, controller of the Sweet and Salty Snacks, is preparing a presentation to senior executives about the performance of its four divisions. Summary data related to the four divisions for the most recent year are as follows:
Spreadsheet screenshot shows cost, assets, and employees allotted to each division of Sweet and Salty Snacks.

Details of the divisions are as follows:

  1. Division: Candy

    Revenues: $ 870,000

    Operating Costs: $330,800

    Operating Income: $539,200

    Identifiable assets: $1,800,000

    Number of employees: 3,600

  2. Division: Nuts

    Revenues: $975,000

    Operating Costs: $378,000

    Operating Income: $597,000

    Identifiable assets: $ 2,880,000

    Number of employees: 6,600

  3. Division: Crackers

    Revenues: $654,000

    Operating Costs: $658,000

    Operating Income: $(4,000) in parentheses

    Identifiable assets: $1,440,000

    Number of employees: 2,700

  4. Division: Cookies

    Revenues: $501,000

    Operating Costs: $314,000

    Operating Income: $187,000

    Identifiable assets: $1,080,000

    Number of employees: 2,100

  5. Total

    Revenues: $3,000,000

    Operating Costs: $1,680,800

    Operating Income: $1.319.200

    Identifiable assets: $7,200,000

    Number of employees: 15,000

  1. Under the existing accounting system, costs incurred at corporate headquarters are collected in a single cost pool ($1.2 million in the most recent year) and allocated to each division on the basis of its actual revenues. The top managers in each division share in a division-income bonus pool. Division income is defined as operating income less allocated corporate costs.
  2. Carpenter has analyzed the components of corporate costs and proposes that corporate costs be collected in four cost pools. The components of corporate costs for the most recent year and Carpenter’s suggested cost pools and allocation bases are as follows:
Spreadsheet screenshot shows the corporate cost category, its amount, suggested cost pool, and suggested allocation base for Sweet and Salty snacks.

Details of the table are as follows:

  1. Corporate cost category: Interest on debt

    • Amount: $380,000

    • Suggested cost pool: Cost Pool 1

    • Suggested Allocation Base: Identifiable assets

  2. Corporate cost category: Corporate salaries

    • Amount: $200,000

    • Suggested cost pool: Cost Pool 2

    • Suggested Allocation Base: Division revenues

  3. Corporate cost category: Accounting and control

    • Amount: $160,000

    • Suggested cost pool: Cost Pool 2

    • Suggested Allocation Base: Division revenues

  4. Corporate cost category: General marketing

    • Amount: $170,000

    • Suggested cost pool: Cost Pool 2

    • Suggested Allocation Base: Division revenues

  5. Corporate cost category: Public affairs

    • Amount: $150,000

    • Suggested cost pool: Cost Pool 3

    • Suggested Allocation Base: Positive operating income

  6. Corporate cost category: Personnel and payroll

    • Amount: $140,000

    • Suggested cost pool: Cost Pool 4

    • Suggested Allocation Base: Number of employees

  7. Total Amount: $1,200,000

  1. Required
  2. 1. Discuss two reasons why Sweet and Salty Snacks should allocate corporate costs to each division.
  3. 2. Calculate the operating income of each division when all corporate costs are allocated based on revenues of each division.
  4. 3. Calculate the operating income of each division when all corporate costs are allocated using the four cost pools.
  5. 4. How do you think the division managers will receive the new proposal? What are the strengths and weaknesses of Carpenter’s proposal relative to the existing single cost-pool method?
  1. 15-35. COST ALLOCATION TO DIVISIONS. Francisco Bakery makes baked goods for grocery stores and has three divisions: bread, cake, and doughnuts. Each division is run and evaluated separately, but the main headquarters incurs costs that are indirect costs for the divisions. Costs incurred in the main headquarters are as follows:
<p>A table shows costs incurred in the main headquarters for Francisco Bakery<p>

The table depicts costs incurred in the main headquarters for Francisco Bakery. The details of the table are as follows:

1. Human resources (HR) costs: 1,700,000 dollars

2. Accounting department costs: 1,300,000 dollars

3. Rent and depreciation: 1,440,000 dollars

4. Other: 510,000 dollars

5. Total costs: 4,950,000 dollars

  1. The Francisco upper management currently allocates this cost to the divisions equally. One of the division managers has done some research on activity-based costing and proposes the use of different allocation bases for the different indirect costs—number of employees for HR costs, total revenues for accounting department costs, square feet of space for rent and depreciation costs, and equal allocation among the divisions of “other” costs. Information about the three divisions follows:
<p>A table shows information about the three divisions of Franciso Bakery<p>

The table depicts total revenues, direct costs, segment margin, number of employees, and square feet of space for the bread, cake, and doughnut divisions. The details of the table are as follows:

1. Total revenues, direct costs, segment margin, number of employees, and square feet of space

2. Direct costs

3. Segment margin

4. Number of employees

5. Square feet of space

  1. Required
  2. 1. Allocate the indirect costs of Francisco to each division equally. Calculate division operating income after allocation of headquarter costs.
  3. 2. Allocate headquarter costs to the individual divisions using the proposed allocation bases. Calculate the division operating income after allocation. Comment on the allocation bases used to allocate headquarter costs.
  4. 3. Which division manager do you think suggested this new allocation. Explain briefly. Which allocation do you think is “better?”
  1. 15-36. COST-HIERARCHY INCOME STATEMENT AND ALLOCATION OF CORPORATE COSTS TO CUSTOMERS. ISPStar offers Internet, phone, and television services to customers in Wyoming. It has two divisions, an Urban Division catering to urban customers and a Rural Division catering to rural customers. Currently, the company allocates corporate overhead on the basis of revenues of the two divisions. Harvey Leonard, ISPStar’s president, believes that this method of allocation does not adequately capture the demands that the two divisions put on corporate resources. He proposes developing a cost-hierarchy income statement and also an income statement allocating corporate overhead costs based on the number of service hours used in the two divisions. The Rural Division has a higher number of service hours because service personnel have to travel longer distances to reach customers.
  2. The following information is available for the forthcoming period:
<p>A table shows information for the two divisions of ISPStar</p>

The table depicts revenue, customer-level costs, customer-level operating income, customer-level operating income percentage, and service-hours worked for the urban division and the rural division, as well as totals.. The details of the table are as follows:

1. Revenue

2. Customer-level costs

3. Customer-level operating income

4. Customer-level operating income percentage

5. Service-hours worked

  1. In addition to the customer-level costs above, the company expects to incur $2,250,000 of corporate costs.
    1. Required
    2. 1. Prepare a cost-hierarchy income statement for ISPStar using the format in Exhibit 15-7. assuming corporate costs are not allocated to each division.
    3. 2. Allocate the corporate costs to each division and calculate the income of each division after assigning corporate costs based on revenues of each division.
    4. 3. Allocate the corporate costs to each division and calculate the income of each division after assigning corporate costs based on service-hours worked in each division.
    5. 4. What are the advantages and disadvantages of ISPStar allocating corporate overhead costs to the two divisions?
    6. 5. Based on your answers to requirements 1 through 4, should Leonard close down the Rural Division? Explain.
  2. 15-37. COST-HIERARCHY INCOME STATEMENT AND ALLOCATION OF CORPORATE, DIVISION, AND CHANNEL COSTS TO CUSTOMERS. Sportscast Inc. has two divisions, the Sporting Goods Division and the Memorabilia Division. Recently the company’s profitability has decreased. Management would like to analyze the profitability of each division based on the following information for the upcoming period:
<p>A table shows information for the two divisions of Sportscast Inc.</p>

The table depicts revenue, customer-level costs, customer-level operating income, and customer-level operating income as a percentage of revenue for the sporting goods division and the memorabilia division, as well as totals. The details of the table are as follows:

1. Revenue

2. Customer-level costs

3. Customer-level operating income

4. Customer-level operating income percentage

  1. The company allocates marketing and administration costs incurred to support the divisions as follows:
TotalAllocation basis
Marketing costs$400,000Channel revenue
Administration costs$450,000Customer-level costs
  1. Based on a special study, the company allocates corporate costs of $200,000 to the two divisions based on the corporate resources demanded by the divisions as follows: Sporting Goods Division, $130,000, and Memorabilia Division, $70,000. If the company were to close a division, none of the corporate costs would be saved.
    1. Required
    2. 1. Calculate the operating income for each division as a percentage of revenue after assigning customer-level costs, marketing costs, administration costs, and corporate costs.
    3. 2. Should Sportscast Inc. close down any division? Explain briefly including any assumptions that you made.
    4. 3. Would you allocate corporate costs to divisions? Why is allocating these costs helpful? What actions would it help you take? 
  2. 15-38 VARIANCE ANALYSIS, SALES-MIX AND SALES-QUANTITY VARIANCES. Miami Infonautics, Inc., produces Windows phones. Miami Infonautics markets three different handheld models: WinPro is a souped-up version for the executive on the go, WinCE is a consumer-oriented version, and WinKid is a stripped-down version for the young adult market. You are Miami Infonautics’ senior vice president of marketing. The chief executive officer (CEO) has discovered that the total contribution margin came in lower than budgeted, and it is your responsibility to explain to him why actual results are different from the budget. Budgeted and actual operating data for the company’s third quarter of 2020 are as follows:
<p>A table shows budgeted operating data for the 2020 third quarter for Miami Infonautics, Inc.</p>

The table depicts selling price, variable cost per unit, contribution margin per unit, and sales volume in units for three models: WinPro, WinCE, and WinKid, as well as the sales volume total. The details of the table are as follows:

1. WinPro

1. WinCE

1. WinKid

4. Total sales volume in units: 102,150

<p>A table shows actual operating data for the 2020 third quarter for Miami Infonautics, Inc.</p>

The table depicts selling price, variable cost per unit, contribution margin per unit, and sales volume in units for three models: WinPro, WinCE, and WinKid, as well as the sales volume total. The details of the table are as follows:

1. WinPro

1. WinCE

1. WinKid

4. Total sales volume in units: 103,000

  1. Required
  2. 1. Compute the actual and budgeted contribution margins in dollars for each product and in total for the third quarter of 2020.
  3. 2. Calculate the actual and budgeted sales mixes for the three products for the third quarter of 2020.
  4. 3. Calculate total sales-volume, sales-mix, and sales-quantity variances for the third quarter of 2020.(Calculate all variances in terms of contribution margins.)
  5. 4. Given that your CEO gets very angry if actual results differ from budget, you want to be well preparedfor this meeting. In order to prepare, write a paragraph or two comparing actual results to budgetedamounts.
  1. 15-39. MARKET-SHARE AND MARKET-SIZE VARIANCES (CONTINUATION OF 15-38). Miami Infonautics’ senior vice president of marketing prepared his budget at the beginning of the third quarter assuming a 25% market share based on total sales. Foolinstead Research estimated that the total market would reach sales of 408,600 units worldwide in the third quarter. However, actual sales in the third quarter were 515,000 units.
    1. Required
    2. 1. Calculate the market-share and market-size variances for Miami Infonautics in the third quarter of 2020 (calculate all variances in terms of contribution margins).
    3. 2. Explain what happened based on the market-share and market-size variances.
    4. 3. Calculate the actual market size, in units, that would have led to no market-size variance (again using budgeted contribution margin per unit). Use this market-size figure to calculate the actual market share that would have led to a zero market-share variance.
  2. 15-40. VARIANCE ANALYSIS, MULTIPLE PRODUCTS. The Robin’s Basket operates a chain of Italian gelato stores. Although the Robin’s Basket charges customers the same price for all flavors, production costs vary, depending on the type of ingredients. Budgeted and actual operating data of its Washington, D.C., store for August 2020 are as follows:
<p>A table shows the budgeted operating data for The Robin’s Basket for August 2020</p>

The table depicts selling price per pint, variable cost per pint, contribution margin per pint, and sales volume in pints for mint chocolate chip, vanilla, and rum raisin, as well as total sales volume in pints. The details of the table are as follows:

1. Mint chocolate chip

2. Vanilla

3. Rum raisin

4. Total sales volume in pints: 100,000

<p>A table shows the actual operating data for The Robin’s Basket for August 2020</p>

The table depicts selling price per pint, variable cost per pint, contribution margin per pint, and sales volume in pints for mint chocolate chip, vanilla, and rum raisin, as well as total sales volume in pints. The details of the table are as follows:

1. Mint chocolate chip

2. Vanilla

3. Rum raisin

4. Total sales volume in pints: 112,500

  1. The Robin’s Basket focuses on contribution margin in its variance analysis.
    1. Required
    2. 1. Compute the total sales-volume variance for August 2020.
    3. 2. Compute the total sales-mix variance for August 2020.
    4. 3. Compute the total sales-quantity variance for August 2020.
    5. 4. Comment on your results in requirements 1, 2, and 3.
  2. 15-41. MARKET-SHARE AND MARKET-SIZE VARIANCES (CONTINUATION OF 15-40). The Robin’s Basket’s senior vice president of marketing prepared her budget at the beginning of the third quarter assuming a 10% market share based on a budgeted market size of 1,000,000 pints in August. However, actual market size in August was 1,250,000 pints.
    1. Required
    2. 1. Calculate the market-share and market-size variances for the Robin’s Basket in August 2020 (calculate all variances in terms of contribution margins).
    3. 2. Explain what happened based on the market-share and market-size variances.
    4. 3. How many pints would the Robin’s Basket have to sell in August 2020 for the market share variance to be zero? Calculate the actual market size, in units, that would have led to no market-size variance.
  3. 15-42. CUSTOMER PROFITABILITY AND ETHICS. KC Corporation manufactures an air-freshening device called GoodAir, which it sells to six merchandising firms. The list price of a GoodAir is $30, and the full manufacturing costs are $18. Salespeople receive a commission on sales, but the commission is based on number of orders taken, not on sales revenue generated or number of units sold. Salespeople receive a commission of $10 per order (in addition to regular salary).
  4. KC Corporation makes products based on anticipated demand. KC carries an inventory of GoodAir, so rush orders do not result in any extra manufacturing costs over and above the $18 per unit. KC ships finished product to the customer at no additional charge for either regular or expedited delivery. KC incurs significantly higher costs for expedited deliveries than for regular deliveries. Customers occasionally return shipments to KC, and the company subtracts these returns from gross revenue. The customers are not charged a restocking fee for returns.
  5. Budgeted (expected) customer-level cost driver rates follow:
<p>A table shows budgeted customer-level cost driver rates for KC Corporation</p>

The table depicts budgeted customer-level cost driver rates for KC Corporation. The details of the table are as follows:

1. Order taking (excluding sales commission): 15 dollars per order

2. Product handling: 1 dollar per unit

3. Delivery: 1.20 dollars per mile driven

4. Expedited (rush) delivery: 175 dollars per shipment

5. Restocking: 50 dollars per returned shipment

6. Visits to customers: 125 dollars per customer

  1. Because salespeople are paid $10 per order, they often break up large orders into multiple smaller orders. This practice reduces the actual order-taking cost by $7 per smaller order (from $15 per order to $8 per order) because the smaller orders are all written at the same time. This lower cost rate is not included in budgeted rates because salespeople create smaller orders without telling management or the accounting department. All other actual costs are the same as budgeted costs.
  2. Information about KC’s clients follows:
ACDCMCJCRCBC
Total number of units purchased2255202951103901,050
Number of actual orders52046918
Number of written orders1020*9122436
Total number of miles driven to deliver all products360580350220790850
Total number of units returned1540003540
Number of returned shipments320015
Number of expedited deliveries080034
* Because DC places 20 separate orders, its order costs are $15 per order. All other orders are multiple smaller orders and so have actual order costs of $8 each.
  1. Required
  2. 1. Classify each of the customer-level operating costs as a customer output unit-level, customer batch-level, or customer-sustaining cost.
  3. 2. Using the preceding information, calculate the expected customer-level operating income for the sixcustomers of KC Corporation. Use the number of written orders at $15 each to calculate expectedorder costs.
  4. 3. Recalculate the customer-level operating income using the number of written orders but at their actual $8 cost per order instead of $15 (except for DC, whose actual cost is $15 per order). How will KCCorporation evaluate customer-level operating cost performance this period?
  5. 4. Recalculate the customer-level operating income if salespeople had not broken up actual orders intomultiple smaller orders. Don’t forget to also adjust sales commissions.