Berkner Corporation has found that 60% of its sales in any given month are credit...

80.2K

Verified Solution

Question

Accounting

Berkner Corporation has found that 60% of its sales in any given month are credit sales,
while the remainder are cash sales. Of the credit sales, Berkner Corporation has
experienced the following collection pattern:
20% received in the month of the sale
40% received in the month after the sale
22% received two months after the sale
18% of the credit sales are never
received
November sales for last year were $90,000, while December sales were
$115,000. Projected sales for the next three months are as follows:
January sales............................. $150,000
February sales......................... $135,000
March sales ................. $185,000
Requirement
Prepare a cash collections budget for the first quarter, with a column for each
month and for the quarter. (Round your answers to the nearest whole dollar.)
Berkner Corporation
Cash Collections Budget
For the Months of January through March
image

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