Homework Help is Here – Start Your Trial Now!
Business
Accounting
j. 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 ne 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 information 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. • 50% of each month's sales are credit card/debit card sales, subject to a 2% merchant fee. All appropriate receipts are deposited in 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, 65% pay in full the month following the sale, and 5% of trade 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. d. How will Tanner's work on the above components assist his supervisor with the budgeted balance sheet for the same period?

j. 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 ne 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 information 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. • 50% of each month's sales are credit card/debit card sales, subject to a 2% merchant fee. All appropriate receipts are deposited in 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, 65% pay in full the month following the sale, and 5% of trade 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. d. How will Tanner's work on the above components assist his supervisor with the budgeted balance sheet for the same period?

Managerial Accounting
Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter10: Evaluating Decentralized Operations
Section: Chapter Questions
Problem 1CMA
See similar textbooks
icon
Related questions
icon
Concept explainers
Question
Do not use chatgpt. Thanks!
5. 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 ne 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 information 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. • 50% of each month's sales are credit card/debit card sales, subject to a 2% merchant fee. All appropriate receipts are deposited in 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, 65% pay in full the month following the sale, and 5% of trade 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. d. How will Tanner's work on the above components assist his supervisor with the budgeted balance sheet for the same period?
Transcribed Image Text:5. 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 ne 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 information 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. • 50% of each month's sales are credit card/debit card sales, subject to a 2% merchant fee. All appropriate receipts are deposited in 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, 65% pay in full the month following the sale, and 5% of trade 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. d. How will Tanner's work on the above components assist his supervisor with the budgeted balance sheet for the same period?
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
SEE MORE TEXTBOOKS