How to Calculate an LCC Spreadsheet

by Alexander Gokhfeld; Updated September 26, 2017
Life-cycle cost analysis helps people make purchasing decisions.

Life-cycle cost (LCC) is the total cost of owning a product. LCC includes the costs of design, construction and purchase, operation, maintenance, renewal, replacement or disposal. Buyers use LCC to make a decision, based on all costs, related to the purchase of a product. Costs that people will incur after purchasing a product becomes an important part of the decision.

Step 1

Start the Excel spreadsheet program. Click "File," then "New" to create a blank worksheet. Type the row labels "Product price," "Delivery," "Installation," "Auxiliary items," "Insurance," "Property tax," "Scheduled inspections," "Consumable items," "Energy expenses" and "Salvage value" into cells "A2," "A3," "A4," "A5," "A6," "A7," "A8," "A9," "A10" and "A11," respectively. Type "Total" into cell "A12."

Step 2

Fill in cost values into the cells "B2," "B3," "B4," "B5," "B6," "B7," "B8," "B9" and "B10," according the row labels.

Step 3

Type "=B2*0.2" into cell "B11." Press the "Enter" key. Type "=SUM(B2:B11)" into cell "B12." Press the "Enter" key to calculate LCC value of the product..

About the Author

Alexander Gokhfeld has been writing since 2002. He has written for the monthly business publications "AutoPublish" and "MGRealty." Gokhfeld holds certification in business intelligence infrastructure development as well as a Bachelor of Science in electric engineering from Urban Trans College.

Photo Credits