**Rocky Mountain Tire Center Case Study**Rocky Mountain Tire Center sells 13,000 go-cart tires per year. The ordering cost for each order is $40, and the holding cost is 40% of the purchase price of the tires per year. The purchase price varies based on the quantity ordered:- $20 per tire if fewer than 200 tires are ordered,- $19 per tire if between 200 and 4,999 tires are ordered,- $16 per tire if 5,000 or more tires are ordered.**Problem Statement**a) How many tires should Rocky Mountain order each time it places an order?*Rocky Mountain's optimal order quantity is [ ] units (enter your response as a whole number).*

Optimal order quantity is economic order quantity which is calculated with following formula…

Answered: Rocky Mountain Tire Center sells 13,000…

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

Potter Machine Company expects total sales of $60,000. The price per unit is $10. The firm estimates an ordering cost of $25 per order, with an inventory carrying cost of $0.70 per unit. What is the optimal order size?
If annual sales in are 65,000 units, price per unit is $25, carrying costs are 30%, and fixed costs per order is $100, then EOQ is 1,316.56. True or False?
Short answer question
A gift shop sells 400 boxes of scented candles a year. The ordering cost is $50 for scented candles, and holding cost is $25 per box per year. What is the economic order size for scented candles?
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…
Annual demand (D) is 49,000 units. Ordering Cost (S) is $1,000 per order. Holding cost (H) is $2 per unit per year. Find economic order quantity (Q*). 7,000 units 49,000,000 units 4,950 units 3,500 units 4,083 units
Yellow Press, Inc., buys paper in 1,500-pound rolls for printing. Annual demand is 3,000 rolls. The cost per roll is $1,000, and the annual holding cost is 28 percent of the cost. Each order costs $75. Part 2 a. How many rolls should Yellow Press order at a time? Yellow Press should order enter your response here rolls at a time. (Enter your response rounded to the nearest whole number.) Part 3 b. What is the time between orders? (Assume 200 workdays per year.) The time between orders is enter your response here days. (Enter your response rounded to one decimal place.)
If Sarah wants to minimize inventory holding and ordering costs, how much Palm oil should she purchase with each order (in kgs)?
If annual demand is 12,000 units, annual holding cost is $15 per unit, and setup cost per order is $25, what is the EOQ lot size?
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.)
Suppose you have been employed by Kam Steels Corporation as a financial manager. You want to change old inventory ordering system to the just-in-time inventory method. The shareholders and the CEO of the firm would like to know how the new would operate and the benefits and disadvantages of the just-in-time inventory method. By providing a high-quality argument, please explain how the new would operate and its benefits and disadvantages to the shareholders and the CEO of the firm.

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