Question #2 PLANNING Budgeted Sales (units) JAN FEB MAR APR Shirts Pants Skirts Blouses Current Inventory:...

Transcribed Image Text:

Question #2 PLANNING Budgeted Sales (units) JAN FEB MAR APR Shirts Pants Skirts Blouses Current Inventory: Jan.1 [Units] 100 150 200 300 80 90 140 190 150 200 300 350 200 250 350 500 Shirts 120 Pants 100 Skirts Blouses 170 150 Target Ending Inventory of Finished goods is to be 20% of next month's sales. Raw Material Current Inventory: Wool Cotton Silk Polyester Jan.1 [Kg] 50 70 20 80 Target Ending Inventory (Kg): 50 00 100 50 50 100 [each month] Raw Material usage Per unit (in kg): Wool Cotton Silk Polyester Shirts .25 0 .30 .40 Pants .45 .10 0 .05 Skirts .20 .10 0 .25 Blouses 0 .30 .20 0 Material cost per kg: Wool Cotton Silk Polyester $4.00 $7.00 $12.00 $2.50 All Materials are bought in 10 kg increments. Materials are paid for 70% in the current month, 30% in the following month. Note: Save Time! Not all the Finished Goods use Silk. REQUIRED: Compute the cash to be paid out for Silk in February. Question #2 PLANNING Budgeted Sales (units) JAN FEB MAR APR Shirts Pants Skirts Blouses Current Inventory: Jan.1 [Units] 100 150 200 300 80 90 140 190 150 200 300 350 200 250 350 500 Shirts 120 Pants 100 Skirts Blouses 170 150 Target Ending Inventory of Finished goods is to be 20% of next month's sales. Raw Material Current Inventory: Wool Cotton Silk Polyester Jan.1 [Kg] 50 70 20 80 Target Ending Inventory (Kg): 50 00 100 50 50 100 [each month] Raw Material usage Per unit (in kg): Wool Cotton Silk Polyester Shirts .25 0 .30 .40 Pants .45 .10 0 .05 Skirts .20 .10 0 .25 Blouses 0 .30 .20 0 Material cost per kg: Wool Cotton Silk Polyester $4.00 $7.00 $12.00 $2.50 All Materials are bought in 10 kg increments. Materials are paid for 70% in the current month, 30% in the following month. Note: Save Time! Not all the Finished Goods use Silk. REQUIRED: Compute the cash to be paid out for Silk in February.