The following information is from Barkleys Auto Alarm Company financial records. Collections from customers are...
90.2K
Verified Solution
Link Copied!
Question
Accounting
The following information is from Barkleys Auto Alarm Company financial records. Collections from customers are normally 70 percent in the month of sale, 20 percent in the month following the sale, and 9 percent in the second month following the sale. The balance is expected to be uncollectible. All purchases are on account. Management takes full advantage of the 3 percent discount allowed on purchases paid for by the tenth of the following month. Purchases for December are budgeted at $72,000, and sales for December are forecasted at $78,000. Cash disbursements for expenses are expected to be $16,800 for the month of December. The companys cash balance on December 1 was $28,000.
Month
Sales
Purchases
August
$
84,000
$
54,000
September
78,000
60,000
October
72,000
48,000
November
90,000
66,000
Required:
Prepare the expected cash collections during December.
Prepare the expected cash disbursements during December.
Prepare the expected cash balance on December 31.
Complete this question by entering your answers in the tabs below.
Required A
Required B
Required C
Prepare the expected cash collections during December.
Month
Expected Collections
October
November
December
Total
Prepare the expected cash disbursements during December.
BARKLEYS AUTO ALARM COMPANY
Expected Cash Disbursements
December
November purchases to be paid in December
Net
Cash disbursements for expenses
Total
Prepare the expected cash balance on December 31.
BARKLEYS AUTO ALARM COMPANY
Expected Cash Balance
December 31
Balance, December 1
Expected balance
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!