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
  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $350,000 for November, $370,000 for December, and $360,000 for January. Collections are expected to be 80% in the month of sale and 20% in the month following the sale. The cost of goods sold is 69% of sales. The company desires an ending merchandise inventory equal to 80% of the cost of goods sold in the following month....

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operation:s follow: . Sales are budgeted at $350,000 for November, $370,000...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operation:s follow: . Sales are budgeted at $350,000 for November, $370,000 for December, and $360,000 for January. . Collections are expected to be 80% in the month of sale and 20% in the month following the sale · The cost of goods sold is 72% of sales * The company desires an ending merchandise inventory equal to 80% of the cost of goods sold...

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: • Sales are budgeted at $370,000 for November, $390,000 for December, and $380,000 for January • Collections are expected to be 80% in the month of sale and 20% in the month following the sale. • The cost of goods sold is 74% of sales. • The company desires an ending merchandise inventory equal to 80% of the cost of goods sold...

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $360,000 for November, $380,000 for December, and $370,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 70% of sales. The company desires an ending merchandise inventory equal to 85% of the cost of goods sold in the following month....

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $380,000 for November, $400,000 for December, and $390,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 72% of sales. The company desires an ending merchandise inventory equal to 85% of the cost of goods sold in the following month....

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $360,000 for November, $380,000 for December, and $370,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 70% of sales. The company desires an ending merchandise inventory equal to 85% of the cost of goods sold in the following month....

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $380,000 for November, $400,000 for December, and $390,000 for January. Collections are expected to be 75% in the month of sale and 25% in the month following the sale. The cost of goods sold is 72% of sales. The company desires an ending merchandise inventory equal to 85% of the cost of goods sold in the following month....

  • Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's...

    Weller Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: Sales are budgeted at $390,000 for November, $410,000 for December, and $400,000 for January. Collections are expected to be 80% in the month of sale and 20% in the month following the sale. The cost of goods sold is 73% of sales. The company desires an ending merchandise inventory equal to 80% of the cost of goods sold in the following month....

  • TB Problem Qu. 8-224 Weller Industrial Gas Corporation ... Weller industrial Gas Corporation supplies acetylene and...

    TB Problem Qu. 8-224 Weller Industrial Gas Corporation ... Weller industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow. • Sales are budgeted at $340,000 for November. $360,000 for December, and $350,000 for January • Collections are expected to be 75% in the month of sale and 25% in the month following the sale. • The cost of goods sold is 68% of sales. • The company desires an ending merchandise Inventory...

  • . 3. Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding...

    . 3. Weldon Industrial Gas Corporation supplies acetylene and other compressed gases to industry. Data regarding the store's operations follow: • Sales are budgeted at $360,000 for November, $380,000 for December, and $350,000 for January. • Collections are expected to be 75% in the month of sale, 20% in the month following the sale, and 5% uncollectible. • The cost of goods sold is 65% of sales. • The company desires an ending merchandise inventory equal to 60% of the...

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