business factors

Part 5

Fill in the blanks highighted in yellow below
Option1: Distibution from the East Coast Factory		Option 2: Building a W/H at West Coast for finished goods				Option 3: Building a manufacturing factory & W/H at the West Coast
Space per truck = 4000ft cubic		Space per truck = 4000ft cubic				Space per truck = 4000ft cubic
Cooler unit size = 2ft cubic		Cooler unit size = 2ft cubic				Cooler unit size = 2ft cubic
total cooler unit capacity = 2000pcs		total cooler unit capacity = 2000pcs				total cooler unit capacity = 2000pcs
Half capacity truck
Units delivered per trip
Charged to customer as freight cost per trip
Freight Charge from East to West Coast
Half truck load	$0					Cost of transporting A
						Cost of transporting B
						Cost of transporting C
		Units transported per freight				Total Raw Materials freight/ cooler			$ - 0
		Units purchased weekly				Opportunity cost of transporting raw materials per full truck load			$0.00
						Customer shipping charges			$0
Units purchased weekly		Number of Trips taken to fill W/H							$0.00
transported per freight	0
Number of trips made	ERROR:#DIV/0!				ERROR:#DIV/0!	Total spent on transport			$0.00
Total cost for transport	ERROR:#DIV/0!	Units delivered per trip to the customer	0
		Charged to customer as freight cost per trip	$0
		Freight Charge from East to West Coast	$0	Total transport	ERROR:#DIV/0!
		Spent on transport	$0
		Relief totals for all trips	ERROR:#DIV/0!
		Total spent on transport			ERROR:#DIV/0!

For the weekly supply of 10,000 units, how many trips to the West Coast are needed?

The distribution of these units would require full truck capacity transport to fill a warehouse in anticipation of demand and a warehouse management system

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.