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?

Solutions

Expert Solution

The equation for finding out the number of units to be produced is as follow:

Budgeted units sales + planned ending inventory - beginning inventory = units to be produced.

In the above question,

Beginning inventory on January = 46,200 units.

Budgeted units sales in January = 154,000 units.

Ending inventory for January is equal to the 30% of February months budgeted unit sales.

Budgeted unit sales of February = 150,000

30 % of units in February. = 45,000 units.

The ending inventory on January = 45,000 units

Now, the number of units to be produced on January will be,

Units to be produced = 154,000 + 45,000 - 46,200

Units to be produced = 152,800 units.

So the company need to produce 152,800 units in the month of January.

Hence, answer is 152,800 units.

SUMMARY :

Budgeted units sales of January = 154,000 units.

Ending inventory = 45,000 units.

So the company need a total production of 199,000 units ( 154,000 + 45,000) in January. But we have 46,200 units as beginning inventory. So units to be produced in January is 152,800 units respectively ( 199,000 - 46,200).

Hence, 152,800 units is the correct answer.

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000...

Garver Industries has budgeted the following unit sales: 2020 Units January 10,000 February 8,000 March 9,000 April 11,000 May 15,000 The finished goods units on hand on December 31, 2019, was 2,000 units. Each unit requires 3 pounds of raw materials that are estimated to cost an average of $4 per pound. It is the company's policy to maintain a finished goods inventory at the end of each month equal to 20% of next month's anticipated sales. They also have...

The following are budgeted data: January February March Sales in units 16,600 23,200 19,600 Production...

The following are budgeted data: January February March Sales in units 16,600 23,200 19,600 Production in units 19,600 20,600 19,300 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 25% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Garrison 16e Rechecks 2017-10-03 Multiple Choice 20,925 pounds 20,575 pounds 20,275 pounds 18,325 pounds , Depasquale Corporation is...

The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in...

The following are budgeted data: January February March Sales in units 15,500 21,000 18,500 Production in units 18,500 19,500 17,400 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 19,970 pounds 18,630 pounds 18,870 pounds 20,130 pounds

The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in...

The following are budgeted data: January February March Sales in units 15,200 20,400 18,200 Production in units 18,200 19,200 17,100 One pound of material is required for each finished unit. The inventory of materials at the end of each month should equal 30% of the following month's production needs. Purchases of raw materials for February would be budgeted to be: Multiple Choice 18,630 pounds 19,830 pounds 19,670 pounds 18,570 pounds

Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900,...

Sill Corporation makes one product. Budgeted unit sales for January, February, March, and April are 9,900, 11,400, 11,900, and 13,400 units, respectively. The ending finished goods inventory equals 20% of the following month's sales. The ending raw materials inventory equals 40% of the following month’s raw materials production needs. Each unit of finished goods requires 5 pounds of raw materials. If 61,000 pounds of raw materials are required for production in March, then the budgeted raw material purchases for February...

The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000...

The following credit sales are budgeted by Roswell Company: $30,000 in January,$50,000 in February and $70,000 in March. The company's past experience indicates that 70% of the credit sales are collected in the month of sale and 30% in the month following the sale. The anticipated cash inflow for the month of March is Select one: a. $58,800 b. $44,000 c. $70,000 d. $64,000

The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The...

The following credit sales are budgeted by Blossom Company. January 200600 February 295000 March 413000 The company’s past experience indicates that 60% of the accounts receivable are collected in the month of sale, 40% in the month following the sale. The anticipated cash inflow for the month of March is $247800. $365800. $413000. $401200.

Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted...

Radcliff Ltd. has budgeted the following sales for the next three months: January February March Budgeted Sales $80,000 $100,000 $140,000 Ninety percent of sales are on account and ten percent of sales are cash sales. A month's sales on account are collected as follows: Month of sale 50% First month following sale 40% Second month following sale 9% Uncollectible 1% The company requires a minimum cash balance of $7,000 to start a month. The beginning cash balance in March is...

Funnel Manufacturing Company has provided the follwoing information: Month Budgeted Sales January $ 76,000 February 85,000...

Funnel Manufacturing Company has provided the follwoing information: Month Budgeted Sales January $ 76,000 February 85,000 March 92,000 April 79,000 Budgeted Selling and Administrative Expenses Per Month are as follows: Wages, $15,000 Advertising, $12,000 Depreciation, $3,000 Other, 4 percent of Sales Cost of Goods Sold is 60% of Sales. All inventory is purchased in the month it is sold. Inventory purchases are paid 2/3 in the month of purchase, the remaining 1/3 paid in the following month. The budgeted net...

ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units...

ABC Company has budgeted sales for the next six months as follows: Budgeted Sales in Units March 12,000 units April 24,000 units May 35,000 units June 13,000 units July 43,000 units August 69,000 units ABC Company sells its inventory to customers for $25 per unit. 30% of the company's sales are cash sales and the other 70% of sales are made on account. The sales on account are collected in the pattern: 35% collected in the month of sale 26%...

Subjects