00:00This is the default 3 days 2 nights file for Jogja City Tour.
00:04There are group sizes, schedules, number of units, tour activities.
00:15Please note, here we are discussing TCC V26 without a database.
00:21So in column D, you have to input the entrance fee for the tourist attraction.
00:26Next for column C, line, this is the total number of characters in cell C9.
00:37The condition is that it must not exceed a maximum of 45 characters.
00:43Why is that?
00:45Because the maximum limit for short descriptions in the itinerary is only in column E.
00:54Take note.
00:57Here is an itinerary that is slightly indented to F.
01:01We'll see.
01:02For exciting adventures.
01:07But the total character count is still safe at 45.
01:12Then this one.
01:14You don't need to change it because it's a formula.
01:17Can be seen.
01:19Can be seen.
01:20This means, if the rank double itinerary contains two syllables he has kai or something else, an example like this.
01:34Then it will automatically appear shuttle including the cost and multiplication.
01:45Carry on.
01:46For fixed costs.
01:51This is an auto recommendation that exists in TCCV 26.3 according to the number of participants.
02:00If the number of participants is, for example, 58, then we can see that he recommends a big bus with 50 seats and that includes the remaining amount.
02:16This person was transported on the existing mode of transport on the C46.
02:24Then for Y and NO.
02:26You can override this manually.
02:30Y or NO.
02:31If NO, then there will be no charges here.
02:36To determine whether a transfer has occurred or not, we can see here.
02:44If in your itinerary there is a transfer in or transfer out, this is even if there is a transfer to the station, departure, but in
02:54It started here this morning, so it's counted as a full day.
03:00So here again type Y.
03:05He will appear here.
03:07Next, for the green cells, even though there is default text, you can develop it later after you have it.
03:18database.
03:18For example, a database is like this.
03:21But I haven't correlated this yet, because this is for manual.
03:25Let's say you don't have a list like this yet.
03:31So once you have a price list or confidential rates, both for transportation, tourist attractions, and others such as hotels, and
03:45other complement, please enter it into this data sheet.
03:49Then you can take the next class TCC V26.2 which uses a database.
03:58These grey cells, note, are autofill, so you don't need to fill them in.
04:09Only the green ones are filled in.
04:15Next, for jeep, rafting, and shuttle bus, this is correlated with the tour itinerary, so whatever we fill in here, as long as
04:28there are jeeps, for example like this.
04:31This is just me randomly.
04:36Then it will automatically fill in.
04:40This means that even if I add adventure here, for example, it will not affect column B.
04:50I just formatted this table, with just two syllables.
05:01For example here, I changed your rafting.
05:10I undo.
05:15Carry on.
05:17Don't forget to enter these components one by one, even if it's only one or two, in the data sheet.
05:28For tour leaders, this is clear.
05:32You just have to choose Y or No.
05:36Same documentation.
05:42For this one, the formula is the multiplication of C76, plus the addition of D47, D49.
05:57From here, you check how to place it on the G85, then in the formula, we click here.
06:09To ensure that the entire summation table rank is highlighted.
06:17We are heading to Fixed Cost.
06:20You just need to manually fill in the hotel name and price.
06:25Then ask for union occupancy, twin, triple, quad.
06:31Which will all be entered automatically here.
06:35Please see the formula.
06:39If B9 is a twin, rounding up, the number of participants is divided by two, and so on.
06:49Fnb, select Y or No.
06:52Once again, these components are overwritten manually, including this one.
07:00Where we will serve for dining.
07:03This is very important in relation to when a deal occurs,
07:07your commitment to serving food at the Kahyangan restaurant for example.
07:11That will be a statement in the employment agreement.
07:18If this is not necessary, write No.
07:22So here, for the total variable cost, we can check.
07:28This is the sum of the tour activities.
07:32And the total sum of all variable costs in G90 to 114.
07:41This activity is above.
07:44Everything is in the spotlight.
07:47For this one, you don't need to think too hard.
07:52Because this is automatic, right?
07:54For example, let's see.
07:58It's been highlighted correctly.
08:01Food and beverage.
08:03It's been highlighted correctly.
08:06And we'll just continue here.
08:08For profit margin after we get the total tour cost.
08:15This one is just for balance in cell G115.
08:21The value is the same.
08:24Please specify.
08:32For commission agents if requested.
08:34If there isn't one, just zero.
08:37You can also write off this tax if there is no PPH.
08:42The way to do it is just to subtract the number zero.
08:45If there is, just return it.
08:49Total income minus cost expensive, minus refund to agent, minus tax, so we will get a net payment of 82,672.
09:03It's exactly the same as this and has to be balanced.
09:07For the itinerary.
09:11This is the default.
09:13We don't need to edit anything.
09:15Unless we check what is in the press included or excluded.
09:25As for the others, please just leave them alone.
09:29In the next material, we will discuss how to replace the image in this dummy example.
09:39Logo, header and footer, and address.
Comments