Answered step by step
Verified Expert Solution
Question
1 Approved Answer
part b please Help Gary prepare the sales forecast for quarter 2 (outlining amounts for each month and for the quarter overall). Gary's supervisor is
part b please
Help Gary prepare the sales forecast for quarter 2 (outlining amounts for each month and for the quarter overall). Gary's supervisor is working on the company's budgeted balance sheet for quarter 2, and he delegates budgeting for the ending A/R balance to Gary. He gets right to work, realizing that he can't determine the June 30A/R balance without a schedule of cash receipts. and all of that hinges on the sales forecast. He gathers information about the company's collection policies and trends, along with relevant information from the sales department, as follows. - Sales volume is expected as follows: April, 590 units; May, 735 units; June, 700 units; and July, 775 units. - Average selling price is expected to be $60 per unit. - Historically, 25% of each month's sales are cash sales; all remaining sales are on credit. - 50% of each month's sales are credit card/debit card sales, subject to a 2% merchant fee. All appropriate receipts will be deposited into the company's account in the month of sale. - 25% of each month's sales are trade credit sales, 30% of trade credit customers pay their balance in the month of the sale, and 65% pay in full the month following the sale. 5% of trade credit sales go uncollected. - The AVR balance on March 31 was $9,600, reflecting the remaining collectible amount from March credit sales. eTextbook and Media Swefor Later Attempts: unlimited Submit Answer Prepare the quarter 2 schedule of cash receipts (outlining amounts for each month and for the quarter overali). (Round onswers to 2 decimal places, es. 15.25.) 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