Solved > Part 2. Questions 2-5 FX+ers/Mnmzm/OneDrive/ l20%ab/Continuous%20ReviewModel.pdfFixed Order Quantity modelExample 2:The Gulf Paper Company produces paper from wood pulp ordered froma lumber products firm. The paper company's daily demand for woodpulp is a eonstant 8,000 Kgs. Lead time is normally distributed, with anaverage of 7 days and a standard deviation of 1.6 days. The Companywishes to maintain a 90% service level.1. What size of safety stock should the company keep ?2. What is the reorder point?3. What would be the reorder point if the company want to limit theprobability of a stockout and work stoppage to 2%.Uncertain Demand and ncertain Lead Time Solved > Part 2. Questions 2-5 F Xrs/Mnmzm/OneDrive/ l20% /Continuous%20Review%20Model.pdfFixed Order Quantity modelExample 3:The Gulf Paper Company produces paper from wood pulp ordered froma lumber products firm. The paper company's daily demand for wood isnormally distributed with an average of 8000 Kg. and a standarddeviation of 450 Kg.Lead time is normally distributed, with an average of 7 days and astandard deviation of 1.6 days. The Company wishes to maintain a 90%service level.1. What size of safety stock should the company keep ?2. What is the reorder point?Expected ShortagepuaF12prt schomeF4

Name: Solved > Part 2. Questions 2-5 FX+ers/Mnmzm/OneDrive/ l20%ab/Continuo
Uploaded: 2024-03-20T06:57:05.000Z
Channel: Bartleby
Description: Solved > Part 2. Questions 2-5 FX+ers/Mnmzm/OneDrive/ l20%ab/Continuous%20ReviewModel.pdfFixed Order Quantity modelExample 2:The Gulf Paper Company produces paper from wood pulp ordered froma lumber products firm. The paper company's daily demand fo

Note: I have answered for 1st question (Example 2). Kindly post the next question separately.

Business

Operations Management

Example 2: The Gulf Paper Company produces paper from wood pulp ordered from a lumber products firm. The paper company's daily demand for wood pulp is a eonstant 8,000 Kgs. Lead time is normally distributed, with an average of 7 days and a standard deviation of 1.6 days. The Company wishes to maintain a 90% service level. 1. What size of safety stock should the company keep ? 2. What is the reorder point? 3. What would be the reorder point if the company want to limit the probability of a stockout and work stoppage to 2%.

Example 2: The Gulf Paper Company produces paper from wood pulp ordered from a lumber products firm. The paper company's daily demand for wood pulp is a eonstant 8,000 Kgs. Lead time is normally distributed, with an average of 7 days and a standard deviation of 1.6 days. The Company wishes to maintain a 90% service level. 1. What size of safety stock should the company keep ? 2. What is the reorder point? 3. What would be the reorder point if the company want to limit the probability of a stockout and work stoppage to 2%.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 14P

See similar textbooks

Similar questions

