Answer using Excell

Cougar Fabricators plans to introduce a new machine next year. This product has a three-year production life and an estimated target demand of 25 units quarterly. The product will be produced 12 weeks per quarter (or 48 weeks per year). Cougar Fabricators estimates the following costs: - Direct materials will be $18,500 per unit. - Setup costs will be $1,800 per set up, thirteen (13) setups will be required per week. - Specialized equipment must be rented for $15,000 per week. - 3rd Party Quality inspection performed each quarter at $10,000 per quarter. - Random Compliance inspector (1) will oversea the shop operation 1 week per quarter at $95 per hour; this one inspector will have oversight of all of the employees during this work week and work the same hours of the employees for the given week. - Engineering and Design costs are estimated to be $65,000 - Research and development costs are estimated at $550,000 - Labor will be paid at \$63 per hour. Twelve (12) employees will be assigned to this product and each employee will work 37.5 hours per week on the product. They will work at this rate during the entire production life of the product. Disregard the taxes that are due. Instead use the gross payroll for this line. Cougar Fabricators uses cost-plus pricing whereby the selling price of each of its products is 175 percent of the life-cycle costs. Determine the selling price of the product. Show your work, show all of your variables of the problem and calculate everything within excel to see the formulas you use to come up with your answers