8. 4 The Western Jeans Company purchases denim from Cumberland Textile Mills. TheWestern Jeans Company uses 35,000 yards of denim per year to make jeans. The cost ofordering denim from the textile company is $500 per order. It costs Western $0.35 per yardannually to hold a yard of denim in inventory. Determine the optimal number of yards ofdenim the Western Jeans Company should order, the minimum total annual inventory cost,the optimal number of orders per year, and the optimal time between orders.( Ans: Q=10000 yards: TC=$3500; No. of orders=3.5 per year; Time between orders= 104.3)

Answered: 8. 4 The Western Jeans Company…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas’s fastest-moving inventory item has a demand of 6,000 units a year. The purchasing cost of each unit is $16 (additional 5% discount applies if at lease 150 units ordered a time), and the inventory carrying cost is $3 per unit per year. The average ordering cost is $10 per order. It takes about 3 working days for an order to arrive. (This is a corporate operation, and there are 300 working days per year.) Answer the following questions, Q1~Q5. Note that you must include Excel formulas/calculations showing how you arrive at the answer. Q1: Assume that the demand is consistent throughout the year. What is the ROP? Note that stockouts and unnecessary inventory holding should be avoided at any times. Q2: Assume that the demand is consistent throughout the year. Based on the EOQ model, to minimize the costs of purchasing, ordering and inventory holding…
Peter Sagan is in charge of maintaining hospital supplies at Champs Hospital. During the past year the mean weekly demand for a special type of tubing was 186 packages of this tubing with a standard deviation of 13 packages of tubing. The lead time for receiving this tubing from the supplier is 1.5 weeks. Peter would like to maintain a 95% service level and places an order for 750 packages every time an order is placed. d) If the weekly demand is 186 and there is a 1.5 week lead time - what is the reorder point (99% service level)? e) If the carrying cost per year is $0.50/unit/year - what is the additional cost associate with the 99% service level compared to 95% service level (i.e. cost of safety stock at 99% level - cost of safety stock at 95% service level)?
Company S offers the following discount schedule for its sheets. Company K orders sheet from Company S. Company K has an ordering cost of $45. The carrying cost is 20%, and the annual demand is 100 sheets. Order Unit Cost 9 sheets or less $18.00 10 to 50 sheets $17.50 More than 50 sheets $17.25 The total cost of ordering more than 50 sheets is
A printing company anticipates using 40,000 reams of paper at a uniform rate over the next year. Each time they place an order for X units of reams of paper, it is charged a flat fee of $200. Carrying costs are $4 per unit per year. A. use the formula for Economic Order Quantity to find out how many reams of paper they should purchase in each order. B. how many orders should they place over the year?
P3-9 Earthbound Corporation is a manufacturer and distributor of air conditioning system. You have been engaged to install an accounting system for Earthbound. Among the inventory control features Earthbound desires as part of the system are indicators of "how much' to order and "when." The following information is furnished for a product called "Hydronix" which is carried in inventory: Hydronix are sold by the gross (twelve dozen) at a list price of P800 per gross FOB shipper. John receives a 40% trade discount off list price on purchases in gross lots. Freight cost is P20 per gross from the shipping point to John's plant. John uses about 5,000 Hydronix during 259-day production year and must purchase a total of 36 gross per year to. allow for normal breakage. Minimum and maximum usages are 12 and 28, respectively. It takes 20 working days (normal delivery time) to receive an order from the date the purchase request is initiated. A rush order in full gross lots can be received by air…
Paulin’s muffler shop has one standard muffler that fits a large variety of cars. The shop wishes to establish a periodic review system to manage inventory of this standard muffler. Use the information table to determine the optimal inventory target level (or order-up to level). Annual demand 3,910 mufflers ordering cost $75 per order S/D of daily demand 6 mufflers/wk. day service probability 87% Item cost $ 27.00 per muffler lead time 2 wk. Days Annual holding cost 36 % of item value wk. Days 230 per year Review period 18 working days What is the optimal target levels (order up to levels) use excels NORMSINVI() function to find the correct critical value for the given a-level. Do not round intermediate calculations. Round value 2 decimal places and final answer to the nearest whole number If the service probability is 90%, the optimal target level will increase, decrease or…
A jewelry firm buys semiprecious stones to make bracelets and rings. The supplier quotes a price of $8.80 per stone for quantities of 600 stones or more, $9.20 per stone for orders of 400 to 599 stones, and $9.70 per stone for lesser quantities. The jewelry firm operates 230 days per year. Usage rate is 16 stones per day, and ordering costs are $45.a. If carrying costs are $2 per year for each stone, find the order quantity that will minimize total annual cost. (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) b. If annual carrying costs are 20 percent of unit cost, what is the optimal order size? (Do not round intermediate calculations, except for order quantities which should be rounded to the nearest whole number. Round your final answer to the nearest whole number.) c. If lead time is 3 working days, at what point should the company reorder? (Do…
Question 1 For supply item ABC, Andrews Company has been ordering 400 units per week. A new purchasing agent has been hired by the company who wants to start using the economic-order- quantity method and its supporting decision elements. She has gathered the following information: Annual demand in units Lead time, in days Ordering costs Insurance and handling costs Purchase price per unit Return on cash investment 20,800 5 $22 $7 $15 15% Required
EOQ, reorder point, and safety stock Alexis Company uses 916 units of a product per year on a continuous basis. The product has a fixed cost of $60 per order, and its carrying cost is $3 per unit per year. It takes 5 days to receive a shipment after an order is placed, and the firm wishes to hold 10 days' usage in inventory as a safety stock. a. Calculate the EOQ. b. Determine the average level of inventory. (Note: Use a 365-day year to calculate daily usage.) c. Determine the reorder point. d. Indicate which of the following variables change if the firm does not hold the safety stock: (1) order cost, (2) carrying cost, (3) total inventory cost, (4) reorder point, (5) economic order quantity. a. Alexis' EOQ is units. (Round to the nearest whole number.)
As the Manager of Branson’s Department Store, you are responsible for ensuring that reorder quantities for the various items have been correctly established. You decide to test one item and choose product Z. A continuous review inventory policy has been used, so you examine this as well as other records and come up with the following data: Cost per unit $35 Holding cost 20 percent of unit cost Average daily demand 10 units Ordering cost $30 per order Standard deviation of daily demand 3 units Delivery lead time 4 days Because customers generally do not wait but go elsewhere, you decide on a service probability of 90 percent. Assume that Branson’s Department Store operates 320 days per year. [What is the annual demand (D)? Determine the optimal order quantity, Q*. Determine the reorder point (R) if demand is constant. Determine the reorder point (R) if demand is varies.
Thomas Kratzer is the purchasing manager for the headquarters of a large insurance company chain with a central inventory operation. Thomas's fastest-moving inventory item has a demand of 5,900 units per year. The cost of each unit is $101, and the inventory carrying cost is $11 per unit per year. The average ordering cost is $31 per order. It takes about 5 days for an order to arrive, and the demand for 1 week is 118 units. (This is a corporate operation, and there are 250 working days per year). a) What is the EOQ? units (round your response to two decimal places). b) What is the average inventory if the EOQ is used? c) What is the optimal number of orders per year? d) What is the optimal number of days in between any two orders? decimal places). units (round your response to two decimal places). orders (round your response to two decimal places). days (round your response to two e) What is the annual cost of ordering and holding inventory? $ decimal places). per year (round your…
Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every two weeks. Data for both products are as follows: ITEM TEGDIW WIDGET Annual demand 7,000 10,000 Holding cost (% of item cost) 30 % 30 % Setup or order cost $ 190.00 $ 10.00 Lead time 7 weeks 2 week Safety stock 45 units 9 units Item cost $ 5 $ 6 a. What is the reorder quantity and reorder point for Tegdiws? (Round your answers to the nearest whole number.) b. What is the inventory control system for Widgets? (Round your answer to the nearest whole number.) Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS