I need detailed help with steps on how to solve, be ready for follow up questions, answer B) was def

I need detailed help with steps on how to solve, be ready for follow up questions, answer B) was defintley wrong.

Carner Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store’s operations follow:

Ac€?c Sales are budgeted at $370,000 for November, $360,000 for December, and $340,000 for January.
Ac€?c Collections are expected to be 85% in the month of sale, 13% in the month following the sale, and 2% uncollectible.
Ac€?c The cost of goods sold is 70% of sales.
Ac€?c The company purchases 30% of its merchandise in the month prior to the month of sale and 70% in the month of sale. Payment for merchandise is made in the month following the purchase.
Ac€?c Other monthly expenses to be paid in cash are $24,600.
Ac€?c Monthly depreciation is $17,000.
Ac€?c Ignore taxes.

Statement of Financial Position October 31
Assets
Cash $19,000
Accounts receivable (net of allowance for uncollectible accounts) 83,000
Inventory 77,700
Property, plant and equipment (net of $502,000 accumulated depreciation) 968,000
Total assets $1,147,700

Liabilities and StockholdersAc€?c Equity
Accounts payable $259,000
Common stock 800,000
Retained earnings 88,700
Total liabilities and stockholdersAc€?c equity $1,147,700

Question : Inventory at end of December would be ?

A) 102,000 B) 176,400 C) 75,600 D) 71,400

Thanks 🙂