Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Jane Bond just started selling gym elastic bands this year, alongside her online exercise sessions which she started two years ago. She enjoys the high

Jane Bond just started selling gym elastic bands this year, alongside her online exercise sessions which she started two years ago. She enjoys the high profit margins this low-cost business generates for her. Her accountant has produced the Statement of Financial Position (SOFP) for the year ended 31 December 2021 (with comparative figures from the year before) as well as details from her Cash Book for the year ended 31 December 2021. Jane would like you to use the information below to produce an Income Statement for her for the year ended 31 December 2021. Note: the 2021 data is in the left hand column. < JB: Statement of Financial Position As At 31 December: 2021- 2020- - Non-Current Assets Plant and Machinery Furniture and Fittings 450- 500- 1,300 1,500 1,750 2,000- Current Assets Inventories 500 400- Trade Receivables 400- 240- Doubtful Debt Provision e +0 (30) Prepayment (Insurance) 70 60- Bank 10,570 12,330 11,540 13,000- 13,290- 15,000 Equity Proprietor's capital 2,000- 2,000- Retained Earnings 10,910 12,760 12,910- 14,760- Current Liabilities 698 [ Equity Proprietor's capital Retained Earnings Current Liabilities Trade Payables Accruals (Delivery Cost) Cash Book for the Year to 31 December 2021 Balance at 1 January 2021 Cash received from credit sales Cash paid for credit purchases Delivery cost paid Insurance cost paid Drawings Other operating expenses Balance at 31 December 2021- Additional Information from Jane:+ 13,290 15,000 2,000+ 2,000-* 10,910 12,910- 12,760 14,760*** 300- 200 80- 380- 240- 13,290 15,000 12,330 19,820-** (1,000)-- (240) (140) (20,000) (200) 10,570 1) All sales and purchases done in the year, were done on credit. 2) There were no purchases, disposals or revaluations of non-current assets in the year. 3) Jane only provides for doubtful debts provisions at the year-end if she is worried about specific customers not paying her. She is sure that all her customers included in the year- and finunn will may bar but she did boun to write off an amount of 500 on the 20 Dasambas () Other operating expenses Balance at 31 December 2021- Additional Information from Jane: < 1) All sales and purchases done in the year, were done on credit. < (200) 10.570 2) There were no purchases, disposals or revaluations of non-current assets in the year. 3) Jane only provides for doubtful debts provisions at the year-end if she is worried about specific customers not paying her. She is sure that all her customers included in the year- end figure will pay her, but she did have to write off an amount of 20 on the 30 December 2021. The gross trade receivables figure in the SOFP above, is after this bad debt write- off. 4) The prepayment relates to Insurance. She paid an annual amount of 120 on the 30 June 2020, to cover the period from 1 July 2020 to 30 June 2021. As the premiums went up, she had to pay 140 on the 30 June 2021 for the next annual payment. < 5) The accruals related to her delivery costs. She receives the invoice for her delivery costs for the 3 months to December, in the January after every year end. She estimated the cost for the 3 months to December 2021 to be 80. < Required:+ a) Prepare an Income Statement for Jane for the year ended 31 December 2021 and use it to reconcile the Retained Earnings figure for the year ended 2020, with the Retained Earnings figure for the year ended 2021, in the SOFP above. (20 marks) < b) Jane would like to hire an assistant on a part-time basis to help sell more elastic bands, so that she (Jane), can just focus on the online sessions. She says she will include the assistant's wages of 12,000 per year in the 'Cost of Sales' figure. She expects the assistant to increase sales enough to maintain her current gross profit margin. (1) Calculate Jane's gross profit margin based on your figures in part (a) before hiring the peeietant 222 Required:+ a) Prepare an Income Statement for Jane for the year ended 31 December 2021 and use it to reconcile the Retained Earnings figure for the year ended 2020, with the Retained Earnings figure for the year ended 2021, in the SOFP above. (20 marks) b) Jane would like to hire an assistant on a part-time basis to help sell more elastic bands, so that she (Jane), can just focus on the online sessions. She says she will include the assistant's wages of 12,000 per year in the 'Cost of Sales' figure. She expects the assistant to increase sales enough to maintain her current gross profit margin. (i) Calculate Jane's gross profit margin based on your figures in part (a) before hiring the assistant. (2 marks) < (ii) How much would the assistant have to generate in sales (assuming the assistant was paid 12,000 per year), in order to achieve the same gross profit margin you calculated in part (i). (3 marks) (iii) Write an email to Jane explaining whether her expectations to generate the same gross profit margin, after hiring an assistant, is reasonable. Discuss any other financial issues that may arise from hiring an assistant. < (5 marks) [Marks will only be awarded for answers that relate to the information and figures from this particular question. No marks will be awarded for general discussions.] Total 30 marks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction To Financial Accounting Exercises And Problems

Authors: Henry Dauderis, David Annand, Lyryx Learning, Athabasca University

1st Edition

1545056668, 978-1545056660

More Books

Students also viewed these Accounting questions

Question

Proficiency with Microsoft Word, Excel, PowerPoint

Answered: 1 week ago