Question

Corporation has found that ​% of its sales in any given month are credit​ sales, while the remainder are cash sales. Of the credit​ sales, Corporation has experienced the following collection​ pattern: 20% received in the month of the sale 40% received in the month after the sale 24% received two months after the sale 16% of the credit sales are never received November sales for last year were ​, while December sales were . Projected sales for the next three months are as​ follows: January sales. . . . . . . . . . . . . . . . $150,000 February sales. . . . . . . . . . . . . . . $130,000 March sales. . . . . . . . . . . . . . . . . $175,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.) Sweeney Corporation Cash Collections Budget For the Months of January through March January Cash sales Collections on credit sales: 20% Month of sale 40% Month after 24% Two months after Total cash collections Enter any number in the edit fields and then click Check An

Answer 1

Answer:

Some information is missing, specifically the % of credit sales. Similar questions use 80%, so I will use that %. Also, November sales were $85,000 and December sales were $115,000.

                              Cash collections budget

                                                January              February             March

Cash sales                               $30,000            $26,000              $35,000

Collection from Nov. sales      $16,320

Collection from Dec. sales     $36,800             $22,080

Collection from Jan. sales      $24,000            $48,000              $28,800

Collection from Feb. sales                                $20,800               $41,600

Collection from March sales                                                          $28,000

Total cash collections            $107,120             $116,880             $133,400