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,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 of raw materials at the end of each month equal to 50% of the following month’s production requirements.

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

Calculate the May raw materials purchases in dollars.

Raw material purchases cost $

Solutions

Expert Solution

Production Budget
May June
Unit Sales 2500 2380
Add:Desired ending inventory 2140 2380
Total needed 4640 4760
Less:Desired bveginning inventory -2290 -2140
Units to be produced 2350 2620
Material Purchase Budget
May
Budgeted Production(in units)                              2,350
Materials requirement per unit                                2.00
Materials needed for production                              4,700
Add:Budgeted ending inventory(2620*50%)                              1,310
Total materials requirement                              6,010
Less:Budgeted beginning inventory(2350*50%)                             (1,175)
Materials to be purchased                              4,835
Cost per unit $                            5.00
Cost of Raw materials purhcased $                        24,175

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