please do it in microsoft excel. thankyou.

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: a.) 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? e.) Compute the margin of safety in both dollar and percentage terms. f.) If Selling prices go up by 20% what is the new Net Profit and break even point