# SAM5 - New Perspectives Excel 2013 Tutorial 10 SAM Project...

This preview shows pages 1–4. Sign up to view the full content.

Tutorial 10: SAM Project 1a Firestone Clock Company WHAT-IF ANALYSES AND SCENARIOS Author: Jasmine Thai New Perspectives Excel 2013 Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the Fle from the SAM website.

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

View Full Document
Firestone Clocks - Desktop Models Desktop Models - Proft Analysis Based on Unit Sales Units Sold Total Sales Total Expenses Units Sold 35,000 35,000 \$ 1,050,000.00 \$ 800,000.00 Price Per Unit \$ 30.00 20,000 600,000.00 500,000.00 Total Sales ### 25,000 750,000.00 600,000.00 30,000 900,000.00 700,000.00 Expenses 35,000 1,050,000.00 800,000.00 Variable Expenses 40,000 1,200,000.00 900,000.00 Units Manufactured 35,000 Variable Cost per Unit \$ 20.00 Total Variable Costs \$ 700,000.00 Desktop Models - Gross Proft Fixed Expenses Units Sold/Price \$ 22.50 \$ 24.00 Total Fixed Cost \$ 100,000.00 20,000 (50,000.00) (20,000.00) Expenses - Total \$ 800,000.00 25,000 (37,500.00) 0.00 Total Expense Per Unit Sold \$ 22.86 30,000 (25,000.00) 20,000.00 35,000 (12,500.00) 40,000.00 Proft 40,000 0.00 60,000.00 Total Sales ### Total Expenses \$ 800,000.00 Gross Proft ### Break-even Analysis Price per Unit \$ 30.00 Cost Per Unit \$ 24.18 Units Sold 23,923 Gross Pro±t \$ 139,234.45
its Sold Gross Proft \$ 250,000.00 (41,000.00) 11,250.00 63,500.00 115,750.00 168,000.00 t Analysis Based on Units Sold and Price Per Unit \$ 25.50 \$ 27.00 \$ 28.50 \$ 30.00 \$ 31.50 10,000.00 40,000.00 70,000.00 100,000.00 130,000.00 37,500.00 75,000.00 112,500.00 150,000.00 187,500.00 65,000.00 110,000.00 155,000.00 200,000.00 245,000.00 92,500.00 145,000.00 197,500.00 250,000.00 302,500.00 120,000.00 180,000.00 240,000.00 300,000.00 360,000.00

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 14

SAM5 - New Perspectives Excel 2013 Tutorial 10 SAM Project...

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

View Full Document
Ask a homework question - tutors are online