Developing a Financial & Project Execution Plan for a Media Project

This presentation focuses on developing a financial and project execution plan for a media project. It covers budget estimation, financial projections, staffing requirements, required equipment, project execution plan, and more.

Developing a Financial &
Project Execution Plan for
a Media Project

Table of Content
• Introduction
• Budget estimation
• Financial projection for next three years
• Staffing level and required competencies
• Required equipment, tools and systems
• Project execution plan
• WBS
• Inputs and outputs
• Internal and External process
• Key Deliverables and KPI
• Gantt Chart
• Conclusion
• References

Introduction
A financial and project execution plan helps in creating a detailed budgeted
business proposal in respect to evaluate success of a project. The main aim of
this presentation is to develop a financial and project execution plan for a media
project. In this presentation, a project for new TV public programme is
discussed which is regarding the life experience of people in the Arabic capital
cities.

Budget estimation
Budget:
Budget is an estimation of revenues and expenses for a specific future period of
time and it is compiled and re-evaluated on a periodic basis. The estimated budget
is prepared for the TV project which covers the people life experience in the
Arabic capital cities. The Estimated budget for the TV public programme is
determined as:

Continue
Particular Year 1 (Amt in AED) Year 2 (Amt in AED) Year 3 (Amt in AED)
Initial Investment 3000000 1999000 1039000
Start Up Cost :
Incorporation expenses 50000 - -
Other 190000 - -
Fixed cost :
Mic 150000 150000 150000
Video equipment 150000 150000 150000
Legal fee 40000 40000 40000
Vehicle insurance 20000 20000 20000
Computer & TV 250000 250000 250000
Variable cost :
Content writing 40000 40000 60000
Graphic expenses 20000 80000 100000
Transportation cost 35000 100000 110000

Financial projection for next
three years
Financial projections are essential for every business plan in order to keep
smooth cash flows in business. The projection enables owners to seek
attention of investors. This includes the sales forecasting, expenses budget,
cash flows and profit and loss statement. Projection is done for entertainment
media project with help of cash flow and profit and loss statement.

Cash flow
Opening Cash Balance 3000000 4396400 5434900
CASH IN -
Cash From Sales 2500000 1800000 2500000
Cash From Out-Licensing of
Intellectual Property - - -
Loans or Other Financial Vehicles - - -
Tax Rebates (e.g. SR&ED) - - -
Taxes Collected from Sales - - -
Revenues from Advertisement 700000 750000 790000
Interest From Bank - - -
TOTAL CASH IN 6200000 6946400 8724900
(Amt in AED)

Continue
Facilities 90000 95000 110000
Office: Rent 15000 15000 15000
Office: Utilities 30000 35000 40000
Office: Furniture and Fittings (cap) 40000 40000 50000
Cleaning and Waste Management 5000 5000 5000
IT/IS 84500 93500 98500
Telephones 20000 20000 25000
Integrated Communications System
(voice/data) 30000 35000 35000
Workstations, Printers and
Peripherals 10000 12000 12000
Software 15000 15000 15000
Network supplies (LAN) 4500 4500 4500
Mobile phones and PDAs 5000 7000 7000
Internal Project Resources 32000 40000 35000

Continue
Professional Fees 62800 68000 68000
Legal -- General 40000 40000 40000
Legal -- Patents 5000 5000 5000
Accounting 7800 8000 8000
Book-keeping 10000 10000 10000
Advisor Fees - 5000 5000
Banking Charges 4000 4000 4000
Bank Fees 4000 4000 4000
Taxes 125000 90000 250000
Sales Tax 125000 90000 250000
Miscellaneous 6800 7000 7000
Insurance 5000 5000 5000
Membership Fees 800 800 800
Couriers, Mail and Postage 1000 1200 1200

Profit and loss account
Year 1 Year 2 Year 3
Sales 2500000 1800000 2500000
Income from Investment 700000 750000 790000
Less: Cost of Goods -500000 -250000 -150000
Gross Profit 2700000 2300000 3140000
Less : Expenses
Salaries 300000 300000 320000
Rent 15000 15000 15000
Project expenses 89000 100000 93000
Office expenses 130000 137000 155000
R&D 6000 6000 6000
IT 204500 213500 218500
Marketing 328000 283000 322000
Legal/Accounting 62800 68000 68000
Miscellaneous 6800 7000 7000
Sales tax 125000 90000 125000
Bank charges 4000 4000 4000
Travel expenses 80000 100000 150000

Staffing level and required
competencies
Staffing is a function for employee recruitment, screening and selection of
candidate in order to fill the vacant job position. The competencies refer to
the skill set which required for an individual to perform their jobs according
to designation. The different staffing level is discussed below:
Top Level Management
Director
Chief Executive Officer
Chief Financial Officer
Middle Level Management
Content Analyst
News Anchor
Lower Level Management
Cameraman
Cinematographer

Continue
Post Competencies
Director Directors have many responsibilities which are linked to
keeping business running smoothly. It is observed that
director require specific skills like multitasking, logical
and critical thinking and handle networking within media
company. Entertainment media task director have
formulated an aim to achieve 500 million views for their
T.V show at the end of second year. Their main duty
involve everything such as crafting components of a
campaign, launching the campaign and measure the
outcome of campaign's.
Chief Executive Officer The CEO necessarily must be conflict solver so that any
type of internal and external fight can be handled
effectively. The also help director in making effective plan
and strategies so that T.V program are managed well. They
also make sure that business objective i.e to achieve 500
million view can be accomplish in time.

Continue
Chief Financial Officer Important decision related to finance and utilisation of
funds are taken by CFO of company. Chief financial
officer of entertainment media project needs to allocate
the available fund in adequate manner so that maximum
return can be gain from investment. They must have
professional skills such as strategic vision, corporate
financial competencies and strong work ethic. That will
support in attaining the overall objective of company.
Content Analyst They plays an important part in media industry as proper
and strong analyst help to make decision either to launch
T.V Show or not. This help in achieving predetermined
goals and set target for company. Basic knowledge and
skills required by Content analyst are proper knowledge
of content and decision making skill. They make sure
that content of program are accurate or not that help to
achieve number of viewers.

Continue
News Anchor News anchor should be able to develop story ideas and report
stories on TV so that goals of high views can be achieved. The
main skills required by competencies required by new anchor
are energetic reporter, effective communication skills and
interviewing so that they may connect to viewer. This help in
increasing number of people so that goal of 500 million view
can be achieved.
Cameraman Cameraman plays an important role in media as they can focus
to find the best angle to cover the report and news and present
in best ways. This will attract number of viewer as people are
always attracted towards new and innovative thing.
Cinematographer Cinematographer is a very important job role in entertainment
media as they add some special effects so that an effective
content can be presented. It requires digital camera, computer
skills and artistic skills to perform their job.

Required equipment, tools and
systems
There are various tools and equipment which are required in an entertainment
media project and these are discussed below:
 Notebook
 Digital recorder (Audio / Video)
 Digital Camera
 USB memory

Continue
 Smartphone
 Extra batteries for digital equipment
 Umbrella
 Flash light or Torch

Project execution plan
A project execution plan set out strategy for managing a project. It describes
policies, procedures and priorities which will be adopted to achieve goals.
The selected Entertainment media project will cover the video content
related to humour due to its increasing popularity.

WBS
Work Breakdown Structure for Entertainment Media Project shows various tasks,
activities and phases regarding the project.

Performance: The performance is a part of the phase and it has different tasks
and activities which are described as below:
 Anchor
 Orchestra
 Venue
 Theatre
 Staging
Continue

Continue
Marketing: Marketing is an activity which is performed by every
organisation in order to promote their projects. These are discussed as
below:
 T.V
 Social media
 Print

Inputs and Outputs
There is different inputs and outputs for the project which are discussed as
below:
 Inputs: Inputs are those which are out by the management to initiate
business project.
 Resources
 Organisational policies
 Risk Identification

Continue
 Organisational Need
 Strategic Alignment
 Legislation
 Technical Experts
 Subject Matter Experts
 Brainstorming
 Customer analysis

Continue
Outputs : Output as work result shows that whether goals are achieved or not.
The different output of business is described as below:
 Work result
 Update Stakeholder register
 Individual's Project Goals

Internal and External process
Internal Process:
It is related with the internal work of organisation. The internal process for
entertainment media project is discussed as below:
 Content analysis
 Fund allocation

Continue
External Process:
The external process is related with outsider activities of business. As the
marketing activities of entertainment media project is an external
activity. The will be done in the various forms such as:
 Social media
 Print
 TV

Key Deliverables and KPIs
Key deliverables: The key deliverables describe tangible or intangible
product or service produced as a result of project which is intended to be
delivered to customers. The set benchmark for the views it 500 million so
if it gets 1 million views per month than it can be said that it can be
achieved. Basically this is a key performance indicator for the business.

Continue
KPI: Key performance indicator evaluate the success by analysing whether
goals has been achieved or not. KPI for this project can be assumed to be 1
Million views per month.

Continue
KPI Group Media Coverage
Measured by Executives and supervisors
Weighting In next two years increase the views of TV program by 500 Million
per month
Definition Organisation's executives and supervisors assesses all the operational
activities that may contribute to enhance overall performance of the
company.
Provides When the views of program of the company get increased then it will
help to reach maximum number of viewers so that appropriate
information can be delivered to them.

Continue
KPI Group Media Coverage
Measured by Executives and supervisors
Weighting By the end second year the monthly revenues will be AED 750000.
Definition Organisation's managers and top executives are going to analyse all the
operational activities that are required to achieve the KPI.
Provides When the revenues of the organisations will be increased then it will help
to conduct operations in more effective manner.

Gantt Chart
Gantt chart shows the time taken by each activities of project. This shows the project
schedule and current schedule status of activities. The char is prepared below:

Continue

Continue

Continue
This media programme is planned to be broadcast for three days on television
that is Monday, Tuesday and Wednesday. Due to this schedule, the working
days for this programme are planned to be as Sunday to Thursday. Apart from
Television, this media show is planned to be broadcast on YouTube channel and
Facebook channel.

Conclusion
In the conclusion, it can be said that financial projections play an important
role while preparing a project. Financial projection enables organisation to
allocate their funds in efficient manner. The resource allocation and
strategy needs to plan according to project nature so that goals can be
achieved effectively. Project execution plan shows the different activities
of project and time taken to complete each activity of project.

References
 Mooney, M. H. and De Soyres, C., 2017. Debt Sustainability Analyses for
Low-Income Countries: An Assessment of Projection Performance.
International Monetary Fund.
 Nicholas, J. M. and Steyn, H., 2017. Project management for engineering,
business and technology. Routledge.
 Martinelli, R. J. and Milosevic, D. Z., 2016. Project management toolbox:
tools and techniques for the practicing project manager. John Wiley & Sons.