I need help filling out the inventory tracking table. Listed are the transactions.

Events

Beginning Balances as of Dec 31, Year 1

Paid a $42,000 cash dividend previously declared for stockholders

Paid wages payable accrued in previous month

Acquired $150,000 by signing a note payable with a local bank

Sold 5,000 shares of $5 par Common Stock for $110,000

Sold 2,000 shares of $40 par, 3% cumulative preferred stock for $120,000

Purchased a truck and piece of Equipment for $128,000. The truck has a market value of 65,000 and the equipment has a market value of 95,000.

Purchased 25,000 Units of Inventory on Account for $8.15 per unit

Sold 45,000 units at $24.50 on Account - Revenue

COGS on sale of 45000 units

Collect $570,000 on Account

Paid $540,250 of Accounts Payable

Purchased 70,000 Units of Inventory on Account for $8.50 per unit

Sold 75,000 units at $24.50 on Account

Record COGS for Sales of 75,000 units on Account

Collect $1,472,500 on Account

Paid $438,500 of Accounts Payable

Purchased 115,000 Units of Inventory on Account for $9.35 per unit

Sold 102,000 units at $24.50

Record COGS for Sale of 102,000 units

Collect $735,000 on Account

Paid $883,150 of Accounts Payable

Purchased 175,000 Units of Inventory on Account for $8.75 per unit

Paid Advertising and Marketing Expenses of $130,000

Paid Fixed Operating Expenses of $275,708

Paid Wages of $1,235,000

Record Wages Payable of $215,000

Paid Product Line Research & Development Expenses of $450,000

Principle & Interest on Note Payable

Year 1 Depreciation on Truck

Year 1 Depreciation on Equipment

Year 2 Depreciation on Building

Common Stock Dividend Declaration

Preferred Stock Dividend Declaration

Goods Available for Sale

Cost of Goods Sold

Ending Inventory

Units

Price/Unit

Total

Units

Price/Unit

Total

Units

Price/Unit

Total

Beg Bal

410,000

$ 8.00

$ 328,000

Purchases:

Total

Average Purchase Price

Average COGS