Question

The Prince Albert Corporation has forecast the following sales for the first seven months of the year.

January		$28,000	May		28,000
February		30,000	June		34,000
March		32,000	July		36,000
April		38,000

Monthly material purchases are set equal to 30 percent of forecasted sales for the next month. Of the total material costs, 40 percent are paid in the month of purchase and 60 percent are paid in the following month. Labour costs will run $5,800 per month, and fixed overhead is $11,000 per month. Interest payments on the debt will be $4,800 for both March and June. Finally, the Prince Albert sales people will receive a 2.0 percent commission on total sales for the first six months of the year, to be paid on June 30.

Prepare a monthly summary of cash payments for the six months from January through June. (Note: Compute prior December purchases to help get total material payments for January.)

Prince Albert Corporation Cash Payments Schedule
	December	January	February	March	April	May	June	July
Sales		$	$	$	$	$	$	$
Purchases	$
Current month payment
Prior month payment
Total payment for materials
Labour costs
Fixed overhead
Interest payments
Sales commission
Total cash payments		$	$	$	$	$	$

Answer 1

I hope my efforts will be fruitful to you

Stay Home Stay Safe

Thank You.