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.
Want to see the full answer?
Check out a sample textbook solutionChapter 9 Solutions
Principles of Accounting Volume 2
Additional Business Textbook Solutions
Managerial Accounting (4th Edition)
Financial Accounting, Student Value Edition (5th Edition)
Principles of Accounting Volume 1
Financial Accounting (11th Edition)
Financial Accounting (12th Edition) (What's New in Accounting)
Financial Accounting, Student Value Edition (4th Edition)
- The following information is from Bluff Run Golf Courses. The company runs three courses and the July income statement for each course is shown. A. Find the missing value for outings revenue, wages, and operating income. B. Comment on the financial performance of each course. 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_forwardRetail 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…arrow_forwardJPL, Inc. has provided its sales and expense data for the most recent period. The Controller has asked you prepare a spreadsheet that shows the related CVP Analysis computations. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below, if in a blank cell, =B5" was entered, the formula would output the result from cell B5. or 75 in this example. • Beslc Math functlons: Allows you to use the basic math symbols to perform mathematical functions. You can use the following keys: - (plus sign to add). - (minus sign to subtract). * (asterisk sign to multiply). and / (forward slash to divide). From the Excel Simulation below, if in a blank cell "=85+B6" was entered, the formula would add the values from those cells and output the result, or 120 in this example. If using the other math symbols the result would output an…arrow_forward
- Refer to Exhibit 2–3, and answer the following questions.Required:1. List the major differences between the income statements shown for Caterpillar, Inc., Walmart Stores, Inc., and Southwest Airlines Company.2. Explain how cost-accounting data were used to prepare these income statements.3. On the income statement for Southwest Airlines Company, where would the ticket agents’ salaries be shown? Where would the costs of the computer equipment used to keep track of reservations be included on the statement?4. On the income statement for Walmart Stores, Inc., where would the cost of newspaper advertising be shown? How about the cost of merchandise?5. Refer to the income statement for Caterpillar, Inc. Where would the salary of the brand manager who plans advertising for Caterpillar equipment be shown? How about the salary of a production employee? Where would the cost of the raw materials used in the company’s products be included on the statement?arrow_forwardYour Task… Using your assigned financial statements calculate the required ratios below Indicate if the change from year to year is favorable or unfavorable. All values should be accurate to at least two decimal places. The expectation is to submit a professional report free of grammar and spelling errors and easy to read. Think of this as a menu you would be handing to a customer. All calculations are to be represented. Analysis of Profitability Gross Profit Ratio Operating Profit Ratio Net Profit Ratio Sales to Total Assets Ratio Return on Total Assets Return on Equity Earnings Per Sharearrow_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_forward
- Answer the following questionsYou were hired to assist Oman based Company in designing an accounting system for Oman Co., Ltd. has developed a list of the journals, ledgers, reports and documents that he thinks Oman Co., Ltd. The company asks you to complete the following tasks:a) Specify what data you think should be collected on each of the following four documents: Sales invoice, purchase order, receiving report, employee time card.b) Design a report to manage inventory.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_forwardThe Northwest regional manager of Logan Outdoor Equipment Company has conducted a study to determine how her store managers are allocating their time. A study was undertaken over three weeks that collected the following data related to the percentage of time each store manager spent on the tasks of attending required meetings, preparing business reports, customer interaction, and being idle. The results of the data collection appear in the following table: a. Create a stacked-bar chart with locations along the vertical axis. Reformat the bar chart to best display these data by adding axis labels, a chart title, and so on. b. Create a clustered-bar chart with locations along the vertical axis and clusters of tasks. Reformat the bar chart to best display these data by adding axis labels, a chart title, and the like. c. Create multiple bar charts in which each location becomes a single bar chart showing the percentage of time spent on tasks. Reformat the bar charts to best display these data by adding axis labels, a chart title, and so forth. d. Which form of bar chart (stacked, clustered, or multiple) is preferable for these data? Why? e. What can we infer about the differences among how store managers are allocating their time at the different locations?arrow_forward
- Please see below. The amounts can be made up but please make sure that they make sense for a merchandising company. Need asap please.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_forwardafter analyzing the skeletal profit and loss statement, a retailer is suffering a loss. list three ways and give examples of what they can do to turn the loss into profit. (Please explain)arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning
- College Accounting (Book Only): A Career ApproachAccountingISBN:9781337280570Author:Scott, Cathy J.Publisher:South-Western College PubCentury 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:CengageCollege Accounting, Chapters 1-27AccountingISBN:9781337794756Author:HEINTZ, James A.Publisher:Cengage Learning,