Project Cost Management and Sales Forecasting with Excel

Name: Project Cost Management and Sales Forecasting with Excel
Rating: 4.2 (27 reviews)

Learn to control your costs, estimate and manage project budget

Created byArda Yanik@ProjePark-Workshop

Last updated 7/2021

English

What you'll learn

How to estimate and manage project costs
How to forecast your advertisement budget and sales
How to design your cash flow diagram
How to prepare professional project budget proposals for your clients
How to plan a 3-year revenue and cost forecast for your company

Course content

7 sections • 33 lectures • 2h 39m total length

Welcome - Course Introduction3:40
What is Project and Project Management?3:10
A project is a temporary set of activities to create a unique product, service, or result within a budget; project management shapes initiation, planning, execution, monitoring, and closing.
In which parts of Project Life Cycle we need Project Cost Management
Project Management Process and Project Cost Management1:56
Project Management Terminology6:23
Project Management Triangle1:31

Section Overview1:21
Join section three’s client project game to estimate cost and timing from scope data, make assumptions, and build a final proposal budget in Excel using simple formulas.
Defining Scope, Schedule and Costs2:43
Define the costs of client project, make assumptions about project budget
Part 1-Designing a proposal template with Excel9:09
Part 2-Designing a proposal template with Excel9:23
Part 3-Designing a proposal template with Excel12:04
Design a proposal template in Excel to finalize project budget by adding additional costs for 3D models and ready assets, calculating total costs, applying a discount, and outlining payment conditions.

Section Overview1:07
Defining costs of an internal project1:46
Define your possible costs and funding opportunities
Part1: Project cost and budget analysis in Excel11:14
Part2: Project cost and budget analysis in Excel10:05
Develop a project cost and budget analysis in Excel by estimating office, hosting, licenses, assets, and monthly cash out, plus publishing fees for Apple Store and Google Play.
Part3: Project cost and budget analysis in Excel4:25
Actual Costs vs Predicted Costs Exercise8:23
Learn to compare actual costs with projected costs using an Excel cash flow model for a six-month mobile game project. Assess variances and budget performance with real-time updates.

Section Overview0:53
Short term / Long term planning approaches1:34
Explore short term and long term planning approaches to project budgeting and sales forecasting, calculating three-year revenue using the asset sales conversion diagram to answer investor questions.
Part1: Sales forecasting with a 3-year planning6:52
Part2: Sales forecasting with a 3-year planning7:31
Format the workbook for 12 months, project downloads and two revenue models, calculate total sales revenue and year-one net profit after costs.
Part3: Sales forecasting with a 3-year planning6:02
Develop year two and three sales forecasts in excel, using monthly download and cost of sales predictions to calculate net profit, with an editable template for future projects.

Requirements

Familiarity with MS Excel is a plus but not mandatory

Description

“Project Cost Management and Sales Forecasting with Excel Course" depends on my 20 years’ experience as a project manager in digital communication and gaming projects. I will explain to you how you can manage your project costs and finish your projects in your budget limits.

In this course we will work on 4 case studies.

First of all, we will design a project budget proposal for a client project with our profit margin.
Our next case study will be estimating our project costs and budget for a short-term project.
The third case study will be designing an Ad-Sale conversion table in excel with simplified formulas.
And finally, we will make calculations about our sales and we will have a Sales Forecast Template.

All of these 4 files will be useful assets for your future projects, startups and entrepreneurships. After finishing the course, you will learn how you can change and adjust them for your business.

Financial problems and calculations can be tricky for technical persons and startup owners. I know you want to concentrate on your product or services and do not want to give too much time and effort for cost and budget analyses. I was in the same situation with you and developed my excel files for non-financial people, they are easy to use, practically can be implemented to any project and robust.

If you are diving to any kind of project, enroll to Project Cost Management Course today and speed up your financial analysis process.

Who this course is for:

Startup owners / Entrepreneurs who want to manage their costs effectively
Project Managers
Product Managers
Project Leaders
Anyone interested in project management

Project Cost Management and Sales Forecasting with Excel

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 17min

Cost and Budget Analysis5 lectures • 12min

Case Study 1: Preparing a Project Budget Proposal with Excel5 lectures • 35min

Case Study 2: Estimating a Project Budget with Excel6 lectures • 37min

Case Study 3: Calculation Ad-Sale Conversion with Excel6 lectures • 33min

Case Study 4: Sale Forecast Template with Excel5 lectures • 23min

Conclusion1 lecture • 1min

Requirements

Description

Who this course is for: