QUESTION $1$

Your task is to run a simulation to estimate costs $($and likelihoods$)$ associated with a kitchen remodel. The remodel is broken down into six activities:

demolition, cabinetry, countertops, flooring, appliances, and painting. The historical cost data for each of these activities is summarized below.

Build a Monte Carlo simulation to estimate the cost of this project.

A partial spreadsheet is provided to get you started: HW$12$ Starter.xlsx

A note on terminology: "Simulation" refers to a collection of trials $($or iterations$).$ One simulation has many trials. One trial gives you one data point

for the overall simulation. The output of a simulation is a probability distribution.

After running your simulation, determine the mean $($average$)$ of your output data. Enter that number below $($no dollar signs$).$