Prepare a Financial Report by using the following data:
1) The Alec Corporation sells inflatable pools. On June 30, there were 105 pools in ending inventory, and accounts receivable had a balance of S12,000. Sales of inflatable pools (in units) have been budgeted at the following levels for the upcoming months:
Accounts receivable, june 30 $12,000
Number of pools budgeted to be sold in July 350
Number of pools budgeted to be sold in August 420
Number of pools budgeted to be sold in September 370
Number of pools budgeted to be sold in October 300
The company has a policy that the ending inventory of inflatable pools should be equal to 30% of the number of pools to be sold in the following month. The Outdoor Leisure Store sells the inflatable pools for $100 each. The company's collection history shows that 30% of the sales in a month are paid for by customers in the month of sale, while the remainder is collected in the
following month.
Required:
a. Prepare a merchandise purchases budget showing how many pools should be purchased in each of the months including July, August, and September.
b. Prepare a cash collections budget for each of the months including July, August, and September.
Part a.
Merchandise Purchases Budget July August September October
Budgeted unit sales
Desired ending inventory
(30% of next month's sales)
Total needs
Less beginning inventory
Required purchases
Part b.
Cash Collections Budget
Budgeted unit sales
Selling price per unit
Budgeted sales
Accounts receivable, June 30
July sales
August sales
September sales
Total cash collections