HELP

Three potential options are available for the major components used to manufacture your finished products Option 1 involves the use of domestic suppliers that are 300 miles from your facility Option 2 involves the use of an Asian supplier that is 10,000 from Nashville ( 8000 miles to California port and 2000 highway Option 3 involves the use of a supplier in Monterry, Nuevo Leon, Mexico which is 2000 highway miles from Nashville We will assume a standard 40ft ocean container and a standard over the road truck load to be 40,000 pounds All costs are per pound or peryear All vellow boxes must be populated in addition to the two text boxes at the bottom of the spreadygeet At what levels would Option 1 be preferred? At what levels would Option 2 be preferred? At what levels would Option 3 be preferted? Three potential options are available for the major components used to manufacture your finished products Option 1 involves the use of domestic suppliers that are 300 miles from your facility Option 2 involves the use of an Asian supplier that is 10,000 from Nashville ( 8000 miles to California port and 2000 highway Option 3 involves the use of a supplier in Monterry, Nuevo Leon, Mexico which is 2000 highway miles from Nashville We will assume a standard 40ft ocean container and a standard over the road truck load to be 40,000 pounds All costs are per pound or peryear All vellow boxes must be populated in addition to the two text boxes at the bottom of the spreadygeet At what levels would Option 1 be preferred? At what levels would Option 2 be preferred? At what levels would Option 3 be preferted