1.
Compute the cost of inputs for the profile 2015, if there is no change from productivity profile 2014 to 2015.
1.
Explanation of Solution
Productivity measurement: The productivity measurement refers to the quantitative assessment of the changes in the productivity.
Profile measurement and analysis: The profile measurement and analysis refers to the computation of a set of operational partial productivity measures and their comparison to the corresponding set of base period, for the assessment of the nature of changes in productivity.
Calculate the cost of inputs for the profile 2015:
Particulars | Amount ($) |
Cost of labor (3) | $1,260,000 |
Cost of materials (4) | $6,300,000 |
Total PQ Cost | $7,560,000 |
Table (1)
Working Notes (1):
Compute the base period productivity ratios for profile 2014:
Compute the Labor Productivity Profile for 2014:
Working Notes (2):
Compute the Material Productivity Profile for 2014:
The Labor Productivity Profile is 5.00 and Material Productivity Profile is 0.25 for 2014.
Working Notes (3):
Calculate the cost of labor:
Working Notes 4):
Calculate the cost of materials:
2.
Compute the actual cost of inputs for the profile 2015. Indicate the net value of productivity changes and identify the profit change attributable to productivity change of each unit.
2.
Explanation of Solution
Profit-linked productivity measurement and analysis: The profit-linked productivity measurement and analysis is the ascertainment of the amount of change in profit, from the base period to the current period, due to the various changes in the productivity.
Calculate the current cost of inputs for the profile 2015:
Particulars | Amount ($) |
Cost of labor (5) | $1,575,000 |
Cost of materials (6) | $5,250,000 |
Total Current Cost | $6,825,000 |
Table (2)
Working Notes (5):
Calculate the cost of labor:
Working Notes (6):
Calculate the cost of materials:
Compute the profit linked productivity measure:
Input | A | C | E | ||||
Labor | 5 | 90,000 | $14 | $1,260,000 | 112,500 | $1,575,000 | ($315,000) |
Materials | 0.25 | 1,800,000 | $3.50 | $6,300,000 | 1,500,000 | $5,250,000 | $1,050,000 |
Total | $7,560,000 | $6,825,000 | $735,000 |
Table (3)
The Net productivity change is $735,000.
The Labor productivity change is ($315,000).
The materials productivity change is $1,050,000.
3.
Compute and describe the price recovery component.
3.
Explanation of Solution
Price-recovery component: The price-recovery component refers to the differences amongst the changes in the total profit with the changed in the productivity effects.
Compute the profit linked productivity measure:
Particulars | Profile 2014 | Profile 2015 | Changes Amount ($) |
Revenues | (7) $10,800,000 | (8) $9,900,000 | (9) ($900,000) |
Costs | (10) $8,640,000 | $6,825,000 | (11) $1,815,000 |
Total Profit | $2,160,000 | $3,075,000 | (12) $915,000 |
Table (4)
Working Notes (7):
Calculate the Revenues for Profile for 2014:
Working Notes (8):
Calculate the Revenues for Profile for 2015:
Working Notes (9):
Calculate the changes in revenues:
Working Notes (10):
Calculate the cost of inputs for Profile 2014:
Working Notes (11):
Calculate the changes in cost of inputs:
Working Notes (12):
Calculate the changes in total profit:
Compute the Price-recovery component:
The Price-recovery component is $180,000.
Want to see more full solutions like this?
Chapter 15 Solutions
Cornerstones Of Cost Management
- In 20x2, Choctaw Company implements a new process affecting labor and materials. The following reported data are provided to evaluate the effect on the companys productivity: Required: 1. Calculate the productivity profile for 20x1. 2. Calculate the productivity profile for 20x2, and comment on the effect of the new production and assembly process. 3. What if the labor hours used in 20x2 were 112,500? What does comparison of the 20x1 and 20x2 profiles now communicate?arrow_forwardThis cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the companys utility costs as an equation where X represents number of tables produced. Predict the utility costs if 800 tables are produced. Predict the utility costs if 600 tables are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of tables produced and utility expenses.arrow_forwardWachowski Company reported these cost data for the year 2017. Use the data to complete the following table. Total prime costs Total manufacturing overhead costs Total conversion costs Total product costs Total period costsarrow_forward
- The president of a small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firms leading product over the past eight years: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. c. What is the average cost increase that the firm has been realizing per year? d. Compute an estimate of the cost/unit for next year.arrow_forwardThis cost data from Hickory Furniture is for the year 2017. Using the high-low method, express the factory utility expenses as an equation where x represents number of chairs produced. Predict the utility costs if 900 chairs are produced. Predict the utility costs if 750 chairs are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between number of chairs processed and utility expenses.arrow_forwardThe Perry Products Company needs to predict the labor cost in producing made-to-order mugs. The following production information is available: Year Mugs Produced Labor-Hours Labor Cost 2012 1,150 850 $ 8,400 2013 1,600 975 $ 9,000 2014 1,100 800 $ 7,900 2015 2,100 1,150 $10,700 2016 1,500 950 $ 9,700 2017 1,300 875 $ 9,900 Select the appropriate independent variable for estimating labor cost. Explain the reason for your selection. Develop an equation for labor costs using the high-low method of cost estimation, and predict total costs for an annual usage of 2,500 labor hours. I need the part of " and predict total costs for an annual usage of 2,500 labor hours." answered it was left off when i first asked this questionarrow_forward
- At the end of 2021, Mejorar Company implemented a low-cost strategy to improve its competitive position. Its objective was to become the low-cost producer in its industry. A Balanced Scorecard was developed to guide the company toward this objective. To lower costs, Mejorar undertook a number of improvement activities such as JIT production, total quality management, and activity-based management. Now, after two years of operation, the president of Mejorar wants some assessment of the achievements. To help provide this assessment, the following information on one product has been gathered: 1. Compute the following measures for 2021 and 2023: a. actual velocity and cycle time (2021 and 2023) (My question: In the book it stated that Actual Velocity (# units produced/time) and Cycle Time (time/# units produced) However, which one is per hour and per minute Or maybe I wrong let me know?) b. Percentage of total revenue from new customers (2021 and 2023) (assume one unit per customer) c.…arrow_forwardTaunton Company uses the high-low method to estimate its cost function. The information for 2017 is provided below: Machine-hours Labor Costs Highest observation of cost driver 3,000 $300,000 Lowest observation of cost driver 2,500 $277,500 What is the constant for the estimated cost equation?arrow_forwardJamison examined monthly data for 2016 (not given in the case), and she detected an improving pattern during the year. Monthly sales were rising, costs were falling, and large losses in the early months had turned to a small profit by December. Thus, the annual data look somewhat worse than the final monthly data. Also, it appears to be taking longer for the advertising program to get the message out, for the new sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words, the lags between spending money and deriving benefits were longer than D’Leon’s managers had anticipated. For these reasons, Jamison and Campo see hope for the company—provided it can survive in the short run. Jamison must prepare an analysis of where the company is now, what it must do to regain its financial health, and what actions should be taken. Your assignment is to help her answer the following questions. Provide clear explanations, not yes or no answers.…arrow_forward
- The C and K Company makes a household appliance with model number X400. The goal for 2017 is to reduce direct materials usage per unit. No defective units are currently produced. Manufacturing conversion costs depend on production capacity defined in terms of X500 units that can be produced. The following additional data are available for 2016 and 2017: 2016 2017 Units of X400 produced and sold 12,000 13,800 Selling price $145 $140 Direct materials (square feet) 36,000 34,800 Direct manufacture costs per square foot $13 $15 Manufacturing capacity for X400 (units) 14,000 13,900 Total conversion costs $406,000 $403,100 Conversion costs per units of capacity $29 $29 Calculate the operating income in 2016 and 2017. Calculate the growth, price-recovery, and productivity component that explain the change in operating income from 2016 to 2017.arrow_forwardTaunton Company uses the high-low method to estimate its cost function. The information for 2017 is provided below: Machine-hours Labor Costs Highest observation of cost driver 4,000 $332,000 Lowest observation of cost driver 3,000 $312,000 What is the estimated total cost when 1,900 machine-hours are used?arrow_forwardRecognising that there would be fierce competition to regain lost markets, Management felt that there should be a renewed focus on the productivity and profitability of the operations. The productivity analysis would focus on the Manufacturing department, and the profitability would examine both products. To conduct this analysis, you have extracted the following information for the Manufacturing Department for the month of January: At the start of the month there were 1,000 units in stock, which were 20% complete with respect to conversion costs, and was valued at $ 16,000. During the month, 9,000 units were introduced to the production. At the end of the month there were 1,000 units in stock which were 40% complete with respect to conversion costs. All Materials are added at the start of the process. Costs incurred for the month were: Materials - $ 63,000; Conversion costs - $ 139,840. The Department uses a FIFO costing system. Further examination of the records showed the…arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT