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

$\backslash$table$[[$March$,12,000],[$April$,14,000],[$May$,11,500],[$June$,10,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 ts paid for in the month incurred. Fixed overhead is $$15,000$ per month. Dividends of $$20,600$ are to be paid in May. The firm produced $11,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$],[$Projected unit sales,March,April,May,$],[$Desired ending inventory,,,,$],[$Total units required,,,,$],[$Beginning inventory,,,,$],[$Units to be produced,,,,$]]$