Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started