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!


3. Central zone: data

The central zone of Part A is where the basic data is entered. It represents the monthly actual or forecast in the unit selected. It takes the form of a matrix where the rows are the selected activities or tasks, and the columns are the months of the year under consideration.

A special color code is used to visually separate the actual from the forecast:

  • the data highlighted in red are the actual data. It is not possible to make any manual changes, and only the unit selection buttons can be used to modify their format (from hours to cost to FTE, etc.);

  • data highlighted in blue are forecast data. In this case, the data can be modified at will;

  • the COMMIT's zone, also with a red background, is where year-end commitments for the business are shown every...

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
Central zone: data