Log in
HomeStudy Guides420,000CA160,000

ACC 406 Study Guide - Final Guide: Cost Driver, Financial Statement, Finished Good

200 views56 pages
School
Ryerson University
Department
Accounting
Course
ACC 406
Professor
George Gekas

For unlimited access to Study Guides, a Grade+ subscription is required.

Get access

Grade+
$40 USD/m
Billed monthly
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
10 Verified Answers

Related Documents

ACC 406
Final Exam
Study Guide
ACC 406 Study Guide - Midterm Guide: Corporate Sustainability, External Auditor, Variable Cost
coralworm861
ACC 406
Final Exam
Study Guide
ACC 406 Final: Review ACC 406 Final
mauvekoala271
ACC 406 Chapter Notes - Chapter 5: Deutsche Luft Hansa, Prosthesis, Income Statement
peachwoodchuck506

Related Questions

Week One: Hands-on MIS Application Software ExerciseSolution

Store & Region Sales Database

This exercise helps students understand how a raw file of salestransactions can be analyzed to produce valuable information formanagers. Your challenge is to ask the right questionsabout the data and then present your case!

Import the data into Excel or Access (or compatiblespreadsheet/database). Use the data to perform the belowanalyses:

Analyze ALL THREE of the below items:

1.Best Performing Regions by TotalRevenue

2.Best Performing Stores by TotalRevenue

3.Best Selling Products by TotalRevenue

Select ONLY ONE of the below items:

A.Strongest Selling Period for eachProduct by Total Revenue

B.Strongest Selling Period for eachRegion by Total Revenue

C.Strongest Selling Period for eachStore by Total Revenue

Provide a business case – in the form of ONE descriptiveparagraph and ONE data table-- for eachanalysis. Each paragraph must refer to the informationpresented in the table using the labeled Table #. UseAPA format to label your tables.

SUBMIT– your final report with one WORDdocument and one EXCEL/ACCESS file.

