Question 1 Surrey Furniture Ltd is a UK company that manufactures two types of office desks,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 1 Surrey Furniture Ltd is a UK company that manufactures two types of office desks, named basic (Product A) and deluxe (Product B). The production data for the two products are shown in the table below. The company currently uses a job costing system to charge overheads to products on a factory-wide basis using direct labour hours as the absorption base. The budgeted overhead costs are £120,000 and 20,000 labour hours are expected to be used. Further information on the manufacturing of the two products are provided below: Product A Product B Volume produced (units) 2,000 3,000 Direct costs assigned directly to product: Direct material £26,000 £35,000 Direct labour £12,000 £18,000 Labour hours Machining Department 600 900 Inspection Department 500 600 Machine hours Machining Department 1,200 1,400 800 1,000 Inspection Department Production runs 200 180 Materials usage (kg) 22,000 25,000 The owner, Matthew, believes that this costing system is leading to inaccurate job costs and is considering changing to departmental overhead absorption rates based on the dominant activity in each department. Details of the costs and activities in the company's two departments are as follows: Inspection Machining 7,500 Labour hours 8,000 Machine hours 12,000 6,500 Overheads £80,000 £40,000 However, the new management accountant Marina believes that an activity based costing system would lead to much more accurate product costs and has allocated manufacturing overheads to activity-based cost pools. The amounts recorded for each activity and the level of the related cost driver identified are as follows: Activity Amount Cost driver Machine maintenance 12,000 MH £40,000 Machine hours £60,000 Production runs Production scheduling 8,000 PR 200,000 kg Material handling £20,000 Quantity of material (kg) Total £120,000 Required: a) Calculate the unit product cost of Product A and Product B according to the existing job costing system of charging manufacturing overhead to products. [8 marks] b) Calculate the unit product cost of Product A and Product B using departmental overhead rates as proposed by Matthew. [8 marks] c) Calculate the unit product cost of Product A and Product B using the cost drivers identified by the new management accountant, to allocate overheads to the two products. [8 marks] SUMMARY OF FORMULAS Cost-Volume Profit Analysis Contribution margin per unit (CMU) = Selling price per unit - Variable cost per unit B.E.P. in units = Fixed costs/CMU B.E.P. in revenues = B.E.P. in units x SPU Margin of safety = Sales units - B.E.P. in units Units to sell to get a profit = (Fixed costs + expected profit)/CMU Profit = Total Revenues-Variable Costs - Fixed costs Cost Allocation Overhead rate=1 Total indirect OR overhead costs Total volume allocation base Budgeting Sales Budget Budgeted sales = budgeted units x selling price per unit Production Budget Budgeted production (units) = Budgeted sales (units) + Target closing finished goods (units) - Opening finished goods (units) Material Budget Budgeted raw material usage = Required production (unit) x material required per unit Budgeted raw material purchase = Budgeted raw material + Target closing raw material stock - Opening raw material stock Cash Budget Cash Budget = opening balance + cash inflow - cash out flow Capital Investment Decisions FV₁ Net Present Value (NPV) = + FV₂ FV3 (1+r)² (1+r)³ ++ FV₂ (1+r)" lo (1+r)¹ NPV, Internal Rate of Return (IRR) = R₁ + {x(R_ -R₂) (NPV-NPV)}*(R. Accounting Rate of Return (ARR) = Average annual net profit before interest and taxes Initial Capital employed on the project Question 1 Surrey Furniture Ltd is a UK company that manufactures two types of office desks, named basic (Product A) and deluxe (Product B). The production data for the two products are shown in the table below. The company currently uses a job costing system to charge overheads to products on a factory-wide basis using direct labour hours as the absorption base. The budgeted overhead costs are £120,000 and 20,000 labour hours are expected to be used. Further information on the manufacturing of the two products are provided below: Product A Product B Volume produced (units) 2,000 3,000 Direct costs assigned directly to product: Direct material £26,000 £35,000 Direct labour £12,000 £18,000 Labour hours Machining Department 600 900 Inspection Department 500 600 Machine hours Machining Department 1,200 1,400 800 1,000 Inspection Department Production runs 200 180 Materials usage (kg) 22,000 25,000 The owner, Matthew, believes that this costing system is leading to inaccurate job costs and is considering changing to departmental overhead absorption rates based on the dominant activity in each department. Details of the costs and activities in the company's two departments are as follows: Inspection Machining 7,500 Labour hours 8,000 Machine hours 12,000 6,500 Overheads £80,000 £40,000 However, the new management accountant Marina believes that an activity based costing system would lead to much more accurate product costs and has allocated manufacturing overheads to activity-based cost pools. The amounts recorded for each activity and the level of the related cost driver identified are as follows: Activity Amount Cost driver Machine maintenance 12,000 MH £40,000 Machine hours £60,000 Production runs Production scheduling 8,000 PR 200,000 kg Material handling £20,000 Quantity of material (kg) Total £120,000 Required: a) Calculate the unit product cost of Product A and Product B according to the existing job costing system of charging manufacturing overhead to products. [8 marks] b) Calculate the unit product cost of Product A and Product B using departmental overhead rates as proposed by Matthew. [8 marks] c) Calculate the unit product cost of Product A and Product B using the cost drivers identified by the new management accountant, to allocate overheads to the two products. [8 marks] SUMMARY OF FORMULAS Cost-Volume Profit Analysis Contribution margin per unit (CMU) = Selling price per unit - Variable cost per unit B.E.P. in units = Fixed costs/CMU B.E.P. in revenues = B.E.P. in units x SPU Margin of safety = Sales units - B.E.P. in units Units to sell to get a profit = (Fixed costs + expected profit)/CMU Profit = Total Revenues-Variable Costs - Fixed costs Cost Allocation Overhead rate=1 Total indirect OR overhead costs Total volume allocation base Budgeting Sales Budget Budgeted sales = budgeted units x selling price per unit Production Budget Budgeted production (units) = Budgeted sales (units) + Target closing finished goods (units) - Opening finished goods (units) Material Budget Budgeted raw material usage = Required production (unit) x material required per unit Budgeted raw material purchase = Budgeted raw material + Target closing raw material stock - Opening raw material stock Cash Budget Cash Budget = opening balance + cash inflow - cash out flow Capital Investment Decisions FV₁ Net Present Value (NPV) = + FV₂ FV3 (1+r)² (1+r)³ ++ FV₂ (1+r)" lo (1+r)¹ NPV, Internal Rate of Return (IRR) = R₁ + {x(R_ -R₂) (NPV-NPV)}*(R. Accounting Rate of Return (ARR) = Average annual net profit before interest and taxes Initial Capital employed on the project
Expert Answer:
Answer rating: 100% (QA)
According to the data Any Survey furniture Ltd is a uk company d The Summary of unmit c... View the full answer
Related Book For
Practical Management Science
ISBN: 978-1305250901
5th edition
Authors: Wayne L. Winston, Christian Albright
Posted Date:
Students also viewed these general management questions
-
A large firm of solicitors uses a job costing system to identify costs with individual clients. Hours worked by professional staff are used as the basis for charging overhead costs to client...
-
A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted to painting type 1 trucks, 800 per day...
-
A company manufactures two types of electric hedge trimmers, one of which is cordless. The cord-type trimmer requires 2 hours to make, and the cordless model requires 4 hours. The company has only...
-
Write a program that takes an integer command-line argument n and prints all the positive powers of 2 less than or equal to n. Make sure that your program works properly for all values of n.
-
A dean of a business school claims that the Graduate Management Admission Test (GMAT) scores of applicants to the schools MBA program have increased during the past 5 years. Five years ago, the mean...
-
Open the Custom Field area and choose Invoice. On the invoice form, open the Gear menu and click Add Custom Field. How would you add a custom field to an invoice form?
-
You are a sales manager for an office supply distributor in a large metropolitan area. What do you use as your basic control unit in creating territories? Why?
-
Presented here are liability items for Desmond Inc. at December 31, 2014. Pre-pare the liabilities section of Desmonds balancesheet. 7,800 40,000 80,000 3,500 1,700 Accounts payable Notes payable...
-
What is the difference in revenue and expense recognition between the cash basis of accounting and the accrual basis of accounting?
-
Peyton Smith enjoys listening to all types of music and owns countless CDs. Over the years, Peyton has gained a local reputation for knowledge of music from classical to rap and the ability to put...
-
L=5m, B=5m, T=5m, H=20m, Density of water Pwater = 1001. kg m Atmospheric pressure po = 101, 325 kPa Uplift Puplift is 10% of absolute pressure at the bottom Calculate the lifting force required to:...
-
Ford motor company. Fair Value Measurements was discussed which is the relation to assets and liabilities measured at fair value, which can include complex financial instruments.
-
Throughout 2023 and 2024, the U.S. stock market opened higher after the Labor Department reported substantial national job growth. If an anthropologist were to study this phenomenon, what might he or...
-
Select all of the items that are the same on the direct and indirect methods of presenting the cash flow statement.
-
At January 1, 2024, Caf Med leased restaurant equipment from Crescent Corporation under a nine-year lease agreement. The lease agreement specifies annual payments of $32,000 beginning January 1,...
-
What is the most common way of amortizing a loan? A single, fixed payment every period a single, variable payment every period several variable payments every period several declining payments every...
-
In the Kraljic Purchasing Portfolio Model, which type of product typically has very little financial impact on the buyer's own products and also there are plenty to choose from in the market place?...
-
6 (a) Briefly develop a mathematical model of the behaviour of a copper-twisted pair cable (b) Derive the magnetic energy from: w given that: K + w, where the - - k symbols have their usual meaning...
-
A European put option allows an investor to sell a share of stock at the exercise price on the exercise data. For example, if the exercise price is $48, and the stock price is $45 on the exercise...
-
Continuing the previous problem, perform a sensitivity analysis on the selling price of VXPs. Let this price vary from $500 to $650 in increments of $10, and keep track of the values in the changing...
-
Sometimes a "single-stage" decision can be broken down into a sequence of decisions, with no uncertainty resolved between these decisions. Similarly, uncertainty can sometimes be broken down into a...
-
Consider the Gompertz model in Eq. (12.35). Graph the expectation function for \(\theta_{1}=1, \theta_{3}=1\), and \(\theta_{2}=\frac{1}{8}, 1,8,64\) over the range \(0 \leq x \leq 10\). Equation...
-
Reconsider the regression models in Problem 12.6, parts a-e. Suppose the error terms in these models were multiplicative, not additive. Rework the problem under this new assumption regarding the...
-
Reconsider the data in the previous problem. The response measurements in the two columns were collected on two different days. Fit a new model \[ y=\theta_{3} x_{2}+\theta_{1} e^{\theta_{2}...
Study smarter with the SolutionInn App