Question

Life Cycle Pricing-(20 Points Each) Cougar Fabricators plans to introduce a new machine next year. This product has a Four-year production life and an estimated target demand of 35 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 $20,000 per unit. Setup costs will be $1,750 per set up, thirteen (13) setups will be required per week. Specialized equipment must be rented for $25,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.50 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 $250,000 Research and development costs are estimated at $450,000 Labor will be paid at $78 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 is3.75 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

Life Cycle Pricing-(20 Points Each)
Cougar Fabricators plans to introduce a new machine next year. This product has a Four-year production life and an estimated target demand of 35 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 $20,000 per unit.
Setup costs will be $1,750 per set up, thirteen (13) setups will be required per week.
Specialized equipment must be rented for $25,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.50 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 $250,000
Research and development costs are estimated at $450,000
Labor will be paid at $78 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 is3.75 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

Added by Jose Manuel P.

Question

Please give Ace some feedback