100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Solutions Manual for Survey of Accounting, 6th Edition by Thomas Edmonds $29.49   Add to cart

Exam (elaborations)

Solutions Manual for Survey of Accounting, 6th Edition by Thomas Edmonds

 35 views  1 purchase
  • Course
  • Survey of Accounting
  • Institution
  • Survey Of Accounting

Complete Solutions Manual for Survey of Accounting 6e 6th Edition by Thomas Edmonds, Christopher Edmonds, Philip Olds, Frances McNair and Bor-Yi Tsay . ISBN 7770 Full Chapters Solutions are included. End of Chapters exercises and problems answers Chapter 1: An Introduction to Accounting Chap...

[Show more]

Preview 4 out of 890  pages

  • July 12, 2023
  • 890
  • 2022/2023
  • Exam (elaborations)
  • Questions & answers
  • Survey of Accounting
  • Survey of Accounting
avatar-seller
StepsSol
SuperStore Data Analysis Project

Learning objectives
1. Load a dataset into the Tableau platform
2. Create a worksheet for each question in the assignment
3. Apply filters to analyze specific aspects of the data
4. Sort the data by sum, count, or average values
5. Create different visualizations to illustrate how to approach a question in different ways
6. Illustrate how colors and size can be used to enhance visualizations.

Data set background
The data set for your assignment is a modified version of the Super Store demonstration dataset
provided by Tableau. The dataset contains sales transaction data for four years. Note that this dataset
is used for demonstration purposes only and is not intended to depict data from a real-world company.

Data dictionary
• Category: This field indicates product category for the sale.
• City: This field contains the name of the city where the SuperStore is located.
• Country: This field contains the name of the country where the SuperStore is located.
• Customer Name: This field is the name of the customer who made the purchase.
• Manufacturer: This field is name of the manufacturer for the product sold.
• Order Date: This field contains the date the customer placed the order.
• Order ID: This field is order ID number.
• Product Name: This field provides the name of the product purchased by the customer.
• Invoice Number: This field is the invoice number.
• Segment: This field contains the segment within SuperStore responsible for the sale.
• Ship Date: This field contains the date the items were shipped to the customer.
• Ship Mode: This field contains the mailing terms for the sale.
• Sub-Category: This field indicates a more specific description of the item sold.
• Discount: This field indicates any discounts applied to the sale.
• Profit: This field indicates the profit recognized on the sale.
• Credit Sales: This field indicates the revenue recognized on the sale.

,Instructions
[Insert Video]

[Insert Dataset Attachment]

After watching the video above, download the “Super Store” excel dataset. Load the dataset into
Tableau to complete the questions in this assignment. You will notice the excel workbook has 3 sheets,
(i) Example Data Set; (ii) Student Data Set; (iii) Inventory Detail. You will use the Student Data Set and
Inventory Detail to complete the following 5 questions:

1. Which Super Store customer accounts for the most credit sales?

William Brown

2. In what year and month did the Company have the highest credit sales?

December 2017

3. Which country has the highest credit sales of “3-ring staple pack” product?

Russia

4. Products shipped “first class” (ship mode) create how much profit on average?

31.834

5. Which city has the highest credit sales?


Moscow

,SOLUTIONS TO ANALYZE, THINK, COMMUNICATE – CHAPTER 1

ATC 1 – 1 (All dollar amounts are in millions.)

a. $ 2,937

b. Net income increased by $23

STOCKHOLDERS’
c. ASSETS = LIABILITIES + EQUITY
$41,290 = $29,993* + $11,297

* Liabilities must be computed by subtracting equity from assets.

d. Sales increased by 3.7% from 2017 to 2018.
($74,443- $71,786) ÷ $71,786 = 3.7%

Cost of sales increased by 4.3% from 2017 to 2018.
($53,299- $51,125) ÷ $51,125 = 4.3%

Selling, general and administrative expenses increased by 3.9% from
2017 to 2018. ($15,723- $ 15,140) ÷ $ 15,140 = 3.9%

The largest percentage increase was for cost of sales expenses.




1-64

, ATC 1-2
a.
Income Statements (amounts given are in millions)

Year 6 Year 5 Year 4 Year 3

Revenue $ 860 $1,520 (a) $2,720 $1,200
Cost and Expenses (a) (840) (a) (1,070) (2,400) (860)
Income from Cont. Op. (b) 20 450 320 (a) 340
Unusual Items -0- 175 (b) (145) (b) ( 40)
Net Income $ 20 (b) $ 625 $ 175 $ 300

Balance Sheets
Cash and Marketable Sec. $ 350 $1,720 (c) $ 750 $ 940
Other Assets 1,900 (c) 1,180 2,500 (c) 2,560
Total Assets $2,250 $2,900 (d) $3,250 $3,500

Liabilities (c) $ 730 (d) $1,555 $1,001 (d) $1,300

Stockholders’ Equity
Common Stock $ 880 $ 720 (e) $1,449 $ 800
Retained Earnings (d) 640 (e) 625 800 (e) 1,400
Total Stockholders’ Equity 1,520 1,345 (f) 2,249 2,200

Total Liab. and Stk. Equity $2,250 (f) $2,900 $3,250 $3,500




1-65

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller StepsSol. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $29.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

81113 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$29.49  1x  sold
  • (0)
  Add to cart