The Whole Question is in the Attached File. Please Help me solve this question.

The Zing snack company is known for its high-caffeine, high-sugar snacks. Their vending machine near the computer lab has two kinds of snacks: Coffee Zings cost $1.00 each. Joltin Zings cost $1.50 each. Each morning at 10am the Zing delivery person stops by and lls the vending machine so it has its capacity of 150 Coffee Zings and 100 Joltin Zings. Every ten minutes the probabilities are 35% no one buys a Coffee Zing. 30% one person buys a Coffee Zing. 25% two people buy a Coffee Zing. 10% three people buy a Coffee Zing. Every ten minums the probabilities are 45% no one buys a Joltin Zing. 30% one person buys a Joltin Zing, and 25% two people buy a Joltin Zing. Once the machine runs out of Coffee Zings no more Coffee Zings can be purchased. Once the machine runs out of Joltin Zings no more Joltin Zings can be purchased. Create a model to simulate 24-hour operation of the vending machine over the course of one day beginning at 10am. in steps of 10 minutes. For each ten-minute period show the number of Coffee Zings purchased. the number of Joltin Zings purchased, the number of Coffee Zings remaining in the vending machine and the number of Joltin Zings remaining in the vending machine. For the day we would like to know: how many Coffee Zings were sold how many J oltin Zings were sold how many minutes the machine was out of stock of Coffee Zings how many minutes the machine was out of stock of Joltin Zings. and I how much money was taken in for the day. There should be separate well-labeled cells at the top of the worksheet for each of these values