Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Details of Salaries and wages are not available please work on available questions. The question paper is complete like that. QUESTION TWO [25] You are

Details of Salaries and wages are not available please work on available questions. The question paper is complete like that. image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

QUESTION TWO [25] You are provided with information of Pick and Pack's Supermarket, a business owned by Joshua Moore. Joshua is worried about his poor cash flow situation at the end of September. In order to rectify the situation, Joshua plans to prepare a Cash Budget and to increase his mark-up percentage. Information: a. Joshua currently uses a mark-up of approximately 52% on cost, but he plans to increase this to 75% from 1 October 2015. b. Extracts from the ledger for the past year ended 30 September 2015: Sales R 2 332 800 (distributed evenly over the year) . Cost of sales 1 536 000 Trading stock 324 000 . Loan from A1 Lenders 90 000 (interest rate 14% p.a.) Bank overdraft 28 000 C. Cash sales comprise 20% of all sales. Joshua predicts total sales and cost of sales to be the following: October November Total sales R210 000 R245 000 Cost of sales R120 000 R140 000 Mark-up% 75% 75% Note: Total sales in preceding months are as follows: d. 180 000 . July 240 000 August 150 000 September e. Debtors are expected to settle their accounts as follows: 50% in the month following the sales transaction month (that is, within 30 days). These debtors are entitled to 5% cash discount for prompt settlement . 44% in the second month following the sales transaction month (that is, within 60 days) 6% will be written off as bad debts. 1. Purchase of trading inventory: . Trading stock is kept at a constant level. (Purchases replace sales in the same month.) All purchases of merchandise are for cash. Loan from A1 Lenders: g. The short-term loan was originally received on 30 September 2015. This is to be repaid in equal instalments over 24 months on the last day of each month. Interest at 14% per annum is also paid on the last day of each month. h. On 1 November 2015, the salary of the shop manager will increase by 12%, while the wages of the six shop assistants will increase by R120 each REQUIRED: 2.1 Prepare the Debtors' Collection Schedule for October and November 2015. All calculations must be rounded off to the nearest rand. (6) Complete the Cash Budget below for October and November 2015. All calculations must be rounded off to the nearest rand. (19) 2.2 QUESTION TWO [25] You are provided with information of Pick and Pack's Supermarket, a business owned by Joshua Moore. Joshua is worried about his poor cash flow situation at the end of September. In order to rectify the situation, Joshua plans to prepare a Cash Budget and to increase his mark-up percentage. Information: a. Joshua currently uses a mark-up of approximately 52% on cost, but he plans to increase this to 75% from 1 October 2015. b. Extracts from the ledger for the past year ended 30 September 2015: Sales R 2 332 800 (distributed evenly over the year) Cost of sales 1 536 000 Trading stock 324 000 Loan from A1 Lenders 90 000 (interest rate 14% p.a.) . . Bank overdraft 28 000 C. Cash sales comprise 20% of all sales. Joshua predicts total sales and cost of sales to be the following: October November Total sales R210 000 R245 000 Cost of sales R120 000 R140 000 Mark-up% 75% 75% Note: Total sales in preceding months are as follows: d. 180 000 July 240 000 August 150 000 September e. Debtors are expected to settle their accounts as follows: 50% in the month following the sales transaction month (that is, within 30 days). These debtors are entitled to 5% cash discount for prompt settlement . 44% in the second month following the sales transaction month (that is, within 60 days) 6% will be written off as bad debts. 1. Purchase of trading inventory . Trading stock is kept at a constant level. (Purchases replace sales in the same month.) All purchases of merchandise are for cash. Loan from A1 Lenders: g The short-term loan was originally received on 30 September 2015. This is to be repaid in equal instalments over 24 months on the last day of each month. Interest at 14% per annum is also paid on the last day of each month. h. On 1 November 2015, the salary of the shop manager will increase by 12%, while the wages of the six shop assistants will increase by R120 each REQUIRED: 2.1 Prepare the Debtors' Collection Schedule for October and November 2015. All calculations must be rounded off to the nearest rand. (6) Complete the Cash Budget below for October and November 2015. All calculations must be rounded off to the nearest rand. (19) 2.2

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

EDI Security Control And Audit

Authors: Albert J. Marcella Jr, Sally Chan, John Merriam

1st Edition

0890066108, 978-0890066102

More Books

Students also viewed these Accounting questions

Question

How can a network design tool help in network design?

Answered: 1 week ago

Question

2. What is the business value of security and control?

Answered: 1 week ago