In: Accounting
Lizz and Taylors, a retail business, has supplied the following information in relation to their actual sales in 2017 and planned sales for the first quarter of 2018.
Cash Credit Total
$ $ $
2017 Actual Sales for November 25,000 25,000 50,000
December 35,000 40,000 75,000
2018 Estimated Sales for January 15,000 20,000 35,000
February 18,000 30,000 48,000
March 22,000 40,000 62,000
Past records indicate that expected receipts collected from debtors will be:
60% in the month of sale
40% in the month following the sale
Based on your answers above, explain how the preparation of a cash budget could assist a company to identify short-term problems.