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

$\backslash$table$[[$January$,$$$112,000,$July,$$57,009],[$February$,195,000,$August,$57,009],[$March$,37,$e$00,$September,$67,009],[$April$,37,$e$00,$October,$97,009],[$May$,32,$e$00,$Novenber,$117,009],[$June$,47,$e$00,$Decenber,$135,009]]$

Total annual sales $=$$$990,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, $30$ percent are for cash and $70$ percent are on account. All accounts recelvable are collected in the month after the sale is made.

a$.$ Construct a monthly production and inventory schedule in units. Beginning inventory in January is $37,000$ units.

Note: Input all your answers as positive numbers.

$\backslash$table$[[$Bombs Away Video Games Corporation$],[$Production and Inventory Schedule in Units$],[,\backslash$table$[[$Beginning$],[$Inventory$]],+,$Production,$-,$Sales,$=,\backslash$table$[[$Ending$],[$Inventory$]]],[$January$,37,000,,15,000,,22,400,,29,600],[$February$,29,600,,15,000,,21,000,,23,600],[$March$,23,600,,15,000,,7,400,,31,200],[$April$,31,200,,15,000,,7\mathrm{.}400,,38,800],[$May$,38,800,,15,000,,6,400,,47,400],[$June$,47,400,,15,000,,9,400,,53,000],[$July$,53,000,,15,000,,11,400,,56,600],[$August$,56,600,,15,000,,11,400,,60,200],[$September$,60,200,,15,000,,13,400,,61,800],[$October$,61,800,,15,000,,19,400,,57,400],[$November$,57,400,,15,000,,23,400,,49,000],[$December$,49,000,,15,000,,27,000,,37,000]]$ b$.$ Prepare a monthly schedule of cash recelpts. Sales in December before the planning year are $$100,000.$ c$.$ Prepare a cash payments schedule for January through December. The production costs of $$2$ per unit are pald for in the month in

which they occur. Other cash payments, besides those for production costs, are $$57,000$ per month. d$.$ Prepare a monthly cash budget for January through December using the cash recelpts 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 certaln to enter $\text{'}0\text{'}$ wherever required. epare a monthly cash budget for January through December using the cash recelpts schedule from part $b$ and the cash payments

hedule from part $c.$ The beginning cash balance is $$5,000,$ which is also the minimum desired.

te: Negative amounts should be indicated by a minus sign. Leave no cells blank be certaln to enter $\text{'}0\text{'}$ wherever required.

NEED HELP WITH D$.$ for AUG SEP OCT NOV DEC for COMULATIVE LOAN BAL