As per my KPI's calculations, which I have sent to you before but have also attached here again, the F&B Revenue is 29, 778 THB and the Cost of F&B is 11,042 THB.
The Revenue figure is taken directly from Comanche's MG_02 Manager Report and is different from the Cash F&B Revenue received as it takes into account F&B Revenue that has been paid (Needs to be paid) by the Agents (Khiri for ABF and Go beyond for ABF and Dinner Sets as part of Packages).
The Cost of F&B is once again taken from a Comanche Report PC_03 Daily Sales Item report, which has been programmed to record the estimated cost of each F&B item sold as per the Cost Matrix I have made (Excel file you sent in a follow up email).
The cost of F&B (37,312 THB), which is as per my Excel Cash Book records the actual cash spent for the purchase of F&B items, some of which are still in stock, namely Liqueur, Beers, Soft drinks, etc. therefore it is higher than the estimated figure for Cost of Goods Sold.
Please let me know if this clarifies the issue.