Question

Here is a forecast of sales by National Bromide for the first 4 months of 2019...

Here is a forecast of sales by National Bromide for the first 4 months of 2019 (figures in thousands of dollars):

Month: 1 2 3 4
Cash sales 30 39 33 29
Sales on credit 175 195 165 145

On average, 60% of credit sales are paid for in the current month, 20% in the next month, and the remainder in the month after that. What are the expected cash collections in months 3 and 4? (Enter your answers in whole dollars not in thousands of dollars.)

Month 3

Month 4

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

Ans Month 3: $ 206

Month 4: $ 188

Month: 1 2 3 4
Cash sales 30 39 33 29
Sales on credit 175 195 165 145
Cash Collection 33 29
Credit Sales collection
60% in current month 99 87
20% of previous month 39 33
20% of month before previous month 35 39
Total Credit Sales Collection in Cash 173 159
Total Cash Sales 206 188
Add a comment
Know the answer?
Add Answer to:
Here is a forecast of sales by National Bromide for the first 4 months of 2019...
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
  • A company has forecast sales in the first 3 months of the year as follows (figures in millions):...

    A company has forecast sales in the first 3 months of the year as follows (figures in millions): January, $60; February, $80; March, $100. 60% of sales are usuallypaid for in the month that they take place and 40% in the following month. Receivables at the end of December were $24 million. What are the forecasted collections onaccounts receivable in March?From: undefinedSource:ISBN: 0077475755 | Title: Principles of Corporate Finance | Publisher: McGraw-Hill Higher Education

  • The months of January, February, March Monachino Corporation has found that 70% of its sales in...

    The months of January, February, March Monachino Corporation has found that 70% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Monachino Corporation has experienced the following collection pattern: November sales for last year were $100,000, while December sales were $115,000. Projected sales for the next three months are as follows: 25% received in the month of the sale 50% received in the month after the sale 18% received...

  • Enterprises was organized on July 1, 2019. Projected Sales for each of the first four months...

    Enterprises was organized on July 1, 2019. Projected Sales for each of the first four months of operations are as follows: July August September October Sales (in dollars) 120,000 160,000 200,000 210,000 The company expects to sell 20% of its merchandise for cash. Of sales on account, 30% are expected to be collected in the month of the sale, 50% in the month following the sale, and the remainder in the second month following the sale. Compute the budgeted amount...

  • E9-28A (similar to) Question Help November sales for last year were $100,000, while December sales were $110,000. P...

    E9-28A (similar to) Question Help November sales for last year were $100,000, while December sales were $110,000. Projected sales for the next three months are as follows: Moraching Corporabon has found at of sales in any given month are credit sales, while the remainder are cash sales of the credit sales, Monachino Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 15% received two months after...

  • Problem 4. (10 Points) Josh 2.0 is attempting to forecast Cash Collections from his new business...

    Problem 4. (10 Points) Josh 2.0 is attempting to forecast Cash Collections from his new business venture. Sales are on Credit and for Cash. Josh expects 50% of all sales to be cash and collected in the month of sale. The other 50 % will be on credit and collected as follows: 60% the month after the sales, 30 % 2 months after the sale, and 10 % 3 months after the sale. Based upon he following projected sales, forecast...

  • Monette Corporation has found that 80% of its sales in any given month are credit sales,...

    Monette Corporation has found that 80% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, Monette Corporation has experienced the following collection pattern: 25% received in the month of the sale 50% received in the month after the sale 22% received two months after the sale 3% of the credit sales are never received November sales for last year were $85,000, while December sales were $115,000. Projected sales for...

  • The following is the sales budget for Coore, Inc., for the first quarter of 2019: January...

    The following is the sales budget for Coore, Inc., for the first quarter of 2019: January $141,000 February $158,000 March $173,000 Sales budget Credit sales are collected as follows: 65 percent in the month of the sale 20 percent in the month after the sale 15 percent in the second month after the sale The accounts receivable balance at the end of the previous quarter was $97,750 ($71,050 of which was uncollected December sales). a. Compute the sales for November....

  • National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as...

    National Scan, Inc., sells radio frequency inventory tags. Monthly sales for a seven-month period were as follows: Month Sales (000)Units Feb. 17 Mar. 20 Apr. 14 May. 22 Jun. 21 Jul. 25 Aug. 29 b. Forecast September sales volume using each of the following: (1) A linear trend equation.(Round your intermediate calculations and final answer to 2 decimal places.)    Yt _ thousands (2) A five-month moving average. (Round your answer to 2 decimal places.)    Moving average _ thousands...

  • 1. Aloan Co. provides the following sales forecast for the next three months: January February March Sales unit...

    1. Aloan Co. provides the following sales forecast for the next three months: January February March Sales units 3,300 4,500 5,300 The company wants to end each month with ending finished goods inventory equal to 10% of the next month’s sales. Finished goods inventory on December 31 is 330 units. The budgeted production units for January are: Multiple Choice 3,300 units. 3,750 units. 33 units. 3,420 units. 3,180 units. 2. Frankie's Chocolate Co. reports the following information from its sales...

  • The following is the sales budget for Shleifer, Inc., for the first quarter of 2019: Sales budget January February Marc...

    The following is the sales budget for Shleifer, Inc., for the first quarter of 2019: Sales budget January February March $208,000 $228,000 $251,000 Credit sales are collected as follows: 55 percent in the month of the sale. 30 percent in the month after the sale. 15 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $92,000 ($62,000 of which were uncollected December sales). a. Calculate the sales for 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