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
5.
FuboTV and hulu are two streaming services companies that many consumers are using to eliminate expensive cable-TV services. They offer similar benefits to customers. If the price of the FuboTV service decreases, this will cause a decrease in the _______ for the hulu brand streaming service which would be graphed as _______.
Group of answer choices
quantity demanded, movement up/left along its demand curve
demand, leftward shift of its demand curve
quantity demanded, leftward shift of its demand curve
demand, movement up/left along its demand curve
6.
A minimum wage is an example of a price floor and results in higher rates of unemployment.
Group of answer choices
True
False
7.
Opportunity cost is defined as the value of everything given up when a decision is made or a course of action is followed.
Group of answer choices
True
False
8.
Assume that a firm is considering using another hour of labor at a cost of $20. The marginal product of this additional hour of labor is 15 units. The selling price is $2 per unit. Which of the following correctly identifies what the firm should do and for the correct reason?
Group of answer choices
The firm should not use the additional hour of labor because the MRP is negative.
The firm should use the additional hour of labor because the firm’s total product will increase.
The firm should use the additional hour of labor because the marginal product is positive.
The firm should obtain more information because there is not enough information provided to determine its best course of action.
The firm should not use the additional hour of labor because the marginal product is less than the wage rate.
The firm should use the additional hour of labor because the firm’s MRP is greater than the wage rate.
9,
It is assumed in economics that firms want to maximize _______, and this assumption provides the foundation for the _______.
Group of answer choices
total revenue, law of supply
total revenue, law of demand
total profit, law of supply
total profit, principle of increasing marginal opportunity cost
10.
The cross-price elasticity of demand between two goods is –1.9. This tells us these two goods are _______ and _______.
Group of answer choices
substitutes, used in place of each other
substitutes, used together
complements, used together
complements, used in place of each other
In: Economics
Bruny Island Dairy is a boutique cheese maker on Bruny Island.
Over the years, the business has grown firstly by supplying local
retailers, and then through exports. In addition, there is a
‘farm-gate’ shop and café located next to the main processing plant
on Bruny Island, serving tourists who also visit the other
specialist food and wine businesses in the region. Quality control
over the cheese manufacturing process and storage of raw materials
and finished products at Bruny Island Dairy is extremely high. All
members of the business are committed to high product quality
because any poor food handling practices which could result in a
drop in cheese quality, failed health and safety inspections, or
contamination of the products which would ruin the business very
quickly. The company has managed to maintain export sales
throughout the COVID-19 pandemic. However, revenue from tourists
visiting the island has dropped off dramatically. The company has
secured government assistance.
The export arm has been built up to become the largest revenue
earner for the business by the younger of the two sisters who have
run Bruny Island Dairy since it was established. Jane Langley has a
natural flair for sales and marketing, but is not so good at
completing the associated detailed paperwork. Some of the export
deals have been poorly documented and Jane often gives discounts to
some customers without consulting her older sister, Melinda, or
informing the sales department. Consequently, there are often
disputes about invoices and Jane makes frequent adjustments to
debtor accounts using credit notes when clients complain about
their statements. Jane sometimes falls behind in responding to
customer complaints because she is very busy juggling the demands
of making export sales and running her other business, Café
Consulting, which manages casual staff working at the café business
at Bruny Island Dairy.
Required
a. Identify the factors that would affect the preliminary
assessment of inherent risk and control risk at Bruny Island
Dairy.
b. Explain how these factors would influence your choice between
the predominantly substantive approach (where planned detection
risk is set at low-medium) and the lower assessed level of control
risk approach (where planned detection risk is set at medium -high)
for sales, inventory and debtors.
In: Finance
1. purchased on sept 1 a one year insurance policy for 1,200
2. provided services to customers during sept and recieved $30,000 cash
Using the equation, write what category (ie cash, A/R, etc) is increased, decreased or no effect for these sections:
Assets=Liabilities+Stockholder's Equity
2nd part//////
using the same formula, assets=liabilities+stockholder's equity, the company needs to record the following ADJUSTING transactions to update their records AT THE END OF THE MONTH
1. the company did a pysical count of suplies and deteremined 1k of supplies are still on hand. record the use of supplies.
2. te company provided services of 1,000 to the customer paid in advance (previously, they recieved a 5,000 cash advance from a customer for services not yet received which resulted cash +5000, unearned revenue +5000)
3. depreciation expense on equipment of $500 needs to be recorded.
4. record insurance expense for the month of october.
5. record accural of interest expense on note payable for the month of october.
In: Accounting
Exercise 5-14 Effect of credit card sales on financial statements LO 5-5
Ultra Day Spa provided $85,050 of services during 2018. All customers paid for the services with credit cards. Ultra submitted the credit card receipts to the credit card company immediately. The credit card company paid Ultra cash in the amount of face value less a 4 percent service charge.
Required
In: Accounting
1. You are the chief financial officer of a firm. You determine that when your firm increased prices by 1%, the quantity demanded by your customers decreased by 0.1%. Demand facing your firm must be _________ and you should _________ in order to maximise total revenue.
(a) elastic; increase prices
(b) elastic; decrease prices
(c) inelastic; decrease prices
(d) inelastic; increase prices
(e) unit-elastic; leave prices unchanged
2. In a competitive market where the government has introduced a price floor above the equilibrium price, one might expect:
|
(a) quantity demanded to equal quantity supplied. |
||
|
(b) excess quantity to be supplied. |
||
|
(c) a shortage to develop. |
||
|
(d) total economic surplus to be reduced. |
||
|
(e) both (b) and (d). |
3. Explain why firms in perfect competition and monopolistic competition markets earn zero economic profits in the long run, while monopoly firms can earn positive economic profits in the long run.
In: Economics
Gym Equipment Manufacturers Ltd (GEM) manufactures and sells gym equipment. It also installs the gym equipment for their customers.
On 1 January 2020, Keeping Fit Gym in Auckland signed a contract to purchase a piece of personalised gym equipment from GEM Ltd. The purchase price in the signed contract is $39,000. GEM Ltd also offers free installation service of the equipment to Keeping Fit.
The selling price of the same type of gym equipment, excluding the free installation, is $36,450. The installation of the equipment can also be done by registered manufacturers at $4,050.
On 10 January 2020, Keeping Fit paid the full amount, and on the same day, the equipment was delivered. The installation of the equipment was performed on the 20 January 2020.
Required:
(a) Advise GEM Ltd on how to recognise the revenues
in accordance with the 5-step model in NZ IFRS 15. (You are
required to explain each step in the model with
calculations).
(b) Prepare relevant journal entries to recognise
revenue for the above sale in terms of the 5-step model in GEM
Ltd’s books.
In: Accounting
At January 1, 2021, Tanner Company reported accounts receivable of $262,750 and had an allowance for doubtful accounts with a $13,690 credit balance. During 2021, Tanner Company had sales revenue of $531,250, recoveries of $6,190, cash collections from credit customers of $493,580 (the $493,580 does not include the recovery), and bad debt expense of $20,870. During 2021, Tanner Company wrote-off accounts receivable as being uncollectible (note - the amount of the write-offs has been intentionally omitted from this problem).
At December 31, 2021, Tanner Company prepared the following aging schedule:
Accounts Receivable % Uncollectible
not past due $146,100 3%
1-45 days past due 56,400 9%
46-90 days past due 38,600 11%
91-135 days past due 21,850 ?
over 135 days past due 23,930 40%
Calculate the percentage estimated to be uncollectible for the accounts receivable that are 91-135 days past due.
In: Accounting
GGG uses a perpetual inventory system. The company’s beginning inventory of a particular product and its purchases during the months of January and February were as follows:
Quantity Unit Cost
Beginning inventory (Jan. 1)................................................. 50 $6.00
Purchase (Jan. 10)................................................................. 25 7.00
Purchase (Jan. 22)................................................................. 25 8.52
Purchase (Feb. 9)………………………………………… 65 11.00
Total ...............................................................................
On February 25, GGG sells 65 units of this product. The other units remain in inventory at February 25.
a Determine the cost of goods sold using each of the following flow assumption. SHOW ALL WORK!
(1) LIFO $_____________
(2) FIFO $_____________
(3) Average cost $_____________
b Determine the cost of the units in ending inventory at February 25 using each of the following flow assumptions. SHOW ALL WORK!
(1) LIFO $_____________
(2) FIFO $_____________
(3) Average cost $_____________
c. Assume that the units are sold to customers at a price of $17 per unit. Compute the total sales revenue to be recognized upon sale of the product?
In: Accounting
Exercise 1 (LO 1, 2) Gross profit: separate firms versus consolidated. Sorel is an 80%-owned subsidiary of Pattern Company. The two affiliates had the following separate income statements for 2015 and 2016.
| Sorel Company | Pattern Company | |||
| 2015 | 2016 | 2015 | 2016 | |
| Sales Revenue | 250,000 | 350,000 | 500,000 | 540,000 |
| Cost of Good Sold | 150,000 | 210,000 | 310,000 | 360,000 |
| Gross Profit | 100,000 | 140,000 | 190,000 | 180,000 |
| Expenses | 45,000 | 66,000 | 120,000 | 125,000 |
| Net Income | 55,000 | 74,000 | 70,000 | 55,000 |
Sorel sells at the same gross profit percentage to all customers. During 2015, Sorel sold goods Pattern for the first time in the amount of $120,000. $30,000 of these sales remained in Pattern's ending inventory. During 2016, sales to Pattern by Sorel were $150,000, of which $25,000 sales were still in Pattern's December 31, 2016, inventory.
Prepare consolidated income statements including the distribution of income to the controlling and noncontrolling interest for 2015 and 2016.
In: Accounting