1. Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1^st quarter budget: July, August, and September. Budgeted sales are as follows:

Additional information:

1. i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase.
2. ii) Closing inventory must equal 50% of the next month’s sales.

iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale.

1. iv) The balance in the bank account as of 30 June is $10,000.

Required (show your workings for each question):

Prepare a purchases budget (in units and $) for the 1^st quarter. (Purchases are based on expected sales).

1. Beauty Spa & Co. manufactures a specialised luxury spa that is supplied to five-star hotels around the country. The owner provides you with the following information to prepare its 1^st quarter budget: July, August, and September. Budgeted sales are as follows:

Additional information:

1. i) Purchases are budgeted at $5.00 per unit and are paid for in full in the month after purchase.
2. ii) Closing inventory must equal 50% of the next month’s sales.

iii) Sales (which are all on credit) are collected as follows: 60% in the month of sale; 30% in the month after the sale; 5% in the second month after the sale.

1. iv) The balance in the bank account as of 30 June is $10,000.

Required (show your workings for each question):

Prepare the schedule of expected cash collections from Accounts Receivable for the months of July and August.