Case10_mmMartinMackenzie_2

Case10_mmMartinMackenzie_2 - CaseGrader 2007 Case 10 -...

Info iconThis preview shows pages 1–15. Sign up to view the full content.

View Full Document Right Arrow Icon
CaseGrader 2007 Case 10 - Performing What-If Analysis Author mm321374 Martin Mackenzie Date 9/27/2009
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
DO NOT DELETE-->
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 4
5447C621A0B290E4 DE7669q843o2p412s6 ll210263!lzqshm!lzbjdmyhd
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
mm321374 Martin Mackenzie
Background image of page 6
Bonus Planner Employee Area Years Employed Michael Smith Regional Manager, Sales 14 Phyllis Vaughn Sales 12 Dwight Stone Sales 10 Stanley Humphries Sales 8 Jim Holiday Sales 5 Ryan Harris Sales 3 Karen Franks Sales 1 Pam Barker Receptionist 6 Kevin Money Accounting 11 Angela Means Accounting 7 Oscar Newton Accounting 4 Toby Falks Human Resources 8 Meredith Potter Technical Support 8 Kelly Kringle Technical Support 5 NewLeaf  Paper
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Normalizer 261.63 Bonus  $994.19   $889.53   $784.88   $680.23   $523.26   $418.60   $313.95   $575.58   $837.21   $627.91   $470.93   $680.23   $680.23   $523.26   $9,000.00 
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
CA7669w843u2v412y6 kk109152!kyprgl!kyaiclxgc
Background image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
mm321374 Martin Mackenzie
Background image of page 12
0 10 20 30 40 50 60 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 Cost-Volume-Profit Revenue Expenses Customers per Month
Background image of page 13

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Scenario Summary Current Values: Best Case Changing Cells: BrandBuilder_selling_price 15 20 Projected_customers__per_month 20 50 Result Cells: Total_Monthly_Revenue $90,000 $300,000 Total_Monthly_Expenses $76,000 $169,000 Net_Monthly_Income
Background image of page 14
Image of page 15
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 33

Case10_mmMartinMackenzie_2 - CaseGrader 2007 Case 10 -...

This preview shows document pages 1 - 15. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online