Value waterfall model

50 %
50 %
Information about Value waterfall model
Business & Mgmt

Published on February 22, 2014

Author: anindyamallick85

Source: slideshare.net

Description

This was a technique developed by my RM during as study on processed seafood

An Understanding of the VALUE WATERFALL MODEL

INTRODUCTION Value = Volume x Price 4 things that can affect value change Y-O-Y 1. Loss in volume due to discontinued SKUs 2. Gain/loss due to change in volume of existing SKUs = ViPi) where Vi is the change in volume sold over previous year. This could be a positive or negative change and the product shall assume the sign accordingly Pi is the average price of each SKU 3. Gain/loss due to change in average price of existing SKUs 4. Gain in volume due to introduction of new SKUs If price bands are to be considered and value is to be analyzed at each price band, change in average price needs to be checked for a corresponding shift of the SKU from one price band to another

METHODOLOGY 2006 2007 2008 2009 2010 A1,1 … … … … … … … … … … … Ai,j … … … … … … … … … … … Am,n Where Ai,j is the number of units of ith SKU sold in jth year To see which SKUs were introduced in 2007, select everything from 2007 and select blanks from 2006 To see which SKUs were discontinued in 2007, select all from 2006 and select blanks from 2007 To see which SKUs were continued across both years, deselect blank in both 2006 and 2007

Add a comment

Related presentations

Related pages

Waterfall chart - Wikipedia, the free encyclopedia

A waterfall chart is a form of data visualization that helps in understanding the cumulative effect of sequentially introduced positive or negative values.
Read more

Spiral model - Wikipedia, the free encyclopedia

The spiral model is a risk-driven process model generator for software projects. ... The waterfall model thus becomes a risk-driven special case of the ...
Read more

What is waterfall model? - Definition from WhatIs.com

The waterfall model is a popular version of the systems development life cycle model for software engineering. Often considered the classic approach to the ...
Read more

Cash Flow Waterfall.xls - Exinfm

Waterfall Model: - The waterfall assumes two parties who split cash flows based on a ... enter zero values. The model is dynamic and amenable to deal ...
Read more

What is Waterfall model- advantages, disadvantages and ...

Diagram of Waterfall-model: Advantages of waterfall model: ... Boundary Value Analysis (BVA) why it is important to do both EP and BVA: Decision tables:
Read more

Create Excel Waterfall Chart - Contextures Website - Excel ...

Create an Excel Waterfall Chart. You can use an Excel Waterfall chart to show the cumulative effect of positive and negative amounts, based on a starting value
Read more

THREE TIER DEVELOPMENT/VALUE ADD WATERFALL MODEL - overview

Model Overview Model Keys / Notes 1. Input Cells 2. Drop Down Input Cells 3. Can Change Title 4. Input and calculation direction will appear when Input ...
Read more

Liquidation Value Waterfall Model & Spreadsheet Discussion

Discussion of model for VC backed company. Join the discussion or start your own at Proformative.
Read more

Waterfall Model - Cunningham & Cunningham, Inc.

For a mostly cynical treatment of this model, see WaterFall. ... cracker pointer at face value. Waterfalls work for ... sdlc.ws/waterfall-model/
Read more

Enterprise Value Waterfall Methodology for AMERICAN ...

Enterprise Value Waterfall Methodology . For investments in portfolio companies that we have identified the M&A market as the principal market, we estimate ...
Read more