This problem is based on the classic order-up-to-level (M.L) inventory policy with a reorder point (L),...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This problem is based on the classic order-up-to-level (M.L) inventory policy with a reorder point (L), a maximum inventory level (M), random demand, and random lead time. A company is selling a non-perishable item. Consider an (M,L) inventory system, in which the procurement quantity Q is defined by Q = {M (M-I if I<L if IZL I is the inventory on hand plus on order at the end of a month M is the maximum inventory level L is the reorder point Use simulation to investigate an (M,L) inventory system with the following properties: The inventory position is reviewed at the end of each month (fixed review) 1 2 3 4 Backordering is allowed at a cost of $4 per item short each month When an order arrives, it will first be used to relieve the backorder. Lead time is uniformly distributed on the interval [0.25, 1.25]. Beginning inventory is 50 units and there are no orders outstanding. Holding costs are $1 per unit in inventory per month. When an order is placed, its cost is $60 + $5Q where $60 is the ordering cost and $5 is the cost of the item. The time between demands is exponentially distributed with a mean of 1/15 month. The size of demands follows this distribution: Demand Probability 0.5 0.25 0.125 0.125 (a) Create a simulation model to evaluate the above inventory problem. (b) Make ten independent replications, each of run length 100 months preceded by a 12 month initialization period, for the (M, L) = (50, 30) policy. (Hint: Run each individual simulation trial using the "One Trial" worksheet in the Example2.8RefrigInventory spreadsheet.) Record each of the ten independent replication results for average ending inventory, average units ordered per month, and average monthly costs. Adjust worksheet graph as needed to reflect average monthly inventory frequencies. (c) Estimate long-run mean monthly cost with a 95% confidence interval. (d) Using the results of part (a) and (b), estimate the total number of replications needed to estimate mean monthly cost within $4. This problem is based on the classic order-up-to-level (M.L) inventory policy with a reorder point (L), a maximum inventory level (M), random demand, and random lead time. A company is selling a non-perishable item. Consider an (M,L) inventory system, in which the procurement quantity Q is defined by Q = {M (M-I if I<L if IZL I is the inventory on hand plus on order at the end of a month M is the maximum inventory level L is the reorder point Use simulation to investigate an (M,L) inventory system with the following properties: The inventory position is reviewed at the end of each month (fixed review) 1 2 3 4 Backordering is allowed at a cost of $4 per item short each month When an order arrives, it will first be used to relieve the backorder. Lead time is uniformly distributed on the interval [0.25, 1.25]. Beginning inventory is 50 units and there are no orders outstanding. Holding costs are $1 per unit in inventory per month. When an order is placed, its cost is $60 + $5Q where $60 is the ordering cost and $5 is the cost of the item. The time between demands is exponentially distributed with a mean of 1/15 month. The size of demands follows this distribution: Demand Probability 0.5 0.25 0.125 0.125 (a) Create a simulation model to evaluate the above inventory problem. (b) Make ten independent replications, each of run length 100 months preceded by a 12 month initialization period, for the (M, L) = (50, 30) policy. (Hint: Run each individual simulation trial using the "One Trial" worksheet in the Example2.8RefrigInventory spreadsheet.) Record each of the ten independent replication results for average ending inventory, average units ordered per month, and average monthly costs. Adjust worksheet graph as needed to reflect average monthly inventory frequencies. (c) Estimate long-run mean monthly cost with a 95% confidence interval. (d) Using the results of part (a) and (b), estimate the total number of replications needed to estimate mean monthly cost within $4.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these mathematics questions
-
make a progress report on python network automation for a university Report Layout and Report Compilation Project Progress Summary Milestones Issues and Recommendations References
-
Please help with the discusin questions ! I give thumbs up Case #1: Hailing a New Era: Haier in Japan As one of the most valuable brands in China, Haier designs,manufactures, and sells various home...
-
THE SHOPPES AT RIVERSIDE Fonda L. Carter, Columbus State University Kirk Heriot, Columbus State University CASE DESCRIPTION This case asks the students to recommend a decision to a group of...
-
What is the asset-liability time mismatch that all banks face?
-
What are the two distinct elements of owners equity in a corporation? Define each element.
-
Creative Dangles is an earring design and manufacturing company. The production function for earrings is Q=25KL, where Q = pairs of earrings per week, K = hours of equipment used, and L = hours of...
-
P 20 Use the Standard Normal Table or technology to find the z-score that corresponds to the cumulative area or percentile. Table 4-Standard Normal Distribution Arca Z 0 Z .09 .08 .07 .06 .05 .04 .03...
-
The partnership of Angel Investor Associates began operations on January 1, 2012, with contributions from two partners as follows: Scott Wilson ... $120,000 Michael Goforth .. 80,000 The following...
-
Managers have to be prepared to lead their organizations through varying economic conditions. Explain why it is important to understand GDP data, and how changes inunemployment and inflation impact...
-
Managers at DeJohn Corporation are analyzing a potential investment of $2,000,000 in equipment and the processes needed to manufacture and market MyHelperBotz, a product line of robots designed to...
-
Alex, single, earns wags of $42,000 in 2026. He also conducts an activity that produces the following revenues and expenses: Revenues $18,000 Expenses Property taxes 3,000 Materials and supplies...
-
This year Carla received corporate stock worth $35,000 as a gift from her grandfather. Her grandfather originally had purchased the stock in 2012 at a cost of $20,000. No gift taxes were paid on the...
-
Identify an investment decision that you, someone you know, or someone fictitious has made (for example, stocks, bonds, real estate, a car, a house, a degree or certificate, et cetera): Buying a...
-
When analyzing a system in static equilibrium that has the potential to rotate, what is your problem-solving process? Please state the steps that you take to solve for, say, a missing force.
-
Rocco operates a beauty salon as a sole proprietorship. Rocco also owns and rents an apartment building. In 2 0 2 3 , Rocco had the following income and expenses. You may assume that Rocco will owe $...
-
Alissa has the following income and expenses for the year: Income Salary $50,000 Interest income $350 Canadian Eligible Dividend income $500 Capital Gains $1,700 Expenses RRSP contribution...
-
Study internal and external environment of the organization, and provide reasonable estimates or calculations of market potential, market demand, and company demand. What are the characteristics of...
-
DEPARTMENT DATA EMPLOYEE DATA EmployeeNumber FirstName Mary Rosalie Richard George Alan 3 4 5 7 8 9 855555ES 12 13 14 15 16 17 Create the database tables in SQL or ACCESS: 18 19 20 PROJECT DATA Ken...
-
Explain the GPC backup technique. Is it used for sequential files or direct access techniques? Explain.
-
Define general controls.
-
What is an XBRL tag?
-
Apple stock is selling for \($120\) per share. Call options with a \($117\) exercise price are priced at \($12.\) What is the intrinsic value of the option, and what is the time value?
-
Ibrahim bought 200 shares of a stock trading in the Abu Dhabi Securities Exchange at AED 12 (United Arab Emirates dirham) per share. Over time, the price of the stock increased to AED 18 per share....
-
Twitter is trading at \($34.50.\) Call options with a strike price of \($35\) are priced at \($2.30\) . What is the intrinsic value of the option, and what is the time value?
Study smarter with the SolutionInn App