You own and operate a chain of electronic stores

You own and operate a chain of electronic stores in Texas and you are considering expanding your inventory to include tablet work stations for small businesses. There is only one supplier of the brand of tablets you would like to stock in your store, and that firm is located in Mexico. You have researched the current spot and forward rates between the U.S. and Mexico, as indicated in Table-1:TABLE-1Spot Rate30-Day Forward90-Day Forward180-Day ForwardU.S. Dollar/Peso1.78511.70521.80511.7555Peso/U.S. Dollar????Questions:Complete the Peso/ U.S. Dollar row in Table-1 and explain your methodology.If you agree to pay 2-million pesos for 100,000 tablets at today’s spot rate, how much would you pay in U.S. dollars?If you agree to pay 2-million pesos but wait 180 days and end up paying the 180-Day forward rate, how much would you be paying for the 100,000 tablets, in U.S. Dollars?Your competitors sell the tablet for $41.20 and you must mark you product up from cost by at least 20% to earn a minimal profit, should you buy the tablets today? Explain your answer.Should you wait to buy the tablets in 30 days at the current 30-day forward rate? Explain your answers.Use the following file naming convention: LastnameFirstInitial_M4_A2.doc. For example, if your name is John Smith, your document will be named SmithJ_M4_A2.doc.By Wednesday, August 13, 2014, deliver your assignment to the M4: Assignment 2 Dropbox.Assignment 2 Grading CriteriaMaximum PointsCorrectly completed Table-1, Peso/Dollar conversion.20Correctly calculated the conversions from pesos to dollars.32Correctly determined the maximum costs that could be incurred that would allow minimal profit goals.32Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources; displayed accurate spelling, grammar, and punctuation.16Total:100