Microsoft Excel for Accounting: Managerial and Cost
by

Dr. Katherine T. Smith
Dr. L. Murphy Smith
Dr. Lawrence C. Smith, Jr.


Assignment Schedule By Topic
Subject Area Matching Spreadsheet Assignment
Introduction to Managerial Accounting 1 Cost of Goods Manufactured
   and Cost of Goods Sold
2 Income Statement
Analyzing Cost Behavior 3 Cost-Volume-Profit Analysis
4 Cost-Volume-Profit Analysis
Job Order Costing 5 Work in Process and Questions
Process Costing 6 Compute Equivalent Units: FIFO
7 Compute Equivalent Units: Weighted Average
Overhead Costs and 
Activity Based Costing
8 Cost Allocation Rates
9 Budgeted Costs, ABC Cost Per Unit
10 Manufacturing Cost Based on ABC Unit Cost
Cost-Volume-Profit Analysis  11 Cost-Volume-Profit Analysis
12 Cost-Volume-Profit Analysis
13 Cost-Volume-Profit Analysis: Graph
14 Cost-Volume-Profit Analysis: Graph
15 Graph Cost Behavior Patterns
16 Contribution Margin Income Statement
Costs  17 Departmental Income Statement
Budgeting 18 Flexible Budget
19 Graph Total Cost Line
Use of Managerial Accounting Data
for Decision-Making
20 Product Mix Analysis
21 Make or Buy Analysis
Responsibility Accounting 22 Best Use of Facilities Analysis
Capital Budgeting 23 Flexible Budget
24 Flexible Budget
Financial Statement Analysis  25 Financial Ratios
26 Financial Ratios
27 Common Size Balance Sheets
28 Common Size Balance Sheets
29 Horizontal Analysis of Income Statement
Statement of Cash Flows 30 Statement of Cash Flows
31 Statement of Cash Flows
International Operations  32 Foreign Currency Translation Using
     the Current Rate Method
33 Foreign Currency Translation Using
     the Current Rate Method
34 Foreign Currency Translation Using
     the Current Rate Method
35 Foreign Currency Translation Using
     the Current Rate Method
36 Foreign Currency Translation Using 
     the Temporal Rate Method
37 Foreign Currency Translation Using
     the Temporal Rate Method
38 Economic Impact of an Import Quota
39 Economic Impact of an Import Quota
40 Economic Impact of a Tariff
41 Economic Impact of a Tariff
42 Economic Impact of a Tariff
Case Problem Comprehensive
Links:
Back to Starting Page
Prentice-Hall
Microsoft Corporation
Web Search Engines
Quotations on Ethics (cool quotes & movie clips)
The Bottom Line is Betrayal