Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

My Topic Is APPLE - One sentence introduction to section- Base case analysis: Present in a table the main output value (e.g., profit) and other

My Topic Is APPLE

- One sentence introduction to section- Base case analysis: Present in a table the main output value (e.g., profit) and other calculated values of interest from your spreadsheet model.o This section should show results for your proposed business plan alongside results for a different plan for the same business, i.e., plan B that assumes lower fixed costs but higher variable cost, higher price, and lower quantity.- Short explanation of this table and what course of action it implies - Go or no/go, plan A or plan B, (always make sure graphics or tables included are understandable to the reader: label them and by adding sufficient text to the body of your report, but as always, be brief). - Breakeven analysis for quantity: what is the cutoff level (or levels) of quantity at which the implied course of action would change (for the go/no-go decision and for the Plan A or Plan B decision), and what would the implied course of action be below and above that quantity level (or levels). This subsection can consist solely of text, with a short explanation of how you found the breakeven values and what they mean; could add a table or chart of some sort if you are inspired to do that.o Note, in this case, we are doing breakeven analysis on quantity. In other cases, you might do breakeven analysis on a different variable, or you might skip it.- General Sensitivity analysis for your proposed business plan:o Create a Tornado chart showing the effect on profit of each changing each individual input parameter value from its low value to its high value, when all other input parameter values are held at their base case. For this quick initial analysis assume the Low value for each parameter is 50% of its Base Case value and the High value is 150% of its Base Case value (this is simpler than what we did in class, where specific forecasts are required for the high and low cases). Only do this and the remaining analysis described below for your proposed plan (Plan A), not for the alternative Plan B considered earlier in the base case analysis and breakeven analysis above. Add a short text explanation of the implications of this chart for the DM. You will have to use the Tornado Chart template from class to create this, but do not show the spreadsheet in the report, only the chart.o From the tornado chart, identify which input variable has the strongest influence on profit. Provide a graph showing profit, cost, and revenue as a function of that input. unit cost, along with a short (1-2 sentence) explanation of what the graph is telling the decision maker. Note, you will need to create a data table for this. It is easier for the reader to quickly understand the graph than the table, so that's why we include the graph but not the table in the report. In some cases, you will want to include 2-way sensitivity analysis (as would be created using 2-way data tables), but only if it helps answer interesting questions. 2-way sensitivity analysis is not required in this case.o Here, you do not need to provide a detailed explanation of why you considered the range of possible input values used. Simply use a wide enough range that any plausible value is considered.- Scenario analysis:o Describe five plausible scenarios, using a table and brief text to describe the input conditions in each scenario: "Maximum Success" - Could be everything at best level, but if that doesn't make logical sense, then just the best realistic case that could occur "Continuing with current momentum" - Everything at the base case level "Higher capacity" - Increased quantity and increased fixed costs "Higher quality product" - Increased price and increased unit costs One more scenario that you identify on your owno Provide a table showing calculated and output values of interest for each scenarioo Compare the scenarios.

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

Payroll Accounting 2018

Authors: Jeanette Landin, Paulette Schirmer

4th edition

1260005127, 1259742514, 1260005165, 126000516X, 978-1259742514

More Books

Students also viewed these Accounting questions

Question

Context, i.e. the context of the information presented and received

Answered: 1 week ago