Posted: November 2nd, 2015

Economic Engineering Evaluating Alternatives (Excel)

Economic Engineering Evaluating Alternatives (Excel)

You are to compare the presented equipment investments across a range of MARR values.  Using MicroSoft Word

and Excel you will include (1) an information block, (2) data block, (2) analysis block, (4) graphics block,

(5) discussion block, and Conclusions (6).

Data:

Data

Krax Seamer

Split-Co Seamer

Life (years)

9

9

Purchase Price

$ 202,000

$ 285,000

Annual Benefits

$ 73,000

$ 88,000

Benefits Gradient

$ 1,200

$ 1,300

Annual O&M Costs

$ 18,000

$ 34,000

O&M Gradient

$ 600

$ 1,100

Salvage Value

$42,000

$48,000

Loan

Krax Seamer

Split-Co Seamer

Down Payment (% of Purchase Price)

30%

30%

Loan Period (years)

6

9

Loan Payment

$34,392.11

$37,441.93

Analysis:

·         Information Block – Include your name, student number, class and section, assignment title, and

date. See also relevant notes.

·         Data Block – Include all data provided in the case along with any other data that you need to

collect to complete the analysis. See also any relevant notes.

·         Analysis Block – Analysis of the data in a tabular format.  The analysis block should reference

items from the data block.  Hard coding of data in the analysis block should be minimized. See also any

relevant notes.

·         Graphics Block – Present the results of the Analysis Block in a graphic format.

·         Discussion Block – A description of the finding of the case in text format.  Also note any

limitations and assumptions that are relevant in the study. See also any relevant notes.

Additional points may be added or subtracted for formatting, ease of use, and use of additional excel

functions.

PLACE THIS ORDER OR A SIMILAR ORDER WITH US TODAY AND GET A GOOD DISCOUNT