I need help with Task1 I just don’t understand…
I need help with Task1 I just don't understand the method used in making these calculations. I have attached a screenshot of my actual spreadsheet for reference Additional Requirements Other Requirements: A. Complete the attached “Simulation Template” by doing the following (responses should include two decimal places): 1. Determine the following costs correctly: a. Average materials cost per unit b. Average labor cost per unit c. Average utilities cost per unit d. Average total cost per unit 2. Show your random interval tables you used to correctly determine the costs in parts A1a–A1d. a. Explain how you correctly used the random interval tables from part A2 to populate the “Simulation Template.” B. Determine the selling price per unit that should be established for this product using your simulation results 1. Explain how you arrived at the selling price from part B. Note: For your calculations in parts B and B1, assume that the company wants to realize an average markup of $20 on each unit sold.