please show work with 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 year. Henderson, Inc. estimates the following costs: 9. 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. 16 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. 1 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. 7 Henderson, Inc still has the same costs outlined in 1-Life Cycle Pricing but now wants to the 8 determine the selling price using Target pricing. They have set the price at $100 per unit and 9 require a 60% retum. 10 11 1. Will the product meet their expectations for a 60% return? 12 2. What if they required a 25% return? 14 Note that "Return" refers to the percentage a company wants left over from the selling price after 15 the company has factored in what it costs to make it in other words