Question



- A - E B 5 E G G H I J BC D E F On the tab labeled Solution, use all available data and a. Prepare a Schedule of Expected Ca
Hle Edt Insert Format Help Qa Calibri - 2. BIUSA. . - ES B C D E 1 FGH UNA Budgeted Sales November December January $330,000
C DE 4 $ Balance Sheet 31-Oct Assets Cash Accounts receivable Merchandise inventory Property, plant and equipment (net of $59
0 0
Add a comment Improve this question Transcribed image text
Answer #1

a)

SCHEDULE OF EXPECTED CASH COLLECTIONS
November December
Beginning accounts receivable 83000
November sales 330000*85%=280500 330000*15%= 49500
December sales 300000*85%= 255000
Total cash collections 363500 304500

b)

MERCHANDISE PURCHASE BUDGET
NOVEMBER DECEMBER JANUARY
Estimated sales 330000 300000 320000
% of cost of goods sold 60% 60% 60%
cost of goods sold

330000*60%= 198000

180000 192000
Desired ending inventory 180000*80%= 144000 192000*80%=153600
Less:beginning inventory -158400 -144000
Estimated purchase 183600 189600

c)

CASH BUDGET
November December
Beginning cash Balance 22000 168300
Cash collections during the month 363500 304500
Total cash available fro disbursement 385500 472800
less
Payment to suppliers -196000 -183600
other cash expense -21200 -21200
Total cash disbursement -217200 -204800
cash balance at end 168300 268000
Add a comment
Know the answer?
Add Answer to:
- A - E B 5 E G G H I J BC D E F...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT