Shorts Manufacturing, Inc., has implemented lean manufacturing in its Kansas City plant as a pilot program. One of its value streams produces a family of small electric tools. The value-stream team managers were quite excited about the results, as some of their efforts to eliminate waste were proving to be effective. During the most recent three weeks, the following data pertaining to the electric tool value stream were collected:
Week 1:
Demand = 90 units @ $40
Beginning inventory = 10 units @ $20 ($5 materials and $15 conversion)
Production = 90 units using $450 of material and $1,350 of conversion cost
Week 2:
Demand = 100 units @ $40
Beginning inventory = 10 units @ $20 ($5 materials and $15 conversion)
Production = 90 units using $450 of material and $1,350 of conversion cost
Week 3:
Demand = 90 units @ $40
Beginning inventory = 0
Production = 100 units using $500 of material and $1,500 of conversion cost
Required:
- 1. Prepare a traditional income statement for each week.
- 2. Calculate the average value-stream product cost for each week. What does this cost signal, if anything?
- 3. Prepare a value-stream income statement for each week. Assume that any increase in inventory is valued at average cost. Comment on the financial performance of the value stream and its relationship to traditional income measurement.
Want to see the full answer?
Check out a sample textbook solutionChapter 15 Solutions
Cornerstones of Cost Management (Cornerstones Series)
- Big Mikes, a large hardware store, has gathered data on its overhead activities and associated costs for the past 10 months. Nizam Sanjay, a member of the controllers department, believes that overhead activities and costs should be classified into groups that have the same driver. He has decided that unloading incoming goods, counting goods, and inspecting goods can be grouped together as a more general receiving activity, since these three activities are all driven by the number of receiving orders. The 10 months of data shown below have been gathered for the receiving activity. Required: 1. Prepare a scattergraph, plotting the receiving costs against the number of purchase orders. Use the vertical axis for costs and the horizontal axis for orders. 2. Select two points that make the best fit, and compute a cost formula for receiving costs. 3. Using the high-low method, prepare a cost formula for the receiving activity. 4. Using the method of least squares, prepare a cost formula for the receiving activity. What is the coefficient of determination?arrow_forwardAssume that at the beginning of 20x2, Cicleta trained the 2 assembly workers in a new approach that had the objective of increasing the efficiency of the assembly process. Cicleta also began moving toward a JIT purchasing and manufacturing system. When JIT is fully implemented, the demand for expediting is expected to be virtually eliminated. It is expected to take two to three years for full implementation. Assume that receiving cost is a step-fixed cost with steps of 1,500 orders. The other three activities employ resources that are acquired as used and needed. At the end of 20x2, the following results were reported for the four activities: Required: 1. Prepare a trend report that shows the non-value-added costs for each activity for 20x1 and 20x2 and the change in costs for the two periods. Discuss the reports implications. 2. Explain the role of activity reduction for receiving and for expediting. What is the expected value of SQ for each activity after JIT is fully implemented? 3. What if at the end of 20x2, the selling price of a competing product is reduced by 27 per unit? Assume that the firm produces and sells 20,000 units of its product and that its product is associated only with the four activities being considered. By virtue of the waste-reduction savings, can the competitors price reduction be matched without reducing the unit profit margin of the product that prevailed at the beginning of the year? If not, how much more waste reduction is needed to achieve this outcome? In this case, what price decision would you recommend?arrow_forwardUchdorf Manufacturing just completed a study of its purchasing activity with the objective of improving its efficiency. The driver for the activity is number of purchase orders. The following data pertain to the activity for the most recent year: Activity supply: five purchasing agents capable of processing 2,400 orders per year (12,000 orders) Purchasing agent cost (salary): 45,600 per year Actual usage: 10,600 orders per year Value-added quantity: 7,000 orders per year Required: 1. Calculate the volume variance and explain its significance. 2. Calculate the unused capacity variance and explain its use. 3. What if the actual usage drops to 9,000 orders? What effect will this have on capacity management? What will be the level of spending reduction if the value-added standard is met?arrow_forward
- The 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_forwardMabbut Company has the following departmental manufacturing layout for one of its plants: A consulting firm recommended a value stream with the following manufacturing cell: Required: 1. Calculate the total time it takes to produce a batch of 10 units using the traditional departmental manufacturing layout. 2. Using cellular manufacturing, how much time is saved producing the same batch of 10 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. Assume the processing time of Welding is reduced to 6 minutes, while the times of the other processes stay the same. What is the production rate now, and how long will it take to produce a batch of 10 units if the cell is in a continuous production mode?arrow_forwardCorazon 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_forward
- Heavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows: Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. Graphical and numerical summaries for the length of time the shopper spends on the web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week? Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser? Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings.arrow_forwardGumbrecht Company has the following departmental manufacturing layout for one of its plants: A consulting firm has recommended a value stream with the following manufacturing cell: Required: 1. Calculate the total time it takes to produce a batch of 20 units using the traditional departmental manufacturing layout. 2. Using cellular manufacturing, how much time is saved producing the same batch of 20 units? Assuming the cell operates continuously, what is the production rate? Which process controls this production rate? 3. Assume the processing time of Casting is reduced to 9 minutes, while the times of the other processes stay the same. What is the production rate now, and how long will it take to produce a batch of 20 units if the cell is in a continuous production mode?arrow_forwardJoseph Fox, controller of Thorpe Company, has been in charge of a project to install an activity-based cost management system. This new system is designed to support the companys efforts to become more competitive. For the past six weeks, he and the project committee members have been identifying and defining activities, associating workers with activities, and assessing the time and resources consumed by individual activities. Now, he and the project committee are focusing on three additional implementation issues: (1) identifying activity drivers, (2) assessing value content, and (3) identifying cost drivers (root causes). Joseph has assigned a committee member the responsibilities of assessing the value content of five activities, choosing a suitable activity driver for each activity, and identifying the possible root causes of the activities. Following are the five activities with possible activity drivers: The committee member ran a regression analysis for each potential activity driver, using the method of least squares to estimate the variable and fixed cost components. In all five cases, costs were highly correlated with the potential drivers. Thus, all drivers appeared to be good candidates for assigning costs to products. The company plans to reward production managers for reducing product costs. Required: 1. What is the difference between an activity driver and a cost driver? In answering the question, describe the purpose of each type of driver. 2. For each activity, assess the value content and classify each activity as value-added or non-value-added (justify the classification). Identify some possible root causes of each activity, and describe how this knowledge can be used to improve activity performance. For purposes of discussion, assume that the value-added activities are not performed with perfect efficiency. 3. Describe the behavior that each activity driver will encourage, and evaluate the suitability of that behavior for the companys objective of becoming more competitive.arrow_forward
- The Calhoun Textile Mill is in the process of deciding on a production schedule. It wishes to know how to weave the various fabrics it will produce during the coming quarter. The sales department has continued orders for each of the 15 fabrics produced by Calhoun. These demands are given in the following table. Also given in this table is the variable cost for each fabric. The mill operates continuously during the quarter: 13 weeks, 7 days a week, and 24 hours a day. There are two types of looms: dobbie and regular. Dobbie looms can be used to make all fabrics and are the only looms that can weave certain fabrics, such as plaids. The rate of production for each fabric on each type of loom is also given in the table. Note that if the production rate is zero, the fabric cannot be woven on that type of loom. Also, if a fabric can be woven on each type of loom, then the production rates are equal. Calhoun has 90 regular looms and 15 dobbie looms. For this problem, assume that the time requirement to change over a loom from one fabric to another is negligible. Management would like to know how to allocate the looms to the fabrics and which fabrics to buy on the market so as to minimize the cost of meeting demand.arrow_forwardFiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from the last three years of operations: Quarter 1 2 3 4 5 6 89912 10 11 12 Machine-Hours 18,850 18,590 17,480 19,240 21,280 19,630 19,240 18,850 18,460 20,670 17,550 18,460 Labor-Hours 14,905 15,477 16,720 15,983 17,501 17,369 15,290 14,366 Required A Required B 15,994 16,995 14,278 18,444 Required: a. Use the high-low method to estimate the fixed and variable portions of factory costs based on labor-hours. b. Managers expect the plant to operate at 20,000 labor-hours next…arrow_forwardFiske Corporation manufactures a popular regional brand of kitchen utensils. The design and variety have been fairly constant over the last three years. The managers at Fiske are planning for some changes in the product line next year, but first they want to understand better the relation between activity and factory costs as experienced with the current products. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from the last three years of operations: Quarter 1 2 3 4 5 6 7 8 9 10 11 12 Machine-Hours 18,850 18,590 17,480 19,240 21,280 19,630 19,240 18,850 18,460 20,670 17,550 18,460 Labor-Hours 14,905 15,477 16,720 15,983 17,501 17,369 15,290 14,366 15,994 16,995 14,278 18,644 Factory costs $ 3,388,671 3,425, 136 3,617,144 3,573,240 3,812, 284 3,777,312 3,531,726 3,369,102 3,512,487 3,730, 734 3,206,415 3,723,786 Required: a. Use the high-low method to estimate the fixed and variable…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher: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