Chapter 4. Tyler decided to open a bakery because everyone he knew told him that his baked goods were "out of this world." He had a little bit of a business school background because he got his Bachelor's from SPS atUIW recently. He remembered his teacher telling him that inventory models can be used for both the raw materials as well as the finished products for a business like his. So, he decided to see if he could use the basicEOQ model for identifying how much quantity to order of raw materials such as eggs, flour, sugar, etc. To get started, he decided to create a model for flour based on the information he had on hand regarding potentialcosts as follows:• Usage per month 100 lbs• Purchase cost $1 per Ib.• Order cost $10.00 per order sent• Annual Holding Rate 10% of purchase price per Ib.• 52-week year 300 working days per year• Lead time 2 daysFill in the following table based on this information:Optimal InventoryPolicyEconomic OrderIbs.Quantity Q*Annual InventorydollarsHolding Cost HAnnual Ordering CostdollarsTotal Annual Cost TCdollarsMaximum InventoryLevel QIbs.Average InventoryLevel Q/2Ibs.Reorder Point rIbs. leftNumber of Orders PerYear (D/Q*)Cycle Time (Days) Tdays

The EOQ model expects that request is steady, and that stock is exhausted at a proper rate until it…

Answered: Chapter 4. Tyler decided to open a…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 15P

See similar textbooks

Similar questions

