Question

Ultravision Inc. anticipates sales of $280,000 from January through April. Materials will represent 50 percent of sales, and because of level production, material purchases will be equal for each month during the four months of January, February, March, and April.

Materials are paid for one month after the month purchased. Materials purchased in December of last year were $24,000 (half of $48,000 in sales). Labor costs for each of the four months are slightly different due to a provision in the labor contract in which bonuses are paid in February and April. The labor figures are:

January	$14,000
February	17,000
March	14,000
April	19,000

Fixed overhead is $10,000 per month.

Prepare a schedule of cash payments for January through April. (Assume the $280,000 of sales occur equally over the four months of January through April, i.e. Monthly sales = $280,000 / 4.)

Answer 1

ULTRAVISION, INC
Cash Payment Schedule
	December	January	February	March	April
* Purchases	24,000	35,000	35,000	35,000	35,000
**Payment to material purchases		24,000	35,000	35,000	35,000
Labor		14,000	17,000	14,000	19,000
Fixed overhead		10,000	10,000	10,000	10,000
Total cash payments		83,000	97,000	94,000	99,000
* Purchases (Jan to April)=280,000/4 *.50= 35000 each months