Answered step by step
Verified Expert Solution
Question
1 Approved Answer
can yoy please explain how to solve 3 and 4 amonut in Q1 in part b AP-11A LOS Buildup Sports Inc. is a retailer of
can yoy please explain how to solve 3 and 4 amonut in Q1 in part b
AP-11A LOS Buildup Sports Inc. is a retailer of shoes and sports gear. The following is Buildup Sports' sales forecast by quarter for the upcoming year. Buildup Sports Inc. Forecasted Sales For the Year Ended December 31, 2020 Q1 Q2 Q3 Q4 Period End Sales $107,000 $289,000 $361,000 $236,000 $993,000 In addition, sales in Q3 and 4 of 2019 totaled $128,000 and $209,000, respectively. According to the company's sales records, 63% of sales are made in cash and the remaining 37% are made on account (i.e. credit sales). Assume the following historical trends were noted by management regarding credit sales: 47% of credit customers pay during the quarter in which the sale took place 28% of credit customers pay in the quarter immediately following the quarter of sale 20% of credit customers pay in the second quarter following the quarter of sale The remaining 5% of credit sales are uncollectible Master Budget Chapter 7 Required a) Calculate the forecasted sales for each quarter (separate revenue into cash and credit sales). Buildup Sports Inc. Forecasted Sales For the Year Ended December 31, 2020 Q1 Q2 Q3 Q4 $107,000 $289,000 $361,000 $236,000 $67,410 $182,070 $227,430 $148,680 $39,590 $106,930 $133,570 $87,320 Sales Cash Sales Credit Sales Period End $993,000 $625,590 $367,410 b) Prepare the cash receipts section of the 2020 cash budget (on a quarterly basis) Period End $625,590 Buildup Sports Inc. Cash Receipts Lor the Year Ended December 31, 2020 Receipts: Q1 Q2 Q3 Q4 Cash Sales $67,410 5182,070 $227,430 $148,680 Current Credit Collections $18,607 $50,257 $62.778 541.040 Previous Quarter Credit Collection $21,652 $11,085 $29,940 $37,400 Two Previous Quarters Credit Collections $9,472 $15,466 $7,918 $21.386 Total Cash Receipts $117,141 $258.878 $328,066 $248,506 $172,682 $100,077 'S54,242 $952,591 11Step 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