Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a mean of 2 0 0 units and a standard deviation of 5 0 units. At the beginning of each month, Galaxy orders enough goggles

a mean of 200 units and a standard deviation of 50 units. At the beginning of each month, Galaxy orders enough goggles from its supplier to bring the inventory level up to 180 goggles. If the monthly demand is less than 180, Galaxy pays $20 per pair of goggles that remains in inventory at the end of the month. If the monthly demand exceeds 180, Galaxy sells only the 180 pairs of goggles in stock. Galaxy assigns a shortage cost of $40 for each unit of demand that is unsatisfied to represent a loss-of-goodwill among its customers. Management would like to use a simulation model to analyze this situation.The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below.Generate trials on a new worksheet.Download spreadsheet galaxy-49446.xIsxa. What is the average monthly profit resulting from its policy of stocking 180 routers at the beginning of each month? Round your answer to the nearest dollar.$b. What is the proportion of months in which demand is completely satisfied? Round your answer to the nearest whole number. %

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ecological Forest Management

Authors: Jerry F. Franklin, K. Norman Johnson, Debora L. Johnson

1st Edition

1478633506, 978-1478633501

More Books

Students also viewed these General Management questions