Question

Goldberg Company is a retail sporting goods store that uses an accrual accounting system. Facts regarding its operations follow: 1. Sales are budgeted at $330,000 for December and $300,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 $26,400. • Annual depreciation is $234,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: $ 28,000 76,000 184,800 GOLDBERG COMPANY Statement of Financial Position November 30, 2019 Assets Cash Accounts receivable (net of $4,000 allowance for doubtful accounts) Inventory Property, plant, and equipment (net of $680,000 accumulated depreciation) Total assets Liabilities and Stockholders' Equity Accounts payable Common stock Retained earnings Total liabilities and equity 1,060,000 $ 1,348, 880 $ 148,000 800,000 400,800 $ 1,348,800 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.)

Answer 1

Answer:

1.)
Cash Collections for December = Accounts Receivable + 50% * December Sales
Cash Collections for December = $76,000 + 50% * $330,000
Cash Collections for December = $76,000 + $165,000
Cash Collections for December = $241,000

2.)
Bad Debt Expense for December = 2% * December Sales
Bad Debt Expense for December = 2% * $330,000
Bad Debt Expense for December = $6,600

Accounts Receivable at the End of December = 48% * December Sales
Accounts Receivable at the End of December = 48% * $330,000
Accounts Receivable at the End of December = $158,400

3.)
December Gross Profit = 30% * December Sales
December Gross Profit = 30% * $330,000
December Gross Profit = $99,000

4.)
Income before Taxes for December = Gross Profit - Bad Debt Expense - Other Cash Operating Expense - Depreciation
Income before Taxes for December = $99,000 - $6,600 - $26,400 - $19,500
Income before Taxes for December = $46,500
.
5.)
Budgeted Ending Inventory for December = 80% * January Sales
Budgeted Ending Inventory for December = 80% * $300,000
Budgeted Ending Inventory for December = $240,000

5.)
Budgeted Purchases for December = Budgeted Sales + Budgeted Ending Inventory - Beginning Inventory
Budgeted Purchases for December = $330,000 + $240,000 - $184,800
Budgeted Purchases for December = $385,200

6.)
Accounts Payable at the End of December = Budgeted Purchases
Accounts Payable at the End of December = $385,200