Jennifer and Kimi are partners in Kiddies Fashion, a boutique shop specialising in clothing for children. The boutique has been
Question 1
Jennifer and Kimi are partners in Kiddies Fashion, a boutique shop specialising in clothing for children. The boutique has been operating for three years and has become a well-known shop in the area where it is located as well as further afield.
The partners decided to embark on a more professional approach to managing the boutique and one of the high-priority initiatives is to implement a
Neither partner is sure how to prepare a cash budget and approached you for assistance to help them prepare a pro-forma cash budget for the period April to June 2021.
They have provided you with the following information:
The total actual sales for the period January to March 2021 were R2 500 000, R2 700 000 and R2 835 000, respectively. Based on advice received from their banker and a business consultant they believe that the total sales for April 2021 will be 3% higher than the sales for March 2021. The total sales for May 2021 are estimated to be 96% of the total sales for April 2021 and the estimated total sales for June 2021 to be 90% of the April 2021 total sales.
Historically cash sales represent 40% of total monthly sales, the balance being credit sales. The boutique’s credit terms stipulate that customers who purchase on credit must pay their account in three monthly instalments of 30%, 35% and 35%, respectively.
Monthly total purchases are found to be 70% of total monthly sales but the partners indicated that for May 2021 it will be 65% of the total sales for May and for June 2021 total purchases will be 60% of the total sales for June.
The company pays 30% of its monthly purchases in cash. The balance of the monthly purchases is credit purchases. The company pays 40% of its credit purchases one month after the month of purchase and the remaining 60% in the second month after the month of purchase.
Note the following:
• There were no debtors amounts outstanding for October, November and December 2020.
• The cash balance at the end of March 2021 was R80 000.
• All other monthly operating expenses for April to June must be budgeted for at R50 000 per month.
• For purposes of the preparation of the pro-forma cash budget for April to June 2021, ignore value-added tax (VAT).
Required:
Prepare a pro-forma cash budget for Kiddies Fashion for the period April to June 2021. The pro-forma budget must be prepared only to the point where the ending cash balances are reflected.
Step by step
Solved in 3 steps
