Please show all work. Thank you!

Please show all work. Thank you!

Problems LO 3 8-35 Target costing calculations A major car manufacturer developed the following information as part of its target costing efforts: Customer Importance Rating by Category CATEGORY IMPORTANCE 140 Safety Comfort and convenience 120 Economy 40 Styling 60 Performance 140 Total 500 Target Cost by Function Group FUNCTION GROUP TARGET COST Chassis 51,400 Transmission 280 Air conditioner 100 700 Other function groups 4,520 Total $7,000 Electrical system OTHER FUNCTION GROUPS CATEGORIES Safety Comfort and convenience Economy Styling Performance Quality Function Deployment (Correlation) Matrix Function Group AIR ELECTRICAL CHASSIS TRANSMISSION CONDITIONER SYSTEM 0.3 0.1 0.1 0.1 0.1 0.2 0.1 0.1 0.1 0.3 0.2 0.1 0.3 0.2 0.5 0.5 0.4 0.9 0.4 Required (a) Prepare an exhibit similar to Exhibit 8-9 showing percentage contributions of each function group to categories of customer requirements. (b) Prepare a value index exhibit similar to Exhibit 8-10. (c) Which function groups are candidates for cost reduction? TO