Empresa: NYK
Gestor: Bruno
Projeto: LCC
User Guide
The Guide as well as the video tutorial below is intended for users only. For technical information on the solution, please check "Manual Técnico" one page back.
!
Video Tutorial
General Overview
Aug-24 - LCC (Lite Cost Control) is a macro-enabled Excel system for detailed cost analysis in marine logistics. It organizes data entry, parameter inputs, and complex calculations across dedicated tabs for each port. The core Computing Engine consolidates results from operational stages into comprehensive Plan vs. Actual totals. Key features include seamless navigation, temporary data storage with Memory Slots, and a robust Recording Data procedure, ensuring efficient and accurate cost management across multiple ports.
Portcalls Upload & Automatic Productivity
Nov-24 - With this improvement we have been made it possible for port calls data from the PortCalls Master file to be uploaded into LCC.
With this new feature, it was also possible to enhance the Productivity panel in Parameters so that Productivity information is fetched automatically. A manual field is also available, however, to be used in its stead.
Dataset Upload
Aug-24 - The Dataset Upload view in LCC (Lite Cost Control) streamlines the import of essential datasets, specifically the Working Schedule (WS) and Checklist (CL). It features an Upload Panel with buttons that trigger macros to open, copy, and paste data from external files into the corresponding tabs (BASE_WS and BASE_CL). This ensures accurate and efficient integration of necessary data for detailed cost analysis.
Parameters
Aug-24 - The Parameters View in LCC (Lite Cost Control) centralizes key inputs for the analysis. It automatically populates some parameters from the uploaded Working Schedule and Checklist datasets, while others are manually entered. This view includes fields for crucial data such as dollar quotations, depth values, and productivity metrics. The accuracy of these inputs is vital as they drive the calculations in the Computing Engine, ensuring precise and reliable cost analysis results.
Parameters - Manual Datetimes & Directions
Aug-24 - The Parameters View in LCC (Lite Cost Control) centralizes key inputs for analysis, automatically consolidating datetimes from the uploaded Working Schedule. Users have the option to manually enter datetimes, which will override the automatic entries. Additionally, a dropdown list allows users to select different directions, filtering the data from the Working Schedule based on the chosen direction. These inputs are crucial for driving the calculations in the Computing Engine, ensuring precise and reliable cost analysis results.
Computing
Aug-24 - The Computing Engine is the heart of LCC (Lite Cost Control), where all essential calculations are performed. It comprises sections, each representing a specific stage of the operation, with most sections multiplying tariff rows by manually entered values. Specialized sections, like Stevedorage and Shifting, distribute quantities based on productivity parameters. The results are consolidated in the Computing Overview Panel, displaying Plan vs. Actual totals and discrepancies in BRL and USD, providing a comprehensive summary of the entire operation.
Computing - Fixed Quantity
Aug-24 - The Computing Engine in LCC (Lite Cost Control) performs various essential calculations, with one common type involving the multiplication of tariffs by manually entered quantity values to generate totals for the overview panel. In some sections, preset quantity values are provided, defaulting to 1 if not manually altered by the user. This ensures that calculations can proceed even if specific quantity inputs are not provided, maintaining the accuracy and consistency of the overall analysis.
Computing - Automatic Quantity
Aug-24 - In the Computing Engine of LCC (Lite Cost Control), another type of calculation involves multiplying quantities by tariffs that depend on GRT (Gross Register Tonnage) and DWT (Deadweight Tonnage) values from the Parameters. Users input the quantity value in a specific cell, and the section's calculations automatically place it in the appropriate row based on the current GRT or DWT values. This automation ensures accuracy and efficiency, eliminating the need for users to manually match quantity values with the correct tariff row based on GRT or DWT numbers.
Computing - Stevedoring & Shifting
Aug-24 - The Stevedoring and Shifting sections in the Computing Engine of LCC (Lite Cost Control) involve complex calculations, distributing passenger cars, high and heavy vehicles, and statics (in tons) throughout the day based on productivity parameters from the Parameters view. These sections use data from the Working Schedule and productivity inputs to ensure accurate and realistic operational planning and cost calculations.
Tariff Register
Aug-24 - The Tariff Register in LCC (Lite Cost Control) is a crucial tab where all tariff values are stored. These values are used as parameters in various calculations throughout the system. The register ensures that accurate and up-to-date tariff data is available for multiplying by quantities in the Computing Engine, facilitating precise cost analysis and reporting.
Keep & Fetch
Aug-24 - T he Keep & Fetch feature in LCC (Lite Cost Control) allows users to save an ongoing analysis to one of five memory slots and free the system for a new analysis on the same port. By using the Keep function, the current state of the Computing Engine, Parameters, and datasets are stored in a selected slot. The Fetch function retrieves this saved data, reinstating it in the official tabs, enabling users to seamlessly pause and resume their analyses. This feature ensures data continuity and efficient workflow management.
Recording
Aug-24 - The Recording Procedure in LCC (Lite Cost Control) can only be initiated once the datasets have been uploaded, parameters are in place, and all items in the Consistency Panel have been checked OK. This ensures that all necessary data is accurately entered and validated before finalizing and recording the analysis, maintaining the integrity and reliability of the results.
Overview
Nov-24 - The Overview is a Comparative Analysis report where the user may see quantifiable differences between the Voyage being currently analyzed in Computing and one Analysis previously kept in one of the Slots.