Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Elias Company has prepared a budget for the first six months of 2020. Monthly budgets for revenues are provided at left. Experience indicates that Elias
Elias Company has prepared a budget for the first six months of 2020. Monthly budgets for revenues are provided at left. Experience indicates that Elias will collect 75% of sales in the month of sale, 15% in the month following the sale, and 7.5% in the second month after the sale. The remaining 2.5% of sales are expected to be uncollectible. Prepare a cash collections budget for Elias for the months of March, April, and May 2020. Show your work.
Revenues budget: | |
January | 8,537,500 |
February | 9,748,615 |
March | 10,250,324 |
April | 8,904,561 |
May | 12,358,975 |
June | 14,548,289 |
64,348,264 | |
Collections experience: | |
Month of sale | 75.0% |
Month after sale | 15.0% |
2 months after sale | 7.5% |
Uncollectible | 2.5% |
100.0% |
Please so some calculations, I'm having difficulty trying to follow just numbered answers.
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