Reference no: EM131004219
I need to answer the assignment using excel the formulas have to be clear and the excel sheet has to be neat with final solutions highlighted box.
1. Weekly demand for Motorola cell phones at a Best Buy store is normally distributed, with a mean of 300 and a standard deviation of 200. Motorola takes two weeks to supply a Best Buy order. Best Buy is targeting a CSL of 95 percent and monitors its inventory continuously. How much safety inven-tory of cell phones should Best Buy can-y? What should its ROP be?
2. Assume that the Best Buy store in Exercise 1 has a policy of ordering cell phones from Motorola in lots of 500. Weekly demand for Motorola cell phones at the store is normally distributed, with a mean of 300 and a standard deviation of 200. Motorola takes two weeks to supply an order. If the store manager is targeting a fill rate of 99 percent, what safety inventory should the store carry? What should its ROP be?
3: Weekly demand for HP printers at a Sam's Club store is normally distributed, with a mean of 250 and a standard deviation of 150. The store manager continuously monitors inventory and currently orders 1,000 printers each time the inventory drops to 600 printers. HP currently takes two weeks to fill an order. How much safety inventory does the store carry? What CSL does Sam's Club achieve as a result of this policy? What fill rate does the store achieve?
Question 1: Evaluating Safety Inventory Given an Inventory Policy
Assume that weekly demand for phones at B&M Office Supplies is normally distributed, with a mean of 2,500 and a standard deviation of 500. The manufacturer takes two weeks to fill an order placed by the B&M manager. The store manager currently orders 10,000 phones when the inventory on hand drops to 6,000. Evaluate the safety inventory and the average inventory carried by B&M. Also evaluate the average time a phone spends at B&M.
Question 2: Evaluating Fill Rate Given a Replenishment Policy
Sample 12-2, recall that weekly demand for phones at B&M is normally distributed, with 3 mean of 2,500 and a standard deviation of 500. The replenishment lead time is two weeks. Assume that the demand is independent from one week to the next. Evaluate the fill rate resulting from the policy of ordering 10,000 phones when there are 6,000 phones in inventory.
Question 3: Evaluating Safety Inventory Given a Desired Cycle Service Level
Weekly demand for Legos at a Wal-Mart store is normally distributed. with a mean of 2.500 boxes and a standard deviation of 500. The replenishment lead time is two week,. Assuming a continuous¬resiew replenishment policy, evaluate the safety inventory that the store should carry to achieve a CSL of 90 percent.
|
Find the marginal revenue for first plant
: A pharmaceutical corporation has two plants that produce the same over-the-counter medicine. Find the marginal revenue for plant 1, and the marginal revenue for plant 2, ∂R/∂x1.
|
|
What are the highlights and limitations of the theory
: Which theorist "fathered" the principle? What were the signs of the time which led the theorist to develop the management concept? What are the highlights and limitations of the theory/principle
|
|
Importance of literature in history and culture
: Review and reflect on the knowledge you have gained from this course. Based on your review and reflection, write 300-500 words on one of the following: The importance of literature in history and culture How the literary canon has changed in modern..
|
|
Find the page where bond activity is reported
: If you have access to the Interactive Edition of the Wall Street Journal, you can use the Briefing Books feature to obtain data on over 10,000 public companies. Use this feature to locate the briefing book on a large commercial bank in your area. ..
|
|
Evaluate the safety inventory and the average inventory
: Evaluate the safety inventory and the average inventory carried by B&M. Also evaluate the average time a phone spends at B&M.
|
|
Determine effect electronic banking having on fed ability
: The Journal of Internet Banking and Commerce at http://www.arraydev.com/ commerce/JIBC/current.asp is a Web-based magazine devoted to Internet banking and related issues.Take a look at the current edition and see whether you can determine what eff..
|
|
Identify the components of a complete job analysis
: Identify the components of a complete job analysis (job content, requirements, competencies, compensation) and explain how the different parts of an integrated staffing management system contributes to each component
|
|
How fast is the height of the water increasing
: A cylindrical tank with radius 7m is being filled with water at a rate of 2 m3/min. How fast is the height of the water increasing?
|
|
Describe the motivation of the change management strategy
: Describe the motivation of the change management strategy. Describe the alignment of the change management strategy with the achievement of business, organizational, and cultural goals
|