Total Lifetime Value Calculator Instructions

Input Tab

Instructions:

"Choose the values specific to your company's situation from the drop-down options in the red-boxed cells for various technology deployment strategies. Choose zero or 'No' for inputs that do not apply. Any answers you choose other than 'No' or '0' will affect the results. See the 'Most Likely Ouputs' sheet for results and the 'Yearly View' sheet for tables and charts comparing the deployment strategies over time. Use the various deployment strategies to compare different vendors' business models or different levels of deployment scaling. See the 'Conservative' sheets for results whereby the assumptions have reduced the savings to the minimally expected values. The 'Conservative Outputs' sheet has explanations on the adjusted assumptions."

Most Likely Outputs Tab

If you see ""Insert Data"" on this sheet, continue to fill out the 'Inputs' sheet to get those results.

Description: The 'Most Likely Outputs' calculates the most likely costs and savings due to the implmentation of generative design according to your company's various deployment strategies as defined in the inputs. This includes:

  1. The 'Total implementation and operating costs over the selected time period.'
  2. The 'Total Materials Savings.'
  3. The 'Total Engineer Time Savings.'
  4. The 'Total Maintenance Savings.'
  5. The 'Payback period.'
  6. The 'Total Lifetime Value,' which shows the sum of all the savings minus all the costs due to implementing generative design for your various deployment strategies. This includes all the savings and costs throughout the Time Period as well as any savings that will continue to recur after the subscription/usage ends."

Conservative Outputs Tab

"If you see ""Insert Data"" on this sheet, continue to fill out the 'Inputs' sheet to get those results. Description: For these results, the assumptions have changed to reflect the minimum expected savings. For example: In the 'Most Likely Outputs' worksheet, additive manufacturing will get better results as will more experienced teams while parts that have been previously 'optimized' with topology optimization software will have less room for improvement; however, in the 'Conservative Outputs' worksheet, the model divides the materials savings by 2. This also affects Further Light-Weight Savings. In the 'Most Likely Outputs' worksheet, the model assumes that engineers will finish designs for low complexity parts in 1/4 of the time; however, in the 'Conservative Ouptuts' worksheet, the model assumes engineers will finish designs for low complexity parts in 1/2 of the time. In the 'Most Likely Outputs' worksheet, the model assumes that engineers will finish designs for high complexity parts in 1/8 of the time; however, in the 'Conservative Ouptuts' worksheet, the model assumes engineers will finish designs for high complexity parts in 1/4 of the time. In the 'Most Likely Outputs' worksheet, the model assumes 30% savings on maintenance costs due to higher quality products; however, however, in the 'Conservative Ouptuts' worksheet, the model assumes only 10% savings on maintenance costs due to higher quality products."