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

DMC Bikes Co. is a retailer of bicycles. The most popular bicycle has an monthly demand of 3000 units. Demand is predictable and spread evenly throughout the year. The bicycles are purchased by PR for $250 each. Ordering costs are $100 per order and the annual cost of holding one bicycle in inventory is $50. Calculate the economic order quantity (EOQ) for the children’s bicycle. show solution
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?
Amber Pvt Ltd sells 240,000 stools per year. Based on the company's policy, a safety stock of 4 percent from yearly sales is to be maintained. The carrying cost is $0.50 per unit annually and the ordering costs are $180. The delivery time is 10 days. Order should be placed in 100 units and there is 360 days in a year. Compute: The economic order quantity The total cost of holding inventory. The reorder inventory level. The number of orders placed annually.
the company expects to sell 38,400 units next year. it operates 355 days a year. annual carrying cost is P64 per unit ordering cost is P300 A. what is the eoq? B. how many times per year does the store reorder? (round up) show solution
The Cerebro Computer Store purchase printers for $100 each. Demand for this is constant during the year, and annual demand is forecasted to be 1350 units. The holding cost is $20 per unit per year, while the cost of ordering is $90 per order. There are 270 working days per year and the lead-time is 8 days. What is the annual order cost? Enter your answer with two decimal places.
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?
B). As an inventory manager, you must decide on the order quantity for an item. Its annual demand is 679 units. Ordering costs are $7 each time an order is placed, and the holding cost is 10% of the unit cost. Your supplier provided the following price schedule. Quantity Price per Unit 1 - 100 $5.65 101 - 350 $4.95 351 or more $4.55 What ordering-quantity policy do you recommend?
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 microbrewery purchases malt for production. The supplier charges $35 for delivery (no matter how much is delivered) and $1.20 per gallon. Annual holding cost is 35% of the price per gallon. Usage is 250 gallons/week. d) If order quantity is 2500 gallons, what is the sum of the ordering and holding costs PER GALLON? e) If orders are for EOQ amount, what is the annual cost of the inventory system as a percentage of the annual purchase cost?
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?