Principles of Accounting Volume 2
19th Edition
ISBN: 9781947172609
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Question
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 total Profit for Online Sales?
- b) Sort the results by Date Sold (A/Z).
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps

Knowledge Booster
Similar questions
- The following information is from Dessert Dynasty. The company runs three stores and the December Income Statement for all stores is shown. A. Find the missing values for retail revenue, ingredients, and operating income. B. Comment on the financial performance of each store. C. Identify a limitation of analyzing the information provided. You may want to consider using Microsoft Excel or another spreadsheet application for the numerical data. This information will be used in a subsequent question.arrow_forwardWhich of the following are common use cases for VLOOKUP? (Check all that apply) Check All That Apply Finding a customer's name based on their ID Calculating the total sales of a specific product Looking up a product's price in a price list Retrieving an employee's phone number from a database Returning values from a different sheet in the same workbook.arrow_forwardWhat are the steps to create a new estimate in QuickBooks Online? Projects > All Sales > New Transaction > Estimate Sales > Customers > New Customer Sales > All Sales > New Transaction > Estimate Gear icon > Estimatearrow_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_forwardi. Briefly inform these stakeholders of the benefits of automation on the current business processes within the organization, specifically referencing the benefits of using a spreadsheet solution and how easy it was to process data to derive the information presented in the report. ii. Give a brief analysis of the data found in the chartarrow_forwardBrian just completed a Client Needs Assessement and his client confirmed that she will requre profitability tracking, and need to create budgets and purchase orders in her accounting solution. What is the mimimum Quick Books online version suitable for Brian's client?arrow_forward
- A wide range of accounting information system (AIS) software programs are available in the marketplace. Businesses select one that fits their needs based on budget and systems requirements. Do some research to understand the differences between the way systems process accounting information and produce reports. Choose two types of software from the following list to compare: QuickBooks, Peachtree, Oracle NetSuite, SAP, or MS Access. compare these aspects of each software program: Compare the pros and cons of each system to show the system's benefits and drawbacks for businesses in the way they handle transaction processing for accounting cycles. Discuss the way artificial intelligence (AI) or machine learning is utilized in the system and how these tools elevate data processing and data analytics.arrow_forwardYou can use Excel functions to find the answers for the following question (round off the values to 4 decimal places): a. Supplier on-time delivery performance is critical to enabling the buyer’s organization to meet its customer service commitments. Therefore, monitoring supplier delivery times is critical. Based on a great deal of historical data, a manufacturer of personal computers finds for one of its just-in-time suppliers that the delivery times are random and well approximated by the Normal distribution with mean 51.7 minutes and standard deviation 9.5 minutes.arrow_forwardUse the following information to answer the questions that follow. A. Calculate the operating income percentage for each of the stores. Comment on how your analysis has changed for each store. B. Perform a vertical analysis for each store. Based on your analysis, what accounts would you want to investigate further? How might management utilize this information? C. Which method of analysis (using a dollar value or percentage) is most relevant and/or useful? Explain.arrow_forward
- Value chain classifications Match each of the following cost items with the value chain business function where you would expect the cost to be incurred: Cost Item Answer Business Function a. Research and development b. Design c. Production d. Marketing e. Distribution t Customer service 1. Labor time to repair products under warranty 2. TV commercial spots 3. Labor costs of filling customer orders 4. Testing of competitor's product 5. Direct manufacturing labor costs 6. Development of order tracking system for the Internet 7. Printing cost of new product brochures 8. Hours spent designing childproof bottles 9. Training costs for representatives to staff the customer call center 10. Installation of robotics equipment in manufacturing plantarrow_forwardHello! Please help me answer the question and activity costs. they are both in bold. Thank you!! :) Selecting Chart of Accounts The company’s accounting intern is new and has confused the Finn Corporation’s regular chart of accounts with the proposed chart of accounts for the lean accounting system. Review the charts of accounts on the Chart of Accounts I and Chart of Accounts II, and then answer the following question. Which chart of accounts should Finn Corporation most likely implement if they want to use lean accounting principles? (chart of accounts I, chart of accounts II, both will work equally well) Question Content Area Cost of Quality Report This year, Finn Corporation implemented programs designed to assess the costs of quality for the company. However, the company recently suffered a data loss, and some of its records have been either partially or completely erased. The accounting intern for Finn Corporation has located a copy of a recent cost of quality…arrow_forwardSubject - account Please help me. Thankyou.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning
- Essentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College

College Accounting, Chapters 1-27
Accounting
ISBN:9781337794756
Author:HEINTZ, James A.
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

Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning