please help me

1. Transportation problem (straightforward with no fixed costs). ZYX, Inc. manages three production plants, located in New Jersey, Chicago, and Denver. Its major markets are in Atlanta, Houston, Los Angeles, and Seattle. In each of those cities, it manages inventory and distribution centers. These centers need to be appropriately stocked with goods to meet expected demand. Table 1 below shows each plant's productive capacity and Table 2 shows expected demand at each city. Table 3 gives the per unit cost of shipping from a given plant to a given distribution center. The company needs to meet demand but not exceed capacity levels at its plants nor its distribution centers. a. Set this problem up in Qla as suggested in the spreadsheet and solve for the amount the firm will produce out of each plant and will ship to each distribution center in order to minimize transportation costs. Interpret your figures as being in $1,000 s of dollars (so if you get an answer of say $2,000, consider that $2,000,000 ). b. Suppose a new route between Atlanta and New Jersey has just opened. The new route is a much better highway, with fewer obstructions, fewer road deficiencies, and fast speed limits. The result is that this reduces the per-unit cost of shipping from 15 to 10. But it's a toll road. Suppose ZYX Inc. estimates its toll costs to be a flat annual rate of $20 (so that's $20,000 ). Should the firm use the new toll road or continue to use the existing route? Explain. 2. Location Decision using Regression. (just follow class example - straightforward) In the "Q2 Data" sheet you will find data on 302 different Taco Bell restaurants in the midwest. The company is looking to build more restaurants but wants to know where to build. It has determined that success is measured by average revenue per transaction over a given year (REV) and has identified 5 locational variables that impact REV. In "Q2 Data" run a regression with REV as your y variable and the other variables as your X variables. Include Labels and put your output starting in J1. Then in "Q2 Decision," copy your coefficients column from your regression into Row 6 where indicated. Then in G, calculate the predicted revenues for each potential area. If the minimum acceptable level of REV is $9.10 (put on B4), where should the firm locate its new restaurants