Lien Company Is a Merchandising Company That Sells a Single

Lien Company is a merchandising company that sells a single product. The company's inventories, production, and sales in units for the next three months have been forecasted as follows:
$$\begin{array} { | l | r | r | r | } \hline & \text { October } & \text { November } & \text { December } \\\hline \text { Beginning inventory } & 10,000 & 10,000 & 10,000 \\\hline \text { Merchandise purchases } & 60,000 & 70,000 & 35,000 \\\hline \text { Sales } & 60,000 & 70,000 & 40,000 \\\hline \text { Ending inventory } & 10,000 & 10,000 & 5,000 \\\hline\end{array}$$
Units are sold for $12 each. One fourth of all sales are paid for in the month of sale and the balance is paid for in the following month. Accounts receivable at September 30 totaled $450,000.
Merchandise is purchased for $7 per unit. Half of the purchases are paid for in the month of the purchase and the remainder is paid for in the month following purchase. Marketing and administrative expenses are expected to total $120,000 each month. One half of these expenses will be paid in the month in which they are incurred and the balance will be paid in the following month. Accounts payable at September 30 totaled $290,000.
Cash at September 30 totaled $80,000. A payment of $300,000 for purchase of equipment is scheduled for November, and a dividend of $200,000 is to be paid in December. Ignore depreciation for purposes of preparing the schedules
Required:
a. Prepare a schedule of expected cash collections for each month October-December.
b. Prepare a schedule showing expected cash disbursements for merchandise purchases and marketing and administrative expenses for each month October-December.
c. Prepare a cash budget for each month October--December. There is no minimum required ending cash balance.