Exceptional line of magnetized wheels

Assignment Help Finance Basics
Reference no: EM1354443

JumboMags makes an exceptional line of magnetized wheels that custom car builders use in kits.

They provided you with the following information:
Product: A13847 - Jumbo Mag

Selling Price at $185.00/unit
Variable Cost: $87.50
Fixed Cost: $250,000
Units Sold Last year: 10,800

JumboMags gave you the following possible scenarios:

1. Break-even at same unit price and same variable price

2. Changed Product: An increase in selling price (from $185 to $225) by adding granite mix paint flecks which will also increase variable cost from ($87.50 to $97.50) and with an increase in units to 12,500 units

3. Compete: An increase in existing product selling price (from $185 to $205) with no change in variable costs and a predicted sales of 11,500 units

4. Worst: A decrease in existing product selling price (from $185 to $180) with an increase in variable costs because of shipping/gas higher prices (from $87.50 to 135.50) and sales at 7,500 because with higher gas prices, luxury items will not be as popular.

Please complete a Scenario Summary in Excel. Make sure to label the scenario so that it looks good. Then write a summary report using an appropriate template.

Make sure you put the raw data in excel and run the scenario summary. It will create a new page.
Keep the raw data on one tab
Make sure to include an analysis of the data. You will have to calculate break even
Hint: Break even should be $0.00

 

Reference no: EM1354443

Questions Cloud

Explain dimension of ethical leadership : Explain Dimension of Ethical Leadership and Support the content of your post with at least one academic journal article.
Analyze the coulombs law : Two charges, qA and qB, are divided by a distance, d, and exert a force, F, on each other. Analyze Coulomb's law and answer the following questions.
Importance and demand for audit : Explain the importance and demand for audit and other assurance services. Explain the auditor's role in providing assurance.
Kraft foods company''s organizational design and strategy : Describe the company plan and design for Kraft Foods Company's as well as their main tactical control systems, the largest human assets and issues
Exceptional line of magnetized wheels : JumboMags creates an exceptional line of magnetized wheels that custom car builders use in kits. An rise in selling price through adding granite mix paint flecks which will also increase variable expenses from and with an increase in units to 12,500 ..
Concept of a coherence approach to truth : Explain the concept of a coherence approach to truth and the role of this approach in the biblical counselling model and the way this view influences BCM's perspective on the relationship between psychology and counselling.
Danger of relationships between client and auditor : There is a danger that interpersonal relationships between client/auditor can potential affect whether the audit evaluation produced is unbiased.
Where does the energy come from : A 50 kg woman stands on the back of a 6 m long, 125 kg raft that is floating at rest in still water with no friction. The raft is 0.50 m from a fixed pier.
Performance management and organizational effectiveness : Assess the strengths and weaknesses of the performance management system in your own, current organization

Reviews

Write a Review

Finance Basics Questions & Answers

  Advantages also disadvantages of stock-for-stock

Elucidate the advantages also disadvantages of stock-for-stock transactions also cash-for-stock transaction.

  Discuss the factors that lead to a valuation of a company

D iscuss the factors that lead to valuation of a firm's worth compared to that of the financial statements, & how firm executives develop the most value for all stakeholders.

  Computation of price of the bond

Computation of price of the bond and what rating must Luther receive on these bonds if they want the bonds to be issued at par

  Computing risk-free rate and the expected return using capm

Computing risk-free rate and the expected return using CAPM and Define a linear regression model consisdent with CAPM in the following way

  Classification of transaction

Given below are transactions or items that are frequently reported in financial statements.

  Free cash flow method of business valuation focus

Multiple choice questions on Cash flow method and sources of external capital and What does the free cash flow method of business valuation focus on?

  Maximum deductible contribution

Determine the  maximum deductible contribution

  Calculate the degree of operating and financing leverage

Corporation X wants to create additional supply development space. The additional space will cost $450,000. The expansion can be financed either by bonds at interest rate of 8 percent, or by selling 40,000 shares of common stock at $20 per share.

  Common denominator to evaluate precise tradeoffs

Tradeoff between 2 decision criteria such as ease of commuting & attractiveness of job, can you use money as a common denominator to evaluate precise tradeoffs?

  Description of stock transactions

On January 1, Armada Corporation had 95,000 shares of no-par common stock issued and outstanding. The stock has a stated value of $5 per share. During the year, the following occurred

  Principal and interest payment

Pauline wonders what her monthly principal and interest payment would be under these circumstances. Use M.S. Excel spreadhseet and PMT Function to help answer:

  Computing the future value of annuity

An employee works at the local hamburger restaurant for 40 years and never earns more than minimum wage-What are your thoughts regarding this sum?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd