Question
Springton makes and sells a single product, black handbags, at a price of $1,600 each. During the three months to December 31,2020, he sold 1,500
Springton makes and sells a single product, black handbags, at a price of $1,600 each. During the three months to December 31,2020, he sold 1,500 handbags and turnover was the same for each month.
He expects the volume of sales to remain unchanged for January 2021 but to increase by 5% in February, and by a further 20% in April. The price of the handbags will be increased by 10% in January and by a further 5% in June.
The following budgeted information is presented to assist in the preparation.
Month | Budgeted sales $ | Budgeted purchases $ |
January | 880,000 | 600,000 |
February | 924,000 | 750,000 |
March | 924,000 | 820,000 |
April | 1,108,800 | 820,000 |
May | 1,250,000 | 968,000 |
June | 1,285,000 | 1,250,000 |
Notes:
Effective January 1, 2021 Springtons collection on sales will be as follows:
- 70% collected in the month of sale
- The balance will be collected one month following sale
Required:
- Prepare a sales budget for the handbags for the six months to June 2021, showing quantity, unit price and total projected sales monthly. (14 marks)
- Prepare the Cash collection schedule, with a total column, for the first three months. (9 marks)
- State two (2) advantages of budgeting. (2 marks)
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