(Answered) Petty components makes a variety of parts for the auto

Accounting

Petty Components makes a variety of parts for the Auto Industry. One of these parts (TR 17) does not seem to be contributing to profits. The selling price of the part is $22.75, the variable cost is $17.50 and the Fixed Cost for this product is $105,000 per year. In the past fiscal year, 18,000 of this product was produced and sold.

A. Construct a correct, flexible and documented spreadsheet model that will allow varying inputs and resulting revenue, costs and profit. Check the base case above to see if the company is losing on this part.

B. Using the model and Goal Seek, find the break even quantity.

C. Construct a data table and chart showing profit vs. quantity.

D. Mr. Petty is trying to determine where to put his efforts in attempting to increase the profitability for TR 17. Should we increase sales volume by 33% or reduce the variable cost by 12%. Using the model, determine which method would increase profitability more.

View complete question

Accounting Basics, Accounting

Category:- Accounting Basics
Reference No.:- M91640650
Price:- $10

Verified Expert

Priced at $20 Now at $10, Verified Solution

Have any Question?Write your Review or question?

Related Questions in Accounting Basics

Question - teresa is an accomplished actress during the

Question - Teresa is an accomplished actress. During the summer, she rented a vacant store to stage productions of four plays, using the local townspeople as actors and stagehands. She sold $24,000 of tickets to the vari ...

Question - on january 1 2016 company x had an inventory

Question - On January 1, 2016, Company X had an inventory balance of $200,000. During the year, Company X had net purchases of $1,000,000 and net sales of $900,000. Historically, Company X's gross profit ratio has been 4 ...

Question - the pritzker music pavilion in downtown chicago

Question - The Pritzker Music Pavilion in downtown Chicago is a technologically sophisticated and uniquely designed performing arts venue that hosts live concerts attended by over half a million patrons a year. A group o ...

Question evaluating the purchase of an asset with various

Question: Evaluating the Purchase of an Asset with Various Capital Budgeting Methods In this activity, you will be evaluating whether you should purchase a hybrid car or its gasoline-engine counterpart. Select two car mo ...

Question - the will of the decedent established a trust for

Question - The will of the decedent established a trust for the benefit of his wife and two sons. The trust states that the trustee shall pay to the widow $25,000 a year and $12,500 a year to each of his two sons. There ...

Question - sheffield corporation operates a retail computer

Question - Sheffield Corporation operates a retail computer store. To improve delivery services to customers, the company purchases four new trucks on April 1, 2017. The terms of acquisition for each truck are described ...

Question answer the following questions1 it has been said

Question: Answer the following questions: 1. It has been said that independence is the cornerstone of the accounting profession. Explain what this means. What does it mean to say that auditors have special and critical g ...

Question - jacks jax has total fixed cost of 25000 if the

Question - Jack's Jax has total fixed cost of $25,000. If the company's contribution margin is 60%, the income tax rate is 25% and the selling price of a box of Jax is $20, how many boxes of Jax would the company need to ...

Question - on may 1 2016 benzs sandwich shop loaned 14000

Question - On May 1, 2016, Benz's Sandwich Shop loaned $14,000 to Mark Henry for one year at 6 percent interest. Required - a. What is Benz's interest income for 2016? b. What is Benz's total amount of receivables at Dec ...

Question - us steel issues a 2000000 bond at 10 for 8 years

Question - US Steel issues a $2,000,000 bond at 10% for 8 years. The market interest rate is 9%. Be sure to use the time value of money tables, not the formulas; and round your answers to the nearest whole dollars. Quest ...

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Accounting Basics Expert