Q9. Wright Lighting Fixtures

Wright Lighting Fixtures forecasts Its sales In unIts forthe nextfour months as follows: .'Iacch 16,886 April 18,886 May 15,586 June 14,886 Wright maIntaIns an ending Inventory for each month In the amount of threetlmes the expected sales In the followlng month. The ending Inventory for February [March'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 deslred ending Inventory mInus beginning Inventory. Note: Input all amounts as positive values except BegInnlng Inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter 0 wherever required. Wright Lighting Fixtures Production Schedule Projected unit sales Desired ending inventory Total units required Beginning inventory Units to be produced Cash Payments February March April May Units produced Material cost Labor cost Fixed overhead Dividends Total cash payments