Store & Region Sales Database
ID StoreNo SalesRegion ItemNo ItemDescription UnitPrice UnitsSold WeekEnding
1 1 South 2005 17"Monitor $229.00 28 10/27/10
2 1 South 2005 17"Monitor $229.00 30 11/24/10
3 1 South 2005 17"Monitor $229.00 9 12/29/10
4 1 South 3006 101Keyboard $19.95 30 10/27/10
5 1 South 3006 101Keyboard $19.95 35 11/24/10
6 1 South 3006 101Keyboard $19.95 39 12/29/10
7 1 South 6050 PC Mouse $8.95 28 10/27/10
8 1 South 6050 PC Mouse $8.95 3 11/24/10
9 1 South 6050 PC Mouse $8.95 38 12/29/10
10 1 South 8500 DesktopCPU $849.95 25 10/27/10
11 1 South 8500 DesktopCPU $849.95 27 11/24/10
12 1 South 8500 DesktopCPU $849.95 33 12/29/10
13 2 South 2005 17"Monitor $229.00 8 10/27/10
14 2 South 2005 17"Monitor $229.00 8 11/24/10
15 2 South 2005 17"Monitor $229.00 10 12/29/10
16 2 South 3006 101Keyboard $19.95 8 10/27/10
17 2 South 3006 101Keyboard $19.95 8 11/24/10
18 2 South 3006 101Keyboard $19.95 8 12/29/10
19 2 South 6050 PC Mouse $8.95 9 10/27/10
20 2 South 6050 PC Mouse $8.95 9 11/24/10
21 2 South 6050 PC Mouse $8.95 8 12/29/10
22 2 South 8500 DesktopCPU $849.95 18 10/27/10
23 2 South 8500 DesktopCPU $849.95 18 11/24/10
24 2 South 8500 DesktopCPU $849.95 20 12/29/10
25 3 South 2005 17"Monitor $229.00 38 10/27/10
26 3 South 2005 17"Monitor $229.00 30 11/24/10
27 3 South 2005 17"Monitor $229.00 3 12/29/10
28 3 South 3006 101Keyboard $19.95 30 10/27/10
29 3 South 3006 101Keyboard $19.95 32 11/24/10
30 3 South 3006 101Keyboard $19.95 33 12/29/10
31 3 South 6050 PC Mouse $8.95 25 10/27/10
32 3 South 6050 PC Mouse $8.95 5 11/24/10
33 3 South 6050 PC Mouse $8.95 26 12/29/10
34 3 South 8500 DesktopCPU $849.95 28 10/27/10
35 3 South 8500 DesktopCPU $849.95 27 11/24/10
36 3 South 8500 DesktopCPU $849.95 29 12/29/10
37 4 North 2005 17"Monitor $229.00 18 10/27/10
38 4 North 2005 17"Monitor $229.00 20 11/24/10
39 4 North 2005 17"Monitor $229.00 4 12/29/10
40 4 North 3006 101Keyboard $19.95 12 10/27/10
41 4 North 3006 101Keyboard $19.95 24 11/24/10
42 4 North 3006 101Keyboard $19.95 36 12/29/10
43 4 North 6050 PC Mouse $8.95 29 10/27/10
44 4 North 6050 PC Mouse $8.95 11 11/24/10
45 4 North 6050 PC Mouse $8.95 38 12/29/10
46 4 North 8500 DesktopCPU $849.95 21 10/27/10
47 4 North 8500 DesktopCPU $849.95 24 11/24/10
48 4 North 8500 DesktopCPU $849.95 30 12/29/10
49 5 North 2005 17"Monitor $229.00 27 10/27/10
50 5 North 2005 17"Monitor $229.00 25 11/24/10
51 5 North 2005 17"Monitor $229.00 23 12/29/10
52 5 North 3006 101Keyboard $19.95 80 10/27/10
53 5 North 3006 101Keyboard $19.95 82 11/24/10
54 5 North 3006 101Keyboard $19.95 75 12/29/10
55 5 North 6050 PC Mouse $8.95 65 10/27/10
56 5 North 6050 PC Mouse $8.95 24 11/24/10
57 5 North 6050 PC Mouse $8.95 55 12/29/10
58 5 North 8500 DesktopCPU $849.95 55 10/27/10
59 5 North 8500 DesktopCPU $849.95 57 11/24/10
60 5 North 8500 DesktopCPU $849.95 47 12/29/10
61 6 East 2005 17"Monitor $229.00 24 10/27/10
62 6 East 2005 17"Monitor $229.00 85 11/24/10
63 6 East 2005 17"Monitor $229.00 56 12/29/10
64 6 East 3006 101Keyboard $19.95 52 10/27/10
65 6 East 3006 101Keyboard $19.95 58 11/24/10
66 6 East 3006 101Keyboard $19.95 69 12/29/10
67 6 East 6050 PC Mouse $8.95 35 10/27/10
68 6 East 6050 PC Mouse $8.95 39 11/24/10
69 6 East 6050 PC Mouse $8.95 44 12/29/10
70 6 East 8500 DesktopCPU $849.95 78 10/27/10
71 6 East 8500 DesktopCPU $849.95 88 11/24/10
72 6 East 8500 DesktopCPU $849.95 99 12/29/10
73 7 East 2005 17"Monitor $229.00 34 10/27/10
74 7 East 2005 17"Monitor $229.00 36 11/24/10
75 7 East 2005 17"Monitor $229.00 35 12/29/10
76 7 East 3006 101Keyboard $19.95 49 10/27/10
77 7 East 3006 101Keyboard $19.95 47 11/24/10
78 7 East 3006 101Keyboard $19.95 48 12/29/10
79 7 East 6050 PC Mouse $8.95 45 10/27/10
80 7 East 6050 PC Mouse $8.95 42 11/24/10
81 7 East 6050 PC Mouse $8.95 45 12/29/10
82 7 East 8500 DesktopCPU $849.95 55 10/27/10
83 7 East 8500 DesktopCPU $849.95 57 11/24/10
84 7 East 8500 DesktopCPU $849.95 55 12/29/10
85 8 East 2005 17"Monitor $229.00 18 10/27/10
86 8 East 2005 17"Monitor $229.00 17 11/24/10
87 8 East 2005 17"Monitor $229.00 23 12/29/10
88 8 East 3006 101Keyboard $19.95 22 10/27/10
89 8 East 3006 101Keyboard $19.95 18 11/24/10
90 8 East 3006 101Keyboard $19.95 22 12/29/10
91 8 East 6050 PC Mouse $8.95 14 10/27/10
92 8 East 6050 PC Mouse $8.95 16 11/24/10
93 8 East 6050 PC Mouse $8.95 17 12/29/10
94 8 East 8500 DesktopCPU $849.95 32 10/27/10
95 8 East 8500 DesktopCPU $849.95 28 11/24/10
96 8 East 8500 DesktopCPU $849.95 30 12/29/10

