SAM5.xlsx - New Perspectives Excel 2013 Tutorial 10: SAM...

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

View Full Document Right Arrow Icon
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.
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

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

Page1 / 14

SAM5.xlsx - New Perspectives Excel 2013 Tutorial 10: SAM...

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

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