Excel template total cost of ownership

Excel template total cost of ownership

This article provides details of Excel template total cost of ownership that you can download now.

Many consumers or businessmen estimate the total cost of a product no matter they are direct costs or indirect costs. The results obtained from the estimate are known as the total cost of ownership. In this process, the total value of the asset is determined. It not only includes the purchase value but also the implementation cost.

If you own a certain type of assets you can calculate all the cost that the assets received. This is termed as Total Cost of Ownership (TCO) which is also known as life-cycle cost analysis. Ownership cost does include the initial purchase cost but along with this it also encompasses the substantial associated cost of installing, using, upgrading or handling the asset.

TCO analysis is used to sustain attainment and scheduling resolutions assets that involve momentous functional costs during the whole ownership life. Total cost of ownership (TCO) analysis is the key point to take the managerial decision to attain computing structures, buildings, vehicles, surgical equipment factory machines, and an expensive aircraft.

Microsoft Excel software under a Windows environment is required to use this template

These Excel template total cost of ownership work on all versions of Excel since 2007.

Examples of a ready-to-use spreadsheet: Download this table in Excel (.xls) format, and complete it with your specific information.

To be able to use these models correctly, you must first activate the macros at startup.

The file to download presents three Excel template total cost of ownership

Use these templates to document and evaluate your total product costs (and indirect costs) per year, and to create an annual cost comparison.

• Total cost of ownership is a philosophy for really understanding all supply chain related costs of doing business with a particular supplier for a particular good or service (Lisa Ellam, May 1999)

Price vs Cost

• Managers often use interchangeably

• Price – Money coming in

• Cost – Money going out

• Profit – is the difference.

TCO is a Management Oriented Approach

• TCO is most often used for the supplier selection decision
• It could also be used to evaluate a supplier's performance

- to enhance the value delivered to the buying

organization

• the assessment of the purchasing department itself and supporting negotiations with suppliers and volume allocation among suppliers.

• The four elements of cost: Quality, Service, Delivery, and Price (QSDP)

TCO = Quality + Service + Delivery + Price EFFECTIVE NEGOTIATION:

• Each element of QSDP has an impact on the TCO
• The importance of each element varies with the product or service being purchased
• The relative weight of each element depends upon our

assessment of the TCO impact on business.

• The identity and weight of each element is an ongoing part of the continuous negotiation process.

Three Components of Total Cost

• Acquisition Costs
• Ownerships Costs
• Post-Ownership Costs

• Acquisition costs

• Purchase price
• Planning costs
• Quality costs
• Taxes
• Financing costs
  • Ownership costs
• Downtime costs
• Risk costs
• Cycle time costs
• Conversion costs
• Non-value added costs
• Supply chain costs

• Post-ownership costs
  • Environmental costs
  • Warranty costs
  • Product liability costs
  • Customer dissatisfaction costs

TCO Analysis

• NPV analysis is frequently incorporated into TCO

analyses

• NPV analyzes present values of the initial expenditure along with the likely future revenue and expenditure streams

• NPV greater than zero suggests accepting the investment
• NPV less than 0 suggests rejecting the investment
• NPV = 0 is the point of indifference

BENEFITS OF TOTAL COST OF OWNERSHIP

• PERFORMANCE MEASUREMENT
  • Good framework to evaluate suppliers.
  • Concrete way to measure results of quality improvement efforts.
  • Excellent tool for benchmarking.
• DECISION MAKING
  • Forces purchasing to quantify tradeoffs.
  • Good bias for making supplier selection decisions.
  • More informed decision making.
  • Creates a structured problem solving environment.
• COMMUNICATION
  • Excellent communication vehicle between firm and suppliers.
  • Way to get other functions involved in purchasing decisions.

• INSIGHT/UNDERSTANDING
  • Provides excellent data for trend analysis on costs, comparing supplier performance and negotiations.
  • Provides critical data for target pricing.
  • Requires purchasing to develop an awareness of the most significant non-price factors that contribute to TCO.
  • Long-term orientation by focusing on "big picture.“

• SUPPORTS CONTINUOUS IMPROVEMENT
  • Identifies where suppliers should focus improvement efforts- drives suppliers to work on "right thing."
  • Helps identify cost savings opportunities.
  • Forces firm to look at internal issues, how their own requirements/specifications may actually increase costs.
  • Encourages professional growth in purchasing personnel by broadening their perspective.

• CULTURAL ISSUES
  • Cost is not important to "users."
  • Difficult to move away from a "price" orientation.
  • Resistance to change.

• EDUCATION/TRAINING ISSUES
  • Image of inflexibility of TCO approach.
  • Need tools/training.
  • Too theoretical.
  • Frustration of trying to quantify "soft" issues.
  • Lack of user expertise/confidence.
  • Define the scope of TCO modelling.
  • Identifying all relevant costs and benefits.

• RESOURCE ISSUES
  • Lack of readily accessible data to support efforts/lack of systems.
  • Labour intensive to develop and support.