6-31 Sales Budget
A Sendai clothing wholesaler was preparing its sales budget for the first quarter of 20X8. Forecast sales are as follows (all values are in thousands of yen).
Sales are 40% cash and 60% credit. 55% of the credit accounts are collected in the month of sale, 35% in the month following the sale, and 10% in the following month. No uncollectable accounts are anticipated. Accounts receivable at the beginning of 20X8 are 82,950 (10% of November credit sales of 140,000 and 4% of December credit sales of 151,000).
Prepare a schedule showing sales and cash collections for January, February, and March, 20X8.