Question

Here is a forecast of sales by XYZ Inc. for the first 4 months of 2018...

Here is a forecast of sales by XYZ Inc. for the first 4 months of 2018 (figures in
thousands of dollars):

Month 1 2 3 4
Cash sales 15 24 18 14
Sales on credit 100 120 90 70

On average, 50% of credit sales are paid for in the current month, 30% in the next
month, and the remainder in the month after that. What are the expected cash
collections in months 3 and 4?

Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

the expected cash collection of 3rd month=18+(90*50%)+(120*30%)+(100*20%)

=119

the expected cash collection of 3th month=19+(70*50%)+(90*30%)+120*20%)

=100

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
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 31 40 34 30 Sales on credit 180 200 170 150 On average, 50% of credit sales are paid for in the current month, 30% 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...
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 35 44 38 34 Sales on credit 200 220 190 170 On average, 50% of credit sales are paid for in the current month, 30% 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...
Here is a forecast of sales by National Bromide for the first 4 months of 2017...
Here is a forecast of sales by National Bromide for the first 4 months of 2017 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 30 39 33 29 Credit sales 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...
Here is a forecast of sales by National Bromide for the first 4 months of 2017...
Here is a forecast of sales by National Bromide for the first 4 months of 2017 (figures in thousands of dollars): Month: 1 2 3 4 Cash sales 29 38 32 28 Credit sales 170 190 160 140 On average, 50% of credit sales are paid for in the current month, 30% 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...
3. DEF Company’s forecasted sales are given below. On average, 50% of credit sales are collected...
3. DEF Company’s forecasted sales are given below. On average, 50% of credit sales are collected in the current quarter, 30% in the next quarter and 20% in the quarter after next. What are the expected total cash collections in quarters 3 and 4? Quarter: 1 2 3   4 ----------------------------------------- Cash Sales    15 24 18 14 Sales on Credit 100 120 90 70
Clopton Inc. forecasts cash sales of $18 million in January, $23 million in February and $25...
Clopton Inc. forecasts cash sales of $18 million in January, $23 million in February and $25 million in March. Credit sales in these three months are forecast at $80 million, $110 million and $145 million. On average 50% of credit sales are paid for in the current month, 30% in the next month, and the remainder in the following month. What is the expected cash inflow in March?
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019...
Information pertaining to Noskey Corporation’s sales revenue follows: November 2018 (Actual) December 2018 (Budgeted) January 2019 (Budgeted) Cash sales $ 120,000 $ 124,000 $ 76,000 Credit sales 288,000 416,000 212,000 Total sales $ 408,000 $ 540,000 $ 288,000 Management estimates 5% of credit sales to be uncollectible. Of collectible credit sales, 60% is collected in the month of sale and the remainder in the month following the month of sale. Purchases of inventory each month include 70% of the next...
Develop a cash budget for the next two months using the information provided below Monthly sales...
Develop a cash budget for the next two months using the information provided below Monthly sales forecast are $210,000 and $30,000 for the next two months The current month's sales were $140,000 80% of sales are collected in the month of sale, with the remainder collected in the following month Cost of goods sold equal 70% of sales The monthly lease payment is $75,000 The cash position at the end of the current month is $70,000 The target cash balance...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 6,000 March $    15,000 February $ 11,000 April $    17,000 Monthly purchases of raw materials accounts for 60 % of sales forecast for the next month. Of total raw material purchases , payments are 60% in cash in the same month and 40% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
Depotissimo " , has predicted the following sales for the first four months of 2015 January...
Depotissimo " , has predicted the following sales for the first four months of 2015 January $ 7,000 March $    15,000 February $    12,000 April $    18,000 Monthly purchases of raw materials accounts for 50 % of sales forecast for the next month. Of total raw material purchases , payments are 50% in cash in the same month and 50% on credit. Of credit purchases 70% is paid in the following month and 30% is paid in two months. Predicted...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT