let jusury ALL your answers in cells A22 through AZ6 3. Go to COST tab (10 Points): a.. For cell C5, format the words "Total Costs for 220 units" so it fits entirely in the cell using the wrap function. You are allowed to make this cell longer but not wider. b. In cell B3, create a dropdown menu that shows amounts from 200-300, increasing in increments of 10. c Using an absolute cell references for cell B3, calculate the total direct materials, direct labor and variable overhead costs for 220 units in cells C6 through C8 d. Using the sum function in Cell C9, calculate the total costs of content in cells C6 through C8. (Widen column if necessary.) e. Using a formula, put the total fixed costs for 220 units in cell C11, using $ and one decimal places. (Widen column if necessary.) f. Name cell C11 "FixedCosts" and uses this name in your formula for 3G below. 8. In cell C12, use the rounddown function to 2 decimal places to calculate the fixed costs per unit for 220 units h. In cell C14 Calculate the Per unit Cost (DL+DM+OH) with blue color and add a border around this cell. In cell A14 write "Per Unit Cost". Center the title "Total Costs across cells al through di j Unlock cells B3, B6, B7 and 38 and then lock the entire worksheet - do not use a password D. Foc B C G H 1 Total Cost 3 Total Units 220 Total Costs for 220 units 1.00 5 Variable Costs type Per Unit 6 Direct Materials $ Direct Labor $ Overhead $ Total Variable Costs 2.00 3.50 9 $ 18,653 11 Total fixed costs 12 Fixed costs per unit 13 12 0 0 19