Question

In: Accounting

Life Symphony Enterprises (LSE) produces health and beauty products with manufacturing and distribution facilities all over...

Life Symphony Enterprises (LSE) produces health and beauty products with manufacturing and distribution facilities all over the UK. The company currently employs 1,000 employees with an annual turnover of £30m. Sally Mason is the Group Management Accountant of the firm and her primary role includes supporting other staff working in various divisions in making decisions on cost management; divisional performance evaluation and operational priorities. This week, she has received several queries from various offices. You, as a promising intern, has been appointed to assist her in various investigations. In your interview for this position, you had demonstrated your knowledge in various management accounting issues, for instance, cost classifications, behavioural analysis, cost reporting under marginal and variable costing, traditional costing system, Activity-based costing system and variance analysis. Sally is really looking forward to working with you and on your fifth day in the job, she has handed you email trails, notes and conversation with her colleagues. You have arranged all materials in order and found the following:

  1. On 10th February, 2020 John Beecroft from the group’s Hull Division sent her an email asking for some clarification on cost calculation. The division estimates overhead costs as £12 per machine hour. John observed that in the last few months, the estimated overhead costs could not predict the product cost well. John sent the following 8 occurrences as evidence:

Machine hours

Actual Overhead costs (£)

1,000

10,700

1,500

15,700

1,250

13,200

2,100

21,700

1,875

19,500

1,680

17,500

2,250

23,200

1,725

17,950

Sally’s note suggests that counting overheads as a variable cost probably cause the inaccurate estimates though she put several interrogative signs (???) suggesting further investigation.

Write an email/ note on behalf of Sally to John explaining the possible causes of distorted overhead cost per machine hour by exhibiting an application of any management accounting technique that may provide a better result.  

Solutions

Expert Solution

Requirement 2 Machine Hours Actual Overhead costs (£) Max 2,250 Min 1,000 machine hours giving negative fixed cost have not been considered 23,200 the costs at the highest level of activity, 10,700 the costs at the lowest level of activity High Low method takes two extreme activity levels (i.e. no of machine hours) from a set of actual data of various activity levels and their corresponding High-Low Method Formulas Variable cost per machine hour (b) is calculated using the following formula: Variable Cost per machine hour = (y2 - y1) /( x2-x1) Y2 is the total cost at highest level of activity; Y1 is the total cost at lowest level of activity; x2 are the number of machine hours at highest level of activity; and x1 are the number of machine hours. at lowest level of activity Variable Cost per machine hour(b) = (y2 - y1)/(x2-x1) 23,200 10,700 2,250 1,000 10.00 The variable cost per machine hour is equal to the slope of the cost volume line (i.e. change in total cost = change in number of machine hours produced) Total fixed cost (a) is calculated by subtracting total variable cost from total cost, thus: Total Fixed Cost (a) = y2 - bx2 = y1 – bx, 700.00 700.00 y = a + bx Y (Overhead costs)= $10x +$ 700 Where x is the number of machine hours required The overhead cost given above is in the nature of mixed cost which has component of both fixed and variable element hence, counting overheads only as a variable cost probably cause the inaccurate estimates. The high-low method is a management accounting technique used to split mixed costs into variable and fixed costs. The fixed component is £700 The variable cost is £10 per Machine hour Y (Overhead costs)= $10x +$700


Related Solutions

