Homework Answers
Reorder point = 160
Order size = 200
Lead time = 4 weeks
We update the table given in question based on data given, we get
As seen from above table, we answer the questions
a) The next order is 200 units as shown in table and as given in question.
b) The next order is in end of week 19
c) The next order after the 1st one is in end of week 25
Add Answer to:
(8 points total) 5. The following questions involve inventory management using the demand data in the...
Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel...
Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Additional Data are given below. Inventory Cost/Week = $ 1.00 Shortage Cost/Week = $ 2.00 Lead Time = 2 weeks Beginning Stock on Hand (SOH) = 0 Supply in Week 1 = 21 units Supply in Week 2 = 22 units What is the total shortage cost at the end of 20...
Given the following information, formulate a continuous-review inventory management system. The item is demanded 50 weeks...
Given the following information, formulate a continuous-review inventory management system. The item is demanded 50 weeks a year. 2. Item cost Order cost Annual holding cost (%) Annual demand Average demand $20 $250 10% df item cost 25,000 500 per week Standard deviation of weekly demand Lead time Service probability 25 per week 1 week 95% Compute the order quantity and reorder point. For the order quantity, please provide at least one step of calculation and the correct answer for...
Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of...
Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 64 gallons of Green Paint every week (for 52 weeks per year). They purchase Green Paint from their supplier at a price of $3.50 per gallon. [The company does not hold Safety Stock] It takes 2.25 weeks to receive an order...
A firm is operating a fixed inventory system. One product has the following characteristics: Order cost...
A firm is operating a fixed inventory system. One product has the following characteristics: Order cost $35/order Unit cost $15/unit Holding cost/unit/year 20% of unit cost Annual demand 1800 Lead time 2 weeks Answer the following questions: a. What is the optimal order quantity, EOQ? b. What is the total annual inventory cost? c. If management decides to use order size of 400 rather than the EOQ, what will be the impact on total cost? (Calculate) c. If demand is...
A golf specialty wholesaler operates 350 days per year. Management is trying to determine an inventory...
A golf specialty wholesaler operates 350 days per year. Management is trying to determine an inventory policy for its 1-irons. The cost to place orders with the supplier is $25/order; the demand averages 12,000 items per day, with a standard deviation of 3,000 item. The annual inventory holding cost is $2.00 per item. The lead time form the supplier is 5 days, with a standard deviation of 2 days. It is important to maintain a 95 percent cycle-service level to...
can you show how to do this work Question 13 Using a computerized Inventory Management System,...
can you show how to do this work
Question 13 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores X and their distribution warehouse. The Paint Supply Store franchise sells an average of 74 gallons of Purple Paint every week (for 52 weeks per year, Standard Deviation of the Demand - 8 gallons). They purchase Purple Paint from their supplier at a price...
3:01 AM Thu Jan 16 85% 5 TODO + BO Assignment 2 Name: Problem 1 A...
3:01 AM Thu Jan 16 85% 5 TODO + BO Assignment 2 Name: Problem 1 A production company A, made JITD strategic alliance with a distribution company B. The content of alliance is, Company A executes work for company B's inventory management and all the inventory cost caused from B is responsible on A. The decision for inventory replenishment is made on every Saturday, An order quantity is arrived every Sunday night after the delivery-process from A to B. The...
Use the Continuous Inventory Model and the data below to answer these six questions. Forecast of...
Use the Continuous Inventory Model and the data below to answer these six questions. Forecast of demanda = 36,000 units per week Forecast error, std. dev. = 800 units per week Lead time = 2.5 weeks Lead time error, std. dev = 1.2 weeks Carrying cost = 20% per year Purchase price, delivered = $65 per unit Replenishment order cost = $2,000 per order Stockout cost - $2 per unit EOQ = 24,000 units In-stock Probability during the lead time...
Scenario 1 You are the operations manager of a firm that uses the continuous inventory control...
Scenario 1 You are the operations manager of a firm that uses the continuous inventory control system. Suppose the firm operates 50 weeks a year, 350 days, and has the following characteristics for its primary item: Demand = 500 units/week Price paid to supplier = $160/unit Ordering cost = $80/order Holding cost = $16/unit/year Lead time = 1.5 weeks Standard deviation in weekly demand = 36 units Use the information in Scenario 1. Which of the following changes would result...
Surved Help Sove & Exit Given the following information, formulate an inventory management system. The item...
Surved Help Sove & Exit Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual deland Average Keekly demand VALUE $ 7.00 $283.ee 32% of item cost 22,100 442 per week PARAMETER Standard deviation of weekly demand Lead time Service probability VALUE 20 per week 1 week 95% a. Determine the order quantity and reorder point (Use Excel's NORM.S.INV() function to find the z...
Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Additional Data are given below. Inventory Cost/Week = $ 1.00 Shortage Cost/Week = $ 2.00 Lead Time = 2 weeks Beginning Stock on Hand (SOH) = 0 Supply in Week 1 = 21 units Supply in Week 2 = 22 units What is the total shortage cost at the end of 20...
Given the following information, formulate a continuous-review inventory management system. The item is demanded 50 weeks a year. 2. Item cost Order cost Annual holding cost (%) Annual demand Average demand $20 $250 10% df item cost 25,000 500 per week Standard deviation of weekly demand Lead time Service probability 25 per week 1 week 95% Compute the order quantity and reorder point. For the order quantity, please provide at least one step of calculation and the correct answer for...
Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 64 gallons of Green Paint every week (for 52 weeks per year). They purchase Green Paint from their supplier at a price of $3.50 per gallon. [The company does not hold Safety Stock] It takes 2.25 weeks to receive an order...
A firm is operating a fixed inventory system. One product has the following characteristics: Order cost $35/order Unit cost $15/unit Holding cost/unit/year 20% of unit cost Annual demand 1800 Lead time 2 weeks Answer the following questions: a. What is the optimal order quantity, EOQ? b. What is the total annual inventory cost? c. If management decides to use order size of 400 rather than the EOQ, what will be the impact on total cost? (Calculate) c. If demand is...
A golf specialty wholesaler operates 350 days per year. Management is trying to determine an inventory policy for its 1-irons. The cost to place orders with the supplier is $25/order; the demand averages 12,000 items per day, with a standard deviation of 3,000 item. The annual inventory holding cost is $2.00 per item. The lead time form the supplier is 5 days, with a standard deviation of 2 days. It is important to maintain a 95 percent cycle-service level to...
can you show how to do this work
Question 13 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores X and their distribution warehouse. The Paint Supply Store franchise sells an average of 74 gallons of Purple Paint every week (for 52 weeks per year, Standard Deviation of the Demand - 8 gallons). They purchase Purple Paint from their supplier at a price...
3:01 AM Thu Jan 16 85% 5 TODO + BO Assignment 2 Name: Problem 1 A production company A, made JITD strategic alliance with a distribution company B. The content of alliance is, Company A executes work for company B's inventory management and all the inventory cost caused from B is responsible on A. The decision for inventory replenishment is made on every Saturday, An order quantity is arrived every Sunday night after the delivery-process from A to B. The...
Use the Continuous Inventory Model and the data below to answer these six questions. Forecast of demanda = 36,000 units per week Forecast error, std. dev. = 800 units per week Lead time = 2.5 weeks Lead time error, std. dev = 1.2 weeks Carrying cost = 20% per year Purchase price, delivered = $65 per unit Replenishment order cost = $2,000 per order Stockout cost - $2 per unit EOQ = 24,000 units In-stock Probability during the lead time...
Surved Help Sove & Exit Given the following information, formulate an inventory management system. The item is demanded 50 weeks a year. PARAMETER Item cost Order cost Annual holding cost Annual deland Average Keekly demand VALUE $ 7.00 $283.ee 32% of item cost 22,100 442 per week PARAMETER Standard deviation of weekly demand Lead time Service probability VALUE 20 per week 1 week 95% a. Determine the order quantity and reorder point (Use Excel's NORM.S.INV() function to find the z...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago