TCO Analysis for ETP (SGD/AGU)
Comparative map and calculation record
TCO Analysis for ETP (SGD/AGU)
Comparative map and calculation record
Showcase
Description
Calculates the Total Cost of Ownership (TCO) of one or more ICT solutions in accordance with SGD and AGU requirements (Law No. 14,133/2021, IN SGD/ME No. 94/2022, IN SEGES/ME No. 65/2021, and IPPC-TIC/AGU), based on the provided attachments. Classifies costs as direct or indirect and fixed or variable; defines and documents the technique used to allocate indirect costs (simple allocation, stepped allocation, or activity-based costing—ABC), along with the corresponding cost driver; and organizes costs into the Acquisition/Contracting, Operation/Execution, Disposal/Transition, and Risks blocks. When indirect costs are not included in the attachments, estimates them parametrically based on the unit's size—using the estimated number of assets and users on a 1:3 scale (1 device for every 3 on-site employees)—and documents this as an assumption. Consults the latest ICTI from IPEA available on the research date to update values to the base date and project costs over the life cycle, using the Selic rate as the discount rate (NPV; and IRR/Payback when the cash flow allows). Delivers a report ready for items 11, 11.1, and 11.2 of the ETP, including cost classification, the allocation technique, and a clear, defensible executive decision table, as well as calculation records in tables/CSV using the SGD spreadsheet format.
Related Skills
View all
Search PNCP
Searches the National Public Procurement Portal (PNCP) by keyword and organizes attachments from the notices found. By default, it applies the filters Status: Closed, Instrument Type: Notice, Bidding Method: Electronic Auction, and Government Level: Federal—all of which can be adjusted by the user. It presents the notices found for confirmation and, after approval, creates a dedicated project (one group per notice), locates the attachments for each procurement, attempts to save them to the project, and, when a file type is unsupported (application/octet-stream), provides a direct download link for each attachment, generating a table report.

Create Executive Presentation
Transforms an analytical document (report, calculation memo, study, or notes) into an executive Slides presentation for senior leadership: reads the material, defines the storyline, chooses the visual style, generates a 3-slide preview, and composes the final deck on the board.
Information
- Version
- v5
- Last updated
- Runtime credits
- Usage-based
- Models
- Auto