$\backslash$table$[[$January$,1,800],[$February$,1,650],[$March$,1,600],[$April$,2,100],[$May$,2,350],[$June$,2,500],[$July$,2,200]]$ b$.$ Prepare a monthly summary of cash payments for January through June. Volt Battery produced $1,600$ units in December.

Volt Battery always keeps an ending inventory equal to $120$ percent of the next month's expected sales. The ending inventory for December $($January$\text{'}$s beginning inventory$)$ is $2,160$ units, which is consistent with this policy.

Materials cost $$13$ per unit and are paid for in the month after purchase. Labor cost is $$6$ per unit and is paid in the month the cost is incurred. Overhead costs are $$11,000$ per month. Interest of $$9,000$ is scheduled to be paid in March, and employee bonuses of $$14,200$ will be paid in June.

a$.$ Prepare a monthly production schedule for January through June.

Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter $0$ wherever required.

$\backslash$table$[[$Volt Battery Company$],[$Production Schedule,,,,,,,$],[,$January,February,March,April,May,June,,$],[$Projected unit sales,,,,,,,,$],[$Desired ending inventory,,,,,,,,$],[$Total units required,,,,,,,,$],[$Beginning inventory,,,,,,,,$],[$Units to be produced,,,,,,,,$]]$