Quantity discounts. This type of problem can be recognized when a list showing prices for eachquantity range is given along with the basic EOQ information.a. If unit holding cost is constant, use these steps to solve the problem:1. Use Formula 13–2 to find Q.2. Locate Q in the price schedule.3. Compute TC using Formula 13–1 for Q and for all lower-cost price breaks.b. If unit holding cost is a percentage of unit price, use these steps to solve the problem:1. Beginning with the lowest cost, and using the corresponding H for that cost, compute Qusing Formula 13–2. Continue moving up in unit cost until a feasible Q is found.2. Locate the feasible Q in the price schedule.3. Compute TC using Formula 13–9 for Q and for all lower-cost price breaks. Remember to usethe corresponding H for each price.A small manufacturing firm uses roughly 3,400 pounds of chemical dye a year. Currently the firmpurchases 300 pounds per order and pays $3 per pound. The supplier has just announced that ordersof…
Omega DB Corp. has a policy of maintaining an inventory of finished goods equal to 40 percent of the next month’s budgeted sales. If Omega DB Corp. plans to produce 6,000 units in June, what are budgeted sales for July in units? Budgeted sales for the first six months of 2019 for Omega DB Corp. are listed below: Units:JANUARY 6,000FEBRUARY 7,000MARCH 8,000APRIL 7,000MAY 5,000JUNE 4,000
Forrest and Dan make boxes of chocolates for which the demand is uncertain. Forrest says, “That’s life.” On the other hand, Dan believes that some demand patterns exist that could be useful for planning the purchase of sugar, chocolate, and shrimp. Forrest insists on placing a surprise chocolatecovered shrimp in some boxes so that “You never know what you’ll get.” Quarterly demand (in boxes of chocolates) for the last 3 years follows: Quarter Year 1 Year 2 Year 3 1 2 3 4 3,000 1,700 900 4,400 3,300 2,100 1,500 5,100 3,502 2,448 1,768 5,882 Total 10,000 12,000 13,600 a. Use intuition and judgment to estimate quarterly demand for the fourth year.b. If the expected sales for chocolates are 14,800 cases for year 4, use the multiplicative seasonal method to prepare a forecast for each quarter of the year. Are any of the quarterly forecasts different from what you thought you would get in part (a)?
Instructions There are four parts to this problem. Use Excel to perform the following. a. Use the economic order quantity formula (EOQ = SQRT((2SD/H)) to determine the optimal number of units that the company should order based on each assumed level of order based on each assumed level of order quantities provided in the data. b. Complete the table by calculating the number of orders per year, annual order cost, annual holding cost, and annual total cost. Highlight the minimum annual total cost using conditional formatting. Hint: The minimum cost should equal the cost at the EOQ you calculated in part a. c. Create a line chart that graphs annual order cost, annual holding cost, and annual total cost. The x-axis should be the quantity ordered. Include a chart legend, appropriate chart title, axes labels, and properly formatted amounts on the axes. d. Examine the chart and your responses to parts a and b. Indicate any relationships.
Exercise 2: The demand per year (D) for product X is 12,100 units. The costs of placing an order (S) are $4.50. The unit cost (C) of the item is $25.00. The maintenance cost (H) per unit per year is 30% of the item's cost. 1. Use the economic order quantity (EOQ) model to determine: *Optimal quantity to order* The expected number of orders*Optimal time between orders*The total annual cost of maintaining that optimal amountNOTE: Show calculations of how you arrived at each amount 2. Answer, what are the potential benefits of using EOQ analysis for inventory management? How can you help businesses strike a balance between inventory holding costs and ordering costs?
c. Once you find the optimal order quantity i.e., EOQ, create a Data Table that generates inventory cost within ±100 units (with 10units increment) from the optimal order quantity. For example, if the EOQ=150, then you need to generate Data Table for inventory cost starting from 50 to 250 with 10 increments. Explain the exact steps completed in excel to create the data table d. Create a Scatter plot with “smooth lines” for the Data Table created in c) to show the inventory cost. Label your plot clearly (axis and title). The optimum order quantity should indicate the minimum cost in your plot.
A mail-order house uses 18,000 boxes a year. Carrying costs are 60 cents per box a year, andordering costs are $96. The following price schedule applies. Determine the following:a. The optimal order quantityb. The number of orders per yearNumber of Boxes Price per Box1,000 to 1,999 $1.25 2,000 to 4,999 1.205,000 to 9,999 1.1510,000 or more 1.10
The demand for a clothing brand is shown in the table below. The cost per order is about $4000. Cost of each unit of clothing = $5. Carrying cost percentage = 25% per item per 5 months. The analysis period = 5 month duration. Month Demand 1 400 2 300 3 200 4 400 5 500 a. Using this data, compute the solutions using the Lot for Lot and Periodic Order Quantity heuristics? Which of these heuristics would perform better and why? b. Assuming that the demand follows a normal distribution with the mean and variance from the data given above, determine the optimal order should be greater or lesser than the single period EOQ model.
XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 500 boxes (unit) per month. It costs OR 10 to make and receive an order and holding cost is OR 2.5 per box per year. The prices depend on quantities purchased such that the order quantities from 1 to 199 at price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. What is the Economic Order Quantity (EOQ) while not consider the purchase cost? Round - up to the nearest integer?? a. 199 units O b. None is correct 500 units d. 180 units e. 220 units
Open the A2 Liquor Company Excel file. Make the following changes: The profit for beer has increased to $6 per ton and its demand has increased to 5 tons per week. What is the profit under the optimal product mix? 14 12 18 16 Which of the following is an assumption of the basic fixed-order-quantity inventory model (for example, EOQ)? Ordering costs are variable. Lead times are constant. Lead times are unknown. Back-orders are allowed
A mail-order house uses 16,870 boxes a year. Carrying costs are 60 cents per box a year, and ordering costs are $96. The following price schedule applies. Number of BoxesPrice per Box1,000 to 1,999$1.25 2,000 to 4,9991.20 5,000 to 9,9991.15 10,000 or more1.10 a.Determine the optimal order quantity. (Round your answer to the nearest whole number.) Optimal order quantity5000 boxes b.Determine the number of orders per year. (Round your answer to 2 decimal places.) Number of order per year
Suppose this information is available for PepsiCo, Inc. for 2015, 2016, and 2017. (in millions) 2015 2016 2017 Beginning inventory $ 2,100 $ 2,400 $ 2,300 Ending inventory 2,400 2,300 2,700 Cost of goods sold 18,227 20,071 20,478 Sales revenue 39,145 42,957 44,066 Calculate the days in inventory for PepsiCo, Inc. for 2015, 2016, and 2017. (Round days in inventory to 1 decimal place, e.g. 5.1.) 2015 2016 2017 Days in inventory days