Question

In: Accounting

Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...

Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows.

Month

Units

April 2,590
May 2,450
June 2,360


The target ending inventory of finished products is as follows.

March 31 2,030
April 30 2,240
May 31 2,170
June 30 2,330


2 units of material are required for each unit of finished product. Production for July is estimated at 2,620 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory of raw materials at the end of each month equal to 40% of the following month’s production requirements.

Raw materials are expected to cost $6 per unit throughout the period.

Calculate the May raw materials purchases in dollars.

Raw material purchases cost

$

Solutions

Expert Solution

Production budget

April

May

June

Units to be sold

2590

2450

2360

Desired Ending Finished Inventoey

2240

2170

2330

Required Units of Available Production

4830

4620

4690

Less : Beginning Finished Inventory

2030

2240

2170

Budgeted Production

2800

2380

2520

For April may and June

April

May

June

Budgeted Production (unis)

2800

2380

2520

Raw material required per unit (Lbs)

2

2

2

Raw material needed for Production (lbs)

5600

4760

5040

Budgeted Ending Inventory (lbs)

1904

2016

2096

Total material requirements (lbs)

7504

6776

7136

Beginning Inventory (Lbs)

1904

2016

material to be Purchased (lbs)

7504

4872

5120

Cost per lb.

6

6

6

Total budgeted direct material cost

$           45,024.00

$           29,232.00

$            30,720.00

Raw material purchases cost

$ 29,232


Related Solutions

Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,530 May 2,420 June 2,310 The target ending inventory of finished products is as follows. March 31 2,050 April 30 2,300 May 31 2,100 June 30 2,300 2 units of material are required for each unit of finished product. Production for July is estimated at 2,710 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,600 May 2,420 June 2,320 The target ending inventory of finished products is as follows. March 31 2,010 April 30 2,270 May 31 2,100 June 30 2,360 2 units of material are required for each unit of finished product. Production for July is estimated at 2,670 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,600 May 2,500 June 2,380 The target ending inventory of finished products is as follows. March 31 2,030 April 30 2,290 May 31 2,140 June 30 2,380 2 units of material are required for each unit of finished product. Production for July is estimated at 2,780 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,560 May 2,420 June 2,340 The target ending inventory of finished products is as follows. March 31 2,040 April 30 2,200 May 31 2,200 June 30 2,300 2 units of material are required for each unit of finished product. Production for July is estimated at 2,800 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,520 May 2,440 June 2,390 The target ending inventory of finished products is as follows. March 31 2,010 April 30 2,280 May 31 2,170 June 30 2,330 2 units of material are required for each unit of finished product. Production for July is estimated at 2,750 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Aztec, Inc. had sales as follows during 2017: Quarter 1 7,000 units Quarter 2 8,000 units...
Aztec, Inc. had sales as follows during 2017: Quarter 1 7,000 units Quarter 2 8,000 units Quarter 3 9,000 units Quarter 4 8,000 units Aztec expects sales in each quarter of 2018 to be 10% more than the respective quarters for 2017. If each unit sells for $100, what amounts will appear as sales revenue in the quarterly sales budgets for 2018? $770,000; $880,000; $990,000; $880,000 $630,000; $720,000; $810,000; $720,000
Q1.ABC Company has projected sales and production in units for the second quarter of 2017 as...
Q1.ABC Company has projected sales and production in units for the second quarter of 2017 as follows Particular April May June sales 35,000 25,000 30,000 Production 30,000 25,000 40,000 Cash production costs are budgeted at SR 7 per unit produced. Of these production costs, 30% are paid in the month in which they are incurred and the balance in the following month. Selling and administrative expenses (all paid in cash) amount to SR 70,000 per month. The accounts payable balance...
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.
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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT