we solved this questions , but we want to check the errors



PART ONE (30)


The Operations manager of AZOON Company which sells supplies (specifically, oven and dishwasher) was trying to simulate their orders against the demand of Oven. It was noted that in the previous months the demand of the Suctions was so uncertain and has a uniformly distribution probability with a minimum demand of 3 and maximum if 100 units. Moreover, it has also noticed that the Oven demand has a linear relationship with the Suction demand as shown in the table below:

Suction

Oven

50

20

100

30

190

45

250

50

300

80

400

70

300

45

350

36

230

23

150

130


Since uncertainty is quite high in the demand, they are concerned about the cost of inventory at the end of each month which is said to be $60 per unit however the shortage cost is estimated to be $12. This particular product is sold at $600 but for the fast-moving product during December, January and April, the company increases the price to 10% more and put back to normal price on the other months. Their yearly fixed cost is estimated to be $9000 daily.


  1. Create a year simulation showing the monthly profit and the total profit for the whole simulation period. Using the following different strategies:

Lead Time (month)

Reorder level

100

200

300

Reorder quantity

200

300

250

Reorder cost

$300

$250

$200


  1. Generate the summary report showing the number of months when stock out occurred, the mean of the closing stock level, number of orders placed, number of times there were back orders.

  2. Which among strategies is the most appropriate for the company and why?

  3. After selecting the best strategy, show at what demand the company with have the best profit?

PART TWO (30)

Management Consultation Center MCC is a well-established educational and training center in Kingdom of Bahrain. The center provides different types of workshops and certificates to enhance knowledge on innovation, and entrepreneurship. The following are the center event schedule for March 2019

Event

Date

Instructor Rate

per participants

Fee

per participants

Package (course material)

per participants

Workshop in entrepreneurship and innovation

1st to 5th March

$30

$200

$30

Workshop in Data science

11th to 15th March

$40

$220

$40

Certificate in Digital Marketing and innovation

21st to 30th March

???

$300

$75

Event

No. Participants

period

Workshop in entrepreneurship and innovation

Max: 100 , Min: 70

5 days

Workshop in Data science

Mean: 75 STD: 15

5 days

Certificate in Digital Marketing and innovation

Max: 30 Min: 15

10 days

The center has the following halls

Capacity

Rent

Hall A

50

$700

Hall B

100

$1000

Hall C

25

$300

  1. Calculate the instructors rate/per hour for the certificate which is decided by the average of the number of customers of workshop 1 and workshop 2 when the profit of the workshop 2 is greater than workshop1 by 800.

  2. Is the MCC schedule is profitable for this month (profit should be more than or equal 3500)

  3. Which events of the MCC (workshop1 or workshop 2) should be conducted on the period between the 16th to 20th of March in order to gain profit of 4500