Homework Answers
| Week | Opening Stock | Supply | Demand | Closing Stock |
| 1 | 0 | 21 | 21 | 0 |
| 2 | 0 | 22 | 22 | 0 |
| 3 | 0 | 20 | 30 | -10 |
| 4 | -10 | 20 | 21 | -11 |
| 5 | -11 | 20 | 27 | -18 |
| 6 | -18 | 20 | 28 | -26 |
| 7 | -26 | 20 | 23 | -29 |
| 8 | -29 | 20 | 29 | -38 |
| 9 | -38 | 20 | 21 | -39 |
| 10 | -39 | 20 | 25 | -44 |
| 11 | -44 | 20 | 22 | -46 |
| 12 | -46 | 20 | 28 | -54 |
| 13 | -54 | 20 | 28 | -62 |
| 14 | -62 | 20 | 29 | -71 |
| 15 | -71 | 20 | 27 | -78 |
| 16 | -78 | 20 | 26 | -84 |
| 17 | -84 | 20 | 24 | -88 |
| 18 | -88 | 20 | 27 | -95 |
| 19 | -95 | 20 | 23 | -98 |
| 20 | -98 | 20 | 21 | -99 |
| Total | -990 | |||
| Total Shortage | -990 | |||
| Shortage Cost per week = $2.00 | ||||
| Total Shortage Cost = 990 * 2.00 | ||||
| = $ | 1980.00 | |||
Closing Stock = opening stock + Supply - Demand
Opening Stock = closing stock of last / previous week
Add Answer to:
Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel...
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...
need C, D, and F completed Use the Continuous Inventory Model and the data below to...
need C, D, and F completed
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...
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...
a large department store is using inventory models to control the replenishment of a particular model...
a large department store is using inventory models to control the replenishment of a particular model of Microwave ovens. The daily demand follows a normal distribution with a mean of 150 units and standard deviation of 16 units. The store pays $100 for each oven. Fixed costs of replenishment are $28. The accounting department recommends a 20% annual holding cost rate. Assume that the average lead time is 5 days with a standard deviation of 1 day. Assume 365 days a year. What is the...
Use the following information to answer questions 17-20. A large hospital uses a certain intravenous solution...
Use the following information to answer questions 17-20.
A large hospital uses a certain intravenous solution that it
maintains in inventory. Assume the hospital uses reorder point
method to control the inventory of this item. Pertinent data about
this item are as follows:
------------------------------------------------------------
Forecast of demanda = 1,000 units per week
Forecast errora, std. dev. =100 units per week
Lead time = 4 weeks
Carrying cost = 25 % per year
Purchase price, delivered = $52 per unit
Replenishment...
A production company A, made JITD strategic alliance with a distribution company B. The content of...
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 amount of starting inventory is 50 at Week 0 Inventory...
(8 points total) 5. The following questions involve inventory management using the demand data in the...
(8 points total) 5. The following questions involve inventory management using the demand data in the table below for 14 weeks (weeks 12-25 for the year) for one product. demand 12 13 14 15 16 17 18 19 20 21 35 40 20 30 35 45 30 23 24 25 30 25 35 Suppose inventory is managed with a continuous review system where the order size Q-200 and the reorder point R-160. The lead time is a constant 4 weeks....
Refer to the Excel speadsheet, "Inventory Management," to complete the "Analytics Exercise: An MRP Explosion -...
Refer to the Excel speadsheet, "Inventory Management," to
complete the "Analytics Exercise: An MRP Explosion - Brunswick
Motors," at the end of Chapter 21 in the textbook. Answer Questions
1-3.
Given Spread Sheet: A-Topic 3 Part 1&2
AND A-Topic 3 Part 3
Please use given information, show formulas/
calculations, and give reasons behind answer.
Part 2 Gear Box Given Information Setu Invento Number of orders (count cells with values for planned order release Set-up Costs=# of Orders X Setup Costs 8...
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...
Dumoor Appliance Center sells and services several brands of major appliances. Past sales for a particular...
Dumoor Appliance Center sells and services several brands of major appliances. Past sales for a particular model of refrigerator have resulted in the following probability distribution for demand: Demand per week 0 1 2 3 Probability 0.10 0.40 0.40 0.10 The lead time, in weeks, is described by the following distribution: Lead Time (weeks) 1 2 3 Probability 0.15 0.80 0.05 Based on the cost considerations as well as storage space, the company has decided to order 6 of these...
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...
need C, D, and F completed
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...
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 following information to answer questions 17-20.
A large hospital uses a certain intravenous solution that it
maintains in inventory. Assume the hospital uses reorder point
method to control the inventory of this item. Pertinent data about
this item are as follows:
------------------------------------------------------------
Forecast of demanda = 1,000 units per week
Forecast errora, std. dev. =100 units per week
Lead time = 4 weeks
Carrying cost = 25 % per year
Purchase price, delivered = $52 per unit
Replenishment...
(8 points total) 5. The following questions involve inventory management using the demand data in the table below for 14 weeks (weeks 12-25 for the year) for one product. demand 12 13 14 15 16 17 18 19 20 21 35 40 20 30 35 45 30 23 24 25 30 25 35 Suppose inventory is managed with a continuous review system where the order size Q-200 and the reorder point R-160. The lead time is a constant 4 weeks....
Refer to the Excel speadsheet, "Inventory Management," to
complete the "Analytics Exercise: An MRP Explosion - Brunswick
Motors," at the end of Chapter 21 in the textbook. Answer Questions
1-3.
Given Spread Sheet: A-Topic 3 Part 1&2
AND A-Topic 3 Part 3
Please use given information, show formulas/
calculations, and give reasons behind answer.
Part 2 Gear Box Given Information Setu Invento Number of orders (count cells with values for planned order release Set-up Costs=# of Orders X Setup Costs 8...
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...
Most questions answered within 3 hours.
-
1. Review the Nike’s marketing strategy. You must include the
company’s target market, possible market segmentation,...
asked 2 minutes ago -
One of the major advantages of ______________ is to enhance
security for private networks by keeping...
asked 8 minutes ago -
Book:
Title: Framework for
Marketing Management, 15th edition
Author/s: Philip T.
Kotler, Kevin Lane Keller
1....
asked 17 minutes ago -
Given Uber’s recent corporate turbulence and ongoing
initiatives, provide a holistic situational analysis of the
environment...
asked 20 minutes ago -
A sculptor has hung up a 42.0 kg horizontal rod of length 4.80 m
. One...
asked 23 minutes ago -
What is the purpose of the 2' hydroxyl group in RNA? What is
the reason this...
asked 41 minutes ago -
You currently have 20,000X ethidium bromide. You want to make
250 mL of 1X ethidium bromide...
asked 54 minutes ago -
What mass of lead is needed to absorb 348 J of heat if the temp
of...
asked 57 minutes ago -
Explain the difference between an auction with reserve
and an auction without reserve. if not specified,...
asked 59 minutes ago -
Write the net ionic equation for the precipitation reaction that
occurs when aqueous solutions of aluminum...
asked 1 hour ago -
How do we find the slope distance, given the horizontal distance
and the zenith angle?
For...
asked 1 hour ago -
The table to the right lists probabilities for the corresponding
numbers of girls in three births....
asked 1 hour ago