4. Consolidation zone
Located to the right of the central zone, this six-column zone summarizes the source data in the unit selected in the choice zone:
the red SPENT column gives the sum of cumulative sales for a given month (sum of red data in the same row);
the blue CTC column shows the amount remaining to be done by the end of the year (sum of the blue data on the same line);
the green FCAC column gives the year-end forecast (SPENT + CTC on the same line);
the LAST FCST column gives the forecast for the previous month;
The VAR FCST column gives the difference between the last two forecasts (FCAC - LAST FCST);
the VAR (%) column gives the previous deviation in percent.
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference
This article is included in
Design and engineering management
This offer includes:
Knowledge Base
Updated and enriched with articles validated by our scientific committees
Services
A set of exclusive tools to complement the resources
Practical Path
Operational and didactic, to guarantee the acquisition of transversal skills
Doc & Quiz
Interactive articles with quizzes, for constructive reading
Consolidation zone
Bibliography
Afitep, Dictionnaire du management de projet , Éditions Afnor, 5th ed. 2010, ISBN 2124843419
Michèle Amelot, VBA Excel 2010 - Programmer sous Excel : Macros et Langage VBA , ENI Éditions, 2010, ISBN 978-2-7460-5461-5
Exclusive to subscribers. 97% yet to be discovered!
You do not have access to this resource.
Click here to request your free trial access!
Already subscribed? Log in!
The Ultimate Scientific and Technical Reference