Project #89674 - Economic Engineering Evaluating Alternatives (Excel)

Instructions:

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. 

Subject Business
Due By (Pacific Time) 10/28/2015 11:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy