Using MS Excel MS Word, and the following information: 

 

Prepare a fixedvariable and overunder pricing structure for the three private fleet opportunities listed below.

Prepare a pro forma income statement for the three private fleet opportunities listed below.

Rank the three opportunities in order of preference.

Variable Costs

Driver Pay: $mile

Fringe Benefits: of wages

Fuel: $Gallon and MPG new Freightliner Cascadia

Maintenance: $mile

Insurance: $mile

Fixed Costs

Tractor Depreciation: $yeartractor

Trailer Depreciation: $yeartrailer

LegalizationRecruitingAdministration: $yeardriver

Tractor Cost: $

Trailer Cost: $

Company will finance of the capital investment

Interest Rate: calculate as simple annual interest

Effective Tax Rate:

ROA Hurdle Rate for New Capital Investments:

OR Target Rate for Truckload Operations:

Weeks per year:

Length of contract: years

Mutually Exclusive

Fleet Opportunities Fleet Opportunity

A B C

Fleet Summary:

Tractors

Trailers

Utilization Weekly Miles per Tractor