Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You have recently been appointed as a senior accountant at an automobile company. You notice that no one has created method to apply overhead to

You have recently been appointed as a senior accountant at an automobile company. You notice that no

one has created method to apply overhead to the products, and they are currently being sold without

this value added to them. Currently all overhead is considered an administrative expense on the

profit/loss statement as they aren't sure which product to apply it to. Understanding that this has an

impact on reporting, and decision making, you have decided to implement a method of traditional based

costing. You're pretty sure that using job costing is the way to go. From what you've been told by your

support staff, the amount to tires used is a good indicator of how much overhead relates to that

product. Of the overhead applied, approximately 30% is variable. For the direct materials, approximately

40% is variable, while only 10% of the direct labour is considered variable. The market is infinite and will

accept as many vehicles as you are willing to produce.

1) How many units, of each product, do you need to produce in order to make a profit of $500.

Provide support. (60)

You have now been approached by a consultant who claims that they can increase your sales of each

product by 20% if you are willing to pay them $300 each year.

2) Is this a good idea, why? Provide support. (25)

3) What is the new breakeven in dollars? Provide support. (15)

Please show me the formula calculation in the xcel sheet.

image text in transcribedimage text in transcribedimage text in transcribed
Question 1 Estimated Activity Fast Slow Kinda Slow MOH ($) Tires 33 34 13 82 Doors 24 16 20 38 Acutal DM ($) 10 13 15 DL ($) 12 14 16 MOH Total Price ($) 40 50 60 Tires Used 12 33 14 Doors Used 18 22 34 Target Profit Consultant Costs Fast Slow Kinda Slow Current Units Sold Before Your Arrival 10 20 30 Fast Slow Kinda Slow Price per model Less variable expenses: DMFast Slow Kinda Slow Price per model Less variable expenses: DM DL MOH Total Variable Costs Contribution margin per model Fast Slow Kinda Slow FC DM DL MOH Total Overall Cash Required Fast Slow Kinda Slow Breakeven in UnitsQuestion 2 Price Change Price Per Model Less variable expenses: Contribution margin per model Revised Ca sh Requied Breakeven in Units Breakeven in Sales Good idea? Why

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

Step: 3

blur-text-image

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

Comprehensive Assurance & Systems Tool An Integrated Practice Set

Authors: Laura R Ingraham, J Greg Jenkins

3rd Edition

0133251969, 9780133251968

More Books

Students also viewed these Accounting questions

Question

What are the need and importance of training ?

Answered: 1 week ago

Question

What is job rotation ?

Answered: 1 week ago

Question

2. In what way can we say that method affects the result we get?

Answered: 1 week ago