Techniques of Management (ME0002)

? Credit Points : 20 ? SCQF Level : 8 ? Acronym : EEL-2-MNTOM

This is a course in management which may be taken in comnination with Industrial Management 1h. The course includes tuition on the use of spreadsheets generally and makes use of these in practical sessions to cover, in a 'hands on' manner, topics such as: forecasting, discrete event simulation, simulation analysis, linear programming, budgeting, costing, book-keeping and financial reporting.

Entry Requirements

none

Subject Areas

Home subject area

Management (School of Engineering and Electronics), (School of Engineering and Electronics, Schedule M)

Delivery Information

? Normal year taken : 2nd year

? Delivery Period : Semester 2 (Blocks 3-4)

? Contact Teaching Time : 6 hour(s) per week for 11 weeks

First Class Information

Date	Start	End	Room	Area	Additional Information
08/01/2007	09:00	09:50	Lecture Theatre 2, Hudson Beare Building	KB

All of the following classes

Type	Day	Start	End	Area
Lecture	Monday	09:00	09:50	KB
Lecture	Wednesday	09:00	09:50	KB
Lecture	Friday	09:00	09:50	KB

1 of the following 3 classes

Type	Day	Start	End	Area
Laboratory	Tu	14:00	15:50	KB
Laboratory	We	14:00	15:50	KB
Laboratory	Th	13:10	14:50	KB

Summary of Intended Learning Outcomes

On completion of the course students should be able to:

Operate a windows-based spreadsheet (Excel) and execute standard file, print and housekeeping functions.

Create Excel spreadsheets and be familiar with all functions contained in the standard toolbar, including use of ChartWizard for graphical presentation.

Prepare a basic cash book with VAT and expenditure analysis, and reconcile this to the bank statement.

Understand the main forms of business entity, the financial reports produced by each and prepare a simple profit and loss account.

Recognise the difference between fixed and variable costs and understand the concept of the break-even point.

Prepare a simple budget and cash flow forecast for a business.

Understand the problems in forecasting, apply some common practical techniques and select the most appropriate technique.

Carry out a forecast using a variety of time series methods and appreciate the problems in using real data.

Apply the process of Monte Carlo simulation to problems which would be difficult to solve using conventional techniques.

Understand the concepts involved in discrete event simulation and implement a simulation model of an operational system.

Formulate and solve a resource allocation problem using the graphical approach of linear programming and the Excel Solver.