Question
Scottie Inc. developed the following budget for the month of October. October 1 cash balance $7,600 Cash sales in October $78,000 Credit sales for the
Scottie Inc. developed the following budget for the month of October.
October 1 cash balance | $7,600 |
Cash sales in October | $78,000 |
Credit sales for the following months are:
August | $42,000 |
September | $37,000 |
October | $40,000 |
For credit sales the controller has found the following collection pattern:
50% | collected in the month of sale |
30% | collected in the month after sale |
15% | collected two months after the sale |
5% | expected to be uncollectible |
Budgeted material purchases for September and October are:
September | $43,000 |
October | $49,000 |
Material purchases are paid:
60% | in the month of purchase |
40% | in the month following purchase |
Other budgeted costs in October:
Utilities | $4,520 |
Salaries | $23,400 |
Depreciation on the building and equipment | $15,000 |
Entry/Rounding Rules:
Never enter $ or , when inputting numerical answers
Round your answer to the nearest whole number.
Examples:
If your answer is $24,500.47, enter 24500
If your answer is $24,500.51, enter 24501
If your answer is $24,500.00, enter 24500
a. How much is the total budgeted cash collection from accounts receivable in October?
b. How much is the total cash inflows from all sources in October?
c. How much is the October cash payments for purchases made in September and October?
d. How much is the total cash disbursements in October?
e. What is the cash balance on October 31?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started