Question

Goldberg Company is a retail sporting goods store that uses an accrual accounting system. Facts regarding its operations follow: . Sales are budgeted at $220,000 for December and $190,000 for January, terms 1/eom, n/60 ·Collections are expected to be 50% in the month of sale and 48% in the month following the sale. Two percent of sales are expected to be uncollectible and recorded in an allowance account at the end of the month of sale. Bad debts expense is included as part of operating expenses ·Gross margin is 30% of gross sales. All accounts receivable are from credit sales. Bad debts are written off against the allowance account at the end of the month following the month of sale. . Goldberg desires to have 80% of the merchandise for the following month's sales on hand at the end of each month. Payment for merchandise is made in the month following the month of purchase. Other monthly operating expenses to be paid in cash total $17,600. Annual depreciation is $162,000, one-twelfth of which is reflected as part of monthly operating expenses Goldberg Company's statement of financial position at the close of business on November 30 follows: GOLDBERG COMPANY Statement of Financial Position November 30, 2019 Assets Cash Accounts receivable $ 17,000 GOLDBERG COMPANY Statement of Financial Position November 30, 2019 Assets Cash $17,000 Accounts receivable (net of $4,000 allowance for doubtful accounts) Inventory Property, plant, and equipment (net of $570,000 accumulated depreciation) 54,000 123,200 950,000 $1,144,200 Total assets Liabilities and Stockholders' Equity Accounts payable $ 137,000 800,000 207,200 Common stock Retained earnings $1,144,200 Total liabilities and equity Required: 1. What is the total of budgeted cash collections for December? 2. How much is the book value of accounts receivable at the end of December? 3. How much IS the Income 〈loss) beto re income taxes tor December 4. What is the projected balance in inventory on December 31, 2019? 5. What are budgeted purchases for December? 6. What is the projected balance in accounts payable on December 31, 2019? (For all requirements, Do not round intermediate calculations.) Required: 1. What is the total of budgeted cash collections for December? 2. How much is the book value of accounts receivable at the end of December? 3. How much is the income (loss) before income taxes for December? 4. What is the projected balance in inventory on December 31, 2019? 5. What are budgeted purchases for December? 6. What is the projected balance in accounts payable on December 31, 2019? (For all requirements, Do not round intermediate calculations.) Budgeted cash collections-December 1. 2. Net accounts receivable-December 31st 3. 4. Budgeted inventory, December 31st 5. Budgeted purchases during December 6. Budgeted accounts payable, December 31st

Answer 1

Answer 1.

Cash Collections for December = Accounts Receivable + 50% * December Sales
Cash Collections for December = $54,000 + 50% * $220,000
Cash Collections for December = $54,000 + $110,000
Cash Collections for December = $164,000

Answer 2.

Bad Debt Expense for December = 2% * December Sales
Bad Debt Expense for December = 2% * $220,000
Bad Debt Expense for December = $4,400

Accounts Receivable at the End of December = 48% * December Sales
Accounts Receivable at the End of December = 48% * $220,000
Accounts Receivable at the End of December = $105,600

Answer 3.

December Gross Profit = 30% * December Sales
December Gross Profit = 30% * $220,000
December Gross Profit = $66,000

Income before Taxes for December = Gross Profit - Bad Debt Expense - Other Cash Operating Expense - Depreciation
Income before Taxes for December = $66,000 - $4,400 - $17,600 - $13,500
Income before Taxes for December = $30,500

Answer 4.

Budgeted Ending Inventory for December = 80% * January Sales
Budgeted Ending Inventory for December = 80% * $190,000
Budgeted Ending Inventory for December = $152,000

Answer 5.

Budgeted Purchases for December = Budgeted Sales + Budgeted Ending Inventory - Beginning Inventory
Budgeted Purchases for December = $220,000 + $152,000 - $123,200
Budgeted Purchases for December = $248,800

Answer 6.

Accounts Payable at the End of December = Budgeted Purchases
Accounts Payable at the End of December = $248,800