A manufacturing company produces three products. All products need to be processed on machines. For the...
A manufacturing company produces three products. All products need to be processed on machines. For the production times, product 1 uses 15 minutes per unit, product 2 uses 17 minutes per unit and product 3 uses 20 minutes per unit. The total regular machine time is 2500 minutes per day. The daily demand of product 1 is between 150 to 200 units and that of product 2 is no more than 55 units and that of product 3 is no...
Milton Manufacturing Company produces a variety of textiles for distribution to wholesale manufacturers of clothing products....
Milton Manufacturing Company produces a variety of textiles for distribution to wholesale manufacturers of clothing products. The company’s primary operations are located in Long Island City, New York, with branch factories and warehouses in several surrounding cities. Milton Manufacturing is a closely held company, and Irv Milton is the president. He started the business in 2008, and it grew in revenue from $500,000 to $5 million in 10 years. However, the revenues declined to $4.5 million in 2018. Net cash...
Josh Garrett is Head of Packaging and Distribution at Biotech Health and Life Products (Biotech). Josh...
Josh Garrett is Head of Packaging and Distribution at Biotech Health and Life Products (Biotech). Josh is in charge of all of the branches the company has throughout the world. Josh has been reviewing cost reports for the different branches. He is concerned with some of the results. His main concern is with the rising costs of unskilled labor at the Germany branch. Many of the employees in the Packaging Department are classified as unskilled laborers making minimum wage. Josh...
Simpson Manufacturing Enterprises uses a joint production process that produces three products at the split-off point....
Simpson Manufacturing Enterprises uses a joint production process that produces three products at the split-off point. Joint production costs during April were $720,000. Product information for April was as follows: Product R S T Gallons produced 2,500 5,000 7,500 Sales prices per gallon: At the split-off $ 100 $ 80 $ 20 After further processing $ 150 $ 115 $ 30 Costs to process after split-off $ 150,000 $ 150,000 $ 100,000 Required: (use a separate sheet to show your...
ABC Manufacturing Corp. is a private company that operates three manufacturing facilities. Each manufacturing facility produces...
ABC Manufacturing Corp. is a private company that operates three manufacturing facilities. Each manufacturing facility produces one of the three product lines ABC sells. ABC purchased the facilities using nonrecourse debt. (Nonrecourse debt is a loan that is secured by a pledge of collateral, in this case the facility, but for which the borrower is not personally liable. If the borrower defaults, the lender can seize the collateral, but the lender’s recovery is limited to the collateral.) Each facility is...
The ABC Corporation is a large multinational company that has facilities (both manufacturing and distribution) located...
The ABC Corporation is a large multinational company that has facilities (both manufacturing and distribution) located in many U.S. states and in overseas countries. The corporation’s long-serving chief financial officer (CFO) just retired, and his replacement is reviewing the corporation’s economic balance sheet. She discovers that the corporation leases many of its distribution facilities and relies heavily on long-term debt for financing. She vaguely recalls having heard about implicit taxes and tax clienteles and would like these concepts explained and...
IT Excel Sdn. Bhd., a manufacturing company that produces a computer component leases a building for RM250,000 per year for its manufacturing facilities.
IT Excel Sdn. Bhd., a manufacturing company that produces a computer component leases a building for RM250,000 per year for its manufacturing facilities. In addition, the machinery in this building is being paid for in installments of RM50,000 per year. Each unit of the product produced costs RM40 in labor and RM20 in materials. The variable costs are estimated at 60 percent of total revenue.(a) Determine the price per unit of the product(b) Calculate the quantity at which the manufacturer...
Galaxy Inc., an American multinational that sells consumer electronic products, has manufacturing facilities in three countries:...
Galaxy Inc., an American multinational that sells consumer electronic products, has manufacturing facilities in three countries: Mexico, Taiwan, and Canada. The average hourly wage rate, output per worker, and annual overhead cost for each location are as follows Mexico Taiwan Canada Hourly wage rate Output per worker Fixed overhead cost $3.00 20 $150,000 mexico $6.00 36 $90,000. taiwAn $12.00 40 $110,000 canda Given the above figures, in your opinion, is Galaxy currently allocating its production resources optimally? If not, what...
The annual production of a manufacturing company that produces generators follows a normal distribution with a...
The annual production of a manufacturing company that produces generators follows a normal distribution with a mean µ=1200 and standard deviation σ=100. 1) The shading area for the probability between 1100 and 1300 units is? 2) The probability of producing between 1100 and 1350 units is ? 3) The probability of producing less than 1200 units is? 4) The probability of producing between 1200 and 1350 units is . 5) A student intends to measure the boiling temperature of a...
Pitt Enterprises manufactures jeans. All materials are introduced at the beginning of the manufacturing process in...
Pitt Enterprises manufactures jeans. All materials are introduced at the beginning of the manufacturing process in the Cutting Department. Conversion costs are incurred uniformly throughout the manufacturing process. As the cutting of material is completed, the pieces are immediately transferred to the Sewing Department. Information for the Cutting Department for the month of May follows. Work in Process, May 1 (32,000 units, 100% complete for direct materials, 80% complete with respect to conversion costs; includes $71,400 of direct material cost;...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT