Old MathJax webview

: . ": " . ( & )

:

Questions:

1) Compute the number of calendar days needed to complete a one acre job using the current truck/trailer combination and the larger truck/trailer combination. Use this to calculate the maximum number of jobs McCoy could accept per year using each truck/trailer combination.

2) Using the question 1 results & exhibit #1, compute the incremental annual revenues (cash inflows) and expenses (cash outlfows) given an investment in a larger truck (i.e. what is the difference in revenue and expense between the old truck and the new truck).

3) Using the results from #2 prepare a model of the initial investment and incremental cash flows for the next 5 years. Utilize NPV, IRR & the payback period.

4) What would you recommend to McCoy regarding the goat rental operation?

=B2/D2 &":"& C2/D2 B op 1 Shop 2 115 0 0 [ 50 20 200 16 8 D GCD I EGCD(B2,C2) =GCD(B3,C3) =GCD(B4,C4) =GCD(B5,C5) =GCD(B6, C6) =GCD(B7,07) E Ratio =B2/D2&":"& C2/02 =B3/D3 &":"& C3/D3 =B4/D4&":"& C4/04 =B5/D5 &":"& C5/05 =B6/06 &":"& C6/06 =B7/07&":"& C7/07 0 Exhibit 1 ACTUAL REVENUES AND COSTS FOR THE RESORT LAND-CLEARING JOB (in U.S. dollars) Per day Project 7 $375.00 $2,625.00 Calendar days needed to complete the project! Revenues Revenue per calendar day Total revenues Variable costs Transportation costs Round trip distance (miles) Rate per mile Transportation costs per calendar day Total transportation costs 80 $0.63 $50.40 (352.80) Shepherd and dog Rate per calendar day Total shepherd and dog costs Total variable costs per calendar day Contribution margin $190.00 (1.330.00) $240.40 (1,682.80) $134.60 $942.20 (100.00) Fixed costs Setup Fencing Linear feet Rate per linear foot Total fencing costs Total fixed costs Profit 962 $0.75 (721.50) (821.50) $120.70 The area cleared was one acre, or 43,560 square feet. At a daily forage rate of 250 square feet per goat, the job required 174.24 goat days. The trailer has a capacity of 25 goats, so it would take 6.97 days for the goats to finish clearing the land. By agreement, McCoy billed for a full trailer (25 goats) for a full day each day the goats were on site. Therefore, McCoy billed the owner for seven calendar days (175 goat days). =B2/D2 &":"& C2/D2 B op 1 Shop 2 115 0 0 [ 50 20 200 16 8 D GCD I EGCD(B2,C2) =GCD(B3,C3) =GCD(B4,C4) =GCD(B5,C5) =GCD(B6, C6) =GCD(B7,07) E Ratio =B2/D2&":"& C2/02 =B3/D3 &":"& C3/D3 =B4/D4&":"& C4/04 =B5/D5 &":"& C5/05 =B6/06 &":"& C6/06 =B7/07&":"& C7/07 0 Exhibit 1 ACTUAL REVENUES AND COSTS FOR THE RESORT LAND-CLEARING JOB (in U.S. dollars) Per day Project 7 $375.00 $2,625.00 Calendar days needed to complete the project! Revenues Revenue per calendar day Total revenues Variable costs Transportation costs Round trip distance (miles) Rate per mile Transportation costs per calendar day Total transportation costs 80 $0.63 $50.40 (352.80) Shepherd and dog Rate per calendar day Total shepherd and dog costs Total variable costs per calendar day Contribution margin $190.00 (1.330.00) $240.40 (1,682.80) $134.60 $942.20 (100.00) Fixed costs Setup Fencing Linear feet Rate per linear foot Total fencing costs Total fixed costs Profit 962 $0.75 (721.50) (821.50) $120.70 The area cleared was one acre, or 43,560 square feet. At a daily forage rate of 250 square feet per goat, the job required 174.24 goat days. The trailer has a capacity of 25 goats, so it would take 6.97 days for the goats to finish clearing the land. By agreement, McCoy billed for a full trailer (25 goats) for a full day each day the goats were on site. Therefore, McCoy billed the owner for seven calendar days (175 goat days)