Table 1 shows Apple's online orders for the last week. When shoppers place an online order, several
Question:
Table 1 shows Apple's online orders for the last week.
•When shoppers place an online order, several "recommended products" (upsells) are shown as at checkout an attempt to upsell
•See table 2 in cell N2 for a list of products that Apple upsells at checkout.
•Upsells, however, will not be shown if the shopper has added either the iPad Mini , iPad Pro, Special Offer or iPhone7, Special Offer into the their shopping cart. For the purpose of this analysis, any orders containing these products are considered ineligible transactions. All other orders are considered eligible transactions.
•You are tasked with providing a report to management about last week's eligible transactions.
•Construct formulas to answer the five questions to the right of the data table (N14:N22).
Table 1. Apple Online Orders for the Week of January 1-7, 2017 Order # - Product 1 I Product 2 T Product 3 T Product 4 T Product 5 - Product 6 I Product 7 - Product 8 - Product 9 2 iPad Pro AppleCare USB Car Charger МасВook iPad Air Smart Battery Case iMac Apple Watch iPhone7 USB Car Charger USB Car Charger 3 iPad Pro AppleCare МасВook iPad Air iMaç Smart Battery Case Apple Watch iPhone7 iPad Pro AppleCare iPad Air iMac Smart Battery Case Apple Watch iPhone7 5 iPad Pro USB Car Charger МaсВook iPad Air Smart Battery Case Apple Watch iPhone7 7 AppleCare USB Car Charger iPad Air Smart Battery Case Apple Watch iPhone7 8 iPad Pro AppleCare МасВook iPad Air iMac iPhone7 9 Smart Battery Case AppleCare USB Car Charger iPad Air iMac iPhone7 10 iPad Pro iPad Air iMac Apple Watch iPhone7 11 AppleCare USB Car Charger Smart Battery Case Apple Watch iPhone7 12 AppleCare USB Car Charger Smart Battery Case iMac iPhone7 13 AppleCare USB Car Charger iMac Smart Battery Case iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger 14 iPad Air Smart Battery Case iPhone7 15 iPad Air Smart Battery Case iPhone7 USB Car Charger USB Car Charger 16 iPad Pro AppleCare Smart Battery Case iPhone7 iPad Pro AppleCare USB Car Charger 17 Smart Battery Case iPhone7 18 AppleCare iPhone 6s Smart Battery Case iPhone7 19 AppleCare Smart Battery Case Apple Watch iPhone7 20 iPad Pro iPad Air iMac iPhone7 USB Car Charger USB Car Charger 21 Smart Battery Case iMac iPhone7 22 Smart Battery Case, Sp iMac iPhone7 25 USB Car Charger iPad Air Smart Battery Case, Sp iPhone7 26 AppleCare МасВook Smart Battery Case, Sp iPhone7 AppleCare AppleCare 27 MaсBook Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 28 Smart Battery Case, Sp iPhone7 29 AppleCare Smart Battery Case, Sp iPhone7 30 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare 31 USB Car Charger Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 32 Smart Battery Case, Sp iPhone7 33 AppleCare Smart Battery Case, Sp iPhone7 34 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger USB Car Charger USB Car Charger 35 Smart Battery Case, Sp iPhone7 36 Smart Battery Case, Sp iPhone7 AppleCare AppleCare 37 Smart Battery Case, Sp iPhone7 38 Smart Battery Case, Sp iPhone7 Table 1. Apple Online Orders for the Week of January 1-7, 2017 Order # - Product 1 I Product 2 T Product 3 T Product 4 T Product 5 - Product 6 I Product 7 - Product 8 - Product 9 2 iPad Pro AppleCare USB Car Charger МасВook iPad Air Smart Battery Case iMac Apple Watch iPhone7 USB Car Charger USB Car Charger 3 iPad Pro AppleCare МасВook iPad Air iMaç Smart Battery Case Apple Watch iPhone7 iPad Pro AppleCare iPad Air iMac Smart Battery Case Apple Watch iPhone7 5 iPad Pro USB Car Charger МaсВook iPad Air Smart Battery Case Apple Watch iPhone7 7 AppleCare USB Car Charger iPad Air Smart Battery Case Apple Watch iPhone7 8 iPad Pro AppleCare МасВook iPad Air iMac iPhone7 9 Smart Battery Case AppleCare USB Car Charger iPad Air iMac iPhone7 10 iPad Pro iPad Air iMac Apple Watch iPhone7 11 AppleCare USB Car Charger Smart Battery Case Apple Watch iPhone7 12 AppleCare USB Car Charger Smart Battery Case iMac iPhone7 13 AppleCare USB Car Charger iMac Smart Battery Case iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger 14 iPad Air Smart Battery Case iPhone7 15 iPad Air Smart Battery Case iPhone7 USB Car Charger USB Car Charger 16 iPad Pro AppleCare Smart Battery Case iPhone7 iPad Pro AppleCare USB Car Charger 17 Smart Battery Case iPhone7 18 AppleCare iPhone 6s Smart Battery Case iPhone7 19 AppleCare Smart Battery Case Apple Watch iPhone7 20 iPad Pro iPad Air iMac iPhone7 USB Car Charger USB Car Charger 21 Smart Battery Case iMac iPhone7 22 Smart Battery Case, Sp iMac iPhone7 25 USB Car Charger iPad Air Smart Battery Case, Sp iPhone7 26 AppleCare МасВook Smart Battery Case, Sp iPhone7 AppleCare AppleCare 27 MaсBook Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 28 Smart Battery Case, Sp iPhone7 29 AppleCare Smart Battery Case, Sp iPhone7 30 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare 31 USB Car Charger Smart Battery Case, Sp iPhone7 USB Car Charger USB Car Charger USB Car Charger 32 Smart Battery Case, Sp iPhone7 33 AppleCare Smart Battery Case, Sp iPhone7 34 AppleCare Smart Battery Case, Sp iPhone7 AppleCare AppleCare USB Car Charger USB Car Charger USB Car Charger USB Car Charger 35 Smart Battery Case, Sp iPhone7 36 Smart Battery Case, Sp iPhone7 AppleCare AppleCare 37 Smart Battery Case, Sp iPhone7 38 Smart Battery Case, Sp iPhone7
Expert Answer:
REPORT All the orders that were placed transactions were eligible since non of the orders had the products iPad mini iPad pro special offer or iPhone ... View the full answer
Students also viewed these accounting questions
-
The following is a list of costs that were incurred in the production and sale of boats: a. Commissions to sales representatives, based upon the number of boats sold. b. Cost of boat for grand prize...
-
The following is a list of measures that may be found in a business' balanced scorecard. Assume the scorecard is divided into the four typical perspectives. (1) Percentage of current employees who...
-
The following is a list of transactions that occurred during the year. Instructions Complete the above table, indicating in which classification(s) each transaction would appear in a statement of...
-
You have been asked to calculate the cost of capital of Mulligan Ltd, a company which specialises in developing new medical equipment products. The following information is available regarding the...
-
The following are historical data on staff salaries (dollars per pupil on 30 schools sampled in the eastern part of the United States in the early 1970s).(a) Compute the sample mean and sample...
-
The nation of Waipo has recently created an economic development plan that includes expanded exports and imports. It has completed a series of extensive studies of the world economy and Waipo's...
-
Bakers versus brewers yeast. The Electronic Journal of Biotechnology (Dec. 15, 2003) published an article on a comparison of two yeast extracts: bakers yeast and brewers yeast. Brewers yeast is a...
-
1. Develop a multiple regression equation using unemployment rate and average monthly temperature to predict emergency road service calls. 2. Create a new temperature variable and relate it to...
-
What is the primary difference between transaction exposure and accounting exposure? Multiple Choice These are not reported in the consolidated financial statements Any gain is shown in the balance...
-
write a closed-research legal memo using the case cases given, addressing whether Mr. Adler can assert an adverse possession claim to Scrub Lot 40. Please write up your memo using the issue , brief...
-
2. What is the difference between the following two sequences of code? (1 point) (a) SKIP (b) &BETA LDA COMP #0 ALPHA JEQ LDA STA SKIP #3 BETA IF SET ENDIF (&ALPHA NE 0)
-
Will the amount of an accrual always be an exact known amount, or could it be an estimate?
-
The reorder point for SKU 303 is 102 units, while average demand during the lead time on an order for SKU 303 is 97 units. How much safety stock is implied by SKU 303's reorder point policy?
-
Please make an excel sheet for the following scenario: The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research...
-
Sales Data for all customers and products MySQL Please! The query should return all customers ,even customers without invoices and also products,even those products that were not sold.Print NA for...
-
You are considering investing in three different assets. The first is a stock, the second is a long-term government bond and the third is a T-bill money market fund that yields a sure rate of 5%. The...
-
Stark Company's most recent balance sheet reported total assets of $178 million, total liabilities of $0.86 million, and total equity of $0.92 million. Its Debt to equity ratio is: Mutiple Choice...
-
Express mass density in kg/m3 and weight density in lb/ft3. 1. Find the mass density of a chunk of rock of mass 215 g that displaces a volume of 75.0 cm3 of water. 2. A block of wood is 55.9 in. x...
-
The Sweet Smell Fertilizer Company markets bags of manure labeled "not less than 60 lb dry weight." The packaged manure is a combination of compost and sewage wastes. To provide good-quality...
-
Explain what is meant in service design by the moment of truth.
-
List five steps in developing and using x-charts and R-charts,
-
Use the PewHealth dataset to address this question: is there a difference between men and women with regard to their willingness to seek out health information on the Internet (as measured by the...
-
Although poor people are the predominant recipients of welfare, they are not one and the same, especially with regard to how people feel about each group. Using ANES data, run t-tests comparing...
-
Using the ANES unique group of sad men, here are the raw data for the recoded religious attendance variable for three groups on the Word of God variable: Literal Word of God: 0, 1.5, 3, 1.5, 8, 0...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App