1. Given Data below from a VA study Current Selling Price /Unit $100 Manufacturing Cost/unit $55 Current annual demand 25,000 units. Expected demand after value analysis study 30,000 units/year. Material cost reduction through value analysis $2.50 /unit. Labor cost reduction through value analysis $3/unit Increase in sales promotion cost- $1.00 /unit It is proposed to charge the following rates for the product after the value analysis study. For the first 10,000 units at $110. Next 5,000 units at $105 Any quantity sold after 15,000 units at $100. The value analysis and the marketing teams spent 50 and 30 hours at a cost of $120 and $100 respectively. Required: i. What is the profit after the value analysis study for the first 10,000 units with the new price? (Hint: Please be sure to take out the value analysis cost.) ii. How much is the profit for the next 10,000 units with the new price? (Hint: Notice the price variations.) iii. What should be the sales volume to realize a profit of $1.50M in the first year after paying for the value analysis study? 2. Develop a cause and effect diagram for a failed bearing. 3. Problem 5/ page 55 from the textbook. (Attached in back.) You can solve this in Excel.)