Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Solve the following inventory problem using the simulation approach. A supermarket sells a specific mobile brand and earns a revenue of AED 510 per mobile.

image text in transcribed Solve the following inventory problem using the simulation approach. A supermarket sells a specific mobile brand and earns a revenue of AED 510 per mobile. An unsold mobile incurs a holding cost of AED40 at the end of the month. Holding cost is a portion of the rent, insurance, and others. If there is any shortage, the market assigns a goodwill cost of AED50 a mobile. The store has a stocking policy of 195 mobiles a month. The demand follows a normal distribution with a mean of 210 and a standard deviation of 40 . 1) Using the given random numbers and other parameters, simulate the operation for 13 months and provide your simulation output below. 2) What is the net profit of the supermarket? (average monthly profit) 3) What is the standard deviation (sample) of the profit? 4) What is the service level? 5) Is the service level acceptable to the supermarket? If yeso, explain why. Why not? 6) To achieve a service level of 90%, how many mobiles does the company stock every month? (Hints: use goal-seek). 7) If the supermarket aims for an average monthly profit of 100,000 , what price should the supermarket charge per mobile to achieve this profit? 8) What do you conclude about the status of the supermarket? What recommendations do you provide to improve the supermarket's performance

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

Natural Resource Management Reimagined

Authors: Robert G. Woodmansee

1st Edition

1108740138, 978-1108740135

More Books

Students also viewed these General Management questions

Question

Describe the linkages between HRM and strategy formulation. page 74

Answered: 1 week ago

Question

Identify approaches to improving retention rates.

Answered: 1 week ago