please re-write this answer by using keyboard

B C D E F G H K L A 1 Question 1 2 3 4 Cash Disbursement April May June Production Cost-Working note 1 -C18 -018 -E18 Selling and administrative expenses 60000 60000 60000 Accounts Payable 96000 Total Disbursement -SUM(C4:C6) -SUM(04:06) -SUM(E4:E6) Question 2 Particulars Sales Sales Price per unit Total Sales April 30000 15 =13*14 May 20000 15 =13*14 June 25000 15 -K3 K4 M N Question 4 Sales 110 Less: Variable Expenses -29.7 Contribution Margin -N2 N3 Contribution Margin ratio =N4/N2 Fixed Cost 345290 Break even units(Fixed Cost/Contribution margin per unit) =N6/N4 Break even -Dollars(Fixed Cost/Contribution margin ratio) =N6/N5 5 6 7 8 9 10 11 12 13 14 Cash Receipts Feb Receivable March Receivable April-Sales May-Sales JUne-Production Cost Working note 1 Particulars Production Production Cost per unit Production Cost Disbursement April-Production Cost May-Production Cost JUne-Production Cost April 25000 6 -C11C12 May 25000 6 -011012 June 30000 6 -E11'E12 April May June 45000 =(255000-45000)*30% 40% =(255000-45000)*10%/40% =15*60% -15-30% =15-10% -J5*60% =J5'30% =K5*60% -SUM(18:112) -SUMQJ8:J12) -SUM(K8:K12) Question 5 Target Profit Fixed Cost Contribution Margin Contribution Margin ratio 16060 345290 =N11+N12 =N5 EN13/N14 110 =N15/N16 15 =C13*40% Sales =C13*60% =013-40% -D13*60% -E13*40% Selling Price Sales-Units -18800*200 -SUM(C15:C17) -SUM(D15:017) -SUM(E15:E17) Question 3 Margin of Safety-Actual Sales-Break Even Sales A Current Sales (18,800 units x SAR 200) B Break Even Sales (14,288 units x SAR 200) A-B Margin of Safety 16 17 18 19 20 21 22 23 24 -14288 200 =117-119 Question 6 Target Profit Fixed Cost Contribution Margin Contribution Margin ratio Sales 40150 345290 EN 20+N21 =N14 =N22/N23