Write in excel

Sole Products Ltd manufactures and sells a single product at $50 per unit. The company has provided the following budgeted information for its first year in business. Required: Calculate for the forthcoming year the: (d) Number of sales units required to maintain the profit of $60,000 per year. ( 2 marks) (e) Due to the intense competition, selling price is expected to reduce to $44 per unit. Calculate the number of units would need to be sold in order to achieve break even. (2 marks) - Contribution per unit = Selling price per unit Variable costs per unit - Breakeven point = Activity level at which there is neither profit nor loss = Total Fixed costs Contribution per unit - Contribution/sales (C/S) ratio = Profit/volume (P/V) ratio =( Contribution Sales )X100% - Sales revenue at breakeven point = Total Fixed costs C/S ratio - Margin of safety (in units) = Budgeted sales units - Breakeven sales units - Margin of safety (%)= (Budgeted sales - Breakeven sales ) budgeted sales X 100% - Sales volume to achieve a target profit =( Total Fixed cost + Target profit ) contribution per unit