Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tanner's supervisor is working on the company's budgeted balance sheet for quarter 2, and she delegates budgeting for the ending A/R balance to Tanner.

  

. • Sales volume is expected as follows: April, 625 units, May, 800 units, June, 750 units; and July, 840 units. Average sell 

 


 

Tanner's supervisor is working on the company's budgeted balance sheet for quarter 2, and she delegates budgeting for the ending A/R balance to Tanner. He gets right to work, realizing that he can't determine the June 30 A/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 infor- mation from the sales department, as follows. Sales volume is expected as follows: April, 625 units; May, 800 units; June, 750 units; and July, 840 units. Average selling price is expected to be $65 per unit. Historically, 25% of each month's sales are cash sales; #remmiming mierare on eredit. 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 credit sales. 30% of credit customers pay their balance in the month of the sale and 65% pay in full the month following the sale. 5% of credit sales go uncollected. The A/R balance on March 31 was $10,000, reflecting the remaining collectible amount from March credit sales. Required a. Help Tanner prepare the sales forecast for quarter 2 (outlining amounts for each month and for the quarter overall). b. Prepare the quarter 2 schedule of cash receipts (outlining amounts for each month and for the quarter overall). c. Determine the collectible (or net) A/R balance at the end of quarter 2.

Step by Step Solution

3.53 Rating (163 Votes )

There are 3 Steps involved in it

Step: 1

a Sales Budget Particulars April May June Quarter Budgeted unit sal... 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

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Management Science

Authors: Cliff T. Ragsdale

5th Edition

324656645, 324656637, 9780324656640, 978-0324656633

More Books

Students also viewed these Finance questions

Question

please don't answer the question, the question will be deleted.

Answered: 1 week ago