b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. \begin{tabular}{|c|} \hline eBook \\ \hline Hint \\ \hline Print \\ \hline References \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{7}{|c|}{ Bombs Away Video Games Corporation } \\ \hline \multicolumn{2}{|c|}{ Cash Budget } \\ \hline & July & August & September & October & November & December \\ \hline Beginning cash & & & & & & \\ \hline Net cash flow & & & & & & \\ \hline Cumulative cash balance & & & & & & \\ \hline Monthly loan or (repayment) & & & & & & \\ \hline Ending cash balance & & & & & & \\ \hline Cumulative loan balance & & & & & & \\ \hline \end{tabular} c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $65,000 per month. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 45,000 units. Note: Input all your answers as positive numbers. d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. Note: Negative amounts should be indicated by a minus sign. Leave no cells blank be certain to enter ' 0 ' wherever required. b. Prepare a monthly schedule of cash receipts. Sales in December before the planning year are $100,000. \begin{tabular}{|c|} \hline eBook \\ \hline Hint \\ \hline Print \\ \hline References \\ \hline \end{tabular} \begin{tabular}{|l|l|l|l|l|l|l|} \hline \multicolumn{7}{|c|}{ Bombs Away Video Games Corporation } \\ \hline \multicolumn{2}{|c|}{ Cash Budget } \\ \hline & July & August & September & October & November & December \\ \hline Beginning cash & & & & & & \\ \hline Net cash flow & & & & & & \\ \hline Cumulative cash balance & & & & & & \\ \hline Monthly loan or (repayment) & & & & & & \\ \hline Ending cash balance & & & & & & \\ \hline Cumulative loan balance & & & & & & \\ \hline \end{tabular} c. Prepare a cash payments schedule for January through December. The production costs of $2 per unit are paid for in the month in which they occur. Other cash payments, besides those for production costs, are $65,000 per month. a. Construct a monthly production and inventory schedule in units. Beginning inventory in January is 45,000 units. Note: Input all your answers as positive numbers. d. Prepare a monthly cash budget for January through December using the cash receipts schedule from part b and the cash payments schedule from part c. The beginning cash balance is $5,000, which is also the minimum desired. Note: Negative amounts should be indicated by a minus sign. Leave no cells blank be certain to enter ' 0 ' wherever required