General Ford produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed in the file P05_54.xlsx, where a blank means that a shipment is not allowed. Los Angeles can produce up to 1600 cars, and Detroit can produce up to 3200 cars. Houston must receive 1800 cars, and Tampa must receive 2900 cars. a. Determine how to minimize the cost of meeting demands in Houston and Tampa. b. Modify the answer to part a if no shipments through Atlanta are allowed.
| unit shipping cost | |||||||||
| to | |||||||||
| LA | Detroit | Atlanta | Houston | Tampa | |||||
| from | LA | $97 | $95 | $125 | $156 | ||||
| Detroit | $94 | $103 | $110 | $148 | |||||
| Atlanta | $87 | $100 | $95 | $56 | |||||
| Houston | $129 | $103 | $88 | $100 | |||||
| Tampa | $147 | $145 | $60 | $103 | |||||
| network formulation | flow balance contraints | ||||||||
| origin | destination | cost | flow | location | index | net flow in/out | Required | ||
| 1 | 2 | $97 | LA | 1 | <= | ||||
| 1 | 3 | $95 | Detroit | 2 | <= | ||||
| 1 | 4 | $125 | Atlanta | 3 | = | ||||
| 1 | 5 | $156 | Houston | 4 | = | ||||
| 2 | 1 | $94 | Tampa | 5 | = | ||||
| 2 | 3 | $103 | |||||||
| 2 | 4 | $110 | |||||||
| 2 | 5 | $148 | |||||||
| 3 | 1 | $87 | |||||||
| 3 | 2 | $100 | |||||||
| 3 | 4 | $95 | |||||||
| 3 | 5 | $56 | |||||||
| 4 | 1 | $129 | |||||||
| 4 | 2 | $103 | |||||||
| 4 | 3 | $88 | |||||||
| 4 | 5 | $100 | |||||||
| 5 | 1 | $147 | |||||||
| 5 | 2 | $145 | |||||||
| 5 | 3 | $60 | |||||||
| 5 | 4 | $103 | |||||||
total cost
In: Advanced Math
Estimate a linear time trend for the Netflix data using data for the period 2000Q1 ... Estimate a linear time trend for the Netflix data using data for the period 2000Q1 to 2008Q4. a. Carry out a preliminary analysis of the data including a line fit plot and interpret your results. b. Test whether the slope is significantly different from zero, using alpha = 0.05. c. Compute S and R2 and interpret the results. d. Compute point forecasts for sales in each quarter of 2009. e. Comment upon your results. Note: you can use Regression under the Data Analysis tool in Microsoft Excel.
| Year | Quarter | QtrNum | Quarterly Sales |
| 2000 | 1 | 1 | 5.17 |
| 2000 | 2 | 2 | 7.15 |
| 2000 | 3 | 3 | 10.18 |
| 2000 | 4 | 4 | 13.39 |
| 2001 | 1 | 5 | 17.06 |
| 2001 | 2 | 6 | 18.36 |
| 2001 | 3 | 7 | 18.88 |
| 2001 | 4 | 8 | 21.62 |
| 2002 | 1 | 9 | 30.53 |
| 2002 | 2 | 10 | 36.36 |
| 2002 | 3 | 11 | 40.73 |
| 2002 | 4 | 12 | 45.19 |
| 2003 | 1 | 13 | 55.67 |
| 2003 | 2 | 14 | 63.19 |
| 2003 | 3 | 15 | 72.20 |
| 2003 | 4 | 16 | 81.19 |
| 2004 | 1 | 17 | 99.82 |
| 2004 | 2 | 18 | 119.71 |
| 2004 | 3 | 19 | 140.41 |
| 2004 | 4 | 20 | 140.66 |
| 2005 | 1 | 21 | 152.45 |
| 2005 | 2 | 22 | 164.03 |
| 2005 | 3 | 23 | 172.74 |
| 2005 | 4 | 24 | 193.00 |
| 2006 | 1 | 25 | 224.13 |
| 2006 | 2 | 26 | 239.35 |
| 2006 | 3 | 27 | 255.95 |
| 2006 | 4 | 28 | 277.23 |
| 2007 | 1 | 29 | 305.32 |
| 2007 | 2 | 30 | 303.69 |
| 2007 | 3 | 31 | 293.97 |
| 2007 | 4 | 32 | 302.36 |
| 2008 | 1 | 33 | 326.18 |
| 2008 | 2 | 34 | 337.61 |
| 2008 | 3 | 35 | 341.27 |
| 2008 | 4 | 36 | 359.94 |
| 2009 | 1 | 37 | 394.1 |
| 2009 | 2 | 38 | 408.59 |
| 2009 | 3 | 39 | 423.12 |
| 2009 | 4 | 40 | 444.19 |
In: Statistics and Probability
The Lucas numbers are very similar to the Fibonacci numbers and are defined by a1=2, a2=1, and an+2=an+1+an. So the first five are 2, 1, 3, 4, 7 and it continues in that fashion.
Give the next 4 Lucas numbers
In: Statistics and Probability
Set and solve a linear system find a polynomial pp of degree 4 such that
p(0)=1, p(1)=1, p(2)=11, p(3)=61, and p(4)=205.
Your answer will be an expression in x.
Modifying your calculation, and without starting from scratch, find a polynomial qq of degree 4 such that q(0)=2, q(1)=3, q(2)=34, q(3)=167, and q(4)=522.
q(x) = ?
In: Advanced Math
Question 4: Homogeneous Second Order Differential equation
Solve the following equation for the particular solution.
i. 2?′′ + 5?′ + 3? = 0; ?(0)=3, ?′(0)=−4
ii. 4 (?2?/??2) + 8 (??/??) + 3y = 0 ?(0)=1,
?′(0)=2
iii. ?′′ + 6?′ + 13? = 0; ?(0)=2, ?′(0)=1
In: Math
|
a. Develop a null and alternative hypothesis for a test of whether or not the mean of the data representing wives’ satisfaction scores and husbands’ satisfaction scores are statistically different. Find descriptive statistics on the three relevant variables in the table. Highlight the means, standard deviations, and observations. |
| TABLE C9-2: Wife and Husband Feedback Scores on 1-7 Scale + Same Day or Not | |||
| Appraisal Survey | Wife's Score | Husband's Score | Same Day |
| 1 | 4 | 5 | Y |
| 2 | 3 | 2 | Y |
| 3 | 1 | 5 | N |
| 4 | 7 | 3 | N |
| 5 | 4 | 3 | Y |
| 6 | 3 | 6 | Y |
| 7 | 5 | 3 | Y |
| 8 | 4 | 7 | N |
| 9 | 5 | 5 | Y |
| 10 | 1 | 4 | N |
| 11 | 7 | 7 | Y |
| 12 | 2 | 6 | N |
| 13 | 2 | 5 | N |
| 14 | 5 | 2 | Y |
| 15 | 3 | 4 | Y |
| 16 | 5 | 7 | Y |
| 17 | 3 | 4 | Y |
| 18 | 1 | 4 | N |
| 19 | 4 | 6 | Y |
| 20 | 7 | 7 | Y |
In: Statistics and Probability
Which of the following statements is NOT true about inflation?
a)When in the 2-4% range, it can be the sign of a healthy economy.
b)Some prices may fall even when most others rise.
c)When in the 2-4% range, it can be the sign of a weak economy.
d)Some prices affect consumers more than others.
In: Economics
2. A cantaloupe has a radius of 4 inches 98 days after it was
planted, and of 9 inches 148
days after it was planted.
(a) Assuming linear growth, write a linear equation that
describes growth of radius of
the cantaloupe.
Answer:
(b) Find the radius of the cantaloupe on day 130.
In: Statistics and Probability
Exercise 4: Find all local extrema for f ? = sin^2 ? + cos ? on the interval [− ?/ 2 , ?/ 2 ]. Verify your answer by graphing.
In: Math
A spring with a spring constant 4 N/m is loaded with a 2 kgmass and allowed to reach equilibrium. It is then displaced 1 meter downward and released. Suppose the mass experiences a damping force in Newtons equal to 1 times the velocity at every point and an external force of F(t)=4sin(3t) driving the system. Set up a differential equation that describes this system and find a particular solution to this non-homogeneous differential equation:
In: Advanced Math