Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In 2019, this shuttle service continues at seven days per week with the help of employee drivers. Each operating day averages 30 trips over an

In 2019, this shuttle service continues at seven days per week with the help of employee drivers. Each operating day averages 30 trips over an extended 8-hour operating period. Shuttle cycle time will be reduced to every 15 minutes (4 per hour) from every 12 minutes (5 per hour) in 2018 to conserve fuel and increase the number of passengers on each trip. The minimum capacity of the new smaller shuttle van is 9 passengers per trip (see next section).

For 2019, shuttle ride prices increased to $4 per ride or 6 rides for $20 on a punch card. Methot decided that this increase is necessary to due to increased operating expenses fuel, insurance and additional employee driver costs. It is expected that 90% of the passengers will purchase punch cards and the remainder will pay cash.

Two employee drivers would share the 7 days each week at the rate of $18 per hour ($15 per hour plus mandatory payroll taxes) which is unchanged from 2018. Gasoline and minor maintenance expenses are estimated to average $2.10 per round trip cycle assuming an average cost of $ 1.30 per litre. Fixed expenses would include insurance of $5,000 for the season, government inspections and fees of $500 and an allowance for major maintenance of $3,000 annually.

An estimate of the expected average utilization of rate of a 9-passenger van is:

Weekdays

% Utilized

Weekend

% Utilized

Total

Average

April 2019

18

30%

12

55%

30

40.0%

May 2019

17

40%

14

90%

31

62.6%

June 2019

16

40%

14

90%

30

63.3%

July 2019

18

75%

13

80%

31

77.1%

August 2019

16

75%

15

80%

31

77.4%

September 2019

16

40%

14

60%

30

49.3%

October 2019

18

25%

13

60%

31

39.7%

Weekend days include Friday, Saturday, Sunday and Statutory Holidays

New Second Shuttle Van and Huckwagon Trailer

Based on the success of the summer 2018 season, Methot believes that the Kamloops Bike Ranch operation would sustain a new smaller shuttle van. With the commitment to Sun Peaks Resort he knows that he cannot be in two places at once and that by the middle of June 2019 he needs to have a second van and bike trailer for use at the Kamloops Bike Ranch to maintain consistent and reliable service.

The current shuttle van is a 2015 Ford Transit T350 EL dual wheel 15 passenger high roof line, the largest and most robust model available. It now has 115,000 kilometres in January 2019. This unit was chosen for its large seating capacity for a driver and 14 paying passengers, easy access for loading and unloading and solid towing capacity. Methot has been comfortable with the drivability and safety features of the Ford Transit as well as the fact that there are two Ford dealerships in Kamloops. Although other brands offer similar models, a single vehicle type is easier for training employee drivers.

Ford Transits passenger wagon series has numerous configurations including engines, various roof heights and seating from 8 to 15 passengers. Methot believes a smaller configuration with a regular wheelbase, medium roof height and 10 passenger seating (a driver and 9 paying passengers). The smaller unit is capable of towing and would be better suited for use at the Kamloops Bike Ranch where the trip involved driving on paved city streets.

Methot browsed the Ford.ca5 site to the 2019 Transit page. He selected the passenger van with medium roof, regular length, 3.5 L EcoBoost engine, 8550 Gross Vehicle Weight Rating, 3.31 Limited Slip Axle and 6-Speed automatic transmission. He selected the XLT model and added the following options: trailer towing package and brake controller, two spare keys, alarm, running boards, trailer brake control, privacy windows, Long-arm power heated mirrors, and 10-seat pewter cloth configuration.

Including delivery to Kamloops at the end of May 2019, the total cost of the van was $60,591 net of a $500 manufacturers rebate and inclusive of $6,492 in 12% taxes (5% federal GST and 7% provincial sales tax). The finance rate for this unit is 2.99% through Ford Canada Credit. Total interest would be $4,717 with payments for this unit of $1,089 per month for 5 years (60 months). Methot estimates this unit to be worth $12,000 at the end of 5 years.

The Ford.ca site also allows you to research vehicles available at dealerships throughout Canada. Methot looked at various locations and found a new 2018 Ford Transit XLT 15 passenger T350 medium roof long wheelbase at Kentwood Ford in Edmonton, Alberta, Canada which is about 800 kilometres from Kamloops (Exhibit 8). It is a longer wheelbase unit with single rear wheels and is priced at $58,204 less $3,250 in rebates plus $950 for tow hitch, brake control and running boards which total of $55,904 before the 12% taxes of $6,708. This unit carries a finance rate of 6.29% and with no down payment the payments for this unit would be $1,219 per month for 5 years (60 months) with total interest of $10,524. Delivery to Kamloops would cost an additional $500 excluding taxes which would be paid directly. This unit would arrive in late January 2019. This unit is estimated to be worth $15,000 at the end of 5 years.

Methot also searched used car websites and located a used 2017 Ford Transit XLT 10 passenger T150 regular wheelbase (Exhibit 9) at Strathmore Ford near Calgary, Alberta, Canada located 700 kilometres from Kamloops. This van had 21,000 kilometres and included remaining factory warranty until September 2020. The total purchase price of $38,600 included $950 for tow hitch, brake control and running boards and $6,708 in 12% taxes. Additional out of pocket expenses before taxes included delivery to Kamloops of $500 and a British Columbia out of province inspection for a used vehicle was another $200. This unit would arrive in late January 2019. The monthly payments are $979 per month with total interest of $8,392 over a four-year period at a 10% interest rate. This unit is estimated to be worth $8,000 at the end of 5 years and would arrive in late January 2019. as it would be older and have higher tot kilometres.

The new shuttle van would require an initial matte black graphics vinyl wrap with the Mostly Mental logo before use. Methot uses a local Kamloops firm to do this work at a cost of $1,000 before taxes which would be paid out of pocket. In addition, all 5% federal GST amounts are claimable as an input tax credit and refundable to Mostly Mental Shuttles when the van is acquired.

Methot also requires a Huckwagon mountain bike trailer for the shuttle van. Huckwagons6 are a custom mountain bike trailer manufacturer located in Stanwood, Washington, USA. Methot purchased his current trailer from them several years ago and ordered a medium size trailer at a cost of $8,000 Canadian after import duties plus 12% taxes. Cash from savings would be used to pay for the acquisition. He estimates that he will spend a full day travelling to pick the trailer up some time in March 2019.

The Huckwagon trailer is expected to last for 20 years and will have a salvage value of $1,000 at that time. It will also require $75 in annual maintenance over its useful life. Methot noted that the revenues from the shuttle van

Methot had ordered the Huckwagon mountain bike trailer but wants your input on which van he should acquire. He expects that the new shuttle van will be used for 40,000 km per year and sold after 5 seasons of use. Vehicles and trailers are Class 10 and 10.1 assets for Capital Cost Allowance purposes with a rate of 30 percent per annum. Mostly Metal Shuttles tax rate is 10% combined federal and provincial income taxes. Methot expects a 15% return on capital for any investments made by the company.

  1. Compute the following individual net present value of each of the three shuttle van capital expenditures (Note: GST amounts paid as working capital recovered at acquisition):
  • new 2019 Ford Transit T150 10 passenger van
  • new 2018 Ford Transit T350 15 passenger van
  • used 2017 Ford Transit T150 10 passenger van

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investments An Introduction

Authors: Herbert B. Mayo

13th Edition

0357127951, 978-0357127957

More Books

Students also viewed these Finance questions