Explore BrainMass
Share

Explore BrainMass

    Scenario Summary in Microsoft Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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

    © BrainMass Inc. brainmass.com October 9, 2019, 11:54 pm ad1c9bdddf
    https://brainmass.com/business/finance/271770

    Solution Summary

    The solution explains how to create a Scenario Summary in Microsoft Excel

    $2.19