Need help with the highlighted part 5. The Warren W. Fisher Computer Corporation purchases8,000 transistors each year as components inminicomputers. The unit cost of each transistor is $10, andthe cost of carrying one transistor in inventory for a yearis $3. Ordering cost is $30 per order.Assume that Fisher operates on a 200-day working year.a. What is the optimal order quantity?a. What is the expected number of orders placed eachyear?b. What is the expected time between orders?What is the total cost?C.The optimal order quantity is 400 unitsThe expected number of orders placed per year would be 20 ordersThe expected time between the orders would be 20 daysPage 1 of 5

Given Data Annual demand (D) = 8000 transistors or units Ordering cost (S) = $30 per order Cost of…

Answered: The Warren W. Fisher Computer…

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

c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.
At Dot Com, a large retailer of popular books, demand isconstant at 20,400 books per year. The cost of placing anorder to replenish stock is $35, and the annual cost of holdingis $6 per book. Stock is received 5 working days after an orderhas been placed. No backordering is allowed. Assume 250working 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) betweenorders?
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
Suppose demand is know and constant at 500 units per year (one year has 250 working days). The holding cost is $2 per unit per year and the ordering cost is $20 per order. Also assume that the lead time is 10 days. Compute the optimal order quantity (EOQ) and the optimal annual inventory cost. Draw a picture of the evolution of the inventory level with time. Indicate the ROP on the picture as well as the length of the cycle. Now assume that the lead time is 90 days. Indicate the ROP on the picture.
The manager of a hardware store decides to use theEOQ with shortages model to determine the orderingpolicy for tape measures. Using economic considerations,the manager determines that she should usean order quantity of Q 5 30 and have a maximumshortageof b 5 3. The lead time for her supplier todeliver an order is L working days, where there are sixworking days in a week. (Essentially, you can ignoreSundays.) The weekly demand is for 20 tape measures.What reorder point should the manager use ifL 5 3; if L 5 5; if L 5 10? (Hint: The manager shouldplan her orders so that the inventory level is 2b whenan order arrives.)
If D = 8000 per month, S = $45 per order and H = $x per unit per month. If doubling the holding cost makes the optimal order quantity (EOQ) become 600, what is the value of x?
In the calculation of an optimal policy for an all-units discount schedule, you firstcompute the EOQ values for each of the three order costs, and you obtain: Q(0) =800, Q(1) =875, and Q(2) =925. The all-units discount schedule has breakpointsat 750 and 900. Based on this information only, can you determine what the optimal order quantity is? Explain your answer.
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?
Penalty costs can be assessed only against the number of units of demand that cannot be satisfied, or against the number of units weighted by the amount of time thatan order stays on the books. Consider the following history of supply and demandtransactions for a particular part:Number of Items Demand duringMonth Received MonthJanuary 200 520February 175 1,640March 750 670April 950 425May 500 280June 2,050 550Assume that starting inventory at the beginning of January is 480 units.a. Determine the ending inventory each month. Assume that excess demands areback-ordered.b. Assume that each time a unit is demanded that cannot be supplied immediately,a one-time charge of $10 is made. Determine the stock-out cost incurred duringthe six months (1) if excess demand at the end of each month is lost, and (2) ifexcess demand at the end of each month is back-ordered.c. Suppose that each stock-out costs $10 per unit per month that the demandremains unfilled. If demands are filled on a first-come,…
A mail-order house uses 16,870 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of BoxesPrice per Box1,000 to 1,999$1.25 2,000 to 4,9991.20 5,000 to 9,9991.15 10,000 or more1.10 a.Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity5000 boxes b.Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year
Suppose that a product with an annual demand of 2400 units, a setup cost per production run of $8, and a holding cost of $1 per unit per year. With 200 working days in a year, conisder the following ordering plans: 1) order 600 units once each quarter and all 600 units will be delivererd in a single day 2) order 200 units once each month and all 200 units will be delivered in a single day 3) order 120 units each 6-month, and each order will be delivered over a period of 60 days a) Suppose that the items will be delivered at a rate of 40 pieces per day, what is the minimum overall costs in this case? b) Which ordering strategy has the lowest overall cost and why?
Suppose that a product with an annual demand of 2400 units, a setup cost per production run of $8, and a holding cost of $1 per unit per year. With 200 working days in a year, conisder the following ordering plans: 1) order 600 units once each quarter and all 600 units will be delivererd in a single day 2) order 200 units once each month and all 200 units will be delivered in a single day 3) order 120 units each 6-month, and each order will be delivered over a period of 60 days a) Calculate the annual holding and setup costs associated with each plan b) When items arrive in one batch, what is the optimal order quantity to minimize overall costs?

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