Sales Forecasts for the first quarter of 2018: January 11 000 units February 13 000 units...

Sales Forecasts for the first quarter of 2018: January 11 000 units February 13 000 units March 14 000 units. Unit selling price $100 Prepare the Sales Budget for Jan, Feb, and March. In addition to the info in problem #1, the company requires jan 20% of next month's budgeted sales as ending finished goods feb inventory each month. Ending inventory for 12/31/17 was mar 2,200 units. The Sales forecast for April is 20,000 units.

Expert Solution

sales budget

	JAN	FEB	MAR	Total
Bugeted sales units	11000	13000	14000	38000
Selling price per unit	100	100	100	100
Budgeted sales	1,100,000	1,300,000	1,400,000	3,800,000

ekkarill92 answered 2 years ago

Milton Inc. has prepared the following first quarter sales forecast: January 370 000 units February 485...

Milton Inc. has prepared the following first quarter sales forecast: January 370 000 units February 485 000 units March 545 000 units Each unit sells for $4.50. The sales budget for the first quarter is: $940 000 $4 900 000 $1 400 000 $6 300 000

The following is the sales budget for Profit, Inc., for the first quarter of 2018: January...

The following is the sales budget for Profit, Inc., for the first quarter of 2018: January February March Sales budget $ 213,000 $ 233,000 $ 256,000 Credit sales are collected as follows: 60 percent in the month of the sale 25 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,000 ($67,000 of which was uncollected December sales). a. Calculate the...

Heely Co. has the following projected sales in units for the first quarter of 20x2: January...

Heely Co. has the following projected sales in units for the first quarter of 20x2: January 10373 February 17195 March 12071 Heely Co.’s budget is based on the following assumptions: 36% of all purchases of merchandise are paid in the month purchased and the remainder in the following month. The number of units in each month’s ending inventory is equal to 60% of the next month’s units of sales. The cost of each unit of inventory is $15. What is...

National Beverage Company anticipates the following first-quarter sales for 2015: $1,874,000(January), $1,592,000(February), and $2,142,000 (March). It...

National Beverage Company anticipates the following first-quarter sales for 2015: $1,874,000(January), $1,592,000(February), and $2,142,000 (March). It posted the following sales figures for the last quarter of 2014: $1,928,000(October), $2,052,000(November), and $2,192,000(December). The company sells 45% of its products on credit; 55% are cash sales. The company collects credit sales as follows: 31% in the following month, 51% two months later, and 17% three months later, with 1% defaults. What are the anticipated cash inflows for the first quarter of 2015?...

Bonita Industries estimates its sales at 170000 units in the first quarter and that sales will...

Bonita Industries estimates its sales at 170000 units in the first quarter and that sales will increase by 13000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at $5625200. $7820400. $3896900. $6778100.

Marigold Corp. estimates its sales at 250000 units in the first quarter and that sales will...

Marigold Corp. estimates its sales at 250000 units in the first quarter and that sales will increase by 25000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at $8610000. $5932500. $10342500. $11970000.

Concord Corporationestimates its sales at 230000 units in the first quarter and that sales will increase...

Concord Corporationestimates its sales at 230000 units in the first quarter and that sales will increase by 23000 units each quarter over the year. They have, and desire, a 25% ending inventory of finished goods. Each unit sells for $25. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Production in units for the third quarter should be budgeted at 276000. 281750. 350750. 264500.

Royal Manufacturing estimates its sales at 100,000 units in the first quarter and that sales will...

Royal Manufacturing estimates its sales at 100,000 units in the first quarter and that sales will increase by 10,000 units each quarter over the year. Company policy requires a 25% ending inventory of finished goods. Each unit sells for $35. 40% of the sales are for cash. 70% of the credit customers pay within the quarter. The remainder is received in the quarter following sale. Cash collections for the third quarter are budgeted at?

A company budgeted unit sales of 154000 units for January, 2017 and 150000 units for February...

A company budgeted unit sales of 154000 units for January, 2017 and 150000 units for February 2017. The company has a policy of having an inventory of units on hand at the end of each month equal to 30% of next month's budgeted unit sales. If there were 46200 units of inventory on hand on December 31, 2016, how many units should be produced in January, 2017 in order for the company to meet its goals?

Barrington Bears has developed the following sales forecasts for the next few months. January 500, February...

Barrington Bears has developed the following sales forecasts for the next few months. January 500, February 600, March 720, April 800 and May 770. BB has 80 bears on hand on Dec. 31. Normal ending inventory policy is to hold 20% of next month’s sales. Each bear needs .8 yards of fabric and two pounds of stuffing. Fabric is budgeted to cost $15 per yard and stuffing $4 per pound. Direct labor is paid $18 per hour. Each bear takes...

Question