# Inventory Management

Satisfactory Essays
270 Words
Grammar
Plagiarism
Writing
Score
Inventory Management
Inventory Management help
This problem entails knowing Inventory Control Subject to known demand. Based out of the book Production and Operations Analysis-5th edition ISBN 0072865385 which is almost Identical to 4th ed.
A local machine shop buys hex nuts and molly screws from the same supplier. The hex nuts cost 15 cents each and the molly screws cost 38 cents each. A setup cost of \$100.00 is assumed for all orders. This includes the cost of tracking and receiving the orders. Holding costs are based on a 25% annual interest rate. The shop uses an average of 20,000 hex nuts and 14,000molly screws annually.
I need help to:
A- Determine the optimal size of the orders of hex nuts and molly screws, and the optimal time between placement of orders of these two items.
B--If both items are ordered and received simultaneously, the setup cost of \$100.00 applies to the combined order. Compare the average annual cost of holding and setup if these items are ordered separately; if they are both ordered when the hex nuts would normally be ordered; and if they are both ordered when the molly screws would be normally ordered.
Solution contains calculations of :
1. EOQ
2.Carrying cost.
3. Ordering cost.
4. the optimal time between placement of orders .
...Annual usage/EOQ = 15,000/5620 = 2.669 or 3 orders
Ordering cost = number of orders*per order cost = 2.669*\$100 = \$266.9
(Note that inventory and ordering costs are same confirming optimality of the EOQ)
Annual cost = \$266.95 + \$266.9 =

## You May Also Find These Documents Helpful

• Powerful Essays

Alternative 2 has the lowest total per a procedure cost. Operating costs of Alternative 1 is \$86.15, which is lower than Alternative 2 of \$92.15Alternative 2 is higher in operation al cost because there is six dollars in extra costs assessed with travel and set up costs. When the other costs, which include capital and maintance, are incorporated, Alternative 2 becomes the lower cost with an annual cost of\$ 251,160 and Alternative 1 is \$ 268,260. Alternative 2 has the total lower cost because there are more capital costs in Alternative 1, as there is an initial purchase of 3 machines instead of 1 machine.…

• 1246 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

If direct materials are \$8.00 per unit, direct labor is \$4.00 per unit, variable manufacturing overhead is \$6.00 per unit, and fixed costs are \$12,000 for the units produced, then what would be the cost assigned to 2,000 of units in ending inventory?…

• 309 Words
• 2 Pages
Satisfactory Essays
• Powerful Essays

Case Study Related to Advising Action Steps for Better Inventory Management A leading consumer products company dealing in cosmetics and other personal care products was seeking ways to:…

• 1048 Words
• 5 Pages
Powerful Essays
• Satisfactory Essays

Duggan company applies manufacturing overhead to jobs on the basis of machine hours used. Overhead costs are expected to total \$341,010 for the year, and machine usage is estimated at 126,300 hours.For the year, \$363, 036 of overhead costs are incurred and 132,600 hours are use. Please compute the manufacturing overhead rate for the year.…

• 391 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

requested 92 engineering tests? The total charged to an in-house manufacturing department would be \$1,046,800. This dollar amount is determined by multiplying the overhead rates of each activity to the amount consumed for that activity and added together for a total. (1,800*70= 126,000), (280*940=263,200) (10*40,000=400,000), (2,800*92=257,600)…

• 389 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

e. What would the cost per order (the ordering cost) need to be in order for a 500 gallon order to have annual holding and ordering costs of \$900.00?…

• 517 Words
• 1 Page
Satisfactory Essays
• Good Essays

Suppose that the annual EOQ cost (setup plus inventory holding) for a product stored in a warehouse is \$42,000. What would the total company EOQ cost be if the firm decided to equally allocate the demand among 25 warehouses instead of one?…

• 5984 Words
• 33 Pages
Good Essays
• Satisfactory Essays

Use this information to answer the following questions. A bakery buys sugar in 15-pound bags. The bakery uses 5000 bags of sugar each year. Carrying costs are \$20 per bag per year. Ordering costs are estimated at \$5 per order. Assume that the bakery is open 250 days a year and its daily demand is estimated at 20 bags. It takes 5 days for each order of sugar to be filled.…

• 1687 Words
• 12 Pages
Satisfactory Essays
• Satisfactory Essays

| | | | | | | | | | Economic Order Quantity = | √2 x current use x order cost / carry cost per unit per year =…

• 884 Words
• 4 Pages
Satisfactory Essays
• Satisfactory Essays

6. Calculate the variable costs per order received at a trade show and the variable costs per order received through a sales rep?…

• 459 Words
• 2 Pages
Satisfactory Essays
• Good Essays

Using the spreadsheet, we found Q* = NORM.INV(.8,500,100) = 584.16. The simulation and newsvendor model give the same optimal stocking quantity.…

• 632 Words
• 3 Pages
Good Essays
• Satisfactory Essays

7000 70000 53285 16715 23500 20325 3175 19890 -12890 Assumption 1. tooling and machining department are dedicated to the production of attaching machines, therefore we deduct these cost from total general overhead cost 2. 93% (= 96/103) sales generated from sale of fasterner, we apply this percentage to estimate the machine overhead, administration , marketing, shipping and commisiion cost 3. the machine overhead on attaching machine is 315 (= 4500 x 0.07) 4. Two-third of current R&D projects was related to fastener production. 5810 x 2/3 = 3873 6. sale of attching machine 7000 (=103,000 - 96,000) 7. since we have already known the general overhead on fastener, we can calculate the cost of sales, general and administration on attaching machine 70000-53285. The same calcuation method applied on calculating the cost of sales, general and administration on attaching machine…

• 251 Words
• 2 Pages
Satisfactory Essays
• Satisfactory Essays

������ Maximum demand for each product is 20% above the estimated sales levels. ������ Total fixed production overhead cost is \$1,470,000. This is absorbed by products A and B at an average rate per hour based on the estimated production levels.…

• 753 Words
• 4 Pages
Satisfactory Essays
• Good Essays

1) The optimal total production quantity per cycle and the corresponding maximal on-hand stock level.…

• 470 Words
• 2 Pages
Good Essays
• Good Essays

Present Production activities Roasting Administration activities Purchasing invoice Research & Marketing Procurement activities Equipment Depreciation in equipment Delivery 70,000 Depreciation in vehicle Procurement activities Other overhead 70,000 70,000 Number of kits 27,777 \$ 2.52 per kit 10,000 90,000 80,000 10,000 60,000 Number of kits Number of kits Number of deliveries Number of deliveries 27,777 27,777 2,714 2,714 \$ \$ 2.88 0.36 per kit per kit per delivery per delivery 220,000 20,000 100,000 100,000 Number of purchasing Number of invoices Number of kits 27,777 18,000 27,777 \$ \$ \$ 0.72 5.56 3.60 per kit per invoice per kit 500,000 500,000 Number of kits 27,777 \$ 18.00 per kit ABC system…

• 926 Words
• 4 Pages
Good Essays