SP6 Frances Drew ib_e03_transportationperformance.xls

SP6 Frances Drew ib_e03_transportationperformance.xls - #...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
# Question: 12 13 14 15 Compare the output of the formulas you created in cells C9 and C10. Is this company making enough money to cover its fuel cost? If fuel prices are increased to $3.05 per gallon, how much will this company have to increase its charge per mile to cover the cost of fuel plus make approximately $1,000 in profit? This company has a goal of maintaining an average capacity per trip of 90%. Is this company achieving its goal? What could this company do to get closer to its capacity target of 90%? How else could you analyze the Trip Detail statistics in the range A12:E52 to answer the above question?
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Answer: Yes 0.31 no use smaller trailors for the smaller capacity trips by comparing the trailor size to the capcity you can see how that affects the compacity.
Background image of page 2
Transportation Weekly Trip Report TRIP DATA Number of Trips 40 Average Miles per Trip 600.25 Highest Miles Driven 1250 Lowest Miles Driven 150 CAPACITY DATA Most Frequent Size 53 Average Capacity per Trip 80% Highest Capacity
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

SP6 Frances Drew ib_e03_transportationperformance.xls - #...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online