Hanson Cooling Solutions (HCS) sells and services several brands of major air conditioners, including, window, portable...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Hanson Cooling Solutions (HCS) sells and services several brands of major air conditioners, including, window, portable and split ACs. Past sales for a particular portable model (PM-HC2) of air conditioner have resulted in the following probability distribution for demand: Demand Per Week Probability 0 0.05 1 0.23 2 0.28 3 0.16 0.13 0.15 4 5 The reorder lead time refers to the time (in weeks) between placing with and receiving from the manufacturer an order for new refrigerators. This lead time is described by the following distribution: Probability Lead Time (Week/s) 1 0.63 2 3 0.24 0.13 Based on the cost considerations as well as storage space, the company has decided to order 12 of these each time an order is placed. The holding cost(or inventory carrying cost) is $8 per week for each unit that is left in inventory at the end of the week. The stockout cost (or shortage cost) has been set at $47 per stockout (or unit of shortage). The company has decided to place an order whenever there are four or less air conditioners left at the end of the week. They cannot place an order unless they have received the previous order. Orders are received at the beginning of the week. If demand is fulfilled then it is considered to be sales, otherwise it is lost sales (i.e., a stockout). Shortage or Stockout: Demand that cannot be supplied from inventory. For example, if you have 2 units in stocks and demand is 4 units then you can only supply 2 units and the remaining 2 units are considered as stockout or lost sales. Lead time: The time between the placing of an order and its receipt in the inventory system. For example, if you place an order with the manufacturer at the end of week 4 and the lead time is 2 weeks then you are going to receive this order at the beginning of the week7. Meanwhile during weeks 5 and 6 you cannot place a new order. Simulate 12 weeks of operation for Hanson Cooling Solutions assuming there are currently 5 units of the portable model (PM-HC2) of air conditioners in inventory. Use as many as you need from the following set of random numbers: Random Numbers 0.85 0.81 0.56 0.91 0.88 0.54 0.93 0.71 0.72 0.68 0.96 0.79 0.14 0.48 for DEMAND Random Numbers 059 0.37 0.76 0.92 0.13 0.23 0.29 0.63 0.98 0.21 0.57 0.45 0.35 0.15 for LEAD TIME (a) Specify an appropriate random number mapping for the demand and lead time. (b) Use the given random numbers to simulate twelve weeks demand, in the given table, add as many rows as you need: [Note: must use the table below and fill it completely] S Ordered units Received Beginning Ending Lost Lead Inventory Random Demand Inventory Sales Order? Random Time # Yes/No # After completion of 12 weeks' simulation answer the next 8 questions: (c) What is the total stockout (or shortage) cost? (d) What is the total inventory carrying cost? (e) How many times was an order placed? (f) In which week/s did they have the maximum number of air conditioners in ending inventory? (g) How many units of air conditioners were sold? (h) In which week did Hanson Cooling Solutions face highest $ amount in the lost sales or stockout? (i) In which week/s ending inventory of air conditioner in stock is greater than six units? (i) In these 12 simulations, what is the percentage of stockout? Hanson Cooling Solutions (HCS) sells and services several brands of major air conditioners, including, window, portable and split ACs. Past sales for a particular portable model (PM-HC2) of air conditioner have resulted in the following probability distribution for demand: Demand Per Week Probability 0 0.05 1 0.23 2 0.28 3 0.16 0.13 0.15 4 5 The reorder lead time refers to the time (in weeks) between placing with and receiving from the manufacturer an order for new refrigerators. This lead time is described by the following distribution: Probability Lead Time (Week/s) 1 0.63 2 3 0.24 0.13 Based on the cost considerations as well as storage space, the company has decided to order 12 of these each time an order is placed. The holding cost(or inventory carrying cost) is $8 per week for each unit that is left in inventory at the end of the week. The stockout cost (or shortage cost) has been set at $47 per stockout (or unit of shortage). The company has decided to place an order whenever there are four or less air conditioners left at the end of the week. They cannot place an order unless they have received the previous order. Orders are received at the beginning of the week. If demand is fulfilled then it is considered to be sales, otherwise it is lost sales (i.e., a stockout). Shortage or Stockout: Demand that cannot be supplied from inventory. For example, if you have 2 units in stocks and demand is 4 units then you can only supply 2 units and the remaining 2 units are considered as stockout or lost sales. Lead time: The time between the placing of an order and its receipt in the inventory system. For example, if you place an order with the manufacturer at the end of week 4 and the lead time is 2 weeks then you are going to receive this order at the beginning of the week7. Meanwhile during weeks 5 and 6 you cannot place a new order. Simulate 12 weeks of operation for Hanson Cooling Solutions assuming there are currently 5 units of the portable model (PM-HC2) of air conditioners in inventory. Use as many as you need from the following set of random numbers: Random Numbers 0.85 0.81 0.56 0.91 0.88 0.54 0.93 0.71 0.72 0.68 0.96 0.79 0.14 0.48 for DEMAND Random Numbers 059 0.37 0.76 0.92 0.13 0.23 0.29 0.63 0.98 0.21 0.57 0.45 0.35 0.15 for LEAD TIME (a) Specify an appropriate random number mapping for the demand and lead time. (b) Use the given random numbers to simulate twelve weeks demand, in the given table, add as many rows as you need: [Note: must use the table below and fill it completely] S Ordered units Received Beginning Ending Lost Lead Inventory Random Demand Inventory Sales Order? Random Time # Yes/No # After completion of 12 weeks' simulation answer the next 8 questions: (c) What is the total stockout (or shortage) cost? (d) What is the total inventory carrying cost? (e) How many times was an order placed? (f) In which week/s did they have the maximum number of air conditioners in ending inventory? (g) How many units of air conditioners were sold? (h) In which week did Hanson Cooling Solutions face highest $ amount in the lost sales or stockout? (i) In which week/s ending inventory of air conditioner in stock is greater than six units? (i) In these 12 simulations, what is the percentage of stockout?
Expert Answer:
Posted Date:
Students also viewed these mathematics questions
-
On December 1, 2011, Lavender Manufacturing Company (a corporation) purchased another company's assets, including a patent. The patent was used in Lavender's manufacturing operations; $49,500 was...
-
Island Publishing Company publishes two types of magazines on a monthly basis: a restaurant and entertainment guide and a real estate guide. The company distributes the magazines free to businesses,...
-
Use the following information for Ingersoll,Inc., (assume the tax rate is 34 percent): Draw up an income statement and balance sheet for this company for 2014 and 2015. 2015 $9,402 $10,091 2014 Sales...
-
PC Design, Inc., is authorized to issue 200,000 shares of \($5.00\) stated value common stock and 50,000 shares of 12%, \($100.00\) par value preferred stock. PC Design has 25,000 shares of common...
-
Yumee Products Inc. is divided into five departments, Mixing, Blending, Finishing, Factory Office, and Building Maintenance. The first three departments are engaged in production work. Factory Office...
-
Wildhorse Co. reported net income of $176,240 for 2022. Wildhorse Co. also reported depreciation expense of $34,330 and a loss of $4,840 on the disposal of plant assets. The comparative balance...
-
Consider a three-node network around which customers must travel cycllcally. The service time at node I is exponentially distributed with mean mi, i = 1,2,3. If there is only one customer in the...
-
Please help with this with at least one thousand and five hundred words. Make a career action plan as an accountant that will help you strategize your professional and personal growth. Start with...
-
What would happen to the net income over the two-year life of the project from the perspective of Vandelay Industries if they leased the equipment for $85,000 a year making those lease payments at...
-
Write a program to implement two searching algorithms. (1) a linear search algorithm and (2) a binary search algorithm. If the algorithm finds the searched key value, print out how many comparisons...
-
. Calculate total trees, fruit yield (in kg) and output of orange juice (in litres) for 100, 150, 200, 250, 300, 350, 400, 450, 500 and 550 Ha of total land use and present your answers in a table...
-
es Yuvwell Corporation's direct labor budget for next year contained the following information: Budgeted direct labor-hours 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 8,200 8,300 8,600 8,000 The...
-
Assume you are in the throws of finalizing a start-up business you have been dreaming of for years (Sports bar and Restaurant). It is almost time to forage out on your own into the business world as...
-
Suppose the S&P 500 futures price is 1000, = 30%, r = 5%, = 5%, T = 1, and n = 3. a. What are the prices of European calls and puts for K = $1000? Why do you find the prices to be equal? b. What...
Study smarter with the SolutionInn App