Terry, an engineering technology graduate who is very entrepreneurial, wants to start an excavation and foundation business in Orlando by investing his own savings to fund part of the start-up. A primary decision is the size of a used dump truck to purchase. He knows that as the bed size increases, the net income increases, but he is uncertain whether the incremental expenditures for the larger sizes are justified. The estimated cash flows are listed below; all trucks have a 5-year useful life. Terry expects a return of at least 18% per year on this investment. (a) Determine which size truck he should purchase. (b) If two trucks are to be purchased, select the size of the second truck. (c) Make both selections using a spreadsheet. (Using single-cell functions for each incremental analysis is acceptable.)

Structural Analysis
6th Edition
ISBN:9781337630931
Author:KASSIMALI, Aslam.
Publisher:KASSIMALI, Aslam.
Chapter2: Loads On Structures
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
Terry, an engineering technology graduate who is very entrepreneurial, wants to start an
excavation and foundation business in Orlando by investing his own savings to fund part
of the start-up. A primary decision is the size of a used dump truck to purchase. He
knows that as the bed size increases, the net income increases, but he is uncertain whether
the incremental expenditures for the larger sizes are justified. The estimated cash flows
are listed below; all trucks have a 5-year useful life. Terry expects a return of at least 18%
per year on this investment. (a) Determine which size truck he should purchase. (b) If
two trucks are to be purchased, select the size of the second truck. (c) Make both
selections using a spreadsheet. (Using single-cell functions for each incremental analysis
is acceptable.)
Truck Bed
Initial
M&O,
Annual
Size, m³
Cost, $
$/year
Revenue, S/year
Salvage Value, $
8
-30,000
-14,000
26,500
2,000
10
-34,000
-15,500
30,000
2,500
15
-38,000
-18,000
33,500
3,000
20
-48,000
-21,000
40,500
3,500
25
-57,000
-26,000
49,000
4,600
Transcribed Image Text:Terry, an engineering technology graduate who is very entrepreneurial, wants to start an excavation and foundation business in Orlando by investing his own savings to fund part of the start-up. A primary decision is the size of a used dump truck to purchase. He knows that as the bed size increases, the net income increases, but he is uncertain whether the incremental expenditures for the larger sizes are justified. The estimated cash flows are listed below; all trucks have a 5-year useful life. Terry expects a return of at least 18% per year on this investment. (a) Determine which size truck he should purchase. (b) If two trucks are to be purchased, select the size of the second truck. (c) Make both selections using a spreadsheet. (Using single-cell functions for each incremental analysis is acceptable.) Truck Bed Initial M&O, Annual Size, m³ Cost, $ $/year Revenue, S/year Salvage Value, $ 8 -30,000 -14,000 26,500 2,000 10 -34,000 -15,500 30,000 2,500 15 -38,000 -18,000 33,500 3,000 20 -48,000 -21,000 40,500 3,500 25 -57,000 -26,000 49,000 4,600
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Knowledge Booster
Pricing construction equipment
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, civil-engineering and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Structural Analysis
Structural Analysis
Civil Engineering
ISBN:
9781337630931
Author:
KASSIMALI, Aslam.
Publisher:
Cengage,
Structural Analysis (10th Edition)
Structural Analysis (10th Edition)
Civil Engineering
ISBN:
9780134610672
Author:
Russell C. Hibbeler
Publisher:
PEARSON
Principles of Foundation Engineering (MindTap Cou…
Principles of Foundation Engineering (MindTap Cou…
Civil Engineering
ISBN:
9781337705028
Author:
Braja M. Das, Nagaratnam Sivakugan
Publisher:
Cengage Learning
Fundamentals of Structural Analysis
Fundamentals of Structural Analysis
Civil Engineering
ISBN:
9780073398006
Author:
Kenneth M. Leet Emeritus, Chia-Ming Uang, Joel Lanning
Publisher:
McGraw-Hill Education
Sustainable Energy
Sustainable Energy
Civil Engineering
ISBN:
9781337551663
Author:
DUNLAP, Richard A.
Publisher:
Cengage,
Traffic and Highway Engineering
Traffic and Highway Engineering
Civil Engineering
ISBN:
9781305156241
Author:
Garber, Nicholas J.
Publisher:
Cengage Learning