CAOND1502 - Assignment 1 - MATH1053 - Luxury Rides Taxi Service Deposit Interest rate Quarter $8,000.00 0.0175 Beginning Balance TC Deposit TC Interest

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

This preview shows page 1 - 7 out of 14 pages.

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
Image of page 1
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
Image of page 2
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
Image of page 3
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
Image of page 4
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
Image of page 5
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
Image of page 6
Image of page 7

You've reached the end of your free preview.

Want to read all 14 pages?

  • One '14
  • LHS

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture