Business Finance project

Acting on your recommendation that the retiring purchasing manager be replaced with a more up-to-date Vice President of Global Supply Chain, the CEO hired a new one. The new VP immediately found herself facing an important decision of where to source some components that have traditionally been very high cost, when the factory makes them in-house. Here is the data she is presented with:

• The currency of Country A is called Reds; of Country B is called Greens.
• The currency and forecasted exchange rates are as follows:
  • $1 = 2 Reds
  • $1 = 2.2 Greens
• The product costs for each of the 5 products from each of the 2 countries are as follows:

Because of the different packaging available in the two countries, and the different skill levels in packaging, the parts per container are different between the two countries.

• From Country A, any of the 5 parts will fit 1,000 per container
• from Country B, any of the 5 parts will fit 800 per container
• The ocean freight costs for a 40' container of any of these products are as follows:
  • For Country A, costs are similar to the ocean freight from Brisbane, Australia to the port of New York City.
  • For Country B, costs are similar to the ocean freight for a 40' container from Tokyo, Japan to the port of New York City.
  • Estimated 40' container ocean freight costs can be found by accessing this Web site (www.freight-calculator.com).
    1. It will take about 10 minutes to fill out an RFQ form.
       • If you are unable to get quotes, use these figures: $5,000 for Brisbane; $4,400 for Tokyo.
    2. Make up a company name.
    3. Assume you are shipping a 40' container of nonhazardous household goods.
    4. Insure the goods for $100,000.
    5. Use the upper left side of the Web page (1. Ocean Cargo) and the section for 20-/40-foot containers.

Individual Portion: 750–1,000 words

Please add at least 2 APA resources as well 

I am using Product 5 on the excel chart submitted with assignment

I will need a Word Document including a Excel insert to justify numbers produced. This is imperative to the assignment