please provide an excel sheet. im stuck

You will need to calculate the piece price by adding up all of the components. Then, multiply the piece price times the volume for each part to understand the total cost for each part and the total cost of per year. Then, multiply the total cost per year times 5 years to get the program cost. Then, you are going to add the tooling for each part. You will need to add each of the parts totals together to complete the total lifetime cost for all parts together