Answer:
Dilbert Farm Supply
1. The difference between cash receipts and cash disbursements for December would be:______.
A. $55,800
2. The net income for December would be:_______.
C. $40,200
3. The cash balance at the end of December would be:_______.
A. $185,000
B. $153,500
C. $82,800
D. $27,000
Answer: $176,550.
4. The accounts receivable balance, net of uncollectible accounts, at the end of December would be:______.
C. $43,700
5. Accounts payable at the end of December would be:_________.
B. $141,700
6. Retained earnings at the end of December would be:_______.
C. $471,300
Explanation:
a) Sales Budget November December January
Sales $260,000 $230,000 $210,000
b) Collections:
80% month of sale $208,000 $184,000 $168,000
19% following month $75,050 $49,400 $43,700
Total collections $283,050 $233,400 $211,700
c) Cost of goods sold $169,000 $149,500 $136,500
d) Ending Inventory $89,700 $81,900
e) Beginning Inventory $101,400 $89,700 $81,900
f) Purchases $157,300 $141,700
g) Disbursements:
Payment purchases $169,000 $157,300 $141,700
Other expenses $20,300 $20,300 $20,300
Total disbursement $189,300 $177,600 $162,000
h) Accounts Receivable Nov. Dec.
Beginning balance (net) $75,050 $49,400
Credit Sales $260,000 $230,000
Collections ($283,050) ($233,400)
Ending balance $52,000 $46,000
Uncollectibles $2,600 $2,300
Net of uncollectibles $49,400 $43,700
i) Accounts Payable Nov. Dec.
Beginning balance $169,000 $157,300
Credit purchases $157,300 $141,700
Payments ($169,000) ($157,300)
Ending balance $157,300 $141,700
j) Difference between collections and disbursements:
November December January
Total collections $283,050 $233,400 $211,700
Total disbursement $189,300 $177,600 $162,000
Difference $93,750 $55,800 $49,700
k) Income Statement
November December January
Sales $260,000 $230,000 $210,000
Cost of goods sold $169,000 $149,500 $136,500
Gross profit $91,000 $80,500 $73,500
Other expenses $20,300 $20,300 $20,300
Depreciation $20,000 $20,000 $20,000
Net Income $50,700 $40,200 $33,200
Retained Earnings $380,400 $431,400 $471,300
Retained Earnings $431,100 $471,300 $504,500
l) Cash balance
November December January
Beginning balance $27,000 $120,750 $176,550
Total collections $283,050 $233,400 $211,700
Total disbursement $189,300 $177,600 $162,000
Ending balance $120,750 $176,550 $226,250
m) Opening balance of Cash:
Total Assets $1,289,400
less stated assets $1,262,400 ($79,000 + 101,400 + 1,082,000)
Difference = Cash balance = $27,000