Cost" of tardiness

Under the decimal system of computing time work at ABC Company, office workers who are tardy are "docked" according to the schedule below:

Minutes Late in Ringing In

Fractional Hour Deducted

1 through 6

1/10

7 through 12

2/10

13 through 18

3/10

19 through 24

4/10

etc.

The regular hours of work, Monday through Friday, are from 7:30 to 11:30am and from 12:30 to 4:30pm. During one week, James Johnson, who earns $12.95 an hour, reports in and checks out as shown below. Employees are not paid for ringing in a few minutes before 7:30 and 12:30 nor for ringing out a few minutes after 11:30 and 4:30.

Day

Morning

Afternoon

In

Out

In

Out

M

7:28

11:31

12:50

4:31

T

7:35

11:30

12:30

4:30

W

7:44

11:33

12:27

4:32

R

7:27

11:31

12:32

4:33

F

7:34

11:32

12:40

4:30

Refer to the partial time card and compute:

a) The hours worked each day:

b) The total hours worked:

c) The gross earnings for the week:

I need these ratios:

Return on Assets

Return on Equity

Return on invested capital

Profit Margin

Gross Margin

Price to earnings

Asset Turnover

Fixed-Asset Turnover

Inventory Turnover

Collection Period

Days' sales in cash

Payables Period

Assets to Equity

Debt to assets

Debt to equity

Times Interest earned

Times Burden covered

Current Ratio

Acid Test

I need these calculated from bellow along with the common-sizeincome statement and common-size balance sheet from the five yearslisted below:

