Problem 12-2 (Algo)A local distributor for a national tire company expects to sell approximately 9,780 tires of a certain size and tread design next year.Annual carrying cost is $18 per tire and ordering cost is $85. The distributor operates 283 days a year.a. What is the EOQ? (Round your answer to a whole number.)EOQb. How many times per year does the store reorder? (Round your answer to two decimal points.)Number of Orders per Yearc. What is the length of an order cycle? (Round your answer to two decimal points.)Length of Order Cycled. What will the total annual carrying and ordering cost be if the EOQ quantity is ordered? (Round your answer to a whole number.)Total Annual Inventory Cost

Annual demand = D = 9780 tires Annual carrying cost per tire = H = $18 Ordering cost = S = $85 No.…

Answered: Problem 12-2 (Algo) A local distributor…

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

Pls solve this question correctly in 5 min i will give u like for sure Question # 1 Teresa Cohan is attempting to perform an inventory analysis on one of her most popular products. Annual demand for this product is 5,000 units; unit cost $200; carrying cost is considered to be approximately 10% of the unit price. Order costs for her company typically run nearly $30 per order and lead time averages 10 days. Discounted unit cost of Rs. $150 (carrying cost remain the same) for more than 300 units is also being offered. (Assume a 50-week year. a)What is economic order quantity? b)What is the reorder point? c)What is the total carrying + ordering cost? d)What is optimal number of orders per year? e)Would you recommend availing the discount?
During the last 5 weeks, demands for a certain SKU at a retailer were 7 units (5 weeks ago), 4 units, 4 units, 4 units, and 5 units (last week). The retailer uses a period review model with order-up-to level 71 units, a review period of 2 weeks, and the lead time is 11 weeks. It is time to order. How much should the retailer order?
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…
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.)
At Matthews Car Repair, customer demand for a certain brand of motor oil is normally distributed with a mean of 15 gallons and a standard deviation of 6 work-days. To be 95% sure that Compact Car Repair will not run out of oil, we should reorder when motor oil in stock is less than _______ gallons. a. 24.9 b. 22.6 c. 23.7 d. 20
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
Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of order-ing tape is $1, and carrying costs are 40 cents per roll a year. Lead time is three days. a. What is the EOQ?b. What ROP will provide a lead time service level of 96 percent?
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.
7. Sam's Cat Hotel operates 52 weeks per year, 5 days per week, and uses a continuous review inventory system. It purchases kitty litter for $11.00 per bag. The following information is available about these bags. Refer to the standard normal table for z-values. ≻Demand = 95 bags/week ≻Order cost = $57/order ≻Annual holding cost = 30 percent of cost ≻Desired cycle-service level=98 percent ≻Lead time = 1 week(s) (5 working days) ≻Standard deviation of weekly demand = 20 bags ≻Current on-hand inventory is 350 bags, with no open orders or backorders. a. What is the EOQ? (Enter your response rounded to the nearest whole number.) and (Enter your response rounded to one decimal place.) b. What should R be? (Enter your response rounded to the nearest whole number.) c. An inventory withdrawal of 10 bags was just made. Is it time to reorder? (is or is not)
Please do not give solution in image format thanku Regional Supermarket is open 360 days per year. Daily use of cash register tape averages 10 rolls. Usage appears normally distributed with a standard deviation of 2 rolls per day. The cost of ordering tape is $1 per order, and carrying costs are 40 cents per roll a year. Lead-time is three days. a) Ignoring the demand uncertainty (i.e., looking only at average values), find the economic order quantity (EOQ) and the reorder point (ROP). b) Consider now the uncertainty. The order quantity remains the same. If the target is to have a 99% annual service level, what should be the ROP
I need answers A company uses on an average 216 parts a day with a standard deviation of 16 parts per day in a manufacturing process. Cost of placing and receiving an ordering is BDT 40,000. Estimated monthly carrying cost is BDT 90 per part. Orders are delivered approximately 7 days after being placed. The delivery time is normal with a mean of 7 days and a standard deviation of 2 days. The company is open 360 days per year. Find the order quantity that is economical. If the Company takes 3% stock out risk, then find safety stock (SS) quantity and Re-Order Point? 3.If the supplier offers a discount of BDT 8 per circuit board for purchasing of 4000 boards at a time, then financially evaluate and justify whether the company will go with the offer or not? 4.The person who orders the boards follows this rule: Order when the amount on…

SEE MORE QUESTIONS

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