Prepare a spreadsheet for cash budget by month, then answer the multiple choice questions that follow.

Great Lake Corporation wishes to prepare a cash budget for November 2014. Sales, purchases, and expenses for October (actual) and November and December (estimated) are as follows:

	Sales	Purchases(inventory)	Expenses
October	$48,000	$35,000	$14,000
November	40,000	30,000	11,000
December	45,000	22,000	9,500

Sales: All sales are on credit, and the company's experience shows that, on an average, 80 percent of sales are collected in the month of sale and the balance in the following month. A two percent (2%) discount is allowed on all collections in the month of sale.

Purchases: The company pays 60 percent of purchases in the month of purchase and the balance in the following month. The company is allowed an average discount of 1 percent on payments made in the month of purchase.

Expenses: The monthly expenses for November include charges for depreciation amounting to $1,000 and $100 of prepaid expenses, which will expire. All other expenses are paid as incurred.

Other: On September 1, 2014, a new machine was purchased for $5,000. A down payment of $500 was made, and it was agreed that the balance would be paid in equal installments in the following three months.

Please show all work

The cash receipts in November for October sales of Great Lake are expected to be

a.	$8,000.
b.	$9,600.
c.	$9,408.
d.	$7,840.

The cash receipts in November for November sales of Great Lake are expected to be

a.	$31,360.
b.	$32,000.
c.	$41,600.
d.	$39,200.

The cash payments in November for all purchases made by Great Lake are expected to be

a.	$32,000.
b.	$18,000.
c.	$17,820.
d.	$31,820.

The cash payments in November for expenses of Great Lake are expected to be

a.	$12,500.
b.	$9,900.
c.	$10,000.
d.	$11,000.