Question

Scottsdale Co. has actual sales for July and August and forecast sales for September October, November, and December as follo
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Required:

September $89,458
October $88,674
November $87,023

Working:

September October November
Cash collection from July sales $5,934 (98,900*6%) - -
Cash collection from August sales $51,548 (105,200*49%) $6,312 (105,200*6%) -
Cash collection from September sales $31,976 (114,200*28%) $55,958 (114,200*49%) $6,852 (114,200*6%)
Cash collection from October sales - $26,404 (94,300*28%) $46,207 (94,300*49%)
Cash collection from November sales $33,964 (121,300*28%)
Estimated cash receipt $89,458 $88,674 $87,023
Add a comment
Know the answer?
Add Answer to:
Scottsdale Co. has actual sales for July and August and forecast sales for September October, November,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November,...

    Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,300 August 105,300 Forecast: September 114,800 October 94,300 November 122,900 December 106,300 Based on past experience, it is estimated that 29% of a month’s sales are collected in the month of sale, 48% are collected in the month following the sale, and 9% are collected in the second month following the sale. Required: Calculate the estimated cash...

  • Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November,...

    Scottsdale Co. has actual sales for July and August and forecast sales for September, October, November, and December as follows: Actual: July $ 97,100 August 105,100 Forecast: September 114,200 October 94,500 November 121,900 December 107,000 Based on past experience, it is estimated that 24% of a month’s sales are collected in the month of sale, 46% are collected in the month following the sale, and 5% are collected in the second month following the sale. Required: Calculate the estimated cash...

  • The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October...

    The following sales and purchases forecast information pertains to Palermo Corporation: Month July August September October November December Sales $13,000 16,000 18,000 23,000 22,500 28,400 Purchases $6,000 5,700 7,500 8,300 9,200 10,100 Based on past experience cash is typically collected from customers in the following manner: Collected within 10 days of sale so receive a 10% cash discount 25% Collected after 10 days but in the month of sale 10% Collected in the month following the sale 40% Collected in...

  • Osage Inc. has actual sales for May and June and forecast sales for July August September,...

    Osage Inc. has actual sales for May and June and forecast sales for July August September, and October as follows: 5,910 units 6,280 units Actual: May June Forecast: July August September October 5,970 units 6,840 units 5,580 units 5,330 units Required: a. The firm's policy is to have finished goods Inventory on hand at the end of the month that is equal to 75% of the next month's sales. It is currently estimated that there will be 4,478 units on...

  • Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows:...

    Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows: September $50,000 (actual) Fourth Quarter October 40,000 November 35,000 December 60,000 Experience has shown 20 percent of sales are collected in the month of sale, 70 percent are collected in the following month, and 10 percent are never collected. Prepare a cash receipts schedule for Power Ridge Corporation covering the fourth quarter (October through December). Power Ridge Corporation Cash Receipts Schedule September October November...

  • J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: September (actual)...

    J. Lo's Clothiers has forecast credit sales for the fourth quarter of the year: September (actual) $ 53,000 Fourth Quarter October $ 43,000 November 38,000 December 63,000 Experience has shown that 25 percent of sales are collected in the month of sale, 60 percent are collected in the following month, and 15 percent are never collected. Prepare a schedule of cash receipts for J. Lo's Clothiers covering the fourth quarter (October through December). J. Lo's Clothiers September October November December...

  • Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows:...

    Power Ridge Corporation has forecast credit sales for the fourth quarter of the year as follows: September (actual Fourth Quarter October November December $58.000 53,000 78,000 Experience has shown 40 percent of sales are collected in the month of sale, 50 percent are collected in the following month, and percent are never collected. Prepare a cash receipts schedule for Power Ridge Corporation covering the fourth quarter (October through December) Power ridge corporation Cash Receipt Schedule September october Sales Collections of...

  • J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year: September (actual)...

    J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year: September (actual) $59,000 Fourth Quarter October $49,000 November 44,000 December 69,000 Experience has shown that 25 percent of sales are collected in the month of sale, 65 percent are collected in the following month, and 10 percent are never collected. Prepare a schedule of cash receipts for J. Lo’s Clothiers covering the fourth quarter (October through December). Experience has shown that 25 percent of sales are...

  • 3) The following information pertains to Amigo Corporation: Month July August September October November December Sa...

    3) The following information pertains to Amigo Corporation: Month July August September October November December Sales $30,000 34,000 38,000 42,000 48,000 60,000 Purchases $10,000 12,000 14,000 16,000 18,000 20,000 Cash is collected from customers in the following manner: Month of sale 40% Month following sale 40% Two months following sale 20% • 60% of purchases are paid for in cash in the month of purchase, and the other 40% is paid the following month. Required: Complete the cash budget for...

  • Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,000. All sales...

    Wells Company reports the following sales forecast: September, $60,000; October, $75,000; and November, $90,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November. WELLS COMPANY Budgeted Cash Receipts For Month Ended November 30 Cash receipts from November...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT