Concept explainers
a
To determine:
Optimal order quantity for Colombian coffee.
Introduction:
Economic order quantity in the optimal inventory kept by any firm which is ideal and do not incur any additional holding cost and order cost.
b
To determine:
Time duration between placement of order.
Introduction:
Lead time is the time between when order is placed and its production is completed.
c
To determine:
Average annual cost of holding and set up cost
Introduction:
Holding cost is the cost incurred when goods are kept in warehouses without sale.
Setup cost is the fixed cost which is incurred for production process.
d
To determine:
Reorder level based on the on − hand inventory
Introduction:
On hand inventory is the stock of goods available to be sold to customers.
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Production and Operations Analysis, Seventh Edition
- Jill's Job Shop buys two parts (Tegdiws and Widgets) for use in its production system from two different suppliers. The parts are needed throughout the entire 52-week year. Tegdiws are used at a relatively constant rate and are ordered whenever the remaining quantity drops to the reorder level. Widgets are ordered from a supplier who stops by every three weeks. Data for both products are as follows: A. Find the total inventory costs if using inventory policy. This is a case considering safety stock (make sure to use the right formula)arrow_forwardAn importer operates a small warehouse that has the following annual costs. Wages for the purchasing agents are $45,000 per year, purchasing expenses are $30,000 per year, customs and brokerage costs are $30 per order, the cost of financing the inventory is 8%, storage costs are 7%, and the risk costs are 10%. The average inventory is $250,000 and 6,000 orders are placed in a year. What is the annual ordering costs (in dollars)? Your answer is an integer. how do you get Order & Carrying cost?arrow_forwardKabel Market store sells electric cable. The demand for cable is normally distributed. The inventory related information at Kabel Market is as follows: Average Annual Demand = 16,900 meters Standard deviation of weekly demand = 28 meters Cable selling price = AMD 640.00 per meter Ordering cost = AMD 1,250.00 per order Lead time = 5 weeks Annual inventory-holding cost estimate = 2.5% of the cable selling price Required service level = 95% Kabel Market works 52 weeks a year. Note: The approximate z values are: for 0.9 ≈ 1.28, for 0.92 ≈ 1.405, for 0.95 ≈ 1.645, for 0.98 ≈ 2.05. Suppose the bar management practices the fixed-QUANTITY ordering system with the use of the economic order quantity. Answer the following questions: (i) How many meters of cable they order from the supplier each time? (ii) When do they place an order? (iii) What is the safety stock?arrow_forward
- EOQ, reorder point, and safety stock Alexis Company uses 937units of a product per year on a continuous basis. The product has a fixed cost of $44 per order, and its carrying cost is $4 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.arrow_forwardEOQ, 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.)arrow_forwardThompson Paint Company uses 60,000 gallons of pigment per year. The cost of ordering pigment is $200 per order, and the cost of carrying the pigment in inventory is $1 per gallon per year. The firm uses pigment at a constant rate every day throughout the year. a. Calculate the EOQ. b. If it takes 20 days to receive an order once it has been placed, determine the reorder point in terms of gallons of pigment. (Note: Use a 365-day year.)arrow_forward
- answer in 30 minutes...arrow_forwardA company operates for 50 weeks a year and uses a fixed quantity inventory system for one of its most important items. Below are the characteristics for the item: Weekly demand follows normal distribution: mean of 400 units and standard deviation of 100 units Order Cost = $40 per order Annual Holding cost = $2/unit/year Desired service level = 95% (z = 1.645) Lead Time = 4 weeks Economic Order Quantity (EOO) = 894 units Now suppose that the management is considering switching to a fixed time inventory system where the time between orders is 2 weeks. Everything else being the same as the information provided for the original problem, which system (Q or P system) is likely to have more safety stock? Please explain why.arrow_forwardNumber of orders placed per yeararrow_forward
- explain the characteristics of inventory situations: 1. lead time 2. sources and level of risk 3. Static versus dynamic problemsarrow_forwardThe sales of Whole Care mouthwash at Jen's of Michigan over the past six months have averaged 2,000 cases per month, which is the current order quantity. Jen's of Michigan's cost is $12.00 per case, and ordering cost is $38. The company estimates its cost of capital to be 12 percent. Insurance, taxes, breakage, handling, and pilferage are estimated to be approximately 6 percent of the item cost. Lead time is 3 days, and considering weekends and holidays, Tom's of Maine operates 250 days per year. Based on the above information please answer the following questions What is EOQ? What is the cost reduction? What is the reorder point? What is Time between Orders (TBO)?arrow_forwardYour objective is to help company by determining EOQ* (Economic Order Quantity) that minimizes the totalinventory cost for a company that sells ceiling fans. Your worksheet provides information about the currentorder quantity, demand quantity and other costs.Questions: Answer A and Ba. With the current order quantity, what is the total cost of inventory?b. Implement the problem in Excel and find the order quantity (EOQ) (round to nearest integer) that givesminimum inventory cost. Note: this is a Non-linear programming, hence select “GRG Nonlinear” method inSolver- How much money would company save by switching to optimum quantity from current orderquantity?arrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning