Question

Gilbert'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___________?

Answer 1

Answer:

$61,500.

Explanation:

Given that,

Beginning cash balance on September 1 = $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:

= $100,000 × 75%

= $75,000

Cash disbursements from purchases made in September:

= $120,000 × 25%

= $30,000

Ending cash balance September 30:

= Beginning cash balance + Cash receipts from credit sales made in August + Cash receipts from credit sales made in September - Cash disbursements from purchases made in August - Cash disbursements from purchases made in September

= $7,500  + $105,000  + $54,000  - $75,000  -  $30,000

= $61,500.