Attachment -1 - PricingSpreadsheet 2026-2027.xlsx

This is a pricing spreadsheet template for a media campaign solicitation issued by the U.S. Embassy Guatemala for fiscal years 2026-2027 (Solicitation No. 19GT5026Q0049). The spreadsheet outlines ten Contract Line Item Numbers (CLINs) for various advertising and marketing services, each with a structured pricing format that includes quantity metrics, fixed rates, monthly subtotals, and contract-length totals.

The CLINs encompass a comprehensive range of media services: CLIN 001 covers radio spots at multiple stations with monthly mention frequencies; CLIN 002 addresses tuk tuk advertising by location; CLIN 003 includes cross-street banners; CLIN 004 covers digital advertising screens; CLIN 005 involves SMS delivery campaigns; CLIN 006 addresses social media advertising across multiple platforms; CLIN 007 covers newspaper advertisements; CLIN 008 addresses printed materials including business cards, posters, and stickers as one-time production costs; CLIN 009 covers jingle production and recording; and CLIN 0010 includes market studies conducted across multiple locations. The spreadsheet provides rows for contractors to input the number of units, fixed rates per unit, quantity multipliers, monthly subtotals, and contract-length totals for each service line. The overall contract price includes calculation lines for press taxes and a 12 percent VAT, indicating the solicitation will be performed in Guatemala with applicable local tax requirements.