The prepaid color costs changed from $15,804.66 to $14238.91. I had forgotten to use the variable for vendor cpc instead of client cpc.

SELECT bldg.building_name, bda.room_name, serial_number, billed_projected_volume_black prebill_black,  bda.vendor_cpc_black, billed_projected_volume_color prebill_color, bda.vendor_cpc_color bda.billing_cycle, bda.date_created

FROM billing_data_archive bda
INNER JOIN buildings bldg ON bldg.id = bda.building_id_ma



CIAG15904,
CIAG15905,
CIAG15908,
CIAG15910,
CIAG16050,
CICG17086,
CICG17114,
CICG17115,
CIFG20420