Pelican Stores
Pelican Stores, a division of National Clothing, is a chain of
women’s apparel stores operating throughout the country. The chain
recently ran a promotion in which discount coupons were sent to
customers of other National Clothing stores. data collected for a
sample of 100 in-store credit card transactions at Pelican Stores
during one day while the promotion was running are contained in the
file named PelicanStores. Table 2.19 shows a portion of the data
set. The Proprietary Card method of payment refers to charges made
using a National Clothing charge card. Customers who made a
purchase using a discount coupon are referred to as promotional
customers and customers who made a purchase but did not use a
discount coupon are referred to as regular customers. because the
promo- tional coupons were not sent to regular Pelican Stores
customers, management considers the sales made to people presenting
the promotional coupons as sales it would not other- wise make. Of
course, Pelican also hopes that the promotional customers will
continue to shop at its stores.
Most of the variables shown in Table 2.19 are self-explanatory, but two of the variables require some clarification.
- Items The total number of items purchased
- Net Sales The total amount ($) charged to the credit card
Pelican’s management would like to use this sample data to learn about its customer base and to evaluate the promotion involving discount coupons.
Managerial Report
Use the tabular and graphical methods of descriptive statistics to help management develop a customer profile and to evaluate the promotional campaign. At a minimum, your report should include the following:
1. Percent frequency distribution for key variables.
2. A bar chart or pie chart showing the number of customer purchases attributable to the method of payment.
3. A crosstabulation of type of customer (regular or promotional) versus net sales. Comment on any similarities or differences present.
4. A scatter diagram to explore the relationship between net sales and customer age.
Table 2.19
| Customer | Type of Customer | Items | Net Sales | Method of Payment | Gender | Marital Status | Age |
| 1 | Regular | 1 | 39.50 | Discover | Male | Married | 32 |
| 2 | Promotional | 1 | 102.40 | Proprietary Card | Female | Married | 36 |
| 3 | Regular | 1 | 22.50 | Proprietary Card | Female | Married | 32 |
| 4 | Promotional | 5 | 100.40 | Proprietary Card | Female | Married | 28 |
| 5 | Regular | 2 | 54.00 | MasterCard | Female | Married | 34 |
| 6 | Regular | 1 | 44.50 | MasterCard | Female | Married | 44 |
| 7 | Promotional | 2 | 78.00 | Proprietary Card | Female | Married | 30 |
| 8 | Regular | 1 | 22.50 | Visa | Female | Married | 40 |
| 9 | Promotional | 2 | 56.52 | Proprietary Card | Female | Married | 46 |
| 10 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 36 |
| 11 | Regular | 1 | 29.50 | Proprietary Card | Female | Married | 48 |
| 12 | Promotional | 1 | 31.60 | Proprietary Card | Female | Married | 40 |
| 13 | Promotional | 9 | 160.40 | Visa | Female | Married | 40 |
| 14 | Promotional | 2 | 64.50 | Visa | Female | Married | 46 |
| 15 | Regular | 1 | 49.50 | Visa | Male | Single | 24 |
| 16 | Promotional | 2 | 71.40 | Proprietary Card | Male | Single | 36 |
| 17 | Promotional | 3 | 94.00 | Proprietary Card | Female | Single | 22 |
| 18 | Regular | 3 | 54.50 | Discover | Female | Married | 40 |
| 19 | Promotional | 2 | 38.50 | MasterCard | Female | Married | 32 |
| 20 | Promotional | 6 | 44.80 | Proprietary Card | Female | Married | 56 |
| 21 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 28 |
| 22 | Promotional | 4 | 70.82 | Proprietary Card | Female | Married | 38 |
| 23 | Promotional | 7 | 266.00 | American Express | Female | Married | 50 |
| 24 | Regular | 2 | 74.00 | Proprietary Card | Female | Married | 42 |
| 25 | Promotional | 2 | 39.50 | Visa | Male | Married | 48 |
| 26 | Promotional | 1 | 30.02 | Proprietary Card | Female | Married | 60 |
| 27 | Regular | 1 | 44.50 | Proprietary Card | Female | Married | 54 |
| 28 | Promotional | 5 | 192.80 | Proprietary Card | Female | Single | 42 |
| 29 | Promotional | 3 | 71.20 | Proprietary Card | Female | Married | 32 |
| 30 | Promotional | 1 | 18.00 | Proprietary Card | Female | Married | 70 |
| 31 | Promotional | 2 | 63.20 | MasterCard | Female | Married | 28 |
| 32 | Regular | 1 | 75.00 | Proprietary Card | Female | Married | 52 |
| 33 | Promotional | 3 | 63.20 | Proprietary Card | Female | Married | 44 |
| 34 | Regular | 1 | 40.00 | Proprietary Card | Female | Married | 34 |
| 35 | Promotional | 5 | 105.50 | MasterCard | Female | Married | 56 |
| 36 | Regular | 1 | 29.50 | MasterCard | Male | Single | 36 |
| 37 | Regular | 2 | 102.50 | Visa | Female | Single | 42 |
| 38 | Promotional | 6 | 117.50 | Proprietary Card | Female | Married | 50 |
| 39 | Promotional | 5 | 13.23 | Proprietary Card | Female | Married | 44 |
| 40 | Regular | 2 | 52.50 | Proprietary Card | Female | Married | 58 |
| 41 | Promotional | 13 | 198.80 | Proprietary Card | Female | Married | 42 |
| 42 | Promotional | 4 | 19.50 | Visa | Female | Married | 46 |
| 43 | Regular | 2 | 123.50 | Proprietary Card | Female | Married | 48 |
| 44 | Promotional | 1 | 62.40 | Proprietary Card | Female | Married | 54 |
| 45 | Promotional | 2 | 23.80 | Proprietary Card | Female | Married | 38 |
| 46 | Promotional | 2 | 39.60 | Proprietary Card | Female | Married | 60 |
| 47 | Regular | 1 | 25.00 | MasterCard | Female | Married | 46 |
| 48 | Promotional | 3 | 63.64 | Proprietary Card | Female | Married | 30 |
| 49 | Promotional | 1 | 14.82 | Proprietary Card | Female | Married | 32 |
| 50 | Promotional | 9 | 145.20 | MasterCard | Female | Married | 46 |
| 51 | Promotional | 6 | 176.62 | Proprietary Card | Female | Married | 38 |
| 52 | Promotional | 5 | 118.80 | Proprietary Card | Male | Married | 68 |
| 53 | Regular | 1 | 58.00 | Discover | Female | Single | 78 |
| 54 | Regular | 2 | 74.00 | Visa | Female | Single | 20 |
| 55 | Regular | 2 | 49.50 | MasterCard | Female | Married | 32 |
| 56 | Promotional | 3 | 141.60 | Proprietary Card | Female | Married | 38 |
| 57 | Promotional | 6 | 123.10 | Proprietary Card | Female | Married | 54 |
| 58 | Promotional | 2 | 80.40 | Proprietary Card | Female | Married | 48 |
| 59 | Promotional | 4 | 65.20 | MasterCard | Female | Married | 46 |
| 60 | Promotional | 4 | 113.00 | Proprietary Card | Female | Single | 50 |
| 61 | Promotional | 1 | 108.80 | Proprietary Card | Female | Married | 46 |
| 62 | Promotional | 3 | 59.91 | Proprietary Card | Female | Single | 30 |
| 63 | Promotional | 5 | 53.60 | Proprietary Card | Female | Married | 54 |
| 64 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 42 |
| 65 | Promotional | 2 | 49.50 | Proprietary Card | Female | Married | 48 |
| 66 | Promotional | 1 | 39.60 | Proprietary Card | Female | Married | 62 |
| 67 | Promotional | 2 | 59.50 | Proprietary Card | Female | Married | 34 |
| 68 | Promotional | 5 | 146.80 | Proprietary Card | Female | Married | 28 |
| 69 | Promotional | 2 | 47.20 | Proprietary Card | Male | Married | 46 |
| 70 | Promotional | 8 | 95.05 | Proprietary Card | Female | Married | 54 |
| 71 | Promotional | 5 | 155.32 | Proprietary Card | Female | Married | 30 |
| 72 | Promotional | 4 | 58.00 | MasterCard | Female | Married | 32 |
| 73 | Regular | 1 | 69.00 | Proprietary Card | Female | Single | 22 |
| 74 | Promotional | 2 | 46.50 | Proprietary Card | Female | Married | 32 |
| 75 | Promotional | 2 | 45.22 | Proprietary Card | Female | Married | 74 |
| 76 | Promotional | 4 | 84.74 | Proprietary Card | Female | Married | 62 |
| 77 | Regular | 2 | 39.00 | Proprietary Card | Female | Married | 42 |
| 78 | Promotional | 4 | 111.14 | Proprietary Card | Female | Married | 28 |
| 79 | Promotional | 3 | 86.80 | Proprietary Card | Female | Married | 38 |
| 80 | Regular | 2 | 89.00 | Discover | Female | Married | 54 |
| 81 | Promotional | 2 | 78.00 | MasterCard | Female | Married | 68 |
| 82 | Promotional | 6 | 53.20 | Proprietary Card | Female | Single | 30 |
| 83 | Promotional | 4 | 58.50 | Visa | Female | Married | 36 |
| 84 | Promotional | 3 | 46.00 | Proprietary Card | Female | Married | 44 |
| 85 | Regular | 2 | 37.50 | Visa | Female | Married | 44 |
| 86 | Promotional | 1 | 20.80 | Proprietary Card | Female | Married | 62 |
| 87 | Regular | 6 | 144.00 | MasterCard | Female | Single | 48 |
| 88 | Regular | 4 | 107.00 | Proprietary Card | Female | Married | 36 |
| 89 | Promotional | 1 | 31.60 | Proprietary Card | Female | Single | 20 |
| 90 | Promotional | 6 | 57.60 | Proprietary Card | Female | Married | 42 |
| 91 | Promotional | 4 | 95.20 | Proprietary Card | Female | Married | 54 |
| 92 | Promotional | 1 | 22.42 | Proprietary Card | Female | Married | 54 |
| 93 | Regular | 5 | 159.75 | Proprietary Card | Female | Married | 72 |
| 94 | Promotional | 17 | 229.50 | Proprietary Card | Female | Married | 30 |
| 95 | Regular | 3 | 66.00 | American Express | Female | Married | 46 |
| 96 | Regular | 1 | 39.50 | MasterCard | Female | Married | 44 |
| 97 | Promotional | 9 | 253.00 | Proprietary Card | Female | Married | 30 |
| 98 | Promotional | 10 | 287.59 | Proprietary Card | Female | Married | 52 |
| 99 | Promotional | 2 | 47.60 | Proprietary Card | Female | Married | 30 |
| 100 | Promotional | 1 | 28.44 | Proprietary Card | Female | Married | 44 |
In: Statistics and Probability
a. Production & Cost Relationship in the
Long-Run
Explain the long-run production concept of diminishing returns to scale, and what it implies about the long-run average costs of production.
b.
|
Quantity of Umbrellas |
Total Cost |
MC |
|
0 |
8 |
na |
|
1 |
10 |
2 |
|
2 |
13 |
3 |
|
3 |
17 |
4 |
|
4 |
22 |
5 |
|
5 |
28 |
6 |
|
6 |
35 |
7 |
(4 pts) Comment on the shape of the short-run total production curve that gives the input and output relationship in the short-run. Sketch and explain the shape. Your answer should be specific to the information given in the table above.
In: Economics
Here are the returns on two stocks.
| Digital Cheese | Executive Fruit | |||||||
| January | +15 | +8 | ||||||
| February | −4 | +2 | ||||||
| March | +6 | +7 | ||||||
| April | +8 | +15 | ||||||
| May | −5 | +3 | ||||||
| June | +4 | +8 | ||||||
| July | −3 | −4 | ||||||
| August | −9 | −3 | ||||||
Required:
a-1. Calculate the variance and standard deviation of each stock.
a-2. Which stock is riskier if held on its own?
b. Now calculate the returns in each month of a portfolio that invests an equal amount each month in the two stocks.
c. Is the variance more or less than halfway between the variance of the two individual stocks?
In: Finance
1. What government agency measures US GDP?
2. Who wrote The General Theory of Employment, Interest and Money?
3. Variables measured at a point in time are called what?
4. Which is the most volatile of the 4 expenditure components of US GDP?
5. For the US, which is the smallest of the 4 expenditure components?
6. What are the two main endogenous variables in the IS-LM model?
7. If the MPS is .25 find the simple expenditure multiplier.
8. If the simple multiplier is 2 in size, find the MPC.
9. What is a good synonym for investment spending?
10. What are the two phases of a business cycle?
In: Economics
An electronics store has 4 branches in a large city. They are curious if sales in any particular department are different depending on location. They take a random sample of purchases throughout the 4 branches – the results are recorded below. Run an independence test for the data below at the 0.05 level of significance.
|
Appliances |
TV |
Computers |
Cameras |
Cell Phones |
|
|
Branch 1 |
54 |
28 |
61 |
24 |
81 |
|
Branch 2 |
44 |
21 |
55 |
23 |
92 |
|
Branch 3 |
49 |
18 |
49 |
30 |
72 |
|
Branch 4 |
51 |
29 |
65 |
29 |
102 |
What is the Test statistic (?2) and how is it done in excel?
In: Math
You are considering an investment with the following cash flows.
Your required return is 8%, you require a payback of 3 years and a
discounted payback of 4 years. If your objective is to maximize
your wealth, should you take this investment?
Year 0 1 2 3 4 5
Cash Flow –$50,000 $20,000 $20,000 $20,000 $20,000 –$50,000
|
Yes, because the payback is 2.5 years. |
||
|
Yes, because the discounted payback is less than 4 years. |
||
|
Yes, because both the payback and the discounted payback are less than 2 years. |
||
|
No, because the NPV is negative. |
||
|
No, because the project cash flows are not conventional. |
In: Finance
Hearne Company has a number of potential capital investments.
Because these projects vary in nature, initial investment, and time
horizon, management is finding it difficult to compare them. Assume
straight line depreciation method is used. (Future Value of $1,
Present Value of $1, Future Value Annuity of $1, Present Value
Annuity of $1.) (Use appropriate factor(s) from the tables
provided.)
Project 1: Retooling Manufacturing Facility
This project would require an initial investment of $4,910,000. It
would generate $919,000 in additional net cash flow each year. The
new machinery has a useful life of eight years and a salvage value
of $1,860,000.
Project 2: Purchase Patent for New Product
The patent would cost $3,610,000, which would be fully amortized
over five years. Production of this product would generate $559,550
additional annual net income for Hearne.
Project 3: Purchase a New Fleet of Delivery
Trucks
Hearne could purchase 25 new delivery trucks at a cost of $137,800
each. The fleet would have a useful life of 10 years, and each
truck would have a salvage value of $5,600. Purchasing the fleet
would allow Hearne to expand its customer territory resulting in
$233,000 of additional net income per year.
Required:
1. Determine each project's accounting rate of
return.
2. Determine each project's payback period.
3. Using a discount rate of 10 percent, calculate
the net present value of each project.
4. Determine the profitability index of each
project and prioritize the projects for Hearne.
Determine each project's accounting rate of return. (Round your answers to 2 decimal places.)
|
|||||||||||||
Determine each project's payback period. (Round your answers to 2 decimal places.)
|
|||||||||||||
Using a discount rate of 10 percent, calculate the net present value of each project. (Round your intermediate calculations to 4 decimal places and final answers to 2 decimal places.)
|
|||||||||
Determine the profitability index of each project and prioritize the projects for Hearne. (Round your intermediate calculations to 2 decimal places. Round your final answers to 4 decimal places.)
|
|||||||||||||
In: Accounting
Lili, a great magician, has a mission to enter a cave
to get treasure inside. The cave only
has 1 path without branches. But the cave is not safe because there
are some traps inside
that can reduce Lili’s life points. But in addition to traps, the
cave also has potions that
can increase Lili’s life points. Before entering the cave, Lili
casts magic that can reveal all
the traps and potions inside the cave. But before entering the
cave, Lili must prepare her
life points first because in the cave because Lili cannot use her
magic to add life points
or destroy the traps. What is the minimum life point that Lili must
prepare so that her
life point is always positive during the trip inside the
cave.
Note: If Lili’s point drops to 0 or negative before entering and
during the trip inside the
cave, then Lili is declared dead.
Format Input
There are
T test cases. Each testcase contains an integer
N which represents the length
of the cave. On the next line there are
N numbers represents the value of trap and potion.
Traps are marked with numbers that are negative and potions are
marked with numbers
that are positive
Format Output
Output
T line with format “Case
#
X: ”, where
X represents the testcase number and
Y represents the initial life points that Lili has to
prepare.
Constraints • 1 ≤ T ≤ 100 • 1 ≤ N ≤ 5000 • −108 ≤ Ai ≤ 10
8
, which
A
i
is the value of each traps and potions.
Sample Input (standard input) 25
1 2 -3 4 -5 5
-1 -1 -1 -2 9
Sample Output (standard output)
Case #1: 2
Case #2: 6
Explanation
In case 1, the minimum life points that Lili must prepare is 2.
With a simulation like the
following.
At position 1, Lili’s life point increased by 1 to 3.
At position 2, Lili’s life point increased by 2 to 5.
At position 3, Lili’s life point is reduced by 3 to 2.
At position 4, Lili’s life point increased to 4 to 6.
At position 5, Lili’s life point is reduced by 5 to 1.
In each position Lili’s life points are positive so the answer is
valid. if the initial life
prepared by Lili is 1, then Lili will die in fifth position with a
life point of 0.
Please answer it in C language , thx
In: Computer Science
Factor the following:
a) f(x)=x^5+5x^4-21x^3-137x^2-88x+240, knowing that f(5)=0 and f(-3)=0.
b) f(x)=x^3+8x^2+5x-50
c)f(x)=-x^4-4x^3+19x^2+46x-120, knowing that (x+5) and (x-2) are factors.
In: Math
Write a program, using your favourite programming language, to parse time log files to report how much time in total spent on project. The time log file TimeLogCarbon.txt.
Time Log:
2/23/12: 9:10pm - 11:40pm getting familiar with Flash
2/29/12: 12:50pm - 2:00pm getting familiar with Flash
3/1/12: 6:00pm - 11:40pm getting familiar with Flash
3/3/12: 3:00pm - 7:00pm step-debug Energy Game code
3/4/12: 8:00pm - 11:40pm start carbon game
3/5/12: 2:00pm - 3:00pm, 4:00pm - 4:30pm carbon game
3/6/12: 11:30am - 1:30pm carbon game data structures and classes
for the first action
3/7/12: 11:00am - 5:00pm tested basic concept
3/8/12: 1:00am - 1:30am changed vector calling,
10:30am - 2:30pm, 4:00pm - 5:00pm wrote code to draw points
indicator and marshal the data code;
3/9/12: 12:00am - 2:30am added CarbonActionCategoryView.as and
captured some icons
11:30am - 4:50pm research how to resize; labor work to capture
icons; research how to use event/delegate;
3/10/12: 1:50am - 6:00am event/delegate alternative implementation;
score fields implementation
10:40am - 1:00pm define CarbonConsts.as for those names;
implemented points fields
3/12/12: 10:45am - 5:00pm research on scrollpane, to no avail
3/13/12: 11:00am - 5:00pm research on Slider customization and make
some progress without fully satisfication
3/14/12: 12:10pm - 5:00pm continue to research on Slider and got
some idea
3/15/12: 3:30am - 4:30am experiment with CarbonSlider concept
11:00am - 5:00pm "Flash Training with Paul Trani" and continue to
experiment with CarbonSlider concept
3/16/12: 10:00am - 5:00pm integrate the CarbonSlider class into the
Game project
8:00pm - 9:00pm added the display of the slider thumb value;
9:30pm - 11:00pm clean-up the resources and adjust slider.x; start
to modify CarbonPointsIndicator.as
3/17/12: 6:00am - 7:00am
12:00pm - 12:50pm, 4:00pm - 7:00pm bad CarbonPointsIndicator
modification
3/18/12: 9:10am - 9:40am draw 2-pixels rectangle and 1-pixel tick
for Points Indicator
9:40am - 10:30am debug biofueled cars & trucks, mix in wood in
coal plants
11:30am - 3:30pm scrollpane implementation - alternative
11:00pm - 12:00am read Adobe Flash Professional online help
3/19/12: 5:00am - 6:00am read Adobe Flash Professional online
help
3/20/12: 9:00am - 10:00am discuss with Dr. Lant and Blanca.
10:00am - 11:00am slider width will be proportional per page or
section, total score is changed to total carbon points, options
remaining tops 100
3/23/12: 1:30pm - 3:30pm install Adobe Illustrator
4:00pm - 5:00pm Flash Professional online help
3/29/12: 3:11am - 7:00am background shape study, to no avail
11:00am - 12:50pm continue background shape study - no longer
needed
3:00pm - 5:05pm scroll pane automatically adjusted based on the
view size; dynamically created static texts
10:25pm - 11:00pm adjust positions of text fields
3/30/12: 9:50am - 11:30am loading images in AS 3 training; flash
work cycle training
11:40am - 2:20pm experiment with ideas; learn illustrator
3:20pm - 5:05pm re-captured all .png files; .ai files do not have
any advantage over .png files
3/31/12: 7:00am - 9:00am change the color of points indicator; add
PPU; use Bitmap instead of MovieClip;
4/2/12: 12:10pm - 1:42pm study mask and Shape; come up with the
concept of carbon progressbar
1:43pm - 5:00pm implement the carbon progressbar using mask and
shape
7:00pm - 7:40pm implement the carbon progressbar by drawing bar and
outline
11:00pm - 12:05am added total options and options
4/3/12: 1:30am - 3:00am added Options In Total static text field;
Options Remaining will not go negative.
4/4/12: 3:50pm - 5:00pm update the icons
8:35pm - 11:50pm continue to update the icons; use the colors in
.ai file
4/9/12: 12:30pm - 6:00pm update based on feedback
9:50pm - 2:30am
4/10/12: 8:56am - 9:57am
- 10.remove "other"
- 9. add "Replace Cement"
- 8. move current points slightly to the right
- 7. center max points on last tic mark
- 6. provide a bit more white space for four large boxes at the
top
- 5. At top of left-hand column, label boxes "Tons of Carbon per
unit"
- 4. PPU boxes. Align vertically. Expand. "Points per Unit" at the
top of this column.
- 3. decrease Improve Insulation limit from 20 to 15
- 2. optionsRemaining and optionsUsed
- 1. total carbon points bar
5/19/12: 4:03pm - 6:57pm update based on teachers' feedback and
dynamically dragging slide
6/4/12: 3:30pm - 5:04pm prev/more options implementation
8:15pm - 10:00pm
3/13/13: 2:11pm - 5:12pm Make numbers in the yellow triangles
bigger and bolder; Make numbers in the options used and remaining
bigger and bolder
In: Computer Science