Question

The budgeted sales for Worchester Manufacturing are shown below: May.......................$5,000 June......................$8,000 July........................$6,000 August.................. $4,000 September.............$9,000 From...

The budgeted sales for Worchester Manufacturing are shown below:

May.......................$5,000

June......................$8,000

July........................$6,000

August.................. $4,000

September.............$9,000

From past experience, the company has collected 30% of the cash in the month of the sale, 40% in the month after the sale, and 30% two months after the sale occurred.

Prepare a schedule of expected cash collections from sales, by month and in total for the third quarter of the year.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer sales . of may September may $1500 collections in the month of June July August $2000 $1500 of June. $ 2400 $3200 $ 24

Add a comment
Know the answer?
Add Answer to:
The budgeted sales for Worchester Manufacturing are shown below: May.......................$5,000 June......................$8,000 July........................$6,000 August.................. $4,000 September.............$9,000 From...
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
  • Meredith Company has budgeted sales for the upcoming months as follows: April May June July August September $451,...

    Meredith Company has budgeted sales for the upcoming months as follows: April May June July August September $451,000 $ 468,000 $ 496,000 $518, 000 $504,000 $481,000 30% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 6% in the second month following the sale. a. Compute Meredith Company's cash receipts for June. (Do not round Intermediate calculations.) Cash Receipts...

  • Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a...

    Prepare a schedule of budgeted cash collections from sales for May, June, and July. Include a three-month summary of estimated cash collections. Cash Receipts The sales budget for Andrew Inc. is forecasted as follows: Month Sales Revenue May $ 150,000 June 175,000 July 160,000 August 200,000 To prepare a cash budget, the company must determine the budgeted cash collections from sales. Historically, the following trend has been established regarding cash collection of sales: • 60 percent in the month of...

  • the company’s sales budget for the second quarter given below: April May June Total Budgeted sales...

    the company’s sales budget for the second quarter given below: April May June Total Budgeted sales (all on account) $320,000 $520,000 $180,000 $1,020,000 From past experience, the company has learned that 30% of a month’s sales are collected in the month of sale, another 65% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $250,000, and March sales totaled...

  • ABC Company’s budgeted sales for June, July, and August are 12,400, 16,400, and 14,400 units respectively....

    ABC Company’s budgeted sales for June, July, and August are 12,400, 16,400, and 14,400 units respectively. The selling price for each unit is $15. Based on past experience, ABC expects that 30% of a month’s sales will be collected in the month of sale, 60% in the following month, and 8% in the second month following the sale. Required: Prepare an analysis of cash receipts from sales for ABC Company for August.

  • Required: 1. Prepare a schedule of expected cash collections for July August, and September 2-a. Prepare...

    Required: 1. Prepare a schedule of expected cash collections for July August, and September 2-a. Prepare a merchandise purchases budget for July August, and September. Also compute total merchandise purchases for the quarter ended September 30. 2.b. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September 3. Prepare an income statement that computes net operating income for the quarter ended September 30, 4. Prepare a balance sheet as of September 30, Complete this question...

  • peak sales for Midwest products, a wholesale distributor of leaf rakes, occur in August. the company’s...

    peak sales for Midwest products, a wholesale distributor of leaf rakes, occur in August. the company’s sales budget for the third quarter showing these peak sales is given bel of Marx Chapter 23 Lab Agent X + connectmheducation.com/Mlow/connect.html Maps News !! Outlook 3 Lab Assignment Helps Peak sales for Midwest Products, a wholesale distributor of leaf rakes, occur in August. The company's sales budget for the third quarter showing these peak sales is given below July August September Quarter Budgeted...

  • 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: $ 98,900 105,200 Actual: July August Forecast September October November December 114,200 94,300 121, 3ee 107,400 Based on past experience, it is estimated that 28% of a month's sales are collected in the month of sale, 49% are collected in the month following the sale, and 6% are collected in the second month following the sale. Required: Calculate the estimated...

  • 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...

  • Blackberry Manufacturing budgeted sales on account of $120,000 for July, $211,000 for August, and $198,000 for...

    Blackberry Manufacturing budgeted sales on account of $120,000 for July, $211,000 for August, and $198,000 for September. Experience indicates that none of the sales on account will be collected in the month of the sale, 60% will be collected the month after the sale, 36% in the second month, and 4% will be uncollectible. The cash receipts from accounts receivable that should be budgeted for September would be: Select one: a. $265,200 b. $251,600 c. $272,000 d. $374,000

  • Sales (in dollars) July 240,000 August 280,000 September 200,000 a All sales on account, sales are...

    Sales (in dollars) July 240,000 August 280,000 September 200,000 a All sales on account, sales are expected to be collected in the following pattern: 40% 50% 10% in the month of sale in the month following sale in the second month following sale a May sales is $160,000 and June Sales is $190,000. Prepare schedule of expected cash collections, by month and for the second quarter. then answer the following questions related to this budget. 1- what is the amount...

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