Fixed-order-interval. This type of problem can be recognized when an order interval is given (e.g.,inventory is ordered every 10 days) along with the demand rate, lead time, and quantity on hand atorder time. Use Formula 13–16 to find the optimal order size.A lab orders a number of chemicals from the same supplier every 30 days. Lead time is five days.The assistant manager of the lab must determine how much of one of these chemicals to order. Acheck of stock revealed that eleven 25-milliliter (ml) jars are on hand. Daily usage of the chemical isapproximately normal with a mean of 15.2 ml per day and a standard deviation of 1.6 ml per day. Thedesired service level for this chemical is 95 percent.a. How many jars of the chemical should be ordered?b. What is the average amount of safety stock of the chemical?
Instructions There are four parts to this problem. Use Excel to perform the following. a. Use the economic order quantity formula (EOQ = SQRT((2SD/H)) to determine the optimal number of units that the company should order based on each assumed level of order based on each assumed level of order quantities provided in the data. b. Complete the table by calculating the number of orders per year, annual order cost, annual holding cost, and annual total cost. Highlight the minimum annual total cost using conditional formatting. Hint: The minimum cost should equal the cost at the EOQ you calculated in part a. c. Create a line chart that graphs annual order cost, annual holding cost, and annual total cost. The x-axis should be the quantity ordered. Include a chart legend, appropriate chart title, axes labels, and properly formatted amounts on the axes. d. Examine the chart and your responses to parts a and b. Indicate any relationships.
What are the primary benefits of implementing the Wilson approach in inventory control?
A firm uses the order-up-to model to manage its inventory. It wants to increase its in-stockprobability while decreasing its holding costs (i.e., reducing its average inventory). Which ofthe following actions will help to achieve this goal? (Consider each action independently.)I. Decrease the lead time.II. Increase the order-up-to level.III. Increase the average quantity on order.a. Only Ib. Only IIc. Only IIId. I and IIe. I and IIIf. II and IIIg. Any of them will help (that is I, II, or III).h. None of them will help.
In Example 2 , the particular items to be cycle counted can be sequentially or randomly selected each day. Another option is to cycle count items when they are reordered. Cycle counting also has the following advantages:1. Eliminates the shutdown and interruption of production necessary for annual physicalinventories.2. Eliminates annual inventory adjustments.3. Trained personnel audit the accuracy of inventory.4. Allows the cause of the errors to be identified and remedial action to be taken.5. Maintains accurate inventory records.
Consider that you work at Kroger Grocery store, and that you've been tasked with creating an ABC inventory classification for 6 items. The 6 items, as well as their profit per case and number of cases sold per week, are as follows:Ribeye Steak - $135 in profit per case, 3 cases sold per weekLobster Tail - $245 in profit per case, 3 cases sold per weekPasta - $23 in profit per case, 12 cases sold per weekSalt - $3 in profit per case, 2 cases sold per weekNapkins - $12 in profit per case, 2 cases sold per weekTomato Sauce - $23 in profit per case, 11 cases sold per weekUsing total weekly profits, please classify each products into A, B, or C categories. Which items form the boundary of the class A and B items in your classification, and why? Which items form the boundary of the class B and C items in your classification, and why?
Rocky Mountain Tire Centre sells 20,000 tires of a particular type per year. The ordering cost for each order is $40, and the holding cost is 20% of the purchase price of the tires per year. The purchase price is $20. per tire if fewer than 500 tires are ordered, $18. Per tire if more than 500 but fewer than 1,000 tires are ordered and $17. per tire if 1,000 or more tires are ordered. Quantity Unit Price 1-499 $20. 500-999 $18. 1000 & over $17 Based on available information, lead time demand for CD-ROM drives averages 50 units (normally distributed), with a standard deviation of 5 drives. Management wants a 97% service level. What value of Z should be applied? How many drives should be carried as safety stock?
The materials manager of a tire manfacturer must predict periodically place order for a key chemical one of the raw materials used in manufacturing uses the chemical at a rate of 300lbs each week and the lead time of delivery is 4 days. Assume that the manufacturing operation runs 5 days a week. At what point should the chemical be reorderedd a. when 1200lbs are remaining b. where 0lbs are remaining c. where 375lbs are remaining d. when 240lbs are rem
At Dot Com, a large retailer of popular books, demand is constant at 32,000 books per year. The cost of placing an order to replenish stock is $10, and the annual cost of holding is $4 per book. Stock is received 5 working days after an order has been placed. No backordering is allowed. Assume 300 working days a year.a. What is Dot Com’s optimal order quantity?b. What is the optimal number of orders per year?c. What is the optimal interval (in working days) between orders?d. What is demand during the lead time?e. What is the reorder point?f. What is the inventory position immediately after an order has been placed?
You were asked to assist with optimising the stock ordering and holding process for a company that sells car batteries. As part of the process, you need to decide the optimal order size to minimise associated costs. You are given the following information: • The batteries cost R400 each. • Sales volumes are constant at 600 batteries per month. • The lead time from order to delivery is 14 days. • It costs R360 for every order to be processed. It is calculated that it costs R5 to store a battery per month. 4) Calculate the optimal total costs.
Please complete the sup part: e,f and g. 1.B&H needs to decide how to manage its inventory of cameras. The demand for cameras at B&H is 200 cameras per week. Each time that B&H places an order for a new shipment of cameras, it must pay $80 in fixed processing fees. A camera costs B&H $60 to purchase. The cost for B&H to hold a camera in its store for one week is $4. Assume that the lead time for the delivery of a camera is 0 weeks.a. Suppose that B&H places orders for cameras in quantities of 50 cameras at a time and places a new order for cameras each time that it runs out. Draw a graph showing the number of cameras that B&H has on-hand in inventory at each point in time up until the time when it places its fourth-order. Label the points in time at which B&H places a new order. Assume that B&H places its first order for 50 cameras on day 0.b. Suppose again that B&H places orders for 50 cameras at a time. What will be B&H’s average holding…
World’s Greatest Coffee EOQ Problem A natural food store carries a brand of coffee called World’s Greatest Coffee. The following data shouldbe used in your calculations.Demand/Sales = 10 cases of coffee per week (you will need to convert this to an annual amount)Ordering Cost = $12 per orderCarrying Charge = 18% per yearUnit Cost = $75 per case Answer the following questions and be sure to show your computations. You can use whatever symbolyou need for square root, if typing in Word.1. How many cases should be ordered at a time? (This number will be the EOQ)2. How often should the coffee be ordered?3. What is the annual cost or ordering the coffee? What is the annual cost of carrying the coffee?And what is the total cost (ordering and carrying costs added together)?4. Name three reasons or factors that might cause the firm to order a larger or smaller amountthan the EOQ. Scoring – 20 possible pointsSection Possible PointsQuestion 1 – EOQ computation 4Question 2 – Frequency of…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS