Questions
Assumption: 1. The acquisition cost for each new customer is $35. 2. Each customer will purchase...

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. x1 x2 x3 s1 s2 z 8...

Write the basic feasible solution from the tableau given.

x1

x2

x3

s1

s2

z
8 6 1 1 0 0 160
5 2 4 0 1 0 148
−6 −10 −5 0 0 1 146

In: Math

Part 1: V2 Quantitative Data Use the list of 100 numbers from Lab 1, column V2...

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...

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...

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....

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...

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...

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...

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...

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