Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
View attached explanation and answer. Let me know if you have any questions.
Author:
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file fr
New Perspectives Excel 2016 | Modules 9-12: SAM Capstone Project 1a
Vitality Exercise Equipment
ANALYZING DATA AND WORKING WITH FINANCIAL TOOLS
Taylor Walker
edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
AM website.
Vitality Exercise Equipment - Home Treadmills
Sales
Units Sold
Price Per Unit
Total Sales
Expenses
Variable Expenses
Units Manufactured
Variable Cost per Unit
Total Variable Costs
Fixed Expenses
Total Fixed Cost
Expenses - Total
Total Expense Per Unit Sold
Profit
Total Sales
Total Expenses
Gross Profit
Break-even Analysis
Price per Unit
Cost Per Unit
Units Sold
Gross Profit
$
$
4.500
499,00
2.245.500,00
$
$
4.500
360,00
1.620.000,00
$
$
$
260.000,00
1.880.000,00
417,78
$
$
$
2.245.500,00
1.880.000,00
365.500,00
$
$
499,00
499,00
1.871
-
$
Home Treadmills - Profit Analysis
Units Sold
Total Sales Total Expenses
4.500 $ 2.245.500 $ 1.880.000
3.500 $ 1.746.500 $ 1.520.000
4.000 $ 1.996.000 $ 1.700.000
4.500 $ 2.245.500 $ 1.880.000
5.000 $ 2.495.000 $ 2.060.000
5.500 $ 2.744.500 $ 2.240.000
Units Sold $
499,00
3.500
226.500,00
4.000
296.000,00
4.500
365.500,00
5.000
435.000,00
5.500
504.500,00
$
Gross Profit
$
365.500
$
226.500
$
296.000
$
365.500
$
435.000
$
504.500
Home Treadmills - Gross Profit Analys
549,00 $
599,00
401.500,00
576.500,00
496.000,00
696.000,00
590.500,00
815.500,00
685.000,00
935.000,00
779.500,00
1.054.500,00
s - Gross Profit Analysis
$
649,00 $
699,00
751.500,00
926.500,00
896.000,00
1.096.000,00
1.040.500,00
1.265.500,00
1.185.000,00
1.435.000,00
1.329.500,00
1.604.500,00
$
749,00
1.101.500,00
1.296.000,00
1.490.500,00
1.685.000,00
1.879.500,00
$
799,00
1.276.500,00
1.496.000,00
1.715.500,00
1.935.000,00
2.154.500,00
Vitality Exercise Equipment - Pro Treadmills
Expenses
Variable Expenses
Units Manufactured
Variable Cost per Unit
Total Variable Costs
Fixed Costs
Total Fixed Cost
Expenses - Total
Total Expense Per Unit Sold
Profit
Total Sales
Total Expenses
Gross Profit
Break-even Analysis
Price per Unit
Cost Per Unit
Units Sold
Gross Profit
$
$
4.000
899,00
3.596.000,00
$
$
4.000
789,00
3.156.000,00
$
$
$
260.000,00
3.416.000,00
854,00
$
$
$
$
$
$
3.596.000,00
3.416.000,00
180.000,00
899,00
854,00
4.000
180.000,00
Pro Treadmills - Break-Even
Units Sold
4.000
1.500
2.000
2.500
3.000
3.500
4.000
4.500
5.000
5.500
6.000.000
Revenue and Expenses
Sales
Units Sold
Price Per Unit
Total Sales
5.000.000
4.000.000
3.000.000
2.000.000
1.000.000
0
-
Pro Treadmills - Break-Even Analysis
Total Sales Total Expenses Gross Profit
3.596.000
3.416.000
180.000
1.348.500
1.443.500
(95.000)
1.798.000
1.838.000
(40.000)
2.247.500
2.232.500
15.000
2.697.000
2.627.000
70.000
3.146.500
3.021.500
125.000
3.596.000
3.416.000
180.000
4.045.500
3.810.500
235.000
4.495.000
4.205.000
290.000
4.944.500
4.599.500
345.000
-
1.000
2.000
3.000
4.000
Units Sold
Total Sales
Total Expenses
5.000
6.000
Vitality Exercise Equipment - Commercial Treadmills
Expenses
Variable Expenses
Units Manufactured
Variable Cost per Unit
Total Variable Costs
Fixed Costs
Total Fixed Cost
Expenses - Total
Total Expense Per Unit Sold
Profit
Total Sales
Total Expenses
Gross Profit
Break-even Analysis
Price per Unit
Cost Per Unit
Units Sold
Gross Profit
$
$
1.250
1.499,00
1.873.750,00
$
$
1.250
1.100,00
1.375.000,00
$
$
$
260.000,00
1.635.000,00
1.308,00
Commercial ...