Assumption:
1. The acquisition cost for each new customer is $35.
2. Each customer will purchase five times a year. For each purchase, the profit value is $8.
3. Retention rate (r) is 80% and Interest rate (i) is 4.5%.
Questions:
Note: Please round up all answers to the nearest tenth (two digits after the decimal point).
(1) Please fill out the empty cells in the table below. And write down all the detailed calculation steps.
(2) In order to make profit from this program, how many years do you think that the customers should stay in this program? Please simply explain why.
(3) Assuming that the retail store can attract 350 customers after it launches the frequent shopper program, and be able to keep this amount of customers till the end of year 4. The owner plans to achieve $3,000 cumulative profits at the end of year 4. Do you think, with 350 frequent shoppers, can the store owner accomplish the $3,000 goal? If not, how many more customers the retail store should recruit and keep till the end of year 4?
|
Frequent Buyer |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
|
Acquisition Cost |
$35 |
-- |
-- |
-- |
-- |
|
A. Margin on each purchase(5 times a year) |
-- |
$8 |
$8 |
$8 |
$8 |
|
B. Survival Rate |
-- |
100% |
80% |
||
|
C. Cost of Mailing(per month) |
-- |
$2 |
$2 |
$2 |
$2 |
|
D. Total Expected Profit per Customer |
-- |
$16 $8*5-$2*12=$16 |
|||
|
E. Net Present Value |
-- |
$15.31 16/(1+4.5%) =15.31 |
|||
|
F. Cumulative Profit per Customer |
-- |
15.31-35 = -19.69 |
In: Finance
Write the basic feasible solution from the tableau given.
|
|
|
|
In: Math
Part 1: V2 Quantitative Data
Use the list of 100 numbers from Lab 1, column V2 for this part of the lab. (Lab 1 data at the bottom)
Identify the name of the quantitative variable V2 that you are using. __________________
B. Use Microsoft Excel to find
Mean ________________________
Median _______________________
Mode _________________________
Standard Deviation _________________________
Minimum Value ________________________
Maximum Value ________________________
Q1 _____________________________
Q3 _____________________________
C. Consider your values for mean, median and mode listed above. Which is the largest?
Discuss the similarities and differences among your three measures.
Which one of these measures of central tendency is most suitable for your data? Explain your choice.
D. Using the appropriate numbers from B above, make a box-and-whisker plot for your data.
What does this plot tell you about your data?
Lab 1 Data
| Row | Items | Sales | Card Type | Gender | Country | Age | Martial Status |
| 1 | 19 | $50.61 | visa-electron | Male | China | 35 | 2 |
| 2 | 14 | $105.37 | mastercard | Female | China | 22 | 2 |
| 3 | 11 | $90.21 | maestro | Female | Russia | 52 | 2 |
| 4 | 20 | $280.84 | visa | Male | China | 38 | 1 |
| 5 | 18 | $265.68 | jcb | Male | China | 44 | 1 |
| 6 | 19 | $103.63 | americanexpress | Female | Indonesia | 56 | 2 |
| 7 | 17 | $215.00 | jcb | Male | Dominican Republic | 51 | 1 |
| 8 | 20 | $168.06 | laser | Male | Czech Republic | 25 | 1 |
| 9 | 3 | $181.42 | maestro | Female | China | 41 | 1 |
| 10 | 11 | $240.51 | mastercard | Female | China | 44 | 1 |
| 11 | 17 | $260.56 | jcb | Male | China | 58 | 1 |
| 12 | 17 | $170.56 | jcb | Female | Belarus | 28 | 2 |
| 13 | 14 | $71.42 | diners-club-carte-blanche | Male | Sweden | 41 | 1 |
| 14 | 3 | $242.23 | diners-club-carte-blanche | Female | Indonesia | 58 | 2 |
| 15 | 15 | $250.44 | visa-electron | Male | Latvia | 41 | 2 |
| 16 | 4 | $71.80 | jcb | Male | New Zealand | 20 | 2 |
| 17 | 6 | $33.62 | diners-club-us-ca | Male | United States | 48 | 2 |
| 18 | 17 | $81.35 | diners-club-enroute | Female | Colombia | 44 | 2 |
| 19 | 13 | $67.09 | maestro | Male | China | 53 | 1 |
| 20 | 3 | $262.41 | jcb | Female | Lithuania | 22 | 1 |
| 21 | 16 | $204.28 | jcb | Female | Indonesia | 23 | 2 |
| 22 | 2 | $289.74 | jcb | Female | Vietnam | 28 | 2 |
| 23 | 1 | $33.45 | china-unionpay | Male | China | 29 | 2 |
| 24 | 19 | $154.19 | jcb | Female | Botswana | 46 | 2 |
| 25 | 20 | $43.29 | diners-club-enroute | Male | Argentina | 58 | 2 |
| 26 | 5 | $96.97 | jcb | Male | Russia | 42 | 2 |
| 27 | 1 | $46.62 | jcb | Male | Ecuador | 21 | 2 |
| 28 | 17 | $241.04 | jcb | Male | China | 41 | 1 |
| 29 | 6 | $251.64 | switch | Female | Sudan | 58 | 1 |
| 30 | 1 | $115.24 | visa-electron | Female | Canada | 52 | 1 |
| 31 | 10 | $263.42 | jcb | Male | France | 44 | 2 |
| 32 | 10 | $274.67 | jcb | Female | Italy | 32 | 2 |
| 33 | 1 | $69.59 | jcb | Female | Switzerland | 48 | 2 |
| 34 | 17 | $136.30 | china-unionpay | Male | China | 44 | 2 |
| 35 | 7 | $201.52 | jcb | Male | Macedonia | 26 | 2 |
| 36 | 8 | $51.44 | switch | Female | Papua New Guinea | 51 | 1 |
| 37 | 11 | $52.95 | jcb | Male | Czech Republic | 48 | 2 |
| 38 | 19 | $162.89 | china-unionpay | Female | China | 36 | 2 |
| 39 | 5 | $160.09 | jcb | Female | China | 38 | 1 |
| 40 | 6 | $91.28 | jcb | Female | Brazil | 39 | 1 |
| 41 | 4 | $140.53 | mastercard | Female | Indonesia | 26 | 2 |
| 42 | 15 | $190.36 | visa | Male | Greece | 57 | 1 |
| 43 | 10 | $181.57 | americanexpress | Male | Philippines | 46 | 2 |
| 44 | 1 | $65.59 | jcb | Female | China | 31 | 1 |
| 45 | 3 | $49.01 | laser | Female | United States | 49 | 2 |
| 46 | 16 | $88.05 | jcb | Female | France | 54 | 2 |
| 47 | 9 | $193.79 | jcb | Male | Indonesia | 38 | 1 |
| 48 | 5 | $39.55 | mastercard | Female | Indonesia | 24 | 2 |
| 49 | 1 | $32.56 | jcb | Male | Japan | 23 | 1 |
| 50 | 2 | $54.52 | china-unionpay | Male | Ireland | 43 | 1 |
| 51 | 19 | $161.89 | jcb | Male | China | 57 | 1 |
| 52 | 2 | $59.63 | maestro | Male | Cyprus | 35 | 1 |
| 53 | 13 | $257.81 | bankcard | Male | China | 38 | 1 |
| 54 | 15 | $166.53 | laser | Male | South Africa | 50 | 1 |
| 55 | 15 | $253.02 | diners-club-carte-blanche | Female | Canada | 39 | 2 |
| 56 | 16 | $193.56 | americanexpress | Female | China | 30 | 2 |
| 57 | 18 | $80.57 | china-unionpay | Male | Brazil | 30 | 1 |
| 58 | 18 | $250.29 | jcb | Male | Yemen | 41 | 1 |
| 59 | 15 | $46.79 | jcb | Female | Japan | 42 | 1 |
| 60 | 18 | $276.56 | laser | Male | Slovenia | 32 | 2 |
| 61 | 14 | $135.13 | jcb | Male | Tanzania | 31 | 1 |
| 62 | 14 | $195.58 | jcb | Female | China | 42 | 1 |
| 63 | 15 | $182.98 | visa | Female | China | 52 | 2 |
| 64 | 8 | $221.03 | jcb | Male | Zimbabwe | 29 | 1 |
| 65 | 3 | $128.11 | jcb | Female | China | 40 | 1 |
| 66 | 19 | $76.60 | diners-club-carte-blanche | Female | Indonesia | 38 | 1 |
| 67 | 13 | $27.07 | jcb | Female | China | 59 | 2 |
| 68 | 4 | $109.20 | diners-club-carte-blanche | Male | Russia | 48 | 2 |
| 69 | 4 | $276.85 | jcb | Male | Uruguay | 57 | 2 |
| 70 | 19 | $195.10 | jcb | Male | Sao Tome and Principe | 25 | 1 |
| 71 | 5 | $112.23 | instapayment | Male | Zambia | 41 | 1 |
| 72 | 15 | $61.94 | jcb | Female | Nigeria | 41 | 1 |
| 73 | 4 | $35.08 | jcb | Female | China | 35 | 2 |
| 74 | 20 | $60.13 | switch | Male | China | 23 | 2 |
| 75 | 6 | $277.11 | visa-electron | Female | Portugal | 54 | 2 |
| 76 | 5 | $220.47 | jcb | Female | Russia | 37 | 2 |
| 77 | 14 | $185.57 | laser | Male | Russia | 53 | 2 |
| 78 | 19 | $295.96 | diners-club-enroute | Male | Greece | 51 | 1 |
| 79 | 12 | $238.86 | visa | Female | Indonesia | 45 | 2 |
| 80 | 3 | $275.81 | visa-electron | Female | Indonesia | 26 | 2 |
| 81 | 7 | $77.07 | visa | Female | Portugal | 57 | 1 |
| 82 | 2 | $252.58 | mastercard | Female | Russia | 45 | 2 |
| 83 | 4 | $134.78 | jcb | Male | Japan | 29 | 1 |
| 84 | 3 | $43.49 | americanexpress | Male | Indonesia | 48 | 2 |
| 85 | 1 | $223.78 | jcb | Male | Mexico | 53 | 2 |
| 86 | 8 | $238.74 | jcb | Female | China | 28 | 2 |
| 87 | 9 | $291.30 | americanexpress | Male | Togo | 44 | 1 |
| 88 | 14 | $79.46 | jcb | Female | Finland | 54 | 2 |
| 89 | 16 | $193.73 | jcb | Male | Indonesia | 57 | 1 |
| 90 | 13 | $224.23 | visa-electron | Female | Pakistan | 23 | 2 |
| 91 | 16 | $247.43 | mastercard | Female | Honduras | 27 | 1 |
| 92 | 9 | $186.11 | jcb | Male | China | 56 | 2 |
| 93 | 17 | $58.48 | jcb | Male | China | 53 | 2 |
| 94 | 1 | $281.40 | jcb | Female | Philippines | 46 | 2 |
| 95 | 10 | $254.37 | bankcard | Male | Brazil | 42 | 1 |
| 96 | 8 | $145.00 | jcb | Female | Indonesia | 50 | 2 |
| 97 | 20 | $122.35 | jcb | Female | Sweden | 25 | 2 |
| 98 | 1 | $210.77 | jcb | Male | Portugal | 50 | 1 |
| 99 | 7 | $225.37 | diners-club-carte-blanche | Female | South Africa | 43 | 2 |
| 100 | 18 | $87.98 | maestro | Male | China | 37 | 2 |
| Note: | |||||||
| Marital Status 1 = Married | |||||||
| Marital Status 2 = Single | |||||||
In: Statistics and Probability
Suppose that 30% of all homeowners in an earthquake-prone area of California are insured against earthquake damage. Four homeowners are selected at random; let x denote the number among the four who have earthquake insurance.
(a) Find the probability distribution of x. (Hint: Let S denote a homeowner who has insurance and F one who does not. Then one possible outcome is SFSS, with probability (.3)(.7)(.3)(.3) and associated x value of 3. There are 15 other outcomes.)
| Value of x | Probability |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 |
(b) What is the most likely value of x?
0
1
1 and 0
3
4
(c) What is the probability that at least two of the four selected
homeowners have earthquake insurance?
P (at least 2 of the 4 have earthquake insurance) =
______
In: Statistics and Probability
make a plot of the data in the table below , plot position versus time time squared (t2 ). make sure to label your graph properly.( Y axis title with units, X axis title with unit, title of the graph with equation , major tick marks. use data to plot the graph manually. use proper scal
| measurement | position(m) | time(s) | time2 (s2 ) |
| 1 | 0 | 0 | 0 |
| 2 | 5 | 1 | 1 |
| 3 | 21 | 2 | 4 |
| 4 | 46 | 3 | 9 |
| 5 | 82 | 4 | 16 |
| 6 | 129 | 5 | 25 |
A) what do you notice about the shape of the plot this time?explain
b) what is the slope of the line in this plot equal to ( not a number)
c) determine the slope of the graph by determing the least Squares best fit line to the data. what is "g" determined from slope?
In: Physics
A housewife is testing the cutting speeds of 4 brands
of knives she has at home. She chose 5 cutting materials of varying
degree at home. Each material was cut once by each one of the 4
knives. (Hence after all 4 cuts the material was cut into 5
pieces).
1) Is this a randomized block design or two factor design?
If random block design, what is used as the block?
If two factor design, what are the two factors in the study?
1. State the null and alternative hypotheses.
2. Here is the output table for ANOVA test with missing values.
Fill in the missing values (where the cells are underlined)
Source df SS MS F
Knife 310
Material 46
Error 12 24
1. What is the F statistic for the test? Will you reject or fail to
reject (at alpha=0.05)?
2. What is the sum square of total?
In: Statistics and Probability
need answers for all 4 years in all three sections
Depreciation by Three Methods; Partial Years
Perdue Company purchased equipment on April 1 for $77,760. The equipment was expected to have a useful life of three years, or 7,560 operating hours, and a residual value of $2,160. The equipment was used for 1,400 hours during Year 1, 2,600 hours in Year 2, 2,300 hours in Year 3, and 1,260 hours in Year 4.
Required:
Determine the amount of depreciation expense for the years ended December 31, Year 1, Year 2, Year 3, and Year 4, by (a) the straight-line method, (b) units-of-output method, and (c) the double-declining-balance method.
Note: FOR DECLINING BALANCE ONLY, round the multiplier to four decimal places. Then round the answer for each year to the nearest whole dollar.
In: Accounting
Present/future value computations
1. How much must be deposited on January 1, 2013 to accumulate a
balance of $50,000 on December 31, 2017? At interest rate of
3.5%
At interest rate of 6%
2. 50,000 is deposited at interest compounded annually what amount
will be on hand in seven years at 4%? at 8%
2A. What if 50,000 is deposited at interest compounded
semi-annually what amount will be on hand in seven years At 4%? At
8%
3. How much must be deposited at 4.5% interest on January 2, 2019
to pay an annuity of 1,000 per year on December 31 of each year for
six years?
3A. What would the amount be if the annuity was paid on January 1
instead of December 21?
4. How much would be on hand if 1,000 were deposited annually at
4.5% for six years?
In: Accounting
State the following questions:
a) The designation of the subshell with n=5 and l=1
b) The designation of the subshell with n=5 and l=3
c)The number of unpaired electrons in a Mo atom
d)The number of unpaired electrons in an arsenic atom
e)The lowest value of n for which a f-subshell can occur
f)The maximum number of electrons possible in an atom with n=4
g)The number of electrons which can have n=1, l=1, ml= -1, ms=+1/2
h)The number of electrons which can have n=2, l=-1, ml= 1, ms=+1/2
In: Chemistry
The corporate CEO of "Life is Fun and Love is Strange Inc." claimed that the average sales of "Fun Life" are less than "Strange Love". In order to test the hypothesis, she asked you to conduct 2 tests. a) test the claim that the variances of the 2 stores are equal. Use a 5% significance level. b) based on your answer, use the appropriate test for the claim that the average sales of "Strange Love" are greater than "Fun Life". Use a 5% significance level for the test.
| Fun Life | Strange Love | ||
| 9/2/19 | $ 10,499.94 | $ 15,602.13 | |
| 9/9/19 | $ 12,570.94 | $ 15,266.79 | |
| 9/16/19 | $ 3,005.02 | $ 4,081.42 | |
| 9/23/19 | $ 14,248.23 | $ 1,382.24 | |
| 9/30/19 | $ 8,636.75 | $ 8,275.37 | |
| 10/7/19 | $ 14,204.85 | $ 1,245.25 | |
| 10/14/19 | $ 9,543.69 | $ 10,673.07 | |
| 10/21/19 | $ 5,263.17 | $ 10,464.89 | |
| 10/28/19 | $ 7,371.62 | $ 8,938.07 | |
| 11/4/19 | $ 5,008.26 | $ 10,442.26 | |
| 11/11/19 | $ 3,489.96 | $ 2,108.36 | |
| 11/18/19 | $ 12,743.37 | $ 13,724.84 | |
| 11/25/19 | $ 1,848.10 | $ 9,319.00 | |
| 12/2/19 | $ 5,789.95 | $ 7,755.35 | |
| 12/9/19 | $ 7,586.66 | $ 12,327.17 | |
| 12/16/19 | $ 2,287.95 | $ 2,343.91 | |
| 12/23/19 | $ 3,356.14 | $ 2,444.49 | |
| 12/30/19 | $ 4,558.28 | $ 12,514.89 | |
| 1/6/20 | $ 7,247.02 | $ 4,998.70 | |
| 1/13/20 | $ 7,374.31 | $ 13,333.44 | |
| 1/20/20 | $ 4,593.70 | $ 14,156.07 | |
| 1/27/20 | $ 1,792.20 | $ 6,646.60 | |
| 2/3/20 | $ 3,248.34 | $ 3,494.17 | |
| 2/10/20 | $ 1,372.53 | $ 17,622.30 | |
| 2/17/20 | $ 11,061.58 | $ 8,109.53 | |
| 2/24/20 | $ 9,250.06 | $ 11,629.81 | |
| 3/2/20 | $ 3,598.44 | $ 1,294.15 | |
| 3/9/20 | $ 13,069.25 | $ 14,609.46 | |
| 3/16/20 | $ 1,769.34 | $ 16,544.91 | |
| 3/23/20 | $ 5,340.35 | $ 6,791.68 | |
| 3/30/20 | $ 9,584.29 | $ 9,749.47 | |
| 4/6/20 | $ 14,422.19 | $ 3,744.22 | |
| 4/13/20 | $ 4,139.96 | $ 11,331.56 | |
| 4/20/20 | $ 4,917.33 | $ 10,489.14 | |
| 4/27/20 | $ 12,172.46 | $ 17,745.47 |
In: Statistics and Probability