Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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 11

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Reporting And Analysis

Authors: John Dunn, Margaret Stewart

1st Edition

0470973609, 9780470973608

More Books

Students also viewed these Accounting questions