How to Calculate an LCC Spreadsheet


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.

  • 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."

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

  • 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..

Related Searches


  • Photo Credit calculator chart image by max blain from
Promoted By Zergnet


You May Also Like

Related Searches

Check It Out

Are You Really Getting A Deal From Discount Stores?

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!