Solve problem a using excel.

Problem 1: The managers of a food company are about to install a number of automatic vending machines at various locations in a major city. Anumber of types of machines are available and managers would like to choose the design which will minimize the profit that will be lost because the machine is out of order. The following model is to be used to represent the lost profit: Cost of lost profit per month = (number of breakdowns per month) x (time to repair machine after each breakdown, in hours) X (profit loss per hour) One machine that is being considered is the Supervend, and the following probability distributions have been estimated for this machine: Number of Repair time Average breakdowns P profit lost (hours) per month per hour 1 2 po | a) Create a simulation model on a spreadsheet to simulate the operation of a machine for 12 months