Fill in the blanks highighted in yellow below Option1: Distibution from the East Coast Factory Space per truck = 4000ft cubic Cooler unit size = 2ft cubic total cooler unit capacity = 2000pcs Option 2: Building a W/H at West Coast for finished goods Space per truck = 4000ft cubic Cooler unit size = 2ft cubic total cooler unit capacity = 2000pcs Half capacity truck Units delivered per trip The distribution of these units would require full truck capacity transport to fill a warehouse in anticipation of demand and a warehouse management system Charged to customer as freight cost per trip Freight Charge from East to West Coast Half truck load $0 For the weekly supply of 10,000 units, how many trips to the West Coast are needed? Units transported per freight Units purchased weekly Units purchased weekly transported per freight 0 Number of trips made #DIV/0! Number of Trips taken to fill W/H Total cost for transport Units delivered per trip to the #DIV/0! customer 0 Charged to customer as freight cost per trip Freight Charge from East to West Coast Spent on transport Relief totals for all trips Total spent on transport $0 $0 $0 #DIV/0! H at West Coast for finished goods Option 3: Building a manufacturing factory & W/H at the West Coast Space per truck = 4000ft cubic Cooler unit size = 2ft cubic total cooler unit capacity = 2000pcs Since the finished goods are now manufactured on the West Coast. No Finished goods transportation is to be added. However, now the raw materials transportation needs to be accounted for. e units would require full truck l a warehouse in anticipation of use management system Cost of transporting A Cost of transporting B Cost of transporting C d per freight Total Raw Materials freight/ cooler d weekly Opportunity cost of transporting raw materials per full truck load Customer shipping charges ken to fill W/H #DIV/0! Total spent on transport $ - $0.00 $0 $0.00 $0.00 Total transport #DIV/0! #DIV/0