We will construct a simulation model to estimate the mean profit per unit. First, download the attached Excel sheet. HW 8 Brinkley Compration - Simulation xisx Step by step, we will fill out the missing numbers and formulas. First, complete the missing data in cells A6:B8 (your answer to question 1), E6:F9 (your answer to question 2), and 16:J7 (your answer to question 3). The fixed selling price is given as $45 in column B. We will calculate the per-unit procurement, labor, and transportation costs for each trial in columns C, D, and E, respectively. Which of the following is the correct formula we write in cell C17 to get the unit procurement cost given a random variable rand0 for the trial? Important: Please pay attention to absolute references, i.e., $ signs in the formula when implementing it in Excel. A1=HLOOKUP(3,$496$$88) B. = HLOOKUP(RANDO.\$A\$6:\$C\$8,2) C1= VLOOKUP(RANDO.\$A\$6.\$C\$8,3) D. =VLOOKUP (3,$496$$8)