Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Just need A/R balance at the end of quarter 2 please. Paul's supervisor is working on the company's budgeted balance sheet for quarter 2 ,

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Just need A/R balance at the end of quarter 2 please.

Paul'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 Paul. 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, 630 units; May, 760 units; June, 790 units; and July, 870 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 A/R balance on March 31 was $9,200, reflecting the remaining collectible amount from March credit sales. Help Paul prepare the sales forecast for quarter 2 (outlining amounts for each month and for the quarter overall). 40April630May760June2180290 $4$0$4800$5$$40060 $400$0 $1$0 April May June Quarter 9200 $9200 9450 0 9450 18522 0 18522 2835 6142.5 0 11400 0 11400 0 22344 0 22344 7410 10830 0 11850 0 23226 0 Petermine the collectible (or net) A/R balance at the end of quarter 2 . (Round answer to 2 decimal places, e.g. 15.25.) A/R balance at the end of quarter 2 $

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

Financial and Managerial Accounting the basis for business decisions

Authors: Jan Williams, Susan Haka, Mark Bettner, Joseph Carcello

17th edition

007802577X, 978-0078025778

More Books

Students also viewed these Accounting questions