Question

ilbert's expects its September sales to be 20% higher than its August sales of $150,000. Manufacturing costs were $100,000 in August and are expected to be $120,000 in September. All sales are on credit and are collected as follows: 30% in the month of the sale and 70% in the following month. Payments of manufacturing costs are as follows: 25% in the month of production and 75% in the following month. The beginning cash balance on September 1 is $7,500. The ending balance on September 30 would be a.$75,000 b.$72,300 c.$61,500 d.$71,500

Answer 1

$61,500

Step-by-step explanation:

The computation of ending balance on September 30 is shown below:-

Beginning cash balance = $7,500

Cash receipts from credit sales made in August = $150,000 × 70%

= $105,000

Cash receipts from credit sales made in September = $150,000 × 1.20 × 30%

= $54,000

Cash disbursements from purchases made in August = $100000 × 75%

= $75,000

Cash disbursements from purchases made in September ($120000 × 25%) = $30,000

Ending cash balance September 30 = $7,500 + $105,000 + $54,000 - $75,000 - $30,000

= $61,500

So, for computing the ending balance in September we simply add all cash receipts with beginning cash balance and deduct the cash disbursement.