Computer - Based Cost Accounting using Excel
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
Inventory Pricing & Valuation, Inventory Control, Payroll Accounting, Cost-Volume-Profit Analysis, BudgetingDescription
Computer – Based Cost Accounting using Excel
Employers around the globe are demanding digital skills especially excel spreadsheet skills in the employment process. These changing requirements of the job market have seen the emergence of a gap between the knowledge generated by the traditional learning management system (LMS) and the skills required by employers worldwide.
The need for graduates from high school level to college and university to start jobs with demand driven digital skills is therefore becoming more of a prerequisite for employment all over the world. This course provides them with the insight to uncover a new set of digital skills they need for employment and job security.
This “Computer - Based Cost Accounting” is a demand driven skill course that shows how to translate Cost Accounting concepts into computer language to solve complex digital problems. Therefore, the central focus is how to learn Cost Accounting through computer. The objective of this course, “Computer - Based Cost Accounting”, is to equip every teacher and student in high school, college and university with demand driven digital skills and prepare them to meet the requirements in the job market.
In furtherance of this objective, Microsoft Excel has been chosen as a tool of teaching and learning of Cost Accounting through computer. Given that Microsoft Excel Spreadsheet is standard software used in commerce and industry across the globe, it is essential to teach teachers and students in their use as an integrated part of their courses.
What you'll learn
Learn how to use computer to solve Inventory Pricing and valuation under FIFO, LIFO and Weighted Average problems in classroom and workplace.
Learn how to use computer to solve Inventory Control problems in classroom and workplace.
Learn how to use computer to solve Payroll problems in classroom and workplace.
Learn how to use computer to solve Cost – Volume – Profit problems in classroom and workplace.
Learn how to use computer to solve Budgeting problems in classroom and workplace.
The course comprises 5 chapters. Chapter 1 is step by step computer-based approach to solving material pricing and valuation problems. Chapter 2 deals with inventory control levels. Chapter 3 outlines how to use computer to solve payroll accounting problems. Chapter 4 deals with how to use computer to solve cost-volume-profit problems. Chapter 5 covers budgeting process from forecasting to Budgeted Balance Sheet.
Course Content / Title
Chapter 1: Material Pricing and Valuation
Lesson 1: How to use Keyboard
Lesson 2: Inventory Pricing under First - In – First – Out (FIFO) method
Lesson 3: Inventory Pricing under Last – In – First – Out (LIFO) method
Lesson 4: Inventory Pricing under Weighted Average (WAV) method
Lesson 5: Profit Analysis under FIFO, LIFO and WAV methods
Chapter 2: Inventory Control Levels
Lesson 1: Economic Order Quantity
Lesson 2: Inventory control levels
Chapter 3: Payroll Accounting
Lesson 1: Labor remuneration under Piece Rate Method
Lesson 2: Labor remuneration under Time Rate Method
Lesson 3: Labor remuneration under Fixed Salary Method
Lesson 4: Income Tax (PAYE) determination
Chapter 4: Cost-Volume-Profit Analysis
Lesson 1: Breakeven Analysis
Lesson 2: Margin of Safety Determination
Lesson 3: Breakeven Sensitivity Analysis
Chapter 5: Budgeting
Lesson 1: Sales Forecast
Lesson 2: Sales Budget
Lesson 3: Production Budget
Lesson 4: Direct Material Budget
Lesson 5: Labor Cost Budget
Lesson 6: Manufacturing Overhead Budget
Lesson 7: Cost of Sales Budget
Lesson 8: Selling & Distribution Budget
Lesson 9: Staff Establishment Budget
Lesson 11: Staff Cost Budget
Lesson 12: Office Cost Budget
Lesson 13: Cash Budget
Lesson 14: Budgeted Income Statement
Lesson 15: Budgeted Balance Sheet
This Course includes:
8 hours of 81 video tutorial clips (5 – 6 minutes each)
37 Spreadsheets on how to learn Cost Accounting through computer
Certificate of Completion
Requirements
The course requires laptop or desktop with Microsoft Window 2007, 2010, 2013 and above.
Target group
Business Students and Teachers at all levels worldwide
Business Graduates looking for employment worldwide
Accounts and Finance Officers and Managers
Course Tutor
ISAAC ALORMENU – MBA (International Finance) Brandeis University, USA - 2009
Requirements
- Requirements
- None
Dr John's Managerial Accounting course in MBA program
- 4.4
-
![]()
![]()
![]()
![]()
![]()
The Managerial Accounting Course is a major part of the Masters of Business Administration Program Learn and Master Each Management Accounting Tool and Technique....
CFA Corporate Finance Level 2
- 3.7
-
![]()
![]()
![]()
![]()
![]()
Learn CFA Corporate Finance Level 2 Syllabus with more illustrations and case studies Welcome to Corporate Finance CFA Level 2 Course....
Computer - Based Cost Accounting using Excel
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Inventory Pricing & Valuation, Inventory Control, Payroll Accounting, Cost-Volume-Profit Analysis, Budgeting Computer – Based Cost Accounting using Excel Therefore, the central focus is how to learn Cost Accounting through computer....
Microsoft Power Pivot (Excel) and SSAS (Tabular DAX model)
- 4.3
-
![]()
![]()
![]()
![]()
![]()
Visualise Data in Power Pivot for Excel or SSAS with DAX. 70-779, 70-768 exams. Business Intelligence PowerPivot tool. Reviews: Thank you for this course!" -- Cynthia Smith...
