Explanation:
1. Budgeted sales for July = Budget sales unit × Selling price per unit
= 27,000 × $65
= $1,755,000
2. Expected cash collections for July = (Budget sales unit of June × Selling price per unit × Following month percentage) + (Budgeted sales for July × finished goods inventory percentage)
= (9,600 × $65 × 70%) + ($1755,000 × 30%)
= $963,300
3. Accounts receivable balance at the end of July = Budgeted sales for July × Following month percentage
= $1,755,000 × 70%
= $1,228,500
4. The estimated raw materials inventory balance is shown below:-
Budgeted sales for August = 29,000
Add: Ending inventory for June = 9,000
(30,000 × 30%)
Less: Beginning inventory = 8,700
(29,000 × 30%)
Units to be produced = 29,300
Raw materials per unit = 4
Total raw materials required = 117,200
(29,300 × 4)
Ending inventory(20%) = 23,440
Cost per unit = 2.5
Raw materials inventory balance = $58,600