In Taiwan, no one goes to work, and everyone consumes a single good (food), which is imported from another place and can be purchased (one meal at a time) from the nearest vending machine. Alternatively, food can be delivered by a distant catapult, capable of flinging a meal through a customer's window. The price of a delivered catapult meal is $8 and the price of a vending-machine meal is $2. The travel cost for consumers is $1 per roundtrip mile ($0.5 per mile traveled).

a. How many miles would the market area (i.e. maximum miles to be traveled for vending) for the vending machine be?

b. Show your answer in a martini shaped glass, indicating the slope of the glass’ arms, price of food at vending machine, and the radius of the city. (Label your axes)

c. Now assume that everyone owns a bike, which reduces the travel cost to $0.2 per round-trip mile. What would the new market area be for the vending machine?

d. Continue from part c above (everyone owns a bike still). Assume that a new vending machine replaces the old one, now allowing customers to purchase 2 meals at a time (meals are storable at no cost). How would that affect (if any) the market area of the vending machine?

e. Continue from part d above, and assume that everyone eats 2 meals per day in this town, and a month is 30 days long. What would the monthly rent difference be for a residence located 5 miles v. 10 miles away from the vending machine? (Hint: a single daily trip to the vending machine is sufficient).

I need to know how to answer this question only in Excel. Please include instructions, screenshots, etc. in Excel which explain the process (formulas included).

TropSun is a leading grower and distributer of fresh citrus products with three large citrus groves scattered around central Florida in the cities of Orlando, Eustis, and Winter Haven. TropSun currently has 275,000 bushels of citrus at the grove in Mt. Dora, 400,000 bushels at the groves in Eustis, and 300,000 bushels at the grove in Clermont. TropSun has citrus processing plants in Ocala, Orlando, and Leesburg with processing capabilities to handle 200,000, 600,000, and 225,000 bushels respectively. TropSun contracts with a local trucking company to transport its fruit from the groves to the processing plant. The trucking company charges a flat rate for each mile that each bushel of fruit must be transported. Each mile a bushel of fruit travels is known as a bushel-mile. The following table summarizes the distances (in miles) between the groves and processing plant.

TropSun wants to determine how many bushels to ship from each grove to each processing plant to minimize the total number of bushel-miles the fruit must be ship. [ Another way to put it, MINIMIZE the TRANSPORTATION costs of the bushel-miles from the groves to the Plants] (30 Points) HINT: What decision variables can change.

1. Define the decision variables.

2. Define the Constraints

3. Implement and Solve the Problem in Excel

4. Analyze the Solution, what is it telling the decision maker?

Wayne Collier designed an experiment to measure the
fuel efficiency of his family car under different tire pressures.
For each run, he set the tire pressure and then measured the
miles he drove on a highway (I-95 between Mills River and
Pisgah Forest, NC) until he ran out of fuel using 2 liters of fuel
each time. To do this, he made some alterations to the normal
flow of gasoline to the engine. In Wayne’s words, “I inserted
a T-junction into the fuel line just before the fuel filter, and a
line into the passenger compartment of my car, where it joined
with a graduated 2 liter Rubbermaid© bottle that I mounted in
d©
a box where the passenger seat is normally fastened. Then I
sealed off the fuel-return line, which under normal operation
sends excess fuel from the fuel pump back to the fuel tank.”
Suppose that you call the mean miles that he can drive with
µ.
µ
normal pressure in the tires
An unbiased estimate for
is the
mean of the sample runs, x. But Wayne has a different idea. He
decides to use the following estimator: He flips a fair coin. If the
coin comes up heads, he will add five miles to each observation.
If tails come up, he will subtract five miles from each observation.
(a) Show that Wayne’s estimate is, in fact, unbiased.
(b) Compare the standard deviation of Wayne’s estimate with
the standard deviation of the sample mean.
(c) Given your answer to (b), why does Wayne’s estimate not
make good sense scientifically

It is a calm summer day in southeast Iowa at the Ottumwa air traffic control radar installation - except there are some small, locally intense thunderstorms passing through the general area. Only two planes are in the vicinity of the station: American Flight 1003 is traveling from Minneapolis to New Orleans is approaching from the north-northwest, and United Flight 336 is traveling from Los Angeles to New York is approaching from west-southwest. Both are on the path that will take them directly over the radar tower. There is plenty of time for the controllers to adjust the flight paths to insure a safe separation of the aircraft.

