$6)$ Summers Gourmet Chocolates forecasts sales for the upcoming year as follows:

January February March April May June

$$108,000$ $$101,000$ $ $56,000$ $ $51,000$ $ $45,000$ $ $55,000$

July August September October November December

$ $65,000$ $ $68,000$ $ $68,000$ $ $93,000$ $ $113,000$ $ $128,000$

Summers sells its gourmet candy bars for $$9\mathrm{.}75$ each. It takes $$5$ in materials to produce each one. Summers plans to use level production to produce the exact number of candy bars it forecasts selling this year.

a$)$ Create an inventory production and sales schedule for Summers. Be sure to convert sales to units before calculating. Assume Summers starts with a beginning inventory of $10,000$ units.

b$)$ Prepare a monthly cash receipts schedule for Summers. They collect $50\%$ of sales in the month they are made, and the remaining $50\%$ in the following month. They had $$108,000$ of sales in December.

c$)$ Prepare a cash payments schedule assuming that all materials used in production are paid for the month they are incurred, as are selling and administrative expenses of $$35,000$ for each month.

d$)$ Prepare a monthly cash budget that starts with a $$5,000$ beginning balance. $$5,000$ is also the minimum desired balance.

e$)$ Graph ending inventory, sales and accounts receivable for each of the $12$ months. What relationships between those three current assets do you see? F$)$ What is the ending cash balance for Summers for January?