The following information is from Barkleys Auto Alarm Company financial records. Collections from customers are...

90.2K

Verified Solution

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!
Become a Member

Other questions asked by students