RUBY TUESDAY INC (RT)Statement of CASH FLOW
Fiscal year ends in May. USD in millionsexcept per share data. 2010-05 2011-05 2012-05 2013-05 2014-05 TTM
Cash Flows From Operating Activities
Net income 45 47 0 -39 -64 -8
Depreciation & amortization 64 64 68 63 57 53
Amortization of debt discount/premium andissuance costs 0 -1
Investment/asset impairment charges 3 7 31 44 25 11
Deferred income taxes 20 -1 -20 -16 2 -1
Stock based compensation 7 8 6 4 8 7
Inventory -8 -2 6 -2 10 0
Prepaid expenses -2 -1 -1 -2 -1 -3
Income taxes payable 10 -4 2 -1 0 2
Other working capital -3 5 19 -19 -6 -26
Other non-cash items 4 -5 2 4 16 9
Net cash provided by operatingactivities 140 116 112 36 45 44
Cash Flows From Investing Activities
Investments in property, plant, andequipment -18 -27 -38 -37 -28 -27
Property, plant, and equipmentreductions 6
Acquisitions, net -4 -24
Other investing activities 8 6 22 59 22 16
Net cash used for investingactivities -9 -24 -34 22 -6 -11
Cash Flows From Financing Activities
Debt issued 246
Debt repayment -204 -91 -263 -27 -40 -16
Common stock issued 73
Common stock repurchased -18 -30 -1 0
Excess tax benefit from stock basedcompensation 1 0 0 0 0
Other financing activities -1 -5 4 0 0
Net cash provided by (used for) financingactivities -131 -92 -40 -53 -41 -16
Net change in cash 0 0 38 5 -2 17
Cash at beginning of period 10 10 10 48 53 44
Cash at end of period 10 10 48 53 51 61
Free Cash Flow
Operating cash flow 140 116 112 36 45 44
Capital expenditure -18 -27 -38 -37 -28 -27
Free cash flow 123 90 74 -1 17 17
RUBY TUESDAY INC (RT)CashFlowFlag BALANCE SHEET
Fiscal year ends in May. USD in millionsexcept per share data. 2010-05 2011-05 2012-05 2013-05 2014-05
Assets
Current assets
Cash
Cash and cash equivalents 10 48 53 51
Total cash 10 48 53 51
Receivables 10 7 1 1 1
Inventories 29 34 29 31 21
Deferred income taxes 14 14 27 7 3
Prepaid expenses 11 12
Other current assets 13 17 23 29 11
Total current assets 76 83 128 121 100
Non-current assets
Property, plant and equipment
Gross property, plant and equipment 1466 1597 1559 1448 1367
Accumulated Depreciation -523 -566 -592 -589 -572
Net property, plant and equipment 943 1031 967 860 795
Goodwill 16 8
Intangible assets 13
Other long-term assets 44 57 71 62 49
Total non-current assets 988 1104 1045 922 857
Total assets 1064 1187 1174 1043 956
Liabilities and stockholders' equity
Liabilities
Current liabilities
Short-term debt 13
Capital leases 15 12 8 5
Accounts payable 23 30 35 15 26
Taxes payable 21 41 47 11 11
Accrued liabilities 27 25 55
Deferred revenues 8 9 9 13 17
Other current liabilities 22 24 29 32
Total current liabilities 115 119 132 106 114
Non-current liabilities
Deferred taxes liabilities 40 43 38 6 4
Deferred revenues 42 60 68 78 75
Other long-term liabilities 329 373 359 337 303
Total non-current liabilities 411 476 465 421 381
Total liabilities 526 595 597 526 495
Stockholders' equity
Common stock 1 1 1 1
Additional paid-in capital 98 105 91 68 76
Retained earnings 452 499 499 460 395
Accumulated other comprehensiveincome -13 -13 -14 -11 -11
Total stockholders' equity 538 592 576 517 461
Total liabilities and stockholders'equity 1064 1187 1174 1043 956
RUBY TUESDAY INC (RT)CashFlowFlag INCOME STATEMENT
Fiscal year ends in May. USD in millionsexcept per share data. 2010-05 2011-05 2012-05 2013-05 2014-05 TTM
Revenue 1195 1265 1326 1251 1169 1137
Cost of revenue 982 1045 1106 1020 986 942
Gross profit 213 221 220 231 182 195
Operating expenses
Sales, General and administrative 71 86 115 139 137 117
Other operating expenses 68 69 101 59 115 87
Total operating expenses 138 155 215 198 252 204
Operating income 74 66 5 33 -70 -8
Interest Expense 17 13
Other income (expense) 1 0 -20 -55
Income before taxes 58 53 -15 -22 -70 -8
Provision for income taxes 12 6 -15 2 -5 0
Net income from continuing operations 45 47 0 -23 -65 -8
Net income from discontinuing ops -16 1 0
Net income 45 47 0 -39 -64 -8
Net income available to commonshareholders 45 47 0 -39 -64 -8
Earnings per share
Basic 0.74 0.73 -0.65 -1.07 -0.13
Diluted 0.73 0.72 -0.65 -1.07 -0.13
Weighted average shares outstanding
Basic 62 64 63 61 60 60
Diluted 62 65 63 61 60 60
EBITDA 140 130 72 97 -12

45