please show your work and formulas used in excel

Henderson Inc. plans to introduce a new product next year. This product has a two-year life and an estimated demand of 20,000 units annually. The product will be produced 50 weeks each Iyear. Henderson, Inc. estimates the following costs: Direct materials will be $15 per unit. 10 Setup costs will be $200 per set up, ten setups will be required per week. 11 Specialized equipment must be rented for $15,000 per week. 12. Design costs are estimated to be $40,000 13. Research and development costs are estimated at $500,000 14. Labor will be paid at $20 per hour. Five employees will be assigned to this product and each employee will work 35 hours per week 17 on the product. They will work at this rate during the entire two year production life of the product. Disregard the taxes that are due. Instead use the gross payroll for this line. Henderson Inc. uses cost-plus pricing whereby the selling price of each of its products is 150 Ipercent of the life-cycle costs. (that is, an additional 50% is added to the total cost to make the product to determine the final price). Defermine the selling price of the product Henderson Inc. plans to introduce a new product next year. This product has a two-year life and an estimated demand of 20,000 units annually. The product will be produced 50 weeks each year. Henderson, Inc. estimates the following costs: Direct materials will be $15 per unit. Setup costs will be $200 per set up, ten setups will be required per week. Specialized equipment must be rented for $15,000 per week. 1. Design costs are estimated to be $40,000 51. Research and development costs are estimated at $500,000 Labor will be paid at $20 per hour. 6 Five employees will be assigned to this product and each employee will work 35 hours per week on the product. They will work at this rate during the entire two year production life of the product Disregard the taxes that are due. Instead use the gross payroll for this line. Henderson Inc. uses cost-plus pricing whereby the selling price of each of its products is 150 percent of the life-cycle costs. (that is, an additional 50% is added to the total cost to make the product to determine the final price). Determine the selling price of the product, 23 24