Galaxy Co. distributes wireless routers to Internet service providers. Galaxy procures each router for $75 from its supplier and sells each router for $125. Monthly demand for the router is a normal random variable with a mean of 100 units and a standard deviation of 20 units. At the beginning of each month, Galaxy orders enough routers from its supplier to bring the inventory level up to 100 routers. If the monthly demand is less than 100, Galaxy pays $15 per router that remains in inventory at the end of the month. If the monthly demand exceeds 100, Galaxy sells only the 100 routers in stock. Galaxy assigns a shortage cost of $30 for each unit of demand thair is unsatisfied to represent a loss-of- goodwill among its customers. Management would like to use a simulation model to analyze this situation. Perform the simulation for 1000 times, what is the average monthly profit resulting from its policy of stocking 100 routers at the beginning of each month?

Galaxy Co. distributes wireless routers to Internet service providers. Galaxy procures each router for $75 from its supplier and sells each router for $125. Monthly demand for the router is a normal random variable with a mean of 100 units and a standard deviation of 20 units. At the beginning of each month, Galaxy orders enough routers from its supplier to bring the inventory level up to 100 routers. If the monthly demand is less than 100, Galaxy pays $15 per router that remains in inventory at the end of the month. If the monthly demand exceeds 100, Galaxy sells only the 100 routers in stock. Galaxy assigns a shortage cost of $30 for each unit of demand thair is unsatisfied to represent a loss-of- goodwill among its customers. Management would like to use a simulation model to analyze this situation. Perform the simulation for 1000 times, what is the average monthly profit resulting from its policy of stocking 100 routers at the beginning of each month?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter10: Introduction To Simulation Modeling

Section10.4: Simulation With Built-in Excel Tools

Problem 13P

See similar textbooks

Similar questions

