Construct a simulation model using MSExcel for the situation below. A small fast-food restaurant is trying to figure out how many hamburgers to make each day. The probability distribution of the number of hamburger customers is as follows: The values of the table must be determined according to the rules below: - NC1 Random number between 1 and 7 - NC2 Random number between 8 and 12 - NC3 Random number between 13 and 17 - PNC Random numbers between 0 and 1. Use three decimals. i=1,2,3 PS: The rules above stand for unique problem for each student. Each student should construct his/her own model with the numbers produced. Customers order 1,2,3, or 4 hamburgers according to the following probability distribution. - PNH Random numbers between 0 and 1 . Use three decimals. i=1,2,3,4 Hamburgers sell for $7.30 each. They cost $5.80 each to make. All hamburgers not sold at the end of the day are sold at half-price to a local grocery store. Based on 5 days of simulation, how many hamburgers should be prepared each day? Tip: Consider News Dealer example model Explanations: 1. The assignment must be submitted as a report prepared with MSWord for your manager (Think of it as giving it to your manager)