Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Master Tool Corporation Limited (MTCL) is a private company that currently manufactures 3 different pliers. Melissa Scranton, the company president, is concerned that MTCL has

image text in transcribed

Master Tool Corporation Limited (MTCL) is a private company that currently manufactures 3 different pliers. Melissa Scranton, the company president, is concerned that MTCL has been losing its market share, and its operating results are deteriorating. You are working as a summer student at MTCL. The company controller is away on vacation and Melissa has asked you to have a look at the production and sale issues MTCL is currently experiencing. In your review of direct manufacturing costs, you note that MTCL has recently upgraded to computer-aided manufacturing equipment that has virtually eliminated waste and spoiled units. As a result, direct labour costs have been cut by 20% per year over the last 5 years. Melissa doesn't think it is possible to reduce costs any further. Melissa was able to provide you with the standard cost report (Appendix 1) that was put together when planning for the current year's budget. This report explains how MTCL currently allocates overhead costs. The VP of Sales at MTCL things he can improve results by adding a new product line - Wrench Sets (Appendix 2). He is certain the wrench sets will make money, but the cost and profit projections aren't supporting his claim The VP of Manufacturing is concerned about scheduling and doesn't know how she is going to manage production, especially if the wrench sets are added. She tells you, "We've been working at close to our capacity, using 170,000 of the available 180,000 machine hours, and costs have been right on target. It's the scheduling of work on machines that is causing me the biggest headache. We're barely managing to keep up with the sales orders, but with any increase in sales, we'll end up with backorders." Required: 1) MTCL currently allocates non-direct costs to product lines based on a variety of drivers (Appendix 1). Melissa would like you to review the current allocations. Please advise whether the current allocations for Manufacturing Overhead Cost, Variable Selling & Admin Cost and Fixed Selling & Admin Cost are appropriate. If they are not appropriate, suggest improvement(s) and explain how the changed allocations would be better. (5 marks) then provide the updated full cost per unit for each of the current product lines. (16 marks) Appendix 1 Master Tool Corporation Limited Standard Cost Summary For the year ending July 31, 20x2 Appendix 2 1. 15-cm pliers Proposed 20-cm pliers Manufacturing overhead is allocated to products at a predetermined rate based on direct labour in dollars. Economy pliers Wrench set Standard unit costs: Budgeted overhead $2.975,000* $10 Per dollar of labour hour costs Direct materials $1.10 $2.75 $3.35 $4.00 Budgeted direct labour $297,500 Direct labour 0.5 0.65 0.75 1 Overhead (Note 1) 5 6.5 7.5 10 *90% of total overhead is composed of depreciation, regular maintenance, related salaries, and Total manufacturing costs 6.6 9.9 11.6 $15.00 other fixed manufacturing costs. The remaining 10% of overhead costs are variable and include the Variable selling & admin costs (Note 2) 0.55 1.1 1.1 costs of operating the machines. Fixed selling & admin costs (Note 3) 0.26 0.4 0.46 0.46 Total cost $7.21 $10.85 $13.16 $16.56 Budgeted fixed selling & admin costs $177.680 4% of manufacturing costs Labour hours per unit 0.04 0.05 0.06 Budgeted total manufacturing costs $4,442,000 Machine hours per unit 0.25 0.25 1 0.5 Variable selling and administrative costs consist entirely of sales commissions. Commission amounts per Unit sales 100,000 300,000 70,000 40,000 unit were negotiated with the salespeople two years ago. Selling price per unit $7.50 $12.00 $14.50 $14.00 Fixed selling and administrative costs are allocated to products at predetermined rate based on total manufacturing costs. 0.35 Master Tool Corporation Limited (MTCL) is a private company that currently manufactures 3 different pliers. Melissa Scranton, the company president, is concerned that MTCL has been losing its market share, and its operating results are deteriorating. You are working as a summer student at MTCL. The company controller is away on vacation and Melissa has asked you to have a look at the production and sale issues MTCL is currently experiencing. In your review of direct manufacturing costs, you note that MTCL has recently upgraded to computer-aided manufacturing equipment that has virtually eliminated waste and spoiled units. As a result, direct labour costs have been cut by 20% per year over the last 5 years. Melissa doesn't think it is possible to reduce costs any further. Melissa was able to provide you with the standard cost report (Appendix 1) that was put together when planning for the current year's budget. This report explains how MTCL currently allocates overhead costs. The VP of Sales at MTCL things he can improve results by adding a new product line - Wrench Sets (Appendix 2). He is certain the wrench sets will make money, but the cost and profit projections aren't supporting his claim The VP of Manufacturing is concerned about scheduling and doesn't know how she is going to manage production, especially if the wrench sets are added. She tells you, "We've been working at close to our capacity, using 170,000 of the available 180,000 machine hours, and costs have been right on target. It's the scheduling of work on machines that is causing me the biggest headache. We're barely managing to keep up with the sales orders, but with any increase in sales, we'll end up with backorders." Required: 1) MTCL currently allocates non-direct costs to product lines based on a variety of drivers (Appendix 1). Melissa would like you to review the current allocations. Please advise whether the current allocations for Manufacturing Overhead Cost, Variable Selling & Admin Cost and Fixed Selling & Admin Cost are appropriate. If they are not appropriate, suggest improvement(s) and explain how the changed allocations would be better. (5 marks) then provide the updated full cost per unit for each of the current product lines. (16 marks) Appendix 1 Master Tool Corporation Limited Standard Cost Summary For the year ending July 31, 20x2 Appendix 2 1. 15-cm pliers Proposed 20-cm pliers Manufacturing overhead is allocated to products at a predetermined rate based on direct labour in dollars. Economy pliers Wrench set Standard unit costs: Budgeted overhead $2.975,000* $10 Per dollar of labour hour costs Direct materials $1.10 $2.75 $3.35 $4.00 Budgeted direct labour $297,500 Direct labour 0.5 0.65 0.75 1 Overhead (Note 1) 5 6.5 7.5 10 *90% of total overhead is composed of depreciation, regular maintenance, related salaries, and Total manufacturing costs 6.6 9.9 11.6 $15.00 other fixed manufacturing costs. The remaining 10% of overhead costs are variable and include the Variable selling & admin costs (Note 2) 0.55 1.1 1.1 costs of operating the machines. Fixed selling & admin costs (Note 3) 0.26 0.4 0.46 0.46 Total cost $7.21 $10.85 $13.16 $16.56 Budgeted fixed selling & admin costs $177.680 4% of manufacturing costs Labour hours per unit 0.04 0.05 0.06 Budgeted total manufacturing costs $4,442,000 Machine hours per unit 0.25 0.25 1 0.5 Variable selling and administrative costs consist entirely of sales commissions. Commission amounts per Unit sales 100,000 300,000 70,000 40,000 unit were negotiated with the salespeople two years ago. Selling price per unit $7.50 $12.00 $14.50 $14.00 Fixed selling and administrative costs are allocated to products at predetermined rate based on total manufacturing costs. 0.35

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Modeling Using Excel And VBA

Authors: Chandan Sengupta

1st Edition

0471267686, 978-0471267683

More Books

Students also viewed these Finance questions

Question

What would happen if the tension force exceeded 51.5 N

Answered: 1 week ago

Question

undertake a thematic analysis of your data;

Answered: 1 week ago