Question

Arnall Ltd., a British merchandising company, is the exclusive distributor of a product that is gaining rapid market acceptance. The company's revenues and expenses in British pounds) for the last three months are given below: Arnall Ltd. Comparative Income Statements For the Three Months Ended June 30 April 1,300 Sales in units May 4,600 June 5,700 Sales revenue Cost of goods sold £ 247,000 115,700 £ 874,000 409,400 £ 1,083,000 507,300 Gross margin 131,300 464,600 575,700 Selling and administrative expenses: Shipping expense Advertising expense Salaries and commissions Insurance expense Depreciation expense 41,100 60,000 82,500 6,600 37,400 103,800 60,000 231,000 6,600 37,400 124,700 60,000 280,500 6,600 37,400 Total selling and administrative expenses 227,600 438,800 509,200 Net operating income (loss) £ (96,300) £ 25,800 £ 66,500 (Note: Arnall Ltd.'s income statement has been recast in the functional format common in the United States. The British currency is the pound, denoted by £.)
Please show work through excel thank you?

Answer 1

classification Expense Cost of goods sold variable cost tool shipping expense mixed cost Adve tisement expensie fixed cost salaries and commission اور mixed cost Insurance Expense fixed cost Deprecation Expense Hostia Fixed cost 2 ins Variable cost per unit Difference in cost (1) Difference in level of A outpet doo For shiping exfense 103800 - 41100 uboor nits - 1300 units 62200 3300 units [19/1 unit Shipping variable cost Shopping fired ost - Totalcost - variable cost pelune tought at 1300 units to 11100 - 13oox 19 16400 EDMI NOTE 6 PRO I DUAL CAMERA

Forsakeries and con mission = 231000 – 82500 46oou nits - 1300 unit Variable cost per unit forsalaries and commission us pesurit salaries and commission fixed cost = 89500 – 13.00 x 45 ) - 82500-58500 - .24000 Arnall itd Income statement for themonthånded June 30 Particulars Amount sales Revenue * 1083.000 (507300) (108300) (256500) £210,900 (ess: variable costs cost of goods sold Shipping Expense (5200 X (9) Salgic and commission (S 700x45) I contribution fined costs Auto shipping expense. Advertisement Expense salaries and commission Insurance Expense Depreciation en pense profit (164oo) 60,000) 24080 (6600) 3400) REDMI NOTE 6 PRO MI DUAL CAMERA 66,500