4. (Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rateper period of 0.02. The additional data for this product is given below:PeriodDemand (units)Fixed Cost (S/order)(i)(ii)17510020110365100Assuming no backordering is allowed, answer the followings:(a) Check whether the demand is lumpy or not.(b) Apply the following heuristics on the problem given above.Period Order Quantity440105590100Silver-Meal(iii) Part-Period Balancing(c) Which of the solutions obtained in part (b) do you select?(d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for eachare on the network.(e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventorylevels, and the minimum sum of the ordering and inventory carrying costs.

This question asked us to (a) check if the demand is lumpy or not. (b) Apply three heuristics:…

(Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rate per period of 0.02. The additional data for this product is given below: Period Demand (units) Fixed Cost (S/order) 75 100 2 0 110 3 65 100 Assuming no backordering is allowed, answer the followings: (a) Check whether the demand is lumpy or not. (b) Apply the following heuristics on the problem given above. (i) Period Order Quantity (ii) 4 5 40 90 105 100 Silver-Meal (iii) Part-Period Balancing (c) Which of the solutions obtained in part (b) do you select? (d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for each are on the network. (e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventory levels, and the minimum sum of the ordering and inventory carrying costs.

(Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rate per period of 0.02. The additional data for this product is given below: Period Demand (units) Fixed Cost (S/order) 75 100 2 0 110 3 65 100 Assuming no backordering is allowed, answer the followings: (a) Check whether the demand is lumpy or not. (b) Apply the following heuristics on the problem given above. (i) Period Order Quantity (ii) 4 5 40 90 105 100 Silver-Meal (iii) Part-Period Balancing (c) Which of the solutions obtained in part (b) do you select? (d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for each are on the network. (e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventory levels, and the minimum sum of the ordering and inventory carrying costs.

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

Related questions

Q: Regional Supermarket is open 355 days per year. Daily use of cash register tape averages 20 rolls.…

A: Given that Today Days = 355 Daily Usage = 20 Annual Demand = 355×20 = 7100 Standard Deviation = 2…

Q: Discuss the relationship between Economic Order Quantity and Just-In-Time inventory system. Which…

A: 1. Economic Order Quantity (EOQ):The optimal order quantity (EOQ), which is a traditional inventory…

Q: Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand…

A: Now we will examine each part of the inventory policy computation in greater depth: (a) The EOQ, or…

Q: Use the ABC method of classifying inventory control over the items in the following inventory list.…

A: ABC classification is a type of inventory management technique in which items are grouped in A, B,…

Q: 1 A company decides to establish an EOQ for an item. The annual demand is 100,000 units. The…

A: Find the Given details below: Given details Annual Demand (D) 100000 Units Carrying (Holding)…

Q: You are running the supply chain for a grocery store operating across Upstate Soun Carolina. You…

A: Inventory management helps in determining the amount of stock that should be ordered and time of…

Q: What is the difference between independent and dependent demand items? Why is this distinction…

A: Dependent demand refers to the demand of products depend on the demand of other products. For…

Q: Demand is variable and the average demand is equal to 30 units per day, with a lead time standard…

A: Average daily demand (d) = 30 units Standard deviation of daily demand (d) = 5 units Lead time (L) =…

Q: An office supply store open five days a week must determine the best inventory policy for boxes of…

A: Find the given details below:

Q: a example 15.I Economic Order Quantity and Reorde nomic order quantity and the reorder point, given…

A: EOQ is short for Economic Order Quantity and gives the exact volume or number of products to reduce…

Q: Please show work so I can understand it. A company decides to establish an EOQ for an item. The…

A: A. Economic Order Quantity is abbreviated as EOQ. To cut down on holding and order costs, the…

Q: ABC shop uses glue at a daily rate that is normally distributed with a mean of 250 ounces and a…

A: ABC shop uses glue at a daily rate that is normally distributed with a mean of 250 ounces and a…

Q: 52 Demand for an item is 3,800 units per year. Each order placed costs $15; the annual cost to…

A: The main aim of the company should be to decrease the cost incurred in its operations. The cost…

Q: What is the economic order quantity?

A: The goal of the EOQ formula is to identify the optimal number of product units to order. If…

Q: You have an annual demand of 800 units of your product which you sell for $90 a unit. It costs you…

A: EOQ = √ [ 2*D*O / C ] Annual Demand D = 800 Order Cost O = 20 Carrying Cost C = 90*0.14 = 12.6

Q: Suppose that the R&B Beverage Company has a soft drink product that shows a constant annual demand…

A: Inventory Policy for R&B Beverage CompanyWe can find the following aspects of the inventory…

Q: Do you think the safety stock (safety inventory) could be negative? What is the meaning of a…

A: The term safety stock can be understood as the inventory which is kept as a buffer. It is the…

Q: Use ABC analysis to determine the items deserving mostattention and tightest inventory control

A: ABC analysis is a tool for classifying products based on their stock requirements. It's difficult to…

Question

4. (Inventory Management - Part 2) An item has a unit purchase cost of $50, and an inventory-carrying rate
per period of 0.02. The additional data for this product is given below:
Period
Demand (units)
Fixed Cost (S/order)
(i)
(ii)
1
75
100
2
0
110
3
65
100
Assuming no backordering is allowed, answer the followings:
(a) Check whether the demand is lumpy or not.
(b) Apply the following heuristics on the problem given above.
Period Order Quantity
4
40
105
5
90
100
Silver-Meal
(iii) Part-Period Balancing
(c) Which of the solutions obtained in part (b) do you select?
(d) Draw a network diagram to illustrate the given lot sizing problem, and calculate the cost values for each
are on the network.
(e) Apply the Wagner-Whitin algorithm to determine the optimal order quantities, the optimal inventory
levels, and the minimum sum of the ordering and inventory carrying costs.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: Introducing the question

VIEW

Step 2: Analyzing Demand Lumpiness

VIEW

Step 3: Implementing Inventory Management Heuristics

VIEW

Step 4: Choosing the Best Solution

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 5 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions

Please show work so I can understand it. Given this information: •Expected demand during lead time = 800 units • Standard deviation of lead time demand = 40 units Assuming that lead time demand is distributed normally. The risk of stockout is 5 percent during lead time (a) What amount of safety stock is appropriate? (b) Calculate ROP
Discuss what is meant by ABC analysis of inventory.Name several measures that can determine ABCstatus
A museum of natural history is having problems managing their inventories. Low inventory turnover is squeezing profit margins and causing cash-flow problems. A Class A item, a birdfeeder is also a top-selling item. See information for this item in the table below. Management has been ordering in lots of 390 units. 1) What is the annual cost of the current policy (hint: find the current total cost with the current order size, Q)? 2) What is the Economic Order Quantity or the optimum order quantity (EOQ) for the birdfeeders? 3) What is the total annual cost of ordering at the EOQ? How much could be saved if the museum ordered at the EOQ opposed to their current order size of 390 units? 4) When should the museum place an order, at how many units (i.e.: what is their reorder point or lead time demand)? Sales per week (demand) Purchase cost Order cost Annual holding cost Birdfeeder: Operating weeks per year Lead time for orders (weeks) Order size EOQ (calculated) 18 $ $ 60.00 45.00 25% of…
4
Please Show EVERY Working VERY Clearly! Calculate the Economic Order Quantity, Total Annual Cost, Reorder Point, and ADDITIONAL Annual Cost (using a GRAPH) if the Procurement Manager increase the order quantity by 25% from the above EOQ.
5
Your 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?
Suppose that we would like to determine Reorder Point for the product. From the historical data the manager determined demand during lead-time for that product fits Normal distribution with a mean of 200 and standard deviation of 10 products. The maximum stock out risk is 10%. Answer the following questions according to the (Q, R) system. a) Find the safety stock if the lead time is 2 weeks. b) Find the reorder point. c) Find the reorder point if the stock out risk decreases to 1%. Comment on the result.
For the most popular craft item at Hobbies & More has an annual demand of 3600. The lead time is 16 days and sigma of d is 8. What is the approximate Reorder point with safety stock if the desired service level is 90% (Z = 1.28 from Appendix A)? [Notes: H&M operates 300 days per year; round the answer to nearest whole number]. 197 216 144 233
Define each of the following in your own words and as a formula:a. Annual ordering cost.b. Annual carrying cost.c. Total annual cost.