ACCT 352
Managerial
Accounting on Computers
Fall Semester
2000
Instructor:
Patty Holmes, CPA
Office: Bldg. 8 Room 06
Phone: (515)964-6349
E-Mail: phholmes@dmacc.cc.ia.us
Text: Microsoft Excel 2000, Shelly Cashman Quasney
Additional Problems: To be handed out.
Reference: A cost accounting text and principles of accounting
text.
Primary Goals:
1. Complete Projects 1-4 plus
12 separate cost/financial accounting problems.
2. Measure the level of
knowledge of excel techniques.
3. Complete capstone project.
Evaluation:
25%
of your grade will be based on the tests
60%
of your grade will be based on the assignments
15%
of your grade will be based on a cost topic presentation
93%
- 100% = A 90% - 92% = A-
87%
- 89% = B+ 83% - 86% = B 80% - 82% = B-
77%
- 79% = C+ 73% - 76% = C 70% - 72% = C-
67%
- 69% = D+ 63% - 66% = D 60% - 62% = D-
Competencies:
Perform
computerized spreadsheet skills.
Develop
basic Spreadsheet models.
Design
managerial accounting reports using computer spreadsheets.
Topics to be covered in the
text include:
1. Creating a Worksheet and
Embedded Chart
2. Formulas, Formatting,
charts, ad Web Queries
3. What-If Analysis and Working
with Large Worksheets
4. Financial Functions, Data Tables,
Amortization Schedules, and Hyperlinks
5. Creating
Templates and Working with Multiple Worksheets and Workbooks
Topics to be covered in the
Cost/Financial accounting assignments
1. Manufacturing statement
2. Activity-based costing
3. Capital budgeting
4. Ratio analysis
5. Cash budgeting
6. Process costing
7. Job costing
8. Cost-volume profit analysis
9. Departmental income
statement
10. Flexible budgeting
11. Master budgeting
12. Present and future value analysis
Every
week we will review the cost principles related to the topic listed above. All assignments must be completed correctly
to receive credit for them.