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 lossofgoodwill 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? Give it in excel so i know how to do the steps and show formula.
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
