Data Analytics For Accounting
19th Edition
ISBN: 9781260375190
Author: RICHARDSON, Vernon J., Teeter, Ryan, Terrell, Katie
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Question
Chapter 4, Problem 6P
To determine
Identify the chart which would be used to assess geographic customer concentration by number. Explain how it could be shown if some customers buy more than other customers on such a map.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Mischief, Inc., is a regional pet toy supplier that tracks its business sales in a spreadsheet. The owner, Lisa Derrick, has provided you with a skeleton worksheet, T2_TotalMischief_ Data.xls, with the totals for each quarter by sales region. Lisa needs you to total each column and row, and then provide her with a clustered column chart of each region by quarter. See Figure T2.21 for a sample of what Lisa would like you to do.
Regional Sales Summary
1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Totals
Northeast
$ 119,700.00
$ 125,100.00
$ 133,400.00
$ 139,500.00
South
$ 48,900.00
$ 52,000.00
$ 49,600.00
$ 54,500.00
Midwest
$ 34,600.00
$ 32,200.00
$ 47,000.00
$ 45,900.00
West
$ 56,200.00
$ 49,000.00
$ 52,000.00
$ 51,300.00
Totals
Retail companies with today’s online, as well as in-store sales have a lot of data to keep track of!
Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company.
Create the following calculated columns.
a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product
Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table
sheet lists the Price and Cost] If any error messages appear, check the Range Lookup.
b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product
Cost)*Units Sold
Format columns I, J, and K as currency with two decimal places.
Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly.
a) What was the…
For the Restaurant Sales database,:(a) Obtain the Min and Max amount in sales(b) For each Bin shown in the excel sheet, calculate the frequency for each bin as follows:For ex: if the Bin value is $200, the frequency is the number of entries, whose sales are Less than or equal to 200.Next Bin value is $250 => Frequency is the number of entries, whose sales is >200 and less than or equal to 250.And so on….
(c) Now that your values for Frequency and Bins is complete, use any data visualization tool/chart to plot – Sales on the X axis and Frequency on Y axis.(d) Looking at the plot /graph/chart in (c), what do you infer about the relationship?
Chapter 4 Solutions
Data Analytics For Accounting
Ch. 4 - Prob. 1MCQCh. 4 - In the late 1960s, Ed Altman developed a model to...Ch. 4 - Justin Zobel suggests that revising your writing...Ch. 4 - Prob. 4MCQCh. 4 - The Fahrenheit scale of temperature measurement...Ch. 4 - _______ data would be considered the least...Ch. 4 - ________ data would be considered the most...Ch. 4 - Prob. 8MCQCh. 4 - Exhibit 4-8 gives chart suggestions for what data...Ch. 4 - Prob. 10MCQ
Ch. 4 - Prob. 1DQCh. 4 - Prob. 2DQCh. 4 - Prob. 3DQCh. 4 - Prob. 4DQCh. 4 - Prob. 5DQCh. 4 - Based on the data from datavizcatalogue.com, how...Ch. 4 - Prob. 7DQCh. 4 - Prob. 8DQCh. 4 - Prob. 9DQCh. 4 - Prob. 1PCh. 4 - Prob. 2PCh. 4 - Prob. 3PCh. 4 - According to Exhibit 4-8, which is the best chart...Ch. 4 - Prob. 5PCh. 4 - Prob. 6PCh. 4 - Prob. 7P
Knowledge Booster
Similar questions
- You have decided to open up a small convenience store in your hometown. As part of the initial set-up process, you need to determine whether to use a perpetual inventory system or a periodic inventory system. Write an evaluation paper comparing the perpetual and periodic inventory systems. Describe the benefits and challenges of each system as it relates to your industry and to your business size. Compare at least one example transaction using the perpetual and periodic inventory systems (a purchase transaction, for example). Research and describe the impact each system has on your financial statements. Decide which system would be the best fit for your business, and support your decision with research.arrow_forwardYou are creating part of an Excel model that will set the price of an item based on whether the customer is a preferred customer or not. The partially completed model in the attached file. <-- Click here to download the Excel file. In cell B6, you will enter the formula that will use this logic:When preferred status is Yes, the price is the preferred price. Otherwise the price is the regular price. Customer ID: 68YJW Prices: Regular $26.95 Customer Name Reggie Greene Preferred $21.95 Preferred? Y/N: Yes Customer Pricearrow_forwardI need help answering the questions below... 1. Using the assumptions provided in Excel Spreadsheet, what is the total number of customers generated from this advertising? 2. If Dr. Corneal’s customers spend $300 on average, what is the total revenue generated from this advertising? 3. The cost to purchase the advertising is as follows: Google Ads: $5,000 Newspapers: $3,000 Magazines: $6,000 Radio: $1,000 Calculate the overall ROI and the ROI per advertising source. How do these number help you plan your advertising budget going forward? To answer this question, define ROI, explain how ROI is used (see your book), apply the numbers you have calculated and show how you would use these numbers for planning purposes. Note - ROI is expressed as a percent. ROI= (Revenue - Costs)/Costsarrow_forward
- A firm plans to use three different types of ads to attract potential customers to its product. The three ad choices are TV ads, Magazine ads, and Sunday Supplement. The following table shows the number of potential customers one ad can reach: TV Ads (TV) - Number of Potential Customers Attracted per Ad 1,500 Magazine Ads (M) - Number of Potential Customers Attracted per Ad 500 Sunday Supplement - (SS)Number of Potential Customers Attracted per Ad 500 There are two categories of spending per ad as below ($, Thousands): Cost Per Ad ($Thousands) TV Ads (TV) Magazine Ads (M) Sunday Supplement (SS) Ad Budget 250 100 100 Planning Budget 100 50 50 There are following constraints: Total Ad Budget <= 3,500 Total Planning Budget <= 1,500 Total number of TV ads <= 5 The question is to find the optimal numbers of TV ads, Magazine ads, and Sunday Supplement, so that the total number of the potential customers attracted by these ads can be MAXIMIXZED.arrow_forwardConsider the following survey results regarding smartphone ownership by age: a. Construct a stacked-column chart to display the survey data on type of cell-phone ownership. Use Age Category as the variable on the horizontal axis. b. Construct a clustered column chart to display the survey data. Use Age Category as the variable on the horizontal axis. c. What can you infer about the relationship between age and smartphone ownership from the column charts in parts a and b? Which column chart (stacked or clustered) is best for interpreting this relationship? Why?arrow_forwardEntrepreneur magazine ranks franchises. Among the factors that the magazine uses in its rankings are growth rate, number of locations, start-up costs, and financial stability. A recent ranking listed the top 20 U.S. franchises and the number of locations as follows: These data can be found in the file Franchises. Create a PivotTable to summarize these data using classes 09,999, 10,00019,999, 20,00029,999, 30,00039,999 to answer the following questions. (Hint: Use Number of U.S. Locations as the COLUMNS, and use Count of Number of U.S. Locations as the VALUES in the PivotTable.) a. How many franchises have between 0 and 9,999 locations? b. How many franchises have more than 30,000 locations?arrow_forward
- Given the following business rules, construct an ER diagram so each rule is captured for the database. Presume each rule is to be treated individually. Construct an ER diagram for each rule.a. A retail sales company prepares sales orders for its customers’ purchases. A customer can make many purchases, but a sales order is written for a single customer.b. A retail sales company orders inventory using a purchase order. An inventory item may be ordered many times, and a purchase order may be created for more than one inventory item.c. A company that sells antique cars prepares a sales order for each car sold. The inventory for this company consists of unique automobiles, and only one of these automobiles may be listed on a sales order.d. A grocery store identifies returning customers via a plastic card that the clerk scans at the time of each purchase. The purpose of this card is to track inventory and to maintain a database of customers and their purchases. Obviously, a customer may…arrow_forwardThe foundation of every marketing strategy is the identification of a target market and the development of a marketing mix. The marketing mix is commonly referred to as the 4 P's of marketing: Product Price Place (also called distribution) Promotion Think about a fairly significant purchase you made recently and analyze how this product or service was marketed to you by the company. Do you think you are part of the target market that the company identified for this product? How did the company use the 4 P's of marketing to try to convince you to buy this product?arrow_forwardA company will buy one of two labeling machines. About theminformation is given below. Which machine do you recommend?arrow_forward
- Which of the following retailers would be the best fit for the Jackery product? (Highlight one answer) Amazon Walmart Cabela’s REI Explain your answerarrow_forwardSunset Graphics often buys inventory after receiving a sales order from the customer. Suppose you are asked to prepare one UML class diagram that combines both the sales and collection process and the purchases and payments process. What would be shared among those processes? What would be unique to each process? Why?arrow_forwardCamel is not the only Amazon tracking or online pricetracking application. Find and describe an exampleof another online price tracking tool for consumers.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L
Principles of Accounting Volume 1
Accounting
ISBN:9781947172685
Author:OpenStax
Publisher:OpenStax College
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,