Below is the budgeted P&L Statement for Pittsburgh Tools, Inc - Cordless Division. Pittsburgh Tools Cordless Division Budgeted Quarterly Product Line Contribution Margin Analy 18v Circular Saw 1x Drill Driver By Light Total 4.300 $537,500 $125.00 Vaate costs 223,600 $313.900 Direct costs $45000 $2.00 210,800 573.00 $254.200 142083 3,100 $150.00 $250,000 800 145600 582.00 $114,400 122900 5,200 12.400 $50.00 $1262.500 28.00 0.000 $22.00 $ 682.500 $175.9442 $112.117 commented SOSA exper Divisional operating e 279479 200.000 7479 Current mix ver Target sales mix preven 42.6% 42.0% 20% 20% Each of the question below is to be treated independently. Basic CVP Analysis - Using Goal Seek 1. Determine the breakeven point for the Drill/Driver product line. 2. Pittsburgh Tools is considering modifications to the 18v Light production line. Analysis suggests that the modifications could result in $0.65 per unit variable cost reduction and $1,300 per quarter fixed cost increase. Assuming these changes have no impact on volume, determine the price that would be necessary to achieve S0 product line margin? Multiproduct CVP Analysis - Using Solver 3. Assuming the current sales mix reaches the targeted sales mix, determine the breakeven point in sales revenue necessary for the division to achieve $0 divisional operating income (breakeven). 4. Assume the current sales mix reaches the targeted sales mix, determine the sales revenue necessary for the division to achieve $100,000 divisional operating income. See the Excel instructions on the next page 1. Making Copies of a Worksheet Tab Your completed Excel file will have 5 worksheet tabs (the original Quarter Budget and one additional worksheet tab for each of the 4 questions above) Right-click on the worksheet tab name > Move or Copy...> (move to end) > Create a copy > OK 2. Finding and Using Goal Seek Find the Data tab: Data > Forecast Group > What-if Analysis > Goal Seek