CAOND1502 - Assignment 1 - MATH1053 - Luxury Rides Taxi...

Luxury Rides Taxi Service
Deposit $8,000.00
Interest rate 0.0175
Quarter Beginning Balance TC Deposit TC Interest Earned TC
1 0 $8,000.00 $140.00
2 $8,140.00 $8,000.00 $282.45
3 $16,422.45 $8,000.00 $427.39
4 $24,849.84 $8,000.00 $574.87
5 $33,424.72 $8,000.00 $724.93
6 $42,149.65 $8,000.00 $877.62
7 $51,027.27 $8,000.00 $1,032.98
8 $60,060.24 $8,000.00 $1,191.05
9 $69,251.30 $8,000.00 $1,351.90
10 $78,603.20 $8,000.00 $1,515.56
11 $88,118.75 $8,000.00 $1,682.08
12 $97,800.83 $8,000.00 $1,851.51
13 $107,652.34 $8,000.00 $2,023.92
14 $117,676.26 $8,000.00 $2,199.33
15 $127,875.59 $8,000.00 $2,377.82
16 $138,253.42 $8,000.00 $2,559.43
17 $148,812.85 $8,000.00 $2,744.22
18 $159,557.08 $8,000.00 $2,932.25
19 $170,489.33 $8,000.00 $3,123.56
20 $181,612.89 $8,000.00 $3,318.23
Shortfall

Deposit $18,659.51
Interest rate 0.0175
Ending Balance TC Quarter Beginning Balance TC
$8,140.00 1 0
$16,422.45 2 $18,986.05
$24,849.84 3 $38,304.36
$33,424.72 4 $57,960.74
$42,149.65 5 $77,961.10
$51,027.27 6 $98,311.47
$60,060.24 7 $119,017.97
$69,251.30 8 $140,086.84
$78,603.20 9 $161,524.41
$88,118.75 10 $183,337.14
$97,800.83 11 $205,531.59
$107,652.34 12 $228,114.44
$117,676.26 13 $251,092.50
$127,875.59 14 $274,472.67
$138,253.42 15 $298,261.99
$148,812.85 16 $322,467.63
$159,557.08 17 $347,096.86
$170,489.33 18 $372,157.11
$181,612.89 19 $397,655.91
$192,931.12 20 $423,600.94
$257,068.88

Deposit TC Interest Earned TC Ending Balance TC
$18,659.51 $326.54 $18,986.05
$18,659.51 $658.80 $38,304.36
$18,659.51 $996.87 $57,960.74
$18,659.51 $1,340.85 $77,961.10
$18,659.51 $1,690.86 $98,311.47
$18,659.51 $2,046.99 $119,017.97
$18,659.51 $2,409.36 $140,086.84
$18,659.51 $2,778.06 $161,524.41
$18,659.51 $3,153.22 $183,337.14
$18,659.51 $3,534.94 $205,531.59
$18,659.51 $3,923.34 $228,114.44
$18,659.51 $4,318.54 $251,092.50
$18,659.51 $4,720.66 $274,472.67
$18,659.51 $5,129.81 $298,261.99
$18,659.51 $5,546.13 $322,467.63
$18,659.51 $5,969.72 $347,096.86
$18,659.51 $6,400.74 $372,157.11
$18,659.51 $6,839.29 $397,655.91
$18,659.51 $7,285.52 $423,600.94
$18,659.51 $7,739.56 $450,000.00

Brass Widgets Inc. sales
Total Cost
0 $12,000 $0 Fixed cost - f (per week) $12,000
50 $16,000 $6,500 Variable cost -v (per unit) $80
100 $20,000 $13,000 Selling price - s (per unit) $130
150 $24,000 $19,500
200 $28,000 $26,000
250 $32,000 $32,500
300 $36,000 $39,000
350 $40,000 $45,500
400 $44,000 $52,000
Total cost Profit/Loss
0 $12,000 $0 ($12,000) Fixed cost - f (per week) $12,000
50 $16,000 $4,000 ($12,000) Variable cost -v (per unit) $80
100 $20,000 $8,000 ($12,000) Selling price - s (per unit) $80
150 $24,000 $12,000 ($12,000)
200 $28,000 $16,000 ($12,000)
250 $32,000 $20,000 ($12,000)
300 $36,000 $24,000 ($12,000)
350 $40,000 $28,000 ($12,000)
400 $44,000 $32,000 ($12,000)
Number
of units
Total
Revenue
Number
of units
Total
revenue

0 50 100 150 200 250 300 350 400
$0
$10,000
$20,000
$30,000
$40,000
$50,000
$60,000
Brass Widget Inc. sales graph
Total Cost Total Revenue
Break-even Point
? =240 ) (?????
0 50 100 150 200 250 300 350 400
$0
$5,000
$10,000
$15,000
$20,000
$25,000
$30,000
$35,000
$40,000
$45,000
$50,000
Total cost Total revenue

Microsoft Excel 15.0 Answer Report
Worksheet: [Assignment 1 - Answer.xlsx]Question 5
Report Created: 11/18/2015 6:18:34 PM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.032 Seconds.
Iterations: 7 Subproblems: 0
Solver Options
Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling
Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%
Objective Cell (Max)
Cell Name Original Value Final Value
$B$12 Profit Simplex $3,750 $6,400
Variable Cells
Cell