Suddenly lightning strikes a power substation five miles away, knocking out the power to the ATC installation. There is, of course, a gasoline powered auxiliary generator, but it fails to start. In desperation, a mechanic rushes outside and kicks the generator; it sputters to life. As the radar screen flickers on, the controllers find that both flights are at 33,000 feet. The American flight is 32 nautical miles (horizontally) from the tower and is approaching it on a heading of 171 degrees at a rate of 405 knots. The United flight is 44 nautical miles from the tower and is approaching it on a heading of 81 degrees at a rate of 465 knots.

a. At the instant of this observation, how fast is the distance between the planes decreasing?
b. How close will the planes come to each other?
c. Will they violate the FAA's minimum separation requirement of 5 nautical miles?
d. How many minutes do the controllers have before the time of closest approach?
e. Should the controllers run away from the tower as fast as possible?

The specific questions asked above are a guide to your work and suggestions of the directions to pursue. Your report must contain not just answers to questions but explanations as well.

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings.

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands

Is there a difference between the means of the total of rooms per hotel in Crete and Southern Aegean Islands? Answer your question by calculating an appropriate, symmetric, 95% confidence interval using a Z statistic and equal standard deviations in the two populations. Explain your findings

REGION ID

1= Crete
2=Southern Aegean Islands
3=Ionian Islands

The manager of a resort hotel stated that the mean guest bill for a weekend is $600 or less. A member of the hotel's accounting staff noticed that the total charges for guest bills have been increasing in recent months. The accountant will use a sample of future weekend guest bills to test the manager's claim.

(a)

Which form of the hypotheses should be used to test the manager's claim? Explain.

H₀: μ ≥ 600

H_a: μ < 600

H₀: μ ≤ 600

H_a: μ > 600

H₀: μ = 600

H_a: μ ≠ 600

A) The hypotheses H₀: μ ≥ 600 and H_a: μ < 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is greater than or equal to 600 and find evidence to support μ < 600.

B)The hypotheses H₀: μ ≤ 600 and H_a: μ > 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is less than or equal to 600 and find evidence to support μ > 600.   

C)The hypotheses H₀: μ = 600 and H_a: μ ≠ 600 should be used because the accountant wants to test the manager's claim that the mean guest bill μ is equal to 600 and find evidence to support μ ≠ 600.

(b)

What conclusion is appropriate when

H₀

cannot be rejected?

A)We are able to conclude that the manager's claim is wrong. We can conclude that μ = 600.

B)We are not able to conclude that the manager's claim is wrong.We cannot conclude that μ > 600.    

C) We are not able to conclude that the manager's claim is wrong. We cannot conclude that μ ≠ 600.

D) We are able to conclude that the manager's claim is wrong. We can conclude that μ ≤ 600.

E) We are not able to conclude that the manager's claim is wrong. We can conclude that μ ≥ 600.

(c)

What conclusion is appropriate when

H₀

can be rejected?

A) We are not able to conclude that the manager's claim is wrong. We can conclude that μ < 600.

B) We are not able to conclude that the manager's claim is wrong. We can conclude that μ > 600.    

C) We are able to conclude that the manager's claim is wrong. We can conclude that μ < 600.

D)We are able to conclude that the manager's claim is wrong. We can conclude that μ ≠ 600.

E) We are able to conclude that the manager's claim is wrong. We can conclude that μ > 600.

Following are the number of victories for the Blue Sox and the hotel occupancy rate for the past eight years. You have been asked to test three forecasting methods to see which method provides a better forecast for the Number of Blue Sox Wins.

For the following, you are to provide all forecasts to one decimal place (example, 93.2)

You are asked to forecast the Number of Blue Sox Wins for Year 9. Although you believe there might be a linear regression relationship, your boss has told you to only consider the following three forecasting methods:

• 3-period moving average
• 3-period weighted moving average given the weights of 0.7 for the most recent period and 0.2 for the next most recent period, and the remaining weight (s) consistent with this method as we have used in class, and
• exponential smoothing with α = 0.25 and the best forecast available for the Number of Blue Sox Wins is for Year 2 which is 66.0.

a) What is the forecast from each of these methods for Year 9?

b) Which forecasting method provides the better forecast for Year 9? Why? Your selection criteria must be based on one of the numerical evaluation methods we have used on the homework this term using the forecast results for Year 5 through Year 8.

If the pressure of O2 in a 1.0-L container at 20 degrees Celsius is 0.37 atm, what will be the pressure on the container if 0.10 mol CO2 is added to it?

How many liters of H2 at STP can be produced from the electrolysis of aqueous NaCl using a current of 50.0 mA for 1.0 hour?