Bombs Away Video Games Corporation has forecasted the following monthly sales:

January $ $116,000$ July $ $61,000$

February $109,000$ August $61,000$

March $41,000$ September $71,000$

April $41,000$ October $101,000$

May $36,000$ November $121,000$

June $51,000$ December $139,000$

Total annual sales $=$ $$948,000$

Bombs Away Video Games sells the popular Strafe and Capture video game. It sells for $$5$ per unit and costs $$2$ per unit to produce. A level production policy is followed. Each month's production is equal to annual sales $($in units$)$ divided by $12.$

Of each month's sales, $40$ percent are for cash and $60$ percent are on account. All accounts receivable are collected in the month after the sale is made.

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 $\text{'}0\text{'}$ wherever required.

Bobs Away Video Games Corporation

Cash Budget

January February March April May June

Beginning cash

Net cash flow

Cumulative cash balance

Monthly loan or $($ repayment$)$

Ending cash balance

Cumulative loan balance

Bobs Away Video Games Corporation

Cash Budget

July August September October November December

Beginning cash

Net cash flow

Cumulative cash balance

Monthly loan or $($ repayment$)$

Ending cash balance

Cumulative loan balance