Managerial Accounting: Creating Value in a Dynamic Business Environment
12th Edition
ISBN: 9781260417074
Author: HILTON, Ronald
Publisher: MCGRAW-HILL HIGHER EDUCATION
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 5, Problem 66P
Refer to the information given in the preceding problem for Fresno Fiber Optics and two of its customers, Trace Telecom and Caltex Computer. Additional information for six of Fresno’s other customers for the most recent year follows:
Required:
- 1. Prepare Fresno Fiber Optics’ customer profitability profile for the most recent year.
- 2. As Fresno Fiber Optics’ director of cost management, write a memo to the company’s vice president of marketing that will accompany the customer profitability profile. Include a brief explanation of the methodology used and comment on the results.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's
controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern
of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an
equation, in the form of Y= a + bx, for maintenance costs. Data regarding the maintenance hours and costs for last year
are as follows:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Total
Average
Hours of
Maintenance
Service
560
480
280
470
350
460
320
430
490
380
350
340
4,910
409
Maintenance cost
Maintenance
Costs
$ 5,110
4,240
2,730
4,300
3,030
4, 120
3,000
3,590
4,000
3,220
3,170
3,070
$ 43,580
$ 3,632
PR 6-38 (Algo) Part 3 Compute the predicted maintenance cost...
3. Compute the predicted maintenance cost at 670 hours of activity.
Answer is complete but not entirely correct.
$
49,192 X
Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's
controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern
of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an
equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year
are as follows:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Total
Average
Hours of
Maintenance
Service
Variable maintenance cost
560
480
280
470
350
460
320
430
490
380
350
340
4,910
409
$
Maintenance
Costs
$ 5,110
4,240
2,730
4,300
3,030
4, 120
PR 6-38 (Algo) Part 2 What is the variable component of the maintenance cost?
2. Using your answer to requirement 1, what is the variable component of the maintenance cost?
Note: Round your answer to 2 decimal places.
3,000
3,590…
Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's
controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern
of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an
equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year
are as follows:
Month
January
February
March
April
May
June
July
August
September
October
November
December
Total
Average
Hours of
Maintenance
Service
560
480
280
470
350
Monthly maintenance cost =
460
320
430
490
380
350
340
4,910
409
Maintenance
Costs
$ 5,110
4,240
2,730
4,300
3,030
4,120
3,000
3,590
4,000
3,220
3,170
3,070
$ 43,580
$ 3,632
PR 6-38 (Algo) Part 1 Estimate the behavior of the maintenance costs incurred...
Required:
1. Using the high-low method of cost estimation, estimate the behavior of the maintenance…
Chapter 5 Solutions
Managerial Accounting: Creating Value in a Dynamic Business Environment
Ch. 5 - Briefly explain how a traditional, volume-based...Ch. 5 - Prob. 2RQCh. 5 - Explain how an activity-based costing system...Ch. 5 - What are cost drivers? What is their role in an...Ch. 5 - List and briefly describe the four broad...Ch. 5 - How can an activity-based costing system alleviate...Ch. 5 - Prob. 7RQCh. 5 - How is the distinction between direct and indirect...Ch. 5 - Explain the concept of a pool rate in...Ch. 5 - Briefly explain two factors that tend to result in...
Ch. 5 - List three factors that are important in selecting...Ch. 5 - Prob. 12RQCh. 5 - Explain why a new product-costing system may be...Ch. 5 - Prob. 14RQCh. 5 - Are activity-based costing systems appropriate for...Ch. 5 - Explain why maintaining their medical-services...Ch. 5 - How could the administration at Immunity Medical...Ch. 5 - Prob. 18RQCh. 5 - Prob. 19RQCh. 5 - What is meant by the term activity analysis? Give...Ch. 5 - Prob. 21RQCh. 5 - What is meant by customer-profitability analysis?...Ch. 5 - Explain the relationship between customer profit...Ch. 5 - What is a customer profitability profile?Ch. 5 - Describe the use of practical capacity in a TDABC...Ch. 5 - Tioga Company manufactures sophisticated lenses...Ch. 5 - Urban Elite Cosmetics has used a traditional cost...Ch. 5 - Kentaro Corporation manufactures Digital Video...Ch. 5 - Kentaro Corporation manufactures Digital Video...Ch. 5 - Prob. 31ECh. 5 - Refer to the description given for Wheelco, Inc....Ch. 5 - Prob. 33ECh. 5 - United Technologies Corporation implemented...Ch. 5 - Redwood Company sells craft kits and supplies to...Ch. 5 - Non-value-added costs occur in nonmanufacturing...Ch. 5 - Since you have always wanted to be an...Ch. 5 - Prob. 39ECh. 5 - Prob. 42ECh. 5 - Prob. 44ECh. 5 - Borealis Manufacturing has just completed a major...Ch. 5 - Ontario, Inc. manufactures two products, Standard...Ch. 5 - Kitchen Kings Toledo plant manufactures three...Ch. 5 - Prob. 48PCh. 5 - Maxey Sons manufactures two types of storage...Ch. 5 - Prob. 50PCh. 5 - John Patrick has recently been hired as controller...Ch. 5 - The controller for Tulsa Medical Supply Company...Ch. 5 - Prob. 53PCh. 5 - Prob. 54PCh. 5 - Prob. 55PCh. 5 - World Gourmet Coffee Company (WGCC) is a...Ch. 5 - Knickknack, Inc. manufactures two products: Odds...Ch. 5 - Prob. 58PCh. 5 - Marconi Manufacturing produces two items in its...Ch. 5 - Gigabyte, Inc. manufactures three products for the...Ch. 5 - Refer to the new target prices for Gigabytes three...Ch. 5 - Prob. 62PCh. 5 - Prob. 63PCh. 5 - Midwest Home Furnishings Corporation (MHFC)...Ch. 5 - Fresno Fiber Optics, Inc. manufactures fiber optic...Ch. 5 - Refer to the information given in the preceding...Ch. 5 - Whitestone Company produces two subassemblies,...Ch. 5 - Morelli Electric Motor Corporation manufactures...Ch. 5 - Refer to the product costs developed in...Ch. 5 - Morelli Electric Motor Corporations controller,...
Knowledge Booster
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
- Ohio 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_forwardA company uses charging rates to allocate service department costs to the using departments. The accountant compiled the following information on one of the service departments: If Department K plans to use 1,350 hours of the service departments service in the coming year, how much of the service departments cost is allocated to Department K? a. 3,375 b. 27,300 c. 26,325 d. 23,950arrow_forwardThe Northwest regional manager of Logan Outdoor Equipment Company has conducted a study to determine how her store managers are allocating their time. A study was undertaken over three weeks that collected the following data related to the percentage of time each store manager spent on the tasks of attending required meetings, preparing business reports, customer interaction, and being idle. The results of the data collection appear in the following table: a. Create a stacked-bar chart with locations along the vertical axis. Reformat the bar chart to best display these data by adding axis labels, a chart title, and so on. b. Create a clustered-bar chart with locations along the vertical axis and clusters of tasks. Reformat the bar chart to best display these data by adding axis labels, a chart title, and the like. c. Create multiple bar charts in which each location becomes a single bar chart showing the percentage of time spent on tasks. Reformat the bar charts to best display these data by adding axis labels, a chart title, and so forth. d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why? e. What can we infer about the differences among how store managers are allocating their time at the different locations?arrow_forward
- Corazon Manufacturing Company has a purchasing department staffed by five purchasing agents. Each agent is paid 28,000 per year and is able to process 4,000 purchase orders. Last year, 17,800 purchase orders were processed by the five agents. Required: 1. Calculate the activity rate per purchase order. 2. Calculate, in terms of purchase orders, the: a. total activity availability b. unused capacity 3. Calculate the dollar cost of: a. total activity availability b. unused capacity 4. Express total activity availability in terms of activity capacity used and unused capacity. 5. What if one of the purchasing agents agreed to work half time for 14,000? How many purchase orders could be processed by four and a half purchasing agents? What would unused capacity be in purchase orders?arrow_forwardThe controller of Emery, Inc. has computed quality costs as a percentage of sales for the past 5 years (20X1 was the first year the company implemented a quality improvement program). This information is as follows: Required: 1. Prepare a trend graph for total quality costs. Comment on what the graph has to say about the success of the quality improvement program. 2. Prepare a graph that shows the trend for each quality cost category. What does the graph have to say about the success of the quality improvement program? Does this graph supply more insight than the total cost trend graph does? 3. Prepare a graph that compares the trend in relative control costs versus relative failure costs. Comment on the significance of this trend.arrow_forwardClassify each of the following actions as either being associated with the financial accounting information system (FS) or the cost management information system (CMS): a. Determining the total compensation of the CEO of a public company b. Issuing a quarterly earnings report c. Determining the unit product cost using TDABC d. Calculating the number of units that must be sold to break even e. Preparing a required report for the SEC f. Preparing a sales budget g. Using cost and revenue information to decide whether to keep, or drop, a product line h. Preparing an annual statement of financial position that conforms to generally accepted accounting principles (GAAP) i. Using cost and revenue information to decide whether to invest in a new production system or not j. Reducing costs by improving the overall quality of a product k. Using a debt-equity ratio and liquidity ratios from a balance sheet to assess the likelihood of bankruptcy l. Using a public companys financial statements to decide whether or not to buy its stockarrow_forward
- Nation's Capital Fitness, Incorporated, operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y = a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service Variable maintenance cost 520 470 250 490 340 470 330 410 480 380 390 340 4,870 406 Maintenance Costs $ 5,305 4,170 2,740 4,280 3,050 4,160 3,040 3,570 3,990 3,230 3,170 3,120 $ 43,825 $ 3,652 2. Using your answer to requirement 1, what is the variable component of the maintenance cost? Note: Round your answer to 2 decimal places. ********* per hourarrow_forwardNation’s Capital Fitness, Inc. operates a chain of fitness centers in the Washington, D.C., area. The firm’s controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm’s equipment maintenance costs must be determined. The accounting staff has suggested the use of an equation, in the form of Y = a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: (image below) Required:1. Using the high-low method of cost estimation, estimate the behavior of the maintenance costs incurred by Nation’s Capital Fitness, Inc. Express the cost behavior pattern in equation form.2. Using your answer to requirement (1), what is the variable component of the maintenance cost?3. Compute the predicted maintenance cost at 590 hours of activity.4. Compute the variable cost per hour and the fixed cost per hour at 600 hours of activity. Explain why the fixed cost per hour could be…arrow_forwardYou have recently been appointed as the management accountant attached to the head office of the company with special responsibility of monitoring the performance of the companies within the group. Each company is treated as an investment center and every month produces an operating statement for the group headquarters. Summaries of the statements for companies X and Y which make similar products selling at similar prices for the last month showed a typical situation. Extract from the company monthly operating statements. X Y GHS000 GHS000 Sales 600 370 Less variable cost 229 208 Contribution 371 162 Less controllable fixed…arrow_forward
- 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: Research Administrative Gene Assistant Assistant Research 75% Shipping Jobbers 30% 20% 15 10 20 Basic ads 15 40 Ultima ads 30 5 Office management 25 15arrow_forwardBig Apple Design Company specializes in designing commercial office space in Chicago. The firm’s president recently reviewed the following income statement and noticed that operating profits were below her expectations. She had a hunch that certain customers were not profitable for the company and asked the controller to perform a customer-profitability analysis showing profitability by customer for the month of March. Required: Put yourself in the position of Big Apple’s controller and write a memo to the president to accompany the customer-profitability graph. Comment on the implications of the customer-profitability analysis and raise four or more questions that should be addressed by the firm’smanagement team.arrow_forwardRequired information [The following information applies to the questions displayed below.] Nation's Capital Fitness, Inc., operates a chain of fitness centers in the Washington, D.C., area. The firm's controller is accumulating data to be used in preparing its annual profit plan for the coming year. The cost behavior pattern of the firm's equipment maintenance costs must be determined. The accounting staff has suggested the use of the high-low method to develop an equation, in the form of Y= a + bX, for maintenance costs. Data regarding the maintenance hours and costs for last year are as follows: Month January February March April May June July August September October November December Total Average Hours of Maintenance Service 520 490 300 500 310 480 Monthly maintenance cost= 320 400 470 350 340 320 4,800 400 Maintenance Costs $ 4,470 4,260 2,820 4,350 2,960 4,200 3,000 3,600 4,050 3,300 3,160 3,030 $43,200 $3,600 Required: 1. Using the high-low method of cost estimation, estimate…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Pricing Decisions; Author: Rutgers Accounting Web;https://www.youtube.com/watch?v=rQHbIVEAOvM;License: Standard Youtube License