At Aspen Trucking Company, the average driver out of its 200 driver employees travels 1,600 miles per week (50 weeks per year) and it charges customers $2.15 per mile. Aspen provides each driver a $95,000 big rig and pays the driver $0.58 per mile. It estimates that the direct cost, other than the driver, for operating a truck is $0.75 per mile. Jack, the sales manager has been working on several ways to grow the revenue of the business by 10%. Since he has had to turn away business, Jack has now decided that the best way to do that is a combination of adding drivers and equipment along with a price increase of 2.5% next year. He knows that a first time driver will only be 75% productive in his or her first year and it will cost $5,500 to recruit each one. Assuming he can get all needed drivers hired by the first working day of the year, what will Aspen’s first year approximate cash flow be from this growth initiative? Please solve with excel.
At Aspen Trucking Company, the average driver out of its 200 driver employees travels 1,600 miles per week (50 weeks per year) and it charges customers $2.15 per mile. Aspen provides each driver a $95,000 big rig and pays the driver $0.58 per mile. It estimates that the direct cost, other than the driver, for operating a truck is $0.75 per mile. Jack, the sales manager has been working on several ways to grow the revenue of the business by 10%. Since he has had to turn away business, Jack has now decided that the best way to do that is a combination of adding drivers and equipment along with a price increase of 2.5% next year. He knows that a first time driver will only be 75% productive in his or her first year and it will cost $5,500 to recruit each one. Assuming he can get all needed drivers hired by the first working day of the year, what will Aspen’s first year approximate
Group of answer choices
a. $8,500
b. ($101,500)
c. $101,500
d. ($1,823,980)
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
