need answer of D, E,F part

Assignment 4 - Multi-product CVP Tony's Piano shop sells 3 types of Keyboards to musicians Yamaha and Casio and Sharp Information relating to the three products for the next month follows: Yamaha Casio Sharp 1,000 400 200 Expected sales (units) Sales price Variable cost $1,500 $200 $120 $600 $80 $50 The company has monthly fixed costs of $100,000 and a tax rate of 20% Required: 2.) Compute the company's expected profit (net income) for the upcoming fiscal period. b) Compute the company's sales mix c.) Assuming a consistent sales mix, how many units of each product type must the company sell to break even? d.) Assuming a consistent sales mix, if the company wishes to earn monthly net income of $25,000, how many units of each product type must be sold? c.) Compute the margin of safety in both dollar and percentage terms. 1) If Selling prices go up by 20% what is the new Net Profit and break even point. Income statement Sales revenue Yamaha 1000* 1500 $1500000 Casio 400*200 $80000 Sharp 200*120 $24000 $1604000 Less variable cose Yamaha 1000*600 $600000 Casio 400*80 32000 Sharp 200*50 10000 $642000 Contribution $962,000 Less fixed cost $100,000 Operating income $862000 Less tax @20% $172400 Profit S689600 B) sales mix = sales / total sales % Yamaha = 1500000/1604,000 =93.5162% Casio = 80,000/1604000= 4.9875 % Sharp = 24000/1604000=1.4963% C) computation for weighted average contribution Particulars yamaha casio sharp Total Unit sale price 1500 200 120 Less variable 50 Unit contribution 900 120 70 Sales mix % 93.5162 4.9875 1.3963 Weighted avg contribution 841.66 5.99 0.98 $848.63 1.3963Breakeven sales in units = fixed cost / unit weightes avarage contribution) = $100,000/ 848.63 = 118 units. Yamaha = 118*93.5152%= 110 units Casio = 118*4.9875%= 6 units Sharp = 118* 1.3963= 2 units D) desired sales 600 80