Question

In: Finance

Gillman Co. is forecasting sales of 61,400 units of product for August. To make one unit...

Gillman Co. is forecasting sales of 61,400 units of product for August. To make one unit of finished product, 4 pounds of raw materials are required. Actual beginning and desired ending inventories of raw materials and finished goods are:

  

August 1
(Actual)
August 31
(Desired)
  Raw materials (pounds) 74,100 68,100
  Finished goods (units) 5,100 8,420
Required:
a. Calculate the number of units of product to be produced during August.
b. Calculate the number of pounds of raw materials to be purchased during August.

Solutions

Expert Solution

a.      64,720 Units
Working:
Units
Sales        61,400
Add Desired ending inventory           8,420
Total units to be available for sale        69,820
Less beginning inventory           5,100
Total units to be produced        64,720
b. Raw Materials to be purchased     2,52,880 Pounds
Working:
Total units to be produced            64,720
Raw materials required to produce 1 unit 4 pounds
Total raw materials required for production        2,58,880 Pounds
(64720*4)
Add: Desired ending inventory of raw materials            68,100 Pounds
Less: Beginning Inventory of raw materials            74,100 Pounds
Raw Materials to be purchased        2,52,880 Pounds

Related Solutions

Jannusch Corporation makes one product. Budgeted unit sales for July, August, September, and October are 10,000,...
Jannusch Corporation makes one product. Budgeted unit sales for July, August, September, and October are 10,000, 11,600, 13,300, and 12,700 units, respectively. The ending finished goods inventory should equal 20% of the following month's sales. The budgeted required production for August is closest to: A) 11,600 units B) 11,940 units C) 14,260 units D) 16,580 units
Ring The Bells Co. makes one product. Budgeted unit sales for 1st Quarter, 2nd Quarter, 3rd...
Ring The Bells Co. makes one product. Budgeted unit sales for 1st Quarter, 2nd Quarter, 3rd Quarter, and 4th Quarter are 580,000; 560,000; 575,000; and 590,000 units, respectively. The ending finished goods inventory should equal 5% of the following month's sales. The budgeted required production for 3rd Quarter is: a. 575,000 units b. 575,750 units c. 574,250 units d. 560,750 units e. 560,000 units
Assume that Product Z is made up of one unit of A and five units of...
Assume that Product Z is made up of one unit of A and five units of B. A is made of three units of C and four units of D. D is made of two units of E. The demand for Z is 500 units in Week 8 and 500 units in Week 10. For Z, A, C, and D, there are no units on hand, no safety stock, and no units allocated. Item E has 900 units on hand,...
Arnold Co. budgeted to sell 11,500 units of Gizmo in September. Production of one unit of...
Arnold Co. budgeted to sell 11,500 units of Gizmo in September. Production of one unit of Gizmo requires two (2) pounds of aluminum and four (4) pounds of steel powder. The beginning inventory and the desired ending inventory are as follows: Beginning Inventory Desired Ending Inventory Gizmo 2,400 units 3,300 units Aluminum 1,500 pounds 1,700 pounds Steel powder 1,300 pounds 1,000 pounds    a) Production budget: How many units of Gizmo should Arnold plan to make in September? b) Direct...
Consider the bill of material for Product "J": To make one unit of "J", it needs...
Consider the bill of material for Product "J": To make one unit of "J", it needs one unit of "K" and two units of "M". To make one unit of K, it requires 4 units (Corrected) of "L" . The gross requirements for J are 200 units in week 6 and 250 units in week 8.   Use the data given in the following table, develop the MRP tables for each item for an 8-week planning period. Use the lot-for-lot lot-sizing rule....
Mcmurtry Corporation sells a product for $120 per unit. The product's current sales are 12,300 units...
Mcmurtry Corporation sells a product for $120 per unit. The product's current sales are 12,300 units and its break-even sales are 10,824 units. The margin of safety as a percentage of sales is closest to: Multiple Choice 12% 14% 88% 86%
Majid Corporation sells a product for $145 per unit. The product's current sales are 41,300 units...
Majid Corporation sells a product for $145 per unit. The product's current sales are 41,300 units and its break-even sales are 32,625 units. What is the margin of safety in dollars? Multiple Choice $3,736,965 $5,988,500 $4,730,625 $1,257,875 Mcdale Inc. produces and sells two products. Data concerning those products for the most recent month appear below: Product I49V Product Z50U Sales $ 32,000 $ 37,000 Variable expenses $ 12,000 $ 27,330 The fixed expenses of the entire company were $39,140. The...
The budgeted sales in units for the next four months as follows: July 7,200 units August...
The budgeted sales in units for the next four months as follows: July 7,200 units August 5,400 units September 6,800 units October 7,000 units 1. Prepare the sales budget for the third quarter of the company knowing that each unit is sold for $40. (1.5pt) 2. Past experience has shown that the ending inventory for each month should be equal to 10% of the next month's sales in units. The inventory in the beginning of July was only 600 units....
1. Harwinton, Inc. anticipates sales of 48,000 units, 46,000 units, and 49,000 units in July, August,...
1. Harwinton, Inc. anticipates sales of 48,000 units, 46,000 units, and 49,000 units in July, August, and September, respectively. Company policy is to maintain an ending finished-goods inventory equal to 40% of the following month's sales. On the basis of this information, how many units would the company plan to produce in July? Multiple Choice 48,800. 47,200. 46,000. 46,800. 2..   Oxford Industries has the following sales forecasts for its snowshoes next year: First Quarter 25,000 pairs Second Quarter 5 %...
One unit of A is made of three units of B, one unit of C, and...
One unit of A is made of three units of B, one unit of C, and two units of D. B is composed of two units of E and one unit of D. C is made of one unit of B and two units of E. E is made of one unit of F. Items B, C, E, and F have one-week lead times; A and D have lead times of two weeks. Assume that lot-for-lot (L4L) lot sizing is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT