Budget Information Problem Based In Metroline Travel Engineering Accounting Essay

This report outlines a budget information problem based in Metroline Travel engineering and logistical function. The report also presents a discussion and analysis of a budget information problem with reference to the problem solving frame work.

The project also includes the 4 P’s within the marketing mix, limitations of incremental budgeting, 10 criteria which are proposed for good-quality information and a financial analysis of the logistical function overtime cost.

These analyses are necessary for competent decision-making. In addition, the report concludes with an investigative examination of these problems and plausible recommendations to address the company’s deficiencies. Also noteworthy, advantages and disadvantages using the SMART framework with recommendations and implications will also be outlined.

Contents

Assignment 02 1

A budget information problem within the logistical function 1

B629/BZX629 Managing 2: Marketing and Finance 1

Report Prepared by: Kelemn Wyllie 1

Senior Material Support Manager 1

Metroline Travel 1

Tutor 1

Mr. Jay Naik 1

1

Date of the Report: 25-08-2010 1

Contents 3

TMA Part 1 5

Introduction 5

Stakeholder Analysis 6

Problem Statement 7

Figure 4 Internal Engineering Value Chain Analysis 7

Analysis 9

10

Conclusion 14

Recommendation 16

Figure 12 recommendations within the budget control loop 16

Bibliography 21

Appendix 22

TMA Part 2: TMA Activities 38

Activity 1: Week 6 Table 6.1 Three new tasks you could do at work 38

Activity 2: Week 6 Table 6.2 Costs & Rewards associated with the proposed 3 new work 39

Activity 3: Week 6 Table 6.3 Communicating your proposed idea to peers in the organisation 40

Activity 4: Week 7 Table 7.1 How I currently deliver the service and how it could be improved 41

Activity 5: Week 8 Table 8.1 Focus group research on a marketing problem 42

Activity 6: Week 9 – Table 9.1 Investigate marketing planning in my own organisation 43

Activity 7: Week 9 Table 9.2 The Marketing Plan 44

Activity 8: Week 10 Part A – What financial information do you deal with at home and at work? 45

Activity 8: Week 10 Part B – Share with other students what you hope to achieve by studying finance 46

Activity 9: Week 10 Table 10.1 – Stakeholders’ financial information needs 47

Activity 10: Week 10 Table 10.2 – Financial information requirements 48

Activity 11: Week 11 A completed version of Table 11.1 Garden Furnishings: solving the problem 49

Activity 12: Week 12 A Word Document noting your/your line manager’s budgetary information requirements 50

Activity 13: Week 12 Part A – A completed version of Table 12.2 Template for cash budget 51

Activity 13: Week 12 Part B – A Word document discussing practical application of master and cash budget information to problems of Garden Furnishings 52

Activity 14: Week 12 Resolving a budget information problem 53

TMA Part 1

Introduction

As senior material manager in a public bus company called Metroline Travel. A subsidiary company owned by the Singapore based ComfortDelGro Corporation. See Appendix for profit and loss account and other related financial information as of 31st march 2010. The world’s second largest listed land transport company. The senior material manager supervises a team of 15 material support managers across London. These personnel are the logistical team and their core responsibilities are the supply, storage and procurement of parts to engineering (core activity). The logistical hierarchy is illustrated in figure 1.

Figure 1 Metroline Organisational Structure (Logistical Department)

Stakeholder Analysis

Stakeholder analysis is a useful technique used to identify the key people within the logistical function framework. These key personnel are very important to the organizational structure because they have tremendous power and influence which affects the performance and future resource planning allocated from senior management. “Managers should consider the organisation’s responsibilities and commitment to all its stakeholders”. (Understanding marketing and financial information, P. 196) According to Mendelow’s matrix these can be grouped into to 4 categories which are illustrated figure 2 in Metroline Travel below:

Figure 2 Mendelow’s matrix

High

Low

C- Keep Satisfied

D- Key Players

A- Minimal Effort

B-Keep Informed

Low

HighPower

Level of Interest

A- Drivers

B- Operation, Suppliers

C- Finance department

D- Engineering (Core Activity)

Assumptions

To make the problem more bounded:

Material managers have complete autonomy over their overtime

Material manager received invoices on a Friday in May, June and July

Budgets are formed outside the control of the logistical function

Cost can be divided in to fixed and variable cost

The material manager’s are constraint to 19 hours per week overtime (limiting factor) in line with the EU working time directive

Problem Statement

Budgets are used for detailed planning in the allocation of resources in a business. This information is important to management and stakeholders alike in assessing the activities and performance of an organisation, illustrated in Figure 3. The logistical function overtime budget is based on an incremental budgeting principle with an absorption costing approach for allocating cost per material managers.

Get Help With Your Essay

If you need assistance with writing your essay, our professional essay writing service is here to help!
Find out more about our Essay Writing Service

The incremental budgeting principle is based on 9% of their base salary plus current inflation. However, the material manger’s overtime for May, June and July allowance were over budgeted which would affect workers’ long term motivational level working on a weekend. This over-budget affects the controlling, planning and decision-making of its activities. This overtime process is very important in maintaining a reliable service to engineering.

Figure 3 Information direction

Senior material support manager

Material mangers

Engineering

The value chain consists of a series of activities that create and builds significance in maintaining a bus. “An organisation can consider the activities in its value chain and assess if they are value added activities or non-value added activities”. (Understanding marketing and financial information, P. 190) This is illustrated in figure 4.

Figure 4 Internal Engineering Value Chain Analysis

EQUIPMENT

ENVIRONMENT

OTHER

OTHER

INPUT

MACHINERY

OUTPUT

TOOLS

QUALITY CHECKS

REPAIR REPORT

ENGINEERS

BUS REPAIR

MANAGEMENT

PARTS

GARAGE

OVERTIME

OTHER

MATERIAL MANAGERS

OTHER

PROCESS

PEOPLE

As their line manager; I was tasked by the head of purchasing and logistics to investigate and place corrective actions to bring this over budgeting back under control. This over- budget is illustrated in figure 5.

Figure 5. Material Managers Overtime budget as of the 31 July 2010

MONTHS

January

February

March

April

May

June

July

USER

Material manager 1

£800

£900

£100

£100

£445

£520

£549

Material manager 2

£0

£220

£200

£220

£458

£612

£323

Material manager 3

£0

£100

£500

£461

£552

£144

£66

Material manager 4

£0

£50

£100

£110

£100

£222

£366

Material manager 5

£0

£60

£631

£100

£223

£141

£316

Material manager 6

£200

£100

£211

£250

£300

£44

£342

Material manager 7

£0

£600

£0

£54

£642

£335

£559

Material manager 8

£102

£0

£200

£0

£452

£500

£445

Material manager 9

£200

£0

£130

£0

£452

£900

£498

Material manager 10

£500

£0

£45

£0

£100

£626

£613

Material manager 11

£100

£200

£115

£225

£100

£225

£889

Material manager 12

£0

£200

£25

£445

£252

£225

£789

Material manager 13

£200

£0

£255

£235

£231

£995

£145

Material manager 14

£0

£120

£22

£122

£85

£452

£445

Material manager 15

£0

£100

£12

£144

£200

£100

£112

Total =

£2,102

£2,650

£2,546

£2,466

£4,592

£6,041

£6,457

Budget

£4,000

£4,000

£4,000

£4,000

£4,000

£4,000

£4,000

Cost variance

£1,898

£1,350

£1,454

£1,534

-£592

-£2,041

-£2,457

adverse

adverse

adverse

Total Budget- £48,000

Monthly allowance £4,000

Daily rate- £12.60

Weekend rate- £20.23

Analysis

Market segmentation is an important marketing task described by Bonomo and Shapiro (1983), cited by Sargeant (2009). It has a number of advantages which can be used to identify existing and potential customers. By placing customers into different groups by successful targeting their needs and managing their expectations.

Figure 5. Organisational market segmentation criteria (Operating variables)

Engineering (core activity) Heavy user

Suppliers Medium user

Finance department

Medium user

OTHER

Light users

After speaking with the material managers and investigating their overtime sheets for the months for May, June and July submitted to payrolls. “The investigation using; the problem solving framework” (The Manager’s Good Study Guide, PG 69). I found that the material managers were working more on a weekend to incur the over budget this is illustrated in figure 6 in appendix, which the daily rate is £12.60 while the weekend rate is £20.23 “The budgeting system can seriously influence the level of motivation and culture of an organisation, because budgets play a central role in” (Understanding marketing and financial information, P. 155).

This was because of an increase of activity; 40 plus financial invoices received from the finance department over May, June and July were received on a Friday and could not be completed that day because of day to day activities. These invoices needed to be resolved as soon as possible and took some time to process on the data base system for payment for the following week from finance illustrated in figure 7 . In addition, the limitation of the incremental budgeting, this budgeting type has inefficiencies and imperfections which were not noticed, until the increase of activity.

Figure 7 total financial invoice hours to completion

Using the 4 P’s-

Price- Was the increase in the usage of overtime to complete the receipt of engineering invoices which will affect the material manager’s long term motivation coming into work “allocating resources and imposing constraints on activity” (Understanding marketing and financial information, P. 155).

Product- Was the volumes and frequency of the engineering invoices given on a Friday “identifying those areas that require corrective action” (Understanding marketing and financial information, P. 155).

Promotion- The finance manager; a senior manager requesting this activity be completed as soon as possible “assessing how well managers have carried out their responsibilities” (Understanding marketing and financial information, P. 155).

Place- Is material manager’s working location “assessing how well managers have carried out their responsibilities” (Understanding marketing and financial information, P. 155).

Budgeting is needed to provide managers at different levels with useful information to keep on the right road. This is illustrated in 11.2 the pyramid of purpose. This information is received for decision making.

Corporate level- Provide a bus service to Transport for London

Material manager overtime

Support engineering

Provide a bus service to Transport for London

Provide parts and technical information

Business level- Support engineering

Operational level-Provide parts and technical information

Operating Level-Material manager daily overtime

Analysis of information criteria not being met

There are 10 criteria which are proposed for good-quality information for decision-making; this is illustrated in figure 8. However the material manager’s overtime sheets were being sent directly to payroll, which added to the budget information problem.

1 Relevant- Their line manager had no knowledge of Material manager’s overtime

7 Timely- No Knowledge of Material managers overtime being over budget until at the end of the month

8 Communicated to the right person- Overtime sheets were sent directly to payrolls

Figure 8 10 criteria which are propose for good-quality information for decision-making

10

Less costly than the value of the benefits it provides

9 Communicated via the right channel

8 Communicated to the right person

7

Timely

6

Concise

5

Trustworthy

4

Complete

3

Sufficiently accurate

2

Clear

1

Relevant

Good-quality information for decision-making

Analysis of the absorption costing approach

From the cost analysis, the logistical function has a total budget figure of £48,000. This is calculated by applying the normal budgeted hourly rate of £12.60 which is the budgeted man (direct labour) hours per manager according to normal capacity illustrated in figure 9, by the using the incremental budgeting principle.

Figure 9 cost assignment is both

Indirect cost- variable

Overtime brought on by finance invoices

Cost object

Bus repair

Direct cost- fixed

Weekly overtime to provide parts and technical information to engineering

The indirect and direct costs are equally distributed illustrated in figure 10, using the absorption costing approach which all cost is allocated to the main budget. This prevents monitoring of actual hours against the actual spend within the budget. The resulting variances should have enabled the logistical function to monitor the productivity and efficiency of all the managers.

Hopefully, you can then see if there is a pattern or a reason for persistent adverse variance. The analysis will provide you with some clues about incentivize or modify such behaviour via the budget building process.

Figure 10 Relationship between costs

Direct cost

Variable cost

Overtime brought on by finance invoices £20.23

Fixed cost

Weekly overtime to technical information to engineering £12.60

Indirect cost

Break-even analysis

Break-even analysis identifies the level of activity and risk at which an organisation can generates no surplus or deficit. In the case of an over-budgeting issue; it relates to the point where the logistical function is in budget and will not be penalized for being over spent illustrated in figure 11.

TotalJanuary

February

March

April

May

June

July

£2,102

£2,650

£2,546

£2,466

£4,592

£6,041

£6,457

Over BudgetNet Total = £26,854

Total Budget-£ 48,000

Monthly allowance £4,000

= £48000-£26,854 = £21,146

21,146(Fixed cost)/ 6 months = £3,524 per month in overtime remaining

£3,524/ 15 material managers= £234.93 per manager

Direct cost £234.93/ £12.60 = 18.64(Contribution) weekly hours per month

or

Indirect cost £234.93/ £20.23 = 11.61(Contribution) weekend hours per month

Figure 11 Break-even analysis

Conclusion

From the analysis, there is a clear budget information problem within the logistical function; the problem solving frame work has identified several problem areas. By Using the 4 P’s to illustrate Material managers working more on a weekend which has a higher premium rate than daily working. The limitations of the incremental budgeting; as an effective forecasting tool. 10 criteria; which are essential for good-quality information for decision-making. In which 3 criteria are not being met. In addition, not identifying true cost drivers within the budget. In which material managers that are working more on a weekend are not identified. These factors combined have affected the logistical function staying within their overtime budget.

Recommendation

Budgeting is part of the control process in organisations: the “control loop” (Understanding marketing and financial information, P. 134). The setting objectives, planning and implementing tasks, monitoring progress, reviewing results and adjusting tasks are crucial in staying and planning budgets illustrated in figure 12. Based on the investigative examination and analysis of the problems; these recommendations should improve the over- budget situation and return productivity.

Figure 12 recommendations within the budget control loop

Check against overtime sheets past weeks

If not working- restart from the begin of the loop

Operational level

Provide parts and technical information

Use recommendation outlined in action plan to control material manger overtime budget- budget building process

Using the “SMART” framework from (Understanding marketing and financial information, Pg 122) the action plan will be outlined as the following

Recommendation

Timeline

Strengths

Weaknesses

Opportunities

Threats

(Price)

Material manager weekly overtime sheets sent to senior material manager

1 week to start

Giving back control to the line manager by improving the Relevant, Communicated to the right person and Timely elements of information

Increase of Senior material manager workload

To start a new process, which can be adapted throughout the company and monitor usage for next year budget review

Material managers might feel disempowered which might affect there motivation

(Place)

Weekend overtime needs pre-approval

1 week to start

Giving back control to line manager by improving the control element of the budgeting loop. In addition the material having to work on a weekend might increase their morale

Increase of Senior material manager workload

To start a new process, which can be adapted throughout the company and monitor usage for efficiency of material mangers

Identification of cost drivers

Control of weekend working (indirect labour)

Material managers might feel disempowered which might affect their motivation

(Product) + Promotion

Finance manager giving the invoices on a Monday instead of a Friday

2 weeks to start

Spread the work load of the material manager

Direct labour cost

Increase of material managers weekly workload

Weekend overtime can be used to complete other essential engineering task

Build up of daily work that carried over from day to day

Rolling budgets

Next financial year

Flexibility is built into the budgeting system to deal with any changes arising from day to day activities

Updated much more frequently increasing work load

It encourage a high level of learning and flexibility

Rolling budget can be expensive in terms of management and administrating time. Which might affect management morale and less time to manage

Activity based costing

Next financial year

Understand what and where is driving costs

Very time consuming, checking each material managers overtime sheet for cost drivers

Understand of cost drivers before an informed decision can be reached

If inappropriate drivers are selected. then it could lead to incorrect decisions resulting in loss of efficiency, de-motivation of staff and eventual failure of the business

Work shredding to engineering administration clerks

2 weeks

Reduce in material manager weekend overtime- It asserts, on quite strong evidence, that 80% of our results are generally produced by 20% of our effort – and that the remaining 80% of our effort is swallowed up in achieving that last 20% of our results

Increase in

administration clerks

workload

Training have to be provided- cost

Training and development

Increase in errors by new users. Responsibility still remains with material manager

1640 Words

References

B629/BZX629 Managing 2: Marketing and finance Understanding marketing and financial information by Produced for the course team by Andrew Lindridge and Haider Ali (Marketing) and Graham Francis and Michael Lucas (Finance) The Open University, Walton Hall, Milton Keynes, MK7 6AA 2010 The Open University

The Manager’s Good Study Guide by Academic Editor: Sheila Tyler 2007 The Open University Walton Hall, Milton Keynes MK7 6AA

Booms, B. H. and Bitner M. J. (1981) ‘Marketing Strategies and Organization Structures for service firms’ in Donnelly, J.H. and George, W. R. (eds) (1981) Marketing of Services, Chicago: American Marketing Association, pp. 47-52.

Hope, J. and Fraser, R.(2003)Beyond Budgeting: How Managers Can Break Free from the Annual Performance Trap, Boston, M.A., Harvard Business School.

Francis, G. Et al, (2009), B629 Managing 2, Marketing and Finance, Understanding marketing and Financial Information Part 3, the Open University, Milton Keynes

Lindridge A et al,, (2009), Understanding Marketing and financial Information, B629/BX629, Managing 2: Marketing and Finance Part 2, Chapter 6, The marketing Mix, Managing Channel Conflict ,Communication difficulties / Expectation Role Incongruities pg21, the Open University, Milton Keynes

Johnson and Scholes (1993) Mendelow’s matrix, Exploring corporate strategy PG. 177 New York: Prentice Hall, 1993. 

Bonomo, T. V. and Shapiro, B. P. (1983) Segmenting The Industrial Market, Lexington, Lexington Books, cited in Sargeant, A. (2009) Marketing Management for Non profit Organisations, Oxford, Oxford University Press.

Bibliography

Examples,

Francis, G (2009), Understanding marketing and financial information, B629/BX629 Managing 2: Marketing

and Finance Part 3, the Open University, Milton Keynes

Lindridge, A et al, (2009), Understanding marketing and financial information, B629/BX629 Managing 2

: Marketing and Finance Part 1, the Open University, Milton Keynes

Lucas, M et al (2009), Managing 2: Marketing and finance, Course Activities 3, the Open University, Milton Keynes

Francis, G (2009), Understanding marketing and financial information, B629/BX629 Managing 2: Marketing and Finance Part 3, the Open University, Milton Keynes

Tyler, S. (2007), The Managers Good Study Guide, 3rd edition, the Open University, Milton Keynes.