Concern:
Have the diesel trucks proven to be cost saving?
Information:
Diesel fuel is 12 cents per gallon cheaper than gasoline
Average Truck gets 10 miles per gallon
Diesel trucks cost more to repair and maintain than gasoline trucks.
Data has been collected on 20 trucks with the following information: age, miles driven and type.
“Tony,” said Mike as he put the data in Table 1 in front of Sanchez, “this data shows that, on average the 6 diesel trucks cost $21,156 in R&M expense whereas the 14 gasoline trucks averaged only $13,269 in R&M expense. I am also surprised that simple correlations show a negative relationship between miles driven and age and between miles driven and type of truck.” Tony looked up at Mike and replied, “Mike can I borrow this data. I have a young college graduate that I just hired and she is very bright. Let me ask her to look at this data and see what she comes up with.”
Required:
Assume that you are an analyst working for Tony Sanchez. He has
asked you to analyze this data and to address the questions below.
Prepare a business memo that addresses his issues.
Does it cost extra to repair a truck as it gets older? If so, how much? How much does mileage contribute to repair expenses?
Truck # | Expense | Miles | Years | Type |
1 | 21,100 | 100,625 | 1 | 1 |
2 | 23,548 | 108,750 | 2 | 1 |
3 | 18,560 | 83,438 | 2 | 1 |
4 | 19,525 | 77,500 | 3 | 1 |
5 | 22,435 | 88,125 | 3 | 1 |
6 | 21,768 | 85,938 | 3 | 1 |
7 | 10,345 | 95,625 | 1 | 0 |
8 | 11,575 | 91,875 | 1 | 0 |
9 | 14,240 | 98,125 | 2 | 0 |
10 | 13,300 | 88,438 | 2 | 0 |
11 | 14,105 | 90,625 | 2 | 0 |
12 | 13,050 | 81,875 | 2 | 0 |
13 | 17,150 | 95,625 | 3 | 0 |
14 | 11,230 | 76,849 | 2 | 0 |
15 | 10,490 | 92,145 | 1 | 0 |
16 | 16,645 | 86,940 | 3 | 0 |
17 | 16,219 | 91,257 | 3 | 0 |
18 | 13,565 | 85,432 | 2 | 0 |
19 | 9,245 | 84,688 | 1 | 0 |
20 | 14,600 | 80,625 | 3 | 0 |
Concern: Have the diesel trucks proven to be cost saving? Information: Diesel fuel is 12 cents...
Concern: Have the diesel trucks proven to be cost saving? Information: Diesel fuel is 12 cents per gallon cheaper than gasoline Average Truck gets 10 miles per gallon Diesel trucks cost more to repair and maintain than gasoline trucks. Data has been collected on 20 trucks with the following information: age, miles driven and type. “Tony,” said Mike as he put the data in Table 1 in front of Sanchez, “this data shows that, on average the 6 diesel trucks...
Concern: Have the diesel trucks proven to be cost saving? Information: Diesel fuel is 12 cents per gallon cheaper than gasoline Average Truck gets 10 miles per gallon Diesel trucks cost more to repair and maintain than gasoline trucks. Data has been collected on 20 trucks with the following information: age, miles driven and type. “Tony,” said Mike as he put the data in Table 1 in front of Sanchez, “this data shows that, on average the 6 diesel trucks...
Concern: Have the diesel trucks proven to be cost saving? Information: Diesel fuel is 12 cents per gallon cheaper than gasoline Average Truck gets 10 miles per gallon Diesel trucks cost more to repair and maintain than gasoline trucks. Data has been collected on 20 trucks with the following information: age, miles driven and type. “Tony,” said Mike as he put the data in Table 1 in front of Sanchez, “this data shows that, on average the 6 diesel trucks...
Exercise 2-12 Cost Behavior, High-Low Method [LO2-3, Lo2-4) Speedy Parcel Service operates a feet of delivery trucks in a large metropoitan area. A careful study by the companys cost enalyst has determined that if a truck is driven 120,000 miles during a yeer, the average operating cost is 11.6 cents per mile. If a truck is driven only 80,000 miles during a year, the average operating cost increases to 136 cents per mile. Required: 1& 2.Using the high-low method, estimate...
THE DUTZEL DIESEL (A 1250 word essay) I. Major Facts State the major facts as you see them. Make Statements clear and concise for your own understanding. II. Major Problem State here the major problem as you see it. You may want to phrase the statement in the form of a question. A good problem statement will be concise, usually one sentence. III. Possible Solutions a. List several of the possible solutions. b. Do not limit the list to a...
INTRODUCTI0NRebecca shook her head and gave a loud sigh as she hung up the phone from talking with her dad."What is it?" her roommate Claire asked."Per usual, Daddy Jim wants me to use my 'schooling, as he likes to call it, to help him decide whether to buy a new crew cab truck with either a diesel or a gas engine," Rebecca replied."Well, maybe he will forget all about it if you just wait him out, "Aaire offered."Oh no, you...
An independent mail delivery service wants to study factors that affect the daily gas usage of its delivery trucks. Using data collected from different trucks on various days, a company analyst uses a software to fit a regression model of the form 9 = -11.7+9.9x2 -1.8x, +5x2 +0.09x4 where y = volume of gasoline used in gallons) *1 - weight of truck (in tons) x2 = tire pressure (in ps, pounds per square inch) xz - weight of initial package...