00:00This is a very common problem, namely staff who have mastered the kitchen of compiling tour packages, know pricing, know suppliers, even
00:12client character, once they have a little capital, open their own business at home.
00:19The question is, do you still trust your staff to create tour packages?
00:25Be careful, you are creating competitors without realizing it.
00:30TCC V26.3 feature introduction
00:33First, the group name data, number of participants, and tour code.
00:43Please ask your potential client where they are from, for example, Jakarta.
00:53The purpose is so that you can adapt to the habits of the people of Jakarta.
00:59Then, the group name, please write.
01:02Pax, this is the number of participants.
01:05You can change it.
01:09For below, FOC is free of starts.
01:13You don't need to ask, unless asked.
01:17Then, for the code, please adjust it.
01:20Next, eta is the estimated arrival time.
01:27You can write it down.
01:28Incidentally, I am using the Indonesian version of Excel.
01:32So when I wrote December 12, 26,
01:37will enter the short date.
01:40However, if your PC is using the English version,
01:45it says 12 DEC.
01:51I returned to 12 DEC Indonesian version.
01:58For the total of this one transportation unit,
02:02will automatically be filled according to the amount here.
02:07because the TCC V26 site can make recommendations when the number of tourists is inputted as, for example, 48,
02:19So for the automatic transportation mode component, Big Bus will be used as a reference.
02:29However, if your participant is small, 22, we enter,
02:38then TCC V26 will immediately recommend with a very suitable base.
02:46You're next, because this doesn't use a database,
02:50Please input manually, for example Rp. 2,500,000.
02:56As for the amount here,
02:59is autofill including the number of days.
03:03We pay attention.
03:06Why when it says here 3 days, 2 nights,
03:12but the base rental is only 2?
03:19Because here there is 1 day without doing any activities,
03:24so use transfer in.
03:28I would recommend transferring in using a hotel car or Grab online,
03:34because it is cheaper than renting half a day of the initial mode of transportation.
03:42If here no,
03:47then the number of rental days will automatically follow the number of days we input above.
03:55Likewise, when we input data that in these 3 days, 2 nights,
04:03there is a day, for example here, no transportation is needed,
04:09then you just choose without trans, just choose 1 day.
04:15Note the number of days is 3,
04:18but in the first component of transportation mode rental,
04:24automatically the number is 2.
04:26Why is that?
04:27Because it was already reduced by 1 day.
04:30Let's bring it back to without without trans.
04:36Furthermore,
04:38on trans 2,
04:40This is a TCC feature that will really help you when you encounter a large number of tourists.
04:47As an example,
04:48bus capacity 50 seats but the number of your tourists,
04:54for example 54 or 56.
04:57So here,
04:58This TCC V26.3 will immediately recommend the second type of transportation mode
05:05to transport the rest that is here.
05:1056
05:15In line C 46,
05:17automatically recommends the Innova Rebound to transport the remaining 6 people.
05:24You can input it according to the tariff configuration.
05:28Once again,
05:29why am i not using database?
05:32Because this is a solution for you, especially travel owners.
05:37who still doubles as a tour planner
05:40who do not have a database yet.
05:43So, you can start working straight away.
05:45Sooner or later you will have your own database.
05:49when you have made offers to more than 20 groups.
05:55We'll see again.
05:57For example 62 people.
06:01We scroll.
06:03He still recommends 50 seats.
06:06Nevertheless,
06:08If your city has this jumbo seat, yes, 60,
06:13then it can be selected manually as shown here.
06:20I would not recommend,
06:22because it's less comfortable.
06:24However, if your client wants a cheaper tour package price,
06:29do it.
06:31The remaining 12,
06:33then it is recommended to commuters.
06:37Once again,
06:38so you understand better.
06:41How about 65 people?
06:44So,
06:46The remaining 15 are immediately recommended using the elf.
06:53Your task is simply to input the elf rental price.
07:02Now let's discuss the activity tour.
07:06For example here,
07:08there is a request for 2 days 1 night
07:13for school reunion.
07:15Favorite in Jogja, yes.
07:21Please change the day and number of nights first.
07:28Only after that,
07:30prepare a notepad like this.
07:33Control C.
07:35Take note,
07:36in compiling notepad,
07:38don't make it too much,
07:41because of its relevance,
07:42we will just play
07:44between B and C only.
07:48So,
07:50please place the cursor
07:52in column I, yes.
07:54Why column I?
07:55Because here there is
07:58text,
07:59so that it is not deleted.
08:01We just stick it on.
08:03V Control
08:05Scroll down.
08:06Well, here we can see.
08:08Starting from 28 to 33,
08:12we delete.
08:13Right click,
08:13delete.
08:15Only after that,
08:17place on C9.
08:19V Control
08:21This one,
08:22may be deleted.
08:24Just Del.
08:26Let's check below.
08:27Safe.
08:28Nothing was deleted.
08:31Furthermore,
08:32we fix for day 1 and 2.
08:34The 3rd,
08:35we delete.
08:36The 2nd,
08:38we copy this.
08:39The notification is,
08:40place it parallel to the tour title,
08:44namely Jogja Tour.
08:46Then we delete this one.
08:49If that is the case,
08:50don't worry if it's covered for breakfast and so on,
08:55because on the itinerary,
08:57we see,
08:57this has been read perfectly.
09:00We just need to fix the method.
09:03Unbolt,
09:04like this.
09:06Just pull it down.
09:11It can go down here.
09:13Later, when this is empty,
09:15stay,
09:15There's a formula for this, right?
09:18This is okay friends,
09:19just delete it.
09:22Wipe,
09:23already not available.
09:25It's still there.
09:26Delete again.
09:27Check the bottom again.
09:30If there are still any,
09:31please just delete it.
09:34It's finished.
09:35Already not available.
09:37Just us
09:38Look.
09:40Day 1 was correct.
09:42We just bold.
09:43Can you give me some color?
09:45The colors are harmonious, yes.
09:47We take the sharp one.
09:52We'll adjust this one.
09:55You can start from here.
09:57The purpose is
09:59so that space
10:00not empty.
10:03So that later when we send it
10:05via PDF,
10:07still looks beautiful.
10:09For the itinerary is complete,
10:12we go back to TC.
10:13We fix it again
10:15for components
10:16check first.
10:18For transportation 1,
10:19exactly 2 days.
10:22let's see first
10:23Is there any
10:24transfer in,
10:25out.
10:26It seems there isn't any.
10:27This is 2 full days.
10:29So here
10:31no transfer in,
10:32na' and
10:33transfer out.
10:35Then for
10:36Which
10:37without trans,
10:38the position is correct.
10:40Not available.
10:42So that
10:43total rent
10:44is
10:45this amount.
10:46This
10:47multiplied by quantity
10:48multiplied by 2.
10:50How
10:51if the amount
10:53his name
10:54reunion right
10:54it's very difficult, isn't it?
10:55can collect
10:5660.
10:57We change it to
10:5830.
11:01Let's check again.
11:04The base that
11:04recommended
11:05Already
11:0633.
11:07Correct.
11:08Once again
11:08You can
11:09determine
11:10when they
11:11want a big bus
11:12Please select
11:13big bus
11:14or
11:15in accordance
11:16their choice.
11:18Then
11:19For
11:19additional transport
11:21The second
11:21because of the number
11:2330
11:23still left
11:24It means
11:25no need
11:26There is
11:26addition
11:28transportation
11:29The second.
11:30This is us
11:30just tidy it up
11:31with
11:32no fill.
11:35This is us
11:36wipe.
11:37How to delete it
11:37take note
11:38just block
11:39on data
11:42data tool
11:44validation
11:45click OK
11:46clear.
11:47So that's it
11:48disappeared.
11:49Stay
11:50the only one
11:50here.
11:51Component
11:52B already
11:52finished.
11:54Then
11:54We can
11:55Look
11:55on
11:56Jeep
11:57Lavature
11:57he
11:58automatic
11:59Y.
11:59See ya
12:00There is
12:00the formula that
12:01can you
12:02look here.
12:04Why?
12:05Because here
12:06There is
12:06Jeep
12:06Lavature.
12:07However
12:08if this
12:08deleted
12:09tour
12:10Merapi
12:11example
12:14so
12:15The Jeep
12:15Already
12:15is lost.
12:18No
12:19There is
12:19all.
12:20The formula
12:21It is here
12:21please you
12:22see for yourself.
12:25We
12:26return
12:26with
12:27tour
12:28who wears
12:28Jeep.
12:29So
12:29he
12:30automatic
12:30appear.
12:32The amount
12:33even
12:33Already
12:34automatic
12:3410.
12:35Why
12:35so?
12:36Because
12:36the division
12:3730
12:37shared
12:383.
12:3810
12:39unit.
12:39Appear
12:40price in
12:40here.
12:41Okay.
12:42Now
12:43You
12:44stay
12:44check
12:44component
12:45in
12:45underneath.
12:46Start
12:46from
12:46Tour Leader
12:47If there are
12:48write
12:49Y
12:49if not
12:50There is
12:500.
12:51Thus
12:52Also
12:52For
12:52documentation
12:54ask
12:55to
12:56your clients
12:56For
12:57video
12:57editor
12:58This
12:58I
12:59recommend
13:00still
13:00There is
13:00Because
13:01editing
13:02is part
13:03the most
13:03difficult
13:04and necessary
13:05time
13:05special
13:05as well as
13:06professionalism.
13:08Supporting
13:08unit
13:09Can
13:09customized
13:12Runner
13:13Runner
13:14This
13:15if necessary
13:16write
13:17Y
13:18so
13:19he would
13:19appear
13:20if not
13:21No
13:25other
13:26Please
13:26adjust
13:28Then
13:29for hotels
13:30this can
13:32chosen
13:32once again
13:33twin
13:33he has
13:35all-round
13:36automatic
13:37make it easier
13:38We
13:38For
13:39determine
13:41in accordance with the
13:42choice
13:42from your clients
13:43the amount too
13:45Already
13:45automatic
13:46in accordance
13:47take note
13:48here
13:528
13:538
13:5314
13:548
13:558
13:5514
13:59food
14:00beverage
14:01this is easy
14:02Please
14:02customized
14:04just
14:13this is not
14:14There is
14:18stay
14:19write
14:20No
14:22other
14:24adjust
14:24just
14:24If there are
14:26request
14:26addition
14:27please write
14:28manually
14:28here
14:29the statement
14:30What
14:31And
14:31the cost
14:32How many
14:32as well as
14:33quantity
14:33How many
14:34from here
14:36We can
14:36see
14:37For
14:37total
14:38overall
14:38on
14:40component
14:40variable
14:41cost
14:41This
14:43For
14:44fixed costs
14:45Finally
14:46We can
14:46see
14:47calculation
14:49or
14:49tour costing
14:50his
14:50on
14:50page
14:51This
14:53This
14:54noticed
14:54total
14:55variable
14:56cost
14:56is
14:57addition
14:58from here
15:00profit margin
15:01Please
15:02determine
15:04commission agent
15:05there is or
15:06No
15:06and here
15:08must be balanced
15:09between
15:10cell
15:11D119
15:12with
15:13D132
15:15new
15:17after that
15:18we click
15:19itinerary
15:21You live
15:23editing
15:24here
15:25one night
15:30adjust
15:34What is
15:35including
15:36and no
15:36including
15:37Okay
15:39ready
15:40Please
15:41Send
15:42in
15:42form
15:43pdf
15:43file
15:44save as
15:47copy
15:49extension
15:50his
15:50choose
15:50pdf
15:51Don't
15:53forget
15:53here
15:54write
15:55Name
15:55client
15:56You
16:04very
16:05fast
16:06And
16:06accurate
16:07Happy
16:09Happy
16:11Happy
16:12Thank you for watching!
Komentar