A retailer has 7 stores in different cities in northern Ontario. The weekly demand for each store follows the normal distribution with a mean value of 60 and a standard deviation of 10. The retailer is planning to use a single centralized store in northern Ontario and they think the demand in the single store will be equal to the sum of the demand in all 7 cities. It takes 3 weeks for the supplier to send the products to the retailer. Calculate the safety stock for the centralized and decentralized cases if the correlation of demands between different cities is 0.3. Assume the planned customer service level is 98%. Please post answer in excel showing formula and answer
Q: (i) (ii) (iii) (iv) What is the optimal sequence? Draw the time-phased chart. What is the total…
A: Sequencing is an appropriate order of plan as per which the process of operations works. It defines…
Q: Provide two prescriptive analytics techniques as related to supply chain management. What would be…
A: In this Q, I would describe two prescriptive analytics techniques which are strongly related to SCM,…
Q: Apple Inc. is one of the world's largest technology companies, with annual revenue more significant…
A: Introduction- Outsourcing has most certainly become noticeable in the realm of information…
Q: What are the typical components of ERP systems?
A: Enterprise resource planning (ERP) is that management software which helps in integrating all the…
Q: While analyzing their annual sales data (liters of wine sold per year) for the past 30 years, a…
A: The regression equation is a mathematical tool used to predict the value of one variable based on…
Q: abc
A: ABC Classification:- ABC (Always-Better-Control) analysis is a technique that sorts inventory based…
Q: In what ways may CAD, CAE, and CAM work together to aid in the product development process?
A: CAD (Computer-Aided Design), CAE (Computer-Aided Engineering), and CAM (Computer-Aided…
Q: Six ships are docked in a harbor awaiting unloading. The times required to unloadthe ships are…
A:
Q: Which primary information security responsibilities would you recommend assigning to a smaller…
A: ANSWER : For a smaller business with just three full-time positions and two or three part-time…
Q: Formulate the LP and then use the graphical 2D method to solve Corner points of the feasible region:…
A: I would formulate the LP, then, I would solve this LP using the graphical method, The LP…
Q: overall mean service level for Purchase Requests.
A: Mean Sim1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Sim 30…
Q: How do I Calculate the total cost of ownership for each supplier? Image of the table is available…
A: Given-
Q: ollowing is a list of tasks to be performed in preparation for a camping trip. Draw a WBS that…
A: A work breakdown structure (WBS) is a tool used in project management to break down a project into…
Q: wolfgang-keller-at-konigsbrau-tak-case study analysis.
A: There was tension between Dmitri Brodsky, the subsidiary's commercial director, and Wolfgang Keller,…
Q: O (4.0, 5.0, 2.25, 0.5)
A: There is following relationship between primal and dual
Q: Discuss the external analysis of Amazon related to how the company is using Blue Ocean Strategy.
A: Blue ocean strategy can be defined as a simultaneous pursuit of high product differentiation and low…
Q: Hannah Byers and Kathleen Taylor are considering the possibility of teaching swimming to kids during…
A: Breakeven point = Fixed cost / Contribution margin Contribution margin = Selling price - Variable…
Q: UCLp = enter your response here (enter your response as a number between 0 and 1, rounded to…
A: Control charts are also known as process-behavior charts. It is a statistical process that helps in…
Q: Manually apply the Hungarian algorithm to solve the assignment problem having the following cost…
A: Introduction to concept- The Hungarian technique is a straightforward approach of resolving…
Q: (a) Determine the cost of each subplan that is possible in this problem (i.e., g(s, t) for s = 1, 2,…
A:
Q: What is the mission and vision of an organization into attainable goals for employees?
A: ANSWER : An organization's mission and vision provide a framework for setting attainable goals for…
Q: It is requested on the basis of the above facts to calculate the cost of the fixed assets and their…
A: Given Data 10-01-2020 Item Cost (Euro) Type of Expense Land Purchase in Cash…
Q: anagers who want to enhance the comparability and comprehension of performance analysis results have…
A: Balanced Scorecard (BSC) is an organizational tool to measure performance and progress toward…
Q: e.) Explain the principles for how these costs are distributed between the Owners of Evita, Gard P &…
A: Evita had P & I Insurance and Hull insurance with Gard and Loss of Hire Insurance (LoH) with…
Q: Case Project 3 Case Project: Think of all the tasks that you perform when you purchase a car.…
A: Estimate duration: 1. Compare different cars or models (Estimated Duration = 2 Days) 4. Discuss…
Q: When looking to purchase new technology or upgrade existing systems, hotel management prioritizes…
A: Purchase of New Technology/up-gradation of technology can be defined as a strategic step to adapt to…
Q: What would the ROI be when using a room service robot in a hotel
A: Meaning of ROI- Return on Investment (ROI)means the monetary advantage you get from an investment…
Q: Some organizations include their vision statement and or values on employee ID badges. How does…
A: The broad definition of organizational culture encompasses all of a company's beliefs, values, and…
Q: Formulate this problem as a linear programming problem.
A: Let A1 be the number of type 1 trucks transported to City A Let A2 be the number of type 2 trucks…
Q: 1) The manufacturer only has 10lbs of each type of meat left and wants to maximize the number of…
A:
Q: Problem 5-12 A manager must decide how many machines of a certain type to purchase. Each machine can…
A: Given- Machine capacity = 100 customers/dayOne Machine Fixed cost = $2100 per dayTwo Machine Fixed…
Q: Mixed Inventory Criteria: Identify and explain, which would be the best approach to have a mix of a…
A: A mix of JIT and Buffer Inventory Strategy can be termed as Mixed Inventory Strategy. JIT:- JIT…
Q: Complete the table below and to predict the demand for Period 5 (See image).…
A: Here, First, I would apply the method-exponential smoothing with the trend adjustment, next, I would…
Q: Why is it important to give a strategic approach to communication in companies? Define in your…
A: Because it increases employee morale, engagement, performance, as well as happiness, communication…
Q: total amount of each asset
A: Hi Based on Fixed cost (one time investment) and Variable/recurring (each time money is needed) I…
Q: In the following table the activities with their precedence sequence and expected time (weeks) are…
A: Given- Activity Nodes Time (weeks) J 1-2 12 K 1-3 8 L 2-4 6 M 2-3 3 N 3-4 2 O 4-5 7…
Q: Define maximum probable yearly aggregate loss (MPY) and estimated maximum loss (EML) and describe…
A: Maximum Probable Yearly Aggregate Loss (MPY) Maximum Probable Yearly Aggregate Loss can be defines…
Q: in two types 3. A trust fund is planning to invest up to Php of bonds.: A and B. Bond A is safer…
A: Linear programming is a mathematical technique that is commonly used in operations management…
Q: Part 2 a) Using a 2-year moving average, the forecast for year 6 = 37753775 miles (round your…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: What does the First Amendment protect regarding religion? Pick two choices. A. It protects the…
A: Ans) First Amendment has two provisions. These 2 provisions are : 1) Establishment Clause 2) Free…
Q: One must ask: "Why is it so important that coding staff productivity compliance be maintained…
A: The information life cycle is an important concept that describes the stages of a piece of…
Q: What is the project management triangle? Own words please.
A: Project management is the management in which a particular type of skills, techniques, and equipment…
Q: Terminology Matching Continued FASB Comparability Verifiable Consistency Free Cash Flow Chart of…
A: Accounting is a system that not only records and summarizes all the business and financial…
Q: Discuss the key distinctions between the supply networks of service providers and those of…
A: Supply networks are an integral part of the global economy. They enable companies to source and…
Q: Differentiate between disruptive goods and disruptive processes using Uber as an example
A: Disruptive goods and disruptive processes are two types of disruptive innovation that can change the…
Q: Calculate the water activity of the brand at this elevated temperature and comment on it’s…
A: The net isosteric heats (Qst, kJ mol−1) have been calculated using Clausius–Clapeyron equation. At…
Q: What is the net impact of the firm’s implementation of its value analysis and business process…
A: Business process reengineering is the process of designing core business processes to achieve the…
Q: If the consulting firm could supply an accurate report, determine how much PlacePlus should be…
A:
Q: What are the management Philosophies that emerged and influence the current personnel…
A: NOTE: We are allowed to do one question only at a time. Management philosophies are the set of…
Q: Determine the average lead time for all four part styles (hours, 2 decimal points).
A:
A retailer has 7 stores in different cities in northern Ontario. The weekly demand for each store follows the
Please post answer in excel showing formula and answer
Step by step
Solved in 3 steps with 2 images
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever a new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. The lead time to get the order in seven days.a. What is the economic order quantity?b. What is the reorder point?Retailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must ensure that numbers are correct for stock on-hand and then phone in a new order. The total cost involved to place an order is about $5. RW figures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year. Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days. What is the economic order quantity? Note: Round your answer to the nearest whole number. What is the reorder point? Note: Use Excel's NORM.S.INV() function to find the z value. Round z…
- Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. -Calculate the item's EOQ. - Use the EOQ to define the parameters of an appropriate continuous review and periodie review system for this item. -Which system requires more safety stock and by how much? -How do you think each system can affect your procurement procedures/methods?Your firm uses a periodic review system for all SKUS classified, using ABC analysis, as B or C items. Further, it uses a continuous review system for all SKUS classified as A items. The demand for a specific SKU, currently classified as an A item, has been dropping. You have been asked to evaluate the impact of moving the item from continuous review to periodic review. Assume your firm operates 52 weeks per year; the item's current characteristics are: Demand (D) = 15,080 units/year Ordering cost (S) = $125.00/order Holding cost (H) = $3.00/unit/year Lead time (L) = 5 weeks Cycle service level = 95 percent Demand is normally distributed, with a standard deviation of weekly demand of 64 units. 1- How do you think each system can affect your procurement procedures/methods?Consider the supply chain illustrated below: Manufacturer Distributor Wholesaler Retailer Last year the retailer's weekly variance of demand was 190 units. The variance of orders was 490, 610, 730, and 1,320 units, for the retailer, wholesaler, distributor, and manufacturer, respectively. (Note that the variance of orders equals the variance of demand for that firm's supplier.) a) The bullwhip measure for the retailer is decimal places.) b) The bullwhip measure for the wholesaler is two decimal places.) (Enter your response rounded to two (Enter your response rounded to c) The bullwhip measure for the distributor is ☐. (Enter your response rounded to two decimal places.) d) The bullwhip measure for the manufacturer is two decimal places.) e) In this supply chain, the bullwhip effect. (Enter your response rounded to appears to be contributing the most to the
- Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.30 a copy. You sell a copy of San Pedro Times for $1.10. Daily demand is distributed normally with mean = 265 and standard deviation = 53. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) Optimal order quantity b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) ProbabilityRetailers Warehouse (RW) is an independent supplier of household items to department stores. RW attempts to stock enough items for a 98 percent service probability. A stainless steel knife set is one item it stocks. Demand (2,400 sets per year) is relatively stable over the entire year. Whenever new stock is ordered, a buyer must assure that numbers are correct for stock on hand and then phone in a new order. The total cost involved to place an order is about $5. RW i gures that holding inventory in stock and paying for interest on borrowed capital, insurance, and so on, add up to about $4 holding cost per unit per year.Analysis of the past data shows that the standard deviation of demand from retailers is about four units per day for a 365-day year. Lead time to get the order is seven days.a. What is the economic order quantity?b. What is the reorder point?Consider the supply : Last year, the retailer’s weekly variance of demand was 200 units.The variance of orders was 500, 600, 750, and 1,350 units for theretailer, wholesaler, distributor, and manufacturer, respectively.(Note that the variance of orders equals the variance of demandfor that firm’s supplier.)a) Calculate the bullwhip measure for the retailer.b) Calculate the bullwhip measure for the wholesaler.c) Calculate the bullwhip measure for the distributor.d) Calculate the bullwhip measure for the manufacturer. e) Which firm appears to be contributing the most to the bull-whip effect in this supply chain?
- Last year the retailer's weekly variance of demand was 190 units. The variance of orders was 480, 590, 730, and 1,380 units, for the retailer, wholesaler, distributor, and manufacturer, respectively (Note that the variance of orders equals the variance of demand for that firm's supplier) a) The bullwhip measure for the retailer is. (Enter your response rounded to two decimal places) b) The bullwhip measure for the wholesaler is c) The bullwhip measure for the distributor is (Enter your response rounded to two decimal places) (Enter your response rounded to two decimal places) d) The bullwhip measure for the manufacturer is (Enter your response rounded to two decimal places) e) In this supply chain, the appears to be contributing the most to the bullwhip effect, Enter your answer in each of the answer boxes javascript doExercise(10) This workstation has a time use limit ofProblem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day’s paper for $0.50 a copy. You sell a copy of San Pedro Times for $1.25. Daily demand is distributed normally with mean = 335 and standard deviation = 67. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given α-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.)Problem 20-10 (Algo) You are a newsvendor selling San Pedro Times every morning. Before you get to work, you go to the printer and buy the day's paper for $0.45 a copy. You sell a copy of San Pedro Times for $1.40. Daily demand is distributed normally with mean = 340 and standard deviation = 68. At the end of each morning, any leftover copies are worthless and they go to a recycle bin. a. How many copies of San Pedro Times should you buy each morning? (Use Excel's NORMSINV() function to find the correct critical value for the given a-level. Round your z-value to 2 decimal places and final answer to to 2 decimal places.) 8 Answer is complete but not entirely correct. Optimal order quantity 0.05 b. Based on a, what is the probability that you will run out of stock? (Round your answer to the nearest whole number.) * Answer is complete but not entirely correct. Probability 3 X %