Sarah's Organic Soap Company makes four kinds of organic liquid soap: regular, lavender, citrus, and tea tree.The demand for the four scents are 150, 120, 75, and 50 kg per hour respectively. Sarah's production processcan produce any soap at the rate of 450 kg per hour, but 1.5 hours are needed to switch between scents. Duringthose switchover times, the process doesn't produce any soap. Sarah wants to choose a production schedulethat (i) cycles repeatedly through the four scents, (ii) meets the required demand and (iii) minimizes the amountof inventory held.Sarah needs to purchase organic palm oil to make her soaps. She needs 1,000 kg of palm oil perday on average. The supplier charges a $60 delivery fee per order (which is independent of theorder size) and $4.75 per kg. Sarah's annual holding cost is 25%. Assume 52 weeks per year and 5days per week. If Sarah wants to minimize inventory holding and ordering costs, how much palm oilshould she purchase with each order (in kg)? (Round your answer to the nearest wholenumber.)5,126 kg5,2265,3265.426

Sarah needs to purchase organic palm oil to make her soaps. She needs 1,000 kg of palm oil per day on average. The supplier charges a $60 delivery fee per order (which is independent of the order size) and $4.75 per kg. Sarah's annual holding cost is 25%. Assume 52 weeks per year and 5 days per week. If Sarah wants to minimize inventory holding and ordering costs, how much palm oil should she purchase with each order (in kg)? (Round your answer to the nearest whole number.)

Sarah needs to purchase organic palm oil to make her soaps. She needs 1,000 kg of palm oil per day on average. The supplier charges a $60 delivery fee per order (which is independent of the order size) and $4.75 per kg. Sarah's annual holding cost is 25%. Assume 52 weeks per year and 5 days per week. If Sarah wants to minimize inventory holding and ordering costs, how much palm oil should she purchase with each order (in kg)? (Round your answer to the nearest whole number.)

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

Demand for your product averages 10,000 units per year. Placing an order costs $500. The holding cost per unit per year is 15% of the cost of the item, and items cost $6.00. What is the EOQ?
Double T appliance is a retailer of small appliances in West Texas. Double T gets all of their merchandise from GE which it then sells to the people of the South Plains. Their annual demand is 10,000 units and the ordering cost is $100 per order. The carrying cost per unit is $50.00 What is their expected annual carrying cost (not including the costs of the goods) if the Economic Order Quantity is used and is equal to 200 units?
You have an annual demand of 800 units of your product which you sell for $90 a unit. It costs you $20 to place an order and carrying costs for the item are 14%. What is your EOQ?
A toy manufacturer uses approximately 32,000 silicon chips annually. The chips are used at a steady rate during the 240 days a year that the plant operates. Annual holding cost is $3 per chip, and ordering cost is $120. Determine the following: What is the reorder point, if the lead time is 7 days?
Determine which delivery alternative would be most economical for 50 boxes of parts. Each box costs $434 and the annual holding cost is 20% of the cost. Assume 365 days per year. Overnight delivery option costs $300, and eight-day delivery option costs $125 a. The overnight option is at least $182 cheaper than eight-day b. The overnight option is at least $91 cheaper than eight-day c. The eight-day option is at least $182 cheaper than overnight d. The eight-day option is at least $91 cheaper than overnight
A bookstore stocks a limited-edition series of collectible comic books, which are considered perishable due to their limited availability and potential for damage if not stored properly. This particular comic book series is highly sought after by collectors and sells for $50 per issue. It comes with a high annual inventory holding cost rate of 30% of its SKU value. The estimated ordering cost is $100 per order. The store anticipates an annual demand of 500 issues for the upcoming year. The lead time for orders is four weeks, assuming 52 weeks in a year. a) Set up a fixed-order-quantity system computing: the EOQ and the reorder point (r). b) Set up a fixed-period system computing: the review period (T) and the replenishment level (M). Round the review period to the next highest number. c) How much more does it cost to hold inventory in an FPS vs. an FQS?
A components manufacturer uses approximately 20,000 units annually of an item. They are used at a steady rate during the 250 workdays that the plant operates. The cost of each item is $7.00, and the annual carrying cost is $0.50 per unit per year. The ordering cost is $50. What is the economic order quantity?
Mac-in-the-Box, Inc., sells computer equipment by mail andtelephone order. Mac sells 1,200 flat-bed scanners per year.Ordering cost is $300, and annual holding cost is 16 percentof the item’s price. The scanner manufacturer offers thefollowing price structure to Mac-in-the-Box: What order quantity minimizes total annual costs?
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?
www.www A toy manufacturer uses approximately 40000 silicon chips annually. The chips are used at a steady rate during 350 working days per year. The annual holding cost is $4 per chip, ordering cost is $145, and lead time is 5 days. Determine the annual cost saving if company uses optimal EOQ (part a) instead of current order quantity of 3000 units (Round your answer to 1 decimal places)
Johnson Tire Plaza (JTP) is a large chain of tire shops, who sells various brand of automobile tires. The yearly demand of a particular brand of time is about 8,888 units per year. JTP purchases these tires from a supplier. The ordering cost is $124 per order and the holding cost is $19 per tire per year. The supplier always deliver the shipment within 6 days after receiving a replenishment order from JTP. The company operates 250 days per year. Assume EOQ model is applicable. What is the optimal annual inventory cost for JTP? Use at least 4 decimal places.
Manipulation Manufacturing Company uses 1,000 units of Chip annually in its production. Order costs consist of P10 for placing a long-distance call to make the order and P40 for delivering the order by truck to the company warehouse. Each Chip costs P100 and the carrying costs are estimated at 15.625% of the inventory cost. If the EOQ for Chip is 80 and the total ordering cost is P625. Compute for the Total Carrying Costs.