In Problem 12 of the previous section, suppose that the demand for cars is normally distributed with mean 100 and standard deviation 15. Use @RISK to determine the best order quantityin this case, the one with the largest mean profit. Using the statistics and/or graphs from @RISK, discuss whether this order quantity would be considered best by the car dealer. (The point is that a decision maker can use more than just mean profit in making a decision.)
Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.
Doc Nix Productions sells specialty T-Shirts that are sold at a single basketball game each. Doc Nix is trying to decide how many to buy for an upcoming game. During the game itself, which lasts one evening, Doc can sell T-Shirts for $10 apiece. However, when the game ends unsold T-shirts have no value. Due to a licensing agreement, Doc needs to make sure that leftover shirts are destroyed using a method that ends up costing $0.50 for each unsold T-Shirt. It costs Doc $6.50 to buy a specialty T-Shirt from the supplier. The supplier he uses has a cost per shirt of $2. Doc estimates that demand is distributed as shown below. Demand 300 350 400 450 500 550 Probability 0.05 0.15 0.20 0.10 0.30 0.20 How many specialty T-Shirts should Doc Nix buy from the supplier to maximize his profits? What is his expected profit? What is the total supply chain profit?
Dallas One Airline has started selling the air tickets for the fight 161 from Dallas to Toronto on June 30. There are 250 economy class seats on board. The airline sells some economy class seats at a discount price of $440 in advance and reserves a number of seats to sell at the full price of $770 Suppose that Dallas One Airline can always sell at discount tickets and the demand for full-price tickets is normally distributed with a mean of 100 and a standard deviation of 25 What is the optimal protection level for the airline? Choose the closest number. a. 89 b. 96 c. 100 d. 104 e. 112
Betty Cooker runs a bakery in San Francisco that specializes in her famous Black Forest cakes. These cakes come with four kinds of frostings: vanilla, chocolate, raspberry and devilicious. She estimates that the daily demand for each type of cake is independent and is normally distributed with a mean of 50 and a standard deviation of 50. Each customer wants to buy exactly one cake. Customers who favor a particular type of frosting will not buy any other if their preferred frosting is out of stock. Every day in the morning, Betty Cooker and her team of bakers prepare a fresh batch of the cakes. for sale that day. Her costs to bake and top each cake are $5. Each cake sells for $15. Betty's Bakery prides itself on its fresh assortment, so cakes not sold by the end of that day are given away to a soup kitchen for the homeless. She hires a consultant, McDonald, who advises her to, "Focus on maximizing your expected daily profits, and the customer demand will take care of itself." In order…
The catering manager of LaVista Hotel, Lisa Ferguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor will offer. ≻For a small order (2,000 pieces or less) her vendor quotes a price of $1.80/piece. ≻If she orders 2,001 to 5,000 pieces, the price drops to $1.60/piece. ≻5,001 to 10,000 pieces brings the price to $1.40/piece, and ≻10,001 and above reduces the price to $1.25/piece. Lisa's order costs are $205 per order, her annual holding costs are 5%, and the annual demand is 45,100 pieces. For the best option (the best option is the price level that results in an EOQ within the acceptable range): Part 2 a) What is the optimum ordering quantity? enter your response here units (round your response to the…
The catering manager of LaVista Hotel, Lisa Ferguson, is disturbed by the amount of silverware she is losing every week. Last Friday night, when her crew tried to set up for a banquet for 500 people, they did not have enough knives. She decides she needs to order some more silverware, but wants to take advantage of any quantity discounts her vendor will offer. ≻For a small order (2,000 pieces or less) her vendor quotes a price of $1.80/piece. ≻If she orders 2,001 to 5,000 pieces, the price drops to $1.60/piece. ≻5,001 to 10,000 pieces brings the price to $1.40/piece, and ≻10,001 and above reduces the price to $1.25/piece. Lisa's order costs are $200.00 per order, her annual holding costs are 5%, and the annual demand is 15,000 pieces. For the best option (the best option is the price level that results in an EOQ within the acceptable range): Part 2 a) What is the optimum ordering quantity? ________ units (round your response to the nearest whole…
Cindy and Mindy were in the same student group while studying for their MBA atUTD. They graduated together but started working as inventory managers in different but competingretailers selling air conditioners in Dallas. While in school, they learned only the economic orderquantity model for finding the optimal order sizes. Now they are both purchasing air conditionersfrom Trane to sell at their stores. Cindy knows that the order setup cost with Trane is $200 and theannual inventory holding cost is $400. Cindy expects that Mindy has the same cost figures. Cindyhas accidentally learned that Mindy is ordering 10 air conditions every time she orders. Show howCindy can use this information to deduce the demand Mindy faces. Explain why would competitorsway want to know each other’s demand
3-2) The optimal quantity of the three products and resulting revenue for Taco Loco is: A) 28 beef, 80 cheese, and 39.27 beans for $147.27. B) 10.22 beef, 5.33 cheese, and 28.73 beans for $147.27. C) 1.45 Z, 8.36 Y, and 0 Z for $129.09. D) 14 Z, 13 Y, and 17 X for $9.81. 3-3) Taco Loco is unsure whether the amount of beef that their computer thinks is in inventory is correct. What is the range in values for beef inventory that would not affect the optimal product mix? A) 26 to 38.22 pounds B) 27.55 to 28.45 pounds C) 17.78 to 30 pounds D) 12.22 to 28 pounds
A hot dog vendor at Wrigley Field sells hot dogs for$1.50 each. He buys them for $1.20 each. All the hot dogshe fails to sell at Wrigley Field during the afternoon can besold that evening at Comiskey Park for $1 each. The dailydemand for hot dogs at Wrigley Field is normally distributedwith a mean of 40 and a standard deviation of 10.a If the vendor buys hot dogs once a day, how manyshould he buy?b If he buys 52 hot dogs, what is the probability that hewill meet all of the day’s demand for hot dogs at Wrigley?
The "Footcandy" shoes store supplies men's black formal shoes. Every 3 months the "Footcandy" shoes store can sell approximately 500 pairs of shoes at a constant price. The store is currently ordering 500 everytime they order. It costs $ 30 to place the order. 20% is the annual rate for the storage fee. With an order of 500 pairs of shoes, the store got the lowest price at $ 28 per pair. The order quantity discounts offered by the manufacturer are as follows Quantity Price 1 0-99 $36 2 100-199 $32 3 200-299 $30 4 300 $28 a. What is the minimum cost order amount for the shoes? b. What is the annual savings from Footcandy Store?
The retail price of a Mother’s Day cake in San Ramon Safeway is $30.00. A local bakery sells the cakes to the Safeway at $20.00. The Safeway will dispose of all of the unsold cakes at 50% off the retail price, at the end of the Mother’s Day weekend. The manager in Safeway estimates that demand for this cake during the Mother’s Day weekend is Normal Distribution with a mean of 100 cakes and a standard deviation of 50 cakes. (1) How many cakes should San Ramon Safeway order from the bakery? (2) If the store manager learned a new forecast method in a class that would reduce the standard deviation of estimated demand from 50 to 25 (mean remains 100), how many cakes should San Ramon Safeway order from the local bakery?