Question: 1. Study Problem #22-6A in your homework and answer the following questions in your own words. Y OU ARE NOT BEING ASKED TO PREPARE A

1. Study Problem #22-6A in your homework and answer the following questions in your own words. YOU ARE NOT BEING ASKED TO PREPARE A REVISED BUDGET; INSTEAD, ANSWER THE QUESTIONS BASED ON CONCEPT AND YOUR UNDERSTANDING OF HOW THE BUDGET NUMBERS ARE INTERRELATED. ASSUME EACH OF THE FOLLOWING QUESTIONS IS AN INDEPENDENT SITUATION:

a. What would be the impact on the cash budget if 30% (instead of 25%) of credit sales is collected in the month of the sale? (Note this is the only change). b. What would be the impact on the cash budget, if 90% (instead of 80%) of the merchandise is paid in the month following the purchase?

Problem 22-6A (50 minutes)

ONEIDA COMPANY

Cash Budget

For September, October, and November

September

October

November

Beginning balance...............................

$ 5,000

$ 99,250

$ 69,500

Cash receipts

Collection on accounts receivable*....

159,250

249,250

338,100

Receipts from bank loan.....................

100,000

_______

_______

Total cash available.............................

264,250

348,500

407,600

Cash disbursements

Payments on accounts payable**........

100,000

217,000

228,000

Payroll................................................

20,000

22,000

24,000

Rent....................................................

10,000

10,000

10,000

Other expenses...................................

35,000

30,000

20,000

Repayment on bank loan....................

100,000

Interest on bank loan***......................

________

________

3,000

Total cash disbursements...................

165,000

279,000

385,000

Ending cash balance............................

$ 99,250

$ 69,500

$ 22,600

*** Interest at 12% on $100,000 for 3 months is $3,000.

Supporting schedules

Collections of credit sales*

August

September

October

November

Aug. sales ($215,000)[25%: 45%: 20%: 9%].........

$ 53,750

$ 96,750

$ 43,000

$ 19,350

Sept. sales ($250,000)[25%: 45%: 20%]...............

-

62,500

112,500

50,000

Oct. sales ($375,000)[25%: 45%]..........................

-

-

93,750

168,750

Nov. sales ($400,000)[25%]...................................

-

-

-

100,000

Total............................................................................

$ 53,750

$159,250

$249,250

$338,100

Payments on credit purchases**

August

September

October

November

Aug. purchases ($125,000)(0%: 80%: 20%)................................

$ 0

$100,000

$ 25,000

$ -

Sept. purchases ($240,000)(0%: 80%: 20%)...............................

-

0

192,000

48,000

Oct. purchases ($225,000)(0%: 80%)...........................................

-

-

0

180,000

Nov. purchases ($200,000)(0%)...................................................

-

-

-

0

Total....................................................................................................

$ 0

$100,000

$217,000

$228,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!