Question

In: Finance

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 24 33 27 23
Sales on credit 145 165 135 115

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

Expected cash collections

Month 3

Month 4

Solutions

Expert Solution

Please upvote if the ans is helpful. In case of doubt,Do comment.Thanks.


Related Solutions

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 25 34 28 24 Sales on credit 150 170 140 120 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...
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the...
The Frontline Corporation's projected sales for the first 8 months of 2019 are shown in the table below. Jan $        190,000 May $    300,000 Feb            120,000 Jun        270,000 Mar            135,000 Jul        225,000 Apr            240,000 Aug        150,000 Of Frontline's sales, 10% is for cash, 60% is collected in the month following the sales, and 30% is collected in the second month following sales. November and December 2018 sales were $220,000 and $175,000, respectively. Frontline purchases...
(Cash budget) The Sharpe Corporation’s projected sales for the first 8 months of 2019 are shown...
(Cash budget) The Sharpe Corporation’s projected sales for the first 8 months of 2019 are shown in the corresponding table. January $190,000 May $300,000 February   120,000 June   270,000 March   135,000 July   225,000 April   240,000 August   150,000 Of Sharpe’s sales, 10 percent is for cash, another 60 percent is collected in the month following the sales, and 30 percent is collected in the second month following sales. November and December sales for 2018 were $220,000 and $175,000, respectively. Sharpe purchases its...
Bengal Co. provides the following sales forecast for the next three months:
Bengal Co. provides the following sales forecast for the next three months: The company wants to end each month with ending finished goods inventory equal to 25% of the next month sales. Finished goods inventory on June 30 is 1, 250 units. The budgeted production units for August are 6, 950 units. 4, 310 units. 7, 090 units. 5, 565 units. 4,135 units.  
1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) ....
1. Hospitable Co. provides the following sales forecast for the next four months: Sales (units) . . . . . . . . April: 500, May: 580, June: 540, July: 620 The company wants to end each month with ending finished goods inventory equal to 25% of next month’s sales. Finished goods inventory on April 1 is 190 units. Assume July’s budgeted production is 540 units. Prepare a production budget for the months of April, May, and June. 2. Refer...
What is the forecast and MSE using regression? 2019 is the holdout sample and "car sales"...
What is the forecast and MSE using regression? 2019 is the holdout sample and "car sales" is the independent variable. Shipments Car Sales Fasteners Jan-17 17680000 335798 Feb-17 17650000 297853 Mar-17 17130000 318399 Apr-17 17230000 311730 May-17 17200000 363876 Jun-17 17200000 296832 Jul-17 17180000 297513 Aug-17 17020000 321144 Sep-17 18380000 317677 Oct-17 18200000 325487 Nov-17 17860000 272937 Dec-17 17700000 276282 Jan-18 17550000 335439 Feb-18 17560000 310514 Mar-18 17690000 407754 Apr-18 17770000 356169 May-18 17780000 345322 Jun-18 17700000 331997 Jul-18 17380000...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 30% of next month's forecasted sales. Finished goods inventory on April 1 is 207 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Ramos Co. provides the following sales forecast and production budget for the next four months. April...
Ramos Co. provides the following sales forecast and production budget for the next four months. April May June July Sales (units) 530 610 560 630 Budgeted production (units) 470 600 570 570 The company plans for finished goods inventory of 150 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month’s production needs. Beginning direct...
Ruiz Co. provides the following sales forecast for the next four months:     April May June...
Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 690 770 720 810 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 276 units. Assume July's budgeted production is 720 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each month with...
Required information Ruiz Co. provides the following sales forecast for the next four months:     April...
Required information Ruiz Co. provides the following sales forecast for the next four months:     April May June July Sales (units) 660 740 690 780 The company wants to end each month with ending finished goods inventory equal to 40% of next month's forecasted sales. Finished goods inventory on April 1 is 264 units. Assume July's budgeted production is 690 units. In addition, each finished unit requires five pounds (lbs.) of raw materials and the company wants to end each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT