Demand for the magazines is distributed

Assignment Help Operation Management

Reference no: EM131234510

Chelsea Truman sells celebrity magazines on Sunday morning in an area surrounded by three busy shopping centers. Demand for the magazines is distributed as shown in the following table: DEMAND PROBABILITY 50 0.05 75 0.10 100 0.25 125 0.30 150 0.20 175 0.10 Chelsea has decided to order 100 magazines from her supplier. Chelsea pays $2 for each magazine she orders and sells each magazine for $3. Unsold magazines can be returned to the supplier for $0.75. (a) Simulate 1 year (52 Sundays) of operation to calculate Chelsea’s total yearly profit. Replicate this calculation N times. What is the average yearly profit? (b) Chelsea would like to investigate the profit ability of ordering 50, 100, 150, and 175 magazines at the start of each Sunday. Which order quantity would you recommend? Why? Is this solved using a random numbers generator program? Excel =RAND() ? Excel =RANDBETWEEN()? Can you give me an example of how to enter the values into =RAND() and =RANDBETWEEN()

Reference no: EM131234510

Questions Cloud

Analyzing and targeting the global market opportunity : The Global Customer and Buyer (4 pts) a. What is the customer value and value equation in your proposed market for your proposed product offering b. Explain the Diffusion Theory and Adoption process for your product offering within the country. 2. Gl..

Equipment effectiveness : Every successful Manager must evaluate the operating efficiencies of the enterprise. A mathematical measuring system known as Equipment Effectiveness (EE) was developed to meet this need. EE can be used to measure the effectiveness of an individual p..

Identify best distribution strategy for your market entry : A channel strategy for your new market entry. Identify the factors that will influence the channel structures; customer, product, middleman and environmental characteristics. Identify the best distribution strategy for your market entry between using..

What was once focus on domestic enterprise activity : What was once a focus on domestic enterprise activity, then international, has given way to global enterprise. What unique strategic challenges does functioning in the global environment present relative to achieving competitive advantage and overall..

Demand for the magazines is distributed : Chelsea Truman sells celebrity magazines on Sunday morning in an area surrounded by three busy shopping centers. Demand for the magazines is distributed as shown in the following table: DEMAND PROBABILITY 50 0.05 75 0.10 100 0.25 125 0.30 150 0.20 17..

Plastics die-casting house serving wide range of clients : Cignet Plastics Corporation is a contract plastics die-casting house serving a wide range of clients. Over the years, Cignet has been a favored supplier of precision die castings for a major producer of model airplane kits. In recent days, the defect..

Introduction of e-mail and other information technologies : In your opinion, has the introduction of e-mail and other information technologies increased or decreased the amount of information flowing through the corporate grapevine? Explain your answer.

Affinity diagrams and interrelationship diagraphs : Consider that you/your group works for Vic & Anthony’s (a premier steakhouse restaurant) and you have been tasked with perfecting the “customer experience.” In the Analyze phase of your Lean Six Sigma project, you decide to brainstorm ideas for why c..

Self-esteem and social esteem : Two friends who have just completed an organizational behavior course at another college inform you that employees must fulfill their need for self-esteem and social esteem before they can reach their full potential through self-actualization. What t..

User Account

All Pages