Case10_LoraineTurkenburg_2

Case10_LoraineTurkenburg_2 - Case10PerformingWhatIfAnalysis...

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

View Full Document Right Arrow Icon
CaseGrader 2007 Case 10 - Performing What-If Analysis Author Loraine Turkenburg Date 28-Jun-10
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
EFC04B1EA1008374 30aby82x9aw9886152 knqzhmd!stqjdmatqf
Background image of page 5

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

View Full DocumentRight Arrow Icon
Loraine Turkenburg
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
B3bcz93y0bx0997263 jmpyglc!rspiclzspe
Background image of page 11

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

View Full DocumentRight Arrow Icon
Loraine Turkenburg
Background image of page 12
0 10 20 30 40 50 0 50,000 100,000 150,000 200,000 250,000 300,000 350,000 Cost-Volume-Profit 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
60 Revenue Expenses
Background image of page 14
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  $14,000 
Background image of page 15

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

View Full DocumentRight Arrow Icon
Image of page 16
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/23/2010 for the course AC 1270 taught by Professor Rac during the Spring '10 term at Lakeland Community College.

Page1 / 34

Case10_LoraineTurkenburg_2 - Case10PerformingWhatIfAnalysis...

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

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