Purchase Solution

Scenario Summary in Microsoft Excel

Not what you're looking for?

Ask Custom Question

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

Purchase this Solution
Solution Summary

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

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

View More Free Quizzes
Related BrainMass Solutions

  • Data set analysis using research team scenario

    A report is provided in Microsoft Word with the following sections and corresponding content: introduction, data selected, discussion of what was learned, and a summary of what can be taken away from this information.

  • Job Satisfaction Survey: A Statistical Analysis

    Calculations and Pie-Charts have been shown in EXCEL. The Report containing the Analysis and Interpretation of Results have been provided in Microsoft Word.

  • PERT, CPM, Gantt, Work Breakdown Structures

    Use of Microsoft Excel Spreadsheet like Microsoft excel is used for various kinds of project tasks, which further will assist the project manager to control and plan the cost of project activities in an effective manner.

  • Organisational Process Recommendation - Quality Textiles

    · Create a histogram for data frequencies using the Microsoft® Excel® program. The bin range should correspond with the UCL and LCL as required below. o You may need to download the add-in program Analysis ToolPak in Microsoft® Excel®.

  • Statistical Analysis of Job Satisfaction

    (Excel Output) The charts/graphs. Summary

  • Sunbest Orange Juice: Supply/demand spreadsheet analysis

    As can be seen, market equilibrium still results from scenario 6. This solution shows how to use Microsoft Excel to complete a supply/demand analysis for Sunbest Orange Juice.

  • Mean, Median, Mode, Standard Deviation and Variance

    I need to list the raw data in which I am examining in a MS Word document or MS Excel spreadsheet (if a MS Excel spreadsheet is ever used, you are welcome to copy and paste your work into a MS Word document, which could make explanations of your steps

  • Job Satisfaction: A Statistical Analysis Report and Graphs

    Copy and paste your output from Excel. The charts/graphs. Summary of what you learned and why the processes are important. Please refer to the attachments for the solutions.

  • Job Satisfaction of Employees

    This report must be done in Microsoft Word and should contain, An Introduction The data selected Discussion (of what was learned by examining your selected data set). Summary (what can be learned / taken away from this information).

View More Related Solutions