Calculate the total cost of a dresser given the information provided below (be careful when making the unit of analysis conversions) and attach either a spreadsheet or a word document SHOWING ALL OF YOUR WORK. (30 points) Price paid to supplier: $200.00 (per dresser) Cubes per dresser (how much space each dresser takes on the container): 25 Cubes per pallet (how much space each pallet takes on the container): 200 Cubes per container (total space on the container): 2400 (standard 40' container) Dressers per pallet: 8 Dressers per container:___ (see hint below) Shipping costs: $3900 per container to the Los Angeles Port Customs Fees: 1.7% of the value of the container Duties: 4% of the value of the container Insurance: $450 (per container) Transportation from Port to Warehouse: $1000 (per container) Transportation from Warehouse to Customer: $900 (per container) Warehouse charges (moving): $175 per pallet Quality control (cycle counts, pilferage, customer prep.): $25 per dresser Hint: 2400 (total space) / 200 (cubes per pallet) = 12 pallets per container Round to the nearest penny Item Total Amount per Dresser Total Amount per Container Price paid to supplier Shipping costs Customs Fees Duties Insurance $450.00 Transportation-Port to WH $1000.00 Transportation-WH to Cust. WH Charges Quality Control $25.00 TOTAL per dresser $ per container