Principles of Accounting Volume 2
19th Edition
ISBN: 9781947172609
Author: OpenStax
Publisher: OpenStax College
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 9, Problem 3EB
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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Every March, Buddie, who owns and operates a small retail shop, takes a large box of receipts and invoices to her accountant so the accountant can file Buddie's taxes in April. Only then does Buddie know if her business has been profitable. Buddie could benefit from a(n) ________.Select one:a. concurrent control systemb. management information system c. balanced scorecard systemd. inventory control system
At the end of February, after the second month of operations of Able Baker Charlie Company, Charles shows you the data he’s collected, but he was unable to figure out some of the amounts. Review the following data and fill in the missing amounts on the chart for Able Baker Charlie Company. Note: It may be helpful to use T accounts to map the flow of the amounts through the manufacturing accounts and solve for the missing dollar values. It may also be helpful to review the steps for determining the cost of materials used, total manufacturing cost incurred, and cost of goods manufactured.
Data for February
Decrease in materials inventory
$2,700
Materials inventory on Feb. 28
50% of materials inventory on Jan. 31
Direct materials purchased
$12,300
Direct materials used
3 times the direct labor incurred
Total manufacturing costs incurred in period
$29,400
Total manufacturing costs incurred in period
70% of Cost of Goods Manufactured
Total manufacturing costs incurred in…
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…
Chapter 9 Solutions
Principles of Accounting Volume 2
Ch. 9 - Which of the following is nor a common goal of an...Ch. 9 - Which of the following does not describe a...Ch. 9 - In centralized organizations, primary decisions...Ch. 9 - A key advantage of a decentralized organization is...Ch. 9 - Strategic decisions occur ______. A. frequently...Ch. 9 - Segments are uniquely identifiable components of...Ch. 9 - Organizational charts _____. A. list the salaries...Ch. 9 - In a centralized organization, where are goals...Ch. 9 - Managers in decentralized organizations make...Ch. 9 - Which of the following is not a type of...
Ch. 9 - A system that establishes financial accountability...Ch. 9 - A responsibility center in which managers are held...Ch. 9 - A responsibility center structure that considers...Ch. 9 - An important goal of a responsibility accounting...Ch. 9 - Costs that a company or manager can influence are...Ch. 9 - An example of an uncontrollable cost would include...Ch. 9 - Internal costs that are charged to the segments of...Ch. 9 - A transfer pricing arrangement that uses the price...Ch. 9 - A transfer pricing structure that considers the...Ch. 9 - What is a management control system? What are its...Ch. 9 - Identify and describe the levels of management,...Ch. 9 - Discuss the difference between centralized and...Ch. 9 - Identity a company where you recently shopped....Ch. 9 - Discuss the difference between daily and strategic...Ch. 9 - Define segments and describe how identifying...Ch. 9 - Choose a company and describe how a specific...Ch. 9 - Choose a company and explain how a specific issue,...Ch. 9 - Assume you are the manager of a local Starbucks....Ch. 9 - Assume you are the manager of a local Starbucks....Ch. 9 - Lavell started out mowing lawns in the...Ch. 9 - Describe the concept of responsibility accounting.Ch. 9 - Describe the concept of a cost center and, using a...Ch. 9 - Describe the concept of a profit center and, using...Ch. 9 - Explain the benefits of a return on investment...Ch. 9 - Explain the benefits of a residual income...Ch. 9 - Discuss the concept of controllable and...Ch. 9 - Discuss the concept of transfer pricing.Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Discuss the advantages and disadvantages of a...Ch. 9 - Assume you have been hired by Hilton Hotels and...Ch. 9 - Consider the national nonprofit organization the...Ch. 9 - The following information is from Bluff Run Golf...Ch. 9 - The following information is from Daves Sporting...Ch. 9 - Assume you are the department B manager for...Ch. 9 - As manager of department B in MarIeys...Ch. 9 - Based on your research of the market in the...Ch. 9 - Using the information in the previous exercises...Ch. 9 - Assume you have been hired by Cabelas Sporting...Ch. 9 - Assume you are the regional manager for a hotel...Ch. 9 - The following information is from Dessert Dynasty....Ch. 9 - The following information is from Good Read Books....Ch. 9 - Assume you are the warehouse manager for Vinnies...Ch. 9 - As manager of the warehouse for Vinnies Vinyls,...Ch. 9 - Discuss how, as warehouse manager for Vinnies...Ch. 9 - Determine the operating income for Vinnies Vinyls...Ch. 9 - Use the following information to answer the...Ch. 9 - The income statement comparison for Forklift...Ch. 9 - Assume you are the leather department manager at...Ch. 9 - Financial information for BDS Enterprises for the...Ch. 9 - Using the information from BDS Enterprises,...Ch. 9 - Management of Great Springs Bottled Water Company...Ch. 9 - The following revenue data were taken from the...Ch. 9 - Use the following information to answer the...Ch. 9 - The income statement comparison for Rush Delivery...Ch. 9 - Assume you are the manager for the semi-trucks...Ch. 9 - Financial information for Lighthizer Trading...Ch. 9 - Using the information for Lighthizer Trading...Ch. 9 - Management of Green Peak Tea Company has asked...Ch. 9 - The following revenue data were taken from the...Ch. 9 - You have just been elected president of a...
Additional Business Textbook Solutions
Find more solutions based on key concepts
Discussion Analysis A13-41 Discussion Questions 1. How do managers use the statement of cash flows? 2. Describ...
Managerial Accounting (4th Edition)
Quick ratio (Learning Objective 7) 510 min. Calculate the quick assets and the quick ratio for each of the foll...
Financial Accounting, Student Value Edition (5th Edition)
Pickles R Us is a pickle farm located in the Northeast. The following transactions take place: A. On November 6...
Principles of Accounting Volume 1
The accounting assumption that governs given situation.
Financial Accounting (11th Edition)
LO 3, 4 (Learning Objectives 3, 4: Evaluate business operations through financial statements; correct errors; c...
Financial Accounting (12th Edition) (What's New in Accounting)
Quick ratio (Learning Objective 7) 510 min. Calculate the quick assets and the quick ratio for each of the foll...
Financial Accounting, Student Value Edition (4th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- 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_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_forwardRefer 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_forward
- The 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_forward1. Identifying alternative accounting treatments: A new restaurant is opening in one month, and the manager will be holding a one-week intensive training session for new employees. Describe two possible accounting methods for accounting for the costs of training the employees. Codification research is not required for this exercise; your goal on this exercise is just to brainstorm. 2. Identify at least one researchable question for the following issue:A vendor ships goods to a customer on credit but does not have previous credit experience with this customer. 3. Identify at least one researchable question for the following issue:A cable network has just entered into an agreement granting it the right to show reruns of a hit TV series. In exchange for this right, the network must pay the TV show’s creators a fee each time the show airs. 4. The six decision traps and biases are not an all-inclusive list. Perform an Internet search for one other bias that you believe could be applicable…arrow_forwardA five-year earnings summary for Motors, Inc. is presented in the following table. Using this data, construct a single graph of the three earnings measures, and then prepare a memo addressing the following items. What type of graph did you create and why? Present your graphs in your memo. Does there appear to be a relationship among the earnings measures? Explain why or why not. Assess your chart's design in terms of presentation bias. If you feel your chart is free from bias, explain why this is so. Then develop a second chart with the data presented in a manner that might be misleading to a viewer. MOTORS: Earnings Measures, 2008-2012 \table[[Year,2012,2011,2010,2009,200],[\table[[Income],[from],[operations]],5,785,6,450,7,250,6,250,5,975,],[\table[[Net],[income]],4,385,5,300,5,325,4,737,4,529,],[\table[[Net cash],[flow from],[operations]],5,050,8,300,7,700,7,530,5,700,]]arrow_forward
- I need help solving 1,2,4,5,&6 of this problem. I submitted this question earlier and 1 and 2 are incorrect. They said to submit another question for 4,5, and 6, but 1 and 2 were incorrect. Thanks for the help. The financial statements are below, and the question are on the screen shots. Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 500,000 shares of common stock were outstanding. The interest rate on the bonds, which were sold at their face value, was 10%. The income tax rate was 40% and the dividend per share of common stock was $0.40 this year. The market value of the company’s common stock at the end of the year was $29. All of the company’s sales are on account. Weller CorporationComparative Balance Sheet(dollars in thousands) This Year Last Year Assets Current assets:…arrow_forwardBe creative. You are a financial accountant for a small business and have been tasked with preparing a monograph for the company's financial statements. The monograph should include a list of economic events that have occurred over the course of one month, including: 1) receivables, 2) merchandising assets, 3) sales, 4) VAT, 5) prepaid expenses and revenues (these five categories have to be in your monograph as mandatory). Your list should include 15 economic events. For each economic event, you will need to create a general journal entry, post the entry to the general ledger, prepare a trial balance, and ultimately prepare the company's income statement and balance sheet. To complete this assignment, you will need to: 1. Create a list of at least 15 economic events that have occurred over the course of one month. Make sure to include the mandatory economic events mentioned above and any other important events that you can think of. 2. For each economic event, create a general journal…arrow_forwardSolar Solutions began operations on January 1, 2015, and is now in its sixth year of operations. It is a retail sales company with a large amount of online sales. The adjusted trial balance as of December 31, 2020 appears below, along with prior year balance sheet data and some additional transaction data for 2020. SOLAR SOLUTIONS Adjusted Trial Balance 12/31/2020 2020 2019 Account Title Adjusted Trial Balance Post-Closing Trial Balance Debit Credit Debit Credit Cash $ 122,200 55,000 125,600 Accounts Receivable 35,000 Prepaid Insurance 5,000 6,000 |Inventory Office Equipment Machinery & Tools Accumulated Depreciation Accounts Payable Salaries Payable Sales Tax Payable Note Payable-Long Term Common Stock, $10 par 46,000 15,600 63,000 47,000 59,000 21,000 21,000 16,000 11,200 16,800 2,600 2,700 2,000 4,000 31,000 22,100 240,000 160,000 Retained Earnings 28,600 28,600 Dividends 10,000 Sales Revenue Cost of Goods Sold Rent Expense Salaries Expense 235,000 127,600 20,000 36,000 Insurance…arrow_forward
- 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 Totalsarrow_forwardFor the transaction below, determine which QuickBooks Online task is the most appropriate to record it. Select a task from the drop down list. Apr. 4: Purchase office supplies from The Office Store, for cash, $900. Review the source documents before answering. The most appropriate QuickBooks task isarrow_forwardThe general ledger of Jay Consulting shows the following balances at July 31: Jay has asked you to develop a worksheet that will serve as a trial balance (file name PTB). Use the data provided as input for your model. Review the Model-Building Problem Checklist on page 154 to ensure that your worksheet is complete. Print the worksheet when done. Check figure: Total debits, 17,731. To test your model, use the following balances at August 31: Print the worksheet when done. Check figure: Total debits, 18,810. CHART (optional) Using the test data worksheet, prepare a pie chart showing the percentage of each asset to total assets. Print the chart when done.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Excel 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 Pub- Century 21 Accounting Multicolumn JournalAccountingISBN:9781337679503Author:GilbertsonPublisher:Cengage
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
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:9781337280570
Author:Scott, Cathy J.
Publisher:South-Western College Pub
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:9781337679503
Author:Gilbertson
Publisher:Cengage
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
How To Analyze an Income Statement; Author: Daniel Pronk;https://www.youtube.com/watch?v=uVHGgSXtQmE;License: Standard Youtube License