The Academy of Motion Pictures Arts & Science Corporation specialized in the development and sale of transmission devices for avatars from earth to visit other planets. The companys Treasurer has assembled the following data for use in forecasting the company's cash position for the next six months.

Current bank balance assume January 1	$5,000
Estimated monthly payroll and related items	$40,000
Estimated monthly depreciation	$4,000
Interest payable in June	$6,000
Real estate taxes payable in March	$4,000

Other Forecasted items:

		Purchases
Month	Sales ($)	Inventory ($)	Capital Items ($)
December	120,000	40,000	80,000
January	120,000	60,000	-0-
February	160,000	120,000	-0-
March	400,000	75,000	25,000
April	200,000	80,000	5,000
May	240,000	90,000	-0-
June	260,000	130,000	-0-

Note: November Sales were $80,000 and October Sales were $100,000. Historically, credit sales have been collected 50% one month after the sale, 25% two months after the sale, and 20% three months after the sale, and 5% not collectible. There are no cash sales. The company has always paid their bills for inventory and capital items 30 days after receipt.

REQUIRED

A monthly forecast of cash inflows, outflows, bank balances, cash shortage or surplus and recommended management actions suggested by the forecast.

I was able to complete most of it, except the "cash out" section, and the suggestion for management action