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

$\backslash$table$[[$March$,13,000],[$April$,15,000],[$May$,12,500],[$June$,11,000]]$

Wright maintains an ending inventory for each month in the amount of one and one$-$half times the expected sales in the following month. The ending inventory for February $($March$\text{'}$s beginning inventory$)$ reflects this policy. Materials cost $$5$ per unit and are paid for in the month after production. Labor cost is $$9$ per unit and is paid for in the month incurred. Fixed overhead is $$15,500$ per month. Dividends of $$20,700$ are to be paid in May. The firm produced $12,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 positlve values except Beginning Inventory values under Productlon Schedule which should be entered with a minus sign. Leave no cells blank be certaln to enter o wherever required.

$\backslash$table$[[$Wright Lighting Fixtures,$],[$Production Schedule,,$],[,$March,April,May,June$],[$Projected unit sales,,,,$],[$Desired ending inventory,,,,$],[$Total units required,,,,$],[$Beginning inventory,,,,$],[$Units to be produced,,,,$]]$

$\backslash$table$[[$Cash Payments,,,,$],[,$February,March,April,May$],[$Units produced,,,,$],[$Material cost$,,,,],[$Labor cost$,,,,],[$Fixed overhead,,,,$],[$Dividends$,,,,],[$Total cash payments,,,,$]]$