help in this

he success of the Cellar Door has resulted in more customers visiting the winery on Saturdays and Sundays.The cellar door manager would like you to simulate if there are sufficient sales assistants rostered on during these peak days.The manager does not want the customers waiting any more than 5 minutes.The tables below show summarises the current service.Service Time

Service Time (min) Probability

0 0

2 0.15

4 0.45

6 0.25

8 0.15

Customer arrivals

Time between arrivals Probability

0 0.05

2 0.1

5 0.45

6 0.25

8 0.1

10 0.05

Required:

1. Create a table to simulate the above information from 10am to 2pm.(10 marks)
2. Explain if the current service level meets the manager's requirements. (5 marks)

Note: The Excel table must include random number and Vlookup functions.The Excel spreadsheet is to be submitted with the Word document.