Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
ahmed reeds, a manufacturer of saxaphone, oboe, and clarinet reeds, has projected sales to be $894,000 in october, $950,000 in november, $1,055,000 in december, and
ahmed reeds, a manufacturer of saxaphone, oboe, and clarinet reeds, has projected sales to be $894,000 in october, $950,000 in november, $1,055,000 in december, and $938,000 in january. ahmed's sales are 20% cash and 80% credit. the companys collection history indicates that credit sales are collected as follows.
25% in the month of sale60% in the month after the sale 14% two months after the sale 1% are never collected Ahmed Reeds, a manufacturer of ophone, ebon, and charmerende, tos projected to be 0.000 in dober, November 1,065.000 in December, and 1.000 in January Alvedes are 20% hand 60 credit. The company's colection history Indees that credite are colected as follows 25 in the month of the sale 00% in the month or resale 14% to months or the sale 1 are nevoited Requirements 1. Prepare a sales budget for at low month, whowing the trackdown bush and credits 2. Prepare a cash collection for December and dry Round it were up to the art of Requirement 1. Prepare a sales budget for all four months, showing the breakdown between cash and credit sales. Ahmed Reeds Sales Budget For the Four Months Ended January October November December January Cash salos $ 178,800 $ 190,000 $ 211,000 $ 187,600 715,200 760,000 844,000 750,400 Credit sales $ 894,000 $ 950,000 $ 1,055,000 $ 938,000 Total sales Requirement 2. Prepare a cash collection budget for December and January, Round all answers up to the nearest dollar. Ahmed Roods Budgeted Cash Collections from Customers For the Months of December and January December January 2110000 1876000 Cash sales Collection of credit sales: 25% of current month credit sales 60% of prior month credit salos 14% of credit sales two months ago Total collection of credit salos Total cash collections
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b8eec18476_699669b8eebbacde.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b8eecad0e3_700669b8eec4fadc.jpg)
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/07/669b8eed43998_700669b8eecdb2fb.jpg)
60% in the month after the sale
14% two months after the sale
1% are never collected
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started