Question: ( 3 Points ) Galaxy Co . distributes wireless routers to Internet service providers. Galaxy procures each router for $ 7 5 from its supplier
Points
Galaxy Co distributes wireless routers to Internet service providers. Galaxy procures each
router for $ from its supplier and sells each router for $ Monthly demand for the
router is a normal random variable with a mean of units and a standard deviation of
units. At the beginning of each month, Galaxy orders enough routers from its supplier
to bring the inventory level up to routers. If the monthly demand is less than
Galaxy pays $ per router that remains in inventory at the end of the month. If the
monthly demand exceeds Galaxy sells only the routers in stock. Galaxy assigns a
shortage cost of $ for each unit of demand that is unsatisfied to represent a lossof
goodwill among its customers. Management would like to use a simulation model to
analyze this situation. Perform the simulation for times, what is the average monthly
profit resulting from its policy of stocking routers at the beginning of each month? please solve in excel
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
