Question
The information provided below was taken from the books of Uli Enterprise for the financial year ended 31 May 2018. Extract of the statement of
The information provided below was taken from the books of Uli Enterprise for the financial year ended 31 May 2018. Extract of the statement of comprehensive income for the year ended 31 May 2018
$ Sales 480 000
Cost of sales 240 000
Rent income 12 000
Advertising 4 800
Salaries and wages 72 000
Rates and taxes 1 200
Other operating expenses 96 000
Additional information: 1. All inventories are priced at cost plus 25%.
2. Sales are divided equally each month. Sales are expected to increase by 18% for the financial year ending 31 May 2019.
3. Fifty percent (50%) of the sales are for cash and the balance is on credit. Debtors normally pay their accounts as follows: 40% in the month of the sale, and these debtors are entitled to a 5% discount; 55% one month after the sale The balance is usually written off as bad debts.
4. Purchases for June and July are expected to be 20 000 per month. All purchases are for cash.
5. In terms of the lease agreement rent is received monthly. The rent for the year ending 31 May 2019 is expected to be 10% more than the previous twelve months.
6. Advertising is paid for monthly and is estimated to be 8% of each months sales.
7. Salaries and wages will increase by 10% with effect from 01 July 2018. 8. Rates and taxes are paid in one installment for the year during July 2018. Rates are calculated at 80 cents (R0.80) per R100 on the value of the premises. The premises are valued at R300 000.
9. Other operating expenses are expected to increase by 5% and are spread evenly throughout the year. Operating expenses are paid for in the month in which they are incurred.
10. On 31 May 2018 an unfavorable bank balance of $18 000 appeared in the ledger of Uli Enterprise. Required: Prepare each of the following for June and July 2018 from the information provided above. (Provide separate monetary columns for each month.)
1.1 Debtors collection schedule
1.2 Cash budget
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started