Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:

$\backslash$table$[[$March$,7,000],[$April$,9,000],[$May$,6,500],[$June$,5,000]]$

Wright maintains an ending inventory for each month in the amount of one times the expected sales in the following month. The ending inventory for February $($March$\text{'}$s beginning inventory$)$ reflects this policy. Materials cost $$4$ per unit and are paid for in the month after production. Labor cost is $$8$ per unit and is paid for in the month incurred. Fixed overhead is $$12,500$ per month. Dividends of $$20,100$ are to be paid in May. The firm produced $6,000$ units in February.

Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory.

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$[[$Wright Lighting Fixtures$],[$Production Schedule$],[,$March,April,May,June$],[$Projected unit sales$],[$Desired ending inventory$],[$Total units required,$0,0,0,],[$Beginning inventory$],[$Units to be produced,$0,0,0,]]$