Practical sheet | REF: FIC1079 V1

List costs to be tracked in Excel: resources section

Author: Lionel PUNTOS

Publication date: May 10, 2014 | Lire en français

You do not have access to this resource.
Click here to request your free trial access!

Already subscribed? Log in!

Automatically translated using artificial intelligence technology (Note that only the original version is binding) > find out more.

    A  |  A

    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.

    ...
    You do not have access to this resource.

    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

    A Comprehensive Knowledge Base, with over 1,200 authors and 100 scientific advisors
    + More than 10,000 articles and 1,000 how-to sheets, over 800 new or updated articles every year
    From design to prototyping, right through to industrialization, the reference for securing the development of your industrial projects

    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

    Subscribe now!

    Ongoing reading
    Consolidation zone