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

$\backslash$table$[[$March$,16,000],[$April$,18,000],[$May$,15,500],[$June$,14,000]]$

Wright maintains an ending inventory for each month in the amount of three times the expected sales in the following month. The ending inventory for February $($March$\text{'}$s beginning inventory$)$ reflects this policy. Materials cost $$8$ per unit and are paid for in the month after production. Labor cost is $$12$ per unit and is paid for in the month incurred. Fixed overhead is $$17,000$ per month. Dividends of $$21,000$ are to be paid in May. The firm produced $15,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 a'mounts 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,June$],[$Desired ending inventory,,,,$],[$Total units required,,,,$],[$Beginning inventory,,,,$],[$Units to be produced,,,,$]]$