You are in the process of deciding the optimal order quantity of shampoopacks for a hotel. The supplier charges you $47 per order and your stockroomcosts approximately $0.69 per shampoo pack per year to store the product.Based on prior research, you were able to determine that the hotel goesthrough approximately 94 shampoo packs per day. They hold 0 safety stock.The supplier is willing to give the following quantity discounts for the product.Using the order quantity that will minimize total cost, what is the total annualcost?Quantity1 - 1499$2.25$2.10$2.05$2.03Note: Round your answer to 2 decimal places. Do NOT include $ sign or acomma. For example, answer like 50246 and NOT $50,246Answer:1500 - 39994000 - 79998000+PriceCheck

Ans) First find EOQ and its cost:

Answered: You are in the process of deciding the…

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

Annual demand for your product is 50,000 units. Holding cost is 25% of the value of the item. The cost, per unit, is $5.00. It costs $200 to place an order. This is a new supplier that you are thinking about buying from, and the catch is that you have to place a pretty big order in order to be able to buy from these people. You have to buy at least 6,957 units every time. What are you total costs, (including the Cost of Goods), if you choose to buy from this supplier?
You have electronics store, and you are planning to buy headphones from china. The supplier in china offers you three different prices for the same headphone. The discount you will get is based on the quantity you order. Below is quotation from the supplier. PRICE RANGE QUANTITY ORDERED Headphone Price Initial price 0 to 999 $200 Discount price 1 999 to 1999 $150 Discount price 2 2000 and above $100 Annual Headphone Demand (Units) = 20000 Ordering or Setup Cost per Order ($) = 1000 holding cost percentage of unit price = 5% What should the order quantity be in order to minimize the total annual cost?
Your distribution company has an annual demand of 1,400 lawn mowers. The cost of a lawn mower is $400. Carrying cost is estimated to be 20% of unit cost, and the ordering cost is $25 per order. If you order in quantities of 330 or more, you can get a 5% discount. Do a complete “EOQ with Discount” calculation and determine the optimal order quantity. Please show all calculations.
a) What is the economic order quantity? b) Find the annual holding costs.c) Find the annual ordering costs.d) What is the reorder point?
A company has an average demand of 30 units per day. The supplier's lead time averages 7 days. Assume that the combined standard deviation of demand over the lead time has been calculated and is equal to 20 units. One unit costs $10 and the inventory carrying cost is 25 percent. What is the reorder point for the company if it decides on a 99 percent service level?
Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. Item cost $ 8.00 Standard deviation of weekly demand 25 per week Order cost $ 298.00 Lead time 4 weeks Annual holding cost (%) 29 % of item cost Service probability 98 % Annual demand 28,100 Average demand 562 per week a. Determine the order quantity and reorder point. (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Do not round intermediate calculations. Round "z" value to 2 decimal places and final answer to the nearest whole number.) Optimal order quantity units Reorder point units b. Determine the annual holding and order costs. (Round your answers to 2 decimal places.) Holding cost $ Ordering cost $ c. Assume a price break of $50 per order was offered for purchase quantities of 2,100 or more units per order. If…
At a recent manufacturing workshop, XYZ, Incorporated explained that demand for disposable masks increase rapidly in March 2020 when quarantine mandates first took effect. At the time, retailers could only place a single order to cover demands through the end of the summer. A certain retailer purchased disposal masks from a supplier at a cost of $20 per unit and sold them for $30 per unit. By the end of summer, demand for masks subsided considerably and all masks that weren't sold during the summer could be sold at a discounted price of $18 per unit. The retailer estimated that demand between March and August would be Normally distributed with mu = 10,000 and sigma = 1525 units With, supply chains becoming more stable since March 2020, the retailer is currently in the process of establishing a contract with a disposable mask supplier. The supplier has agreed to sell masks to the retailer for $18 per unit and will make deliveries any time the supplier places an order for a cost of $100…
A daily newspaper is stocked by a coffee shop so its patrons can purchase and read it while they drink coffee. The newspaper costs $1.14 per unit and sells for $1.55 per unit. If units are unsold at the end of the day, the supplier takes them back at a rebate of $1 per unit. Assume that daily demand is approximately normally distributed with µ = 150 and σ = 30. (a) What is your recommended daily order quantity for the coffee shop? (Round your answer to the nearest integer.) (b) What is the probability that the coffee shop will sell all the units it orders? (Round your answer to four decimal places.) (c) In problems such as these, why would the supplier offer a rebate as high as $1? For example, why not offer a nominal rebate? Find the recommended order quantity at 25¢ per unit. (Round your answer to the nearest integer.) What happens to the coffee shop's order quantity as the rebate is reduced? The higher rebate ---Select--- ▾ the quantity that the coffee shop should order.
What factors should a company consider when deciding whether to adopt the Wilson approach for its inventory management?
A manufacturer buys cardboard boxes from a supplier. The annual demand is 40,000 boxes and is uniformly distributed. The boxes cost $5 each. The estimated order cost is $10, and the carrying cost rate is 20% per year. What is the EOQ and what is the annual order and carrying cost? How many times a year are orders placed, and what is the average time, in weeks, between orders? Using the answer from (b), if you round the average time between orders to the nearest week, what should the order quantity be? Would you recommend using this order quantity and time interval? Suppose that the actual demand turns out to be 80,000 boxes instead of 40,000 boxes.If you had used the EOQ from the (a), what would be the annual order and carrying cost be?
Delaney Co. uses 12,000 of an item per year. They are open 300 days per year. The item takes 8 days from the time they place an order until they receive it. They like to maintain a safety stock of 200. What is Delaney's reorder point for this item?
Don't give answer in image format

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