Computer – Based Management 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 Management Accounting” is a demand driven skill course that shows how to translate Management Accounting concepts into computer language to solve complex digital problems. Therefore, the central focus is how to learn Management Accounting through computer. The objective of this course, “Computer - Based Management 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 Management 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 in Management Accounting for Cash Flow Planning
Learn how to use computer in Management Accounting for Inventory Planning and Monitoring
Learn how to use computer in Management Accounting for Statistical-Based Decision Making
Learn how to use computer in Management Accounting for Capital Budgeting
Learn how to use computer in Management Accounting for Budgetary Control
The course comprises 5 chapters. Chapter 1 is step by step computer-based approach to Cash Flow Planning. Chapter 2 deals with Inventory Planning and Monitoring. Chapter 3 deals with Statistical-Based Decision Making. Chapter 4 covers Capital Budgeting. Chapter 5 covers Budgetary Control including Variance Analysis.
Course Content / Title
Chapter 1: Cash Flow Planning
Lesson 1: Financing Cash Deficit using Goal Seek Tool
Chapter 2: Inventory Planning & Monitoring
Lesson 1: Determination of Economic Order Quantity of Multiple Products
Lesson 2: Determination of Total Ordering & Holding Cost
Lesson 3: Determination of Inventory Management Cost
Lesson 4: Determination of Inventory Budget of Multiple Products
Lesson 5: Just-In-Time Inventory Monitoring System
Chapter 3: Statistical-Based Decision Making
Lesson 1: How to use computer to analyze Make or Buy Decision of a Product
Lesson 2: How to use computer to analyze Make or Sub-Contract Decision
Lesson 3: How to use computer to analyze Investment Options under conditions of uncertainty
Chapter 4: Capital Budgeting
Lesson 1: How to use computer to evaluate Investment Projects
Lesson 2: How to use computer to analyze Outright Purchase versus Leasing of Asset
Chapter 5: Budgetary Control
Lesson 1: Sale Price, Mix and Volume Variance Analysis
Lesson 2: Material Price, Mix and Usage Variance Analysis
Lesson 3: Wage Rate and Efficiency Variance Analysis
Lesson 4: Variable Overheads Efficiency Variance Analysis
Lesson 5: Fixed Overheads Expenditure Variance Analysis
Lesson 6: Fixed Overheads Efficiency Variance Analysis
Lesson 7: Fixed Overheads Capacity Variance Analysis
This Course includes:
6 hours, 34 minutes of video tutorials (3 – 6 minutes each)
Excel File with 33 Spreadsheets
Certificate of Completion
Requirements
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
