00:00Now we want to discuss the fixed cost component, namely costs that are not affected by the number of tourists.
00:08This means, if we use a 30 degasit bus with a certain cost, whether it contains 1, 2, 30, 29, the price is the same, Rp. 2
00:19.500,000.
00:21Now, even though cell 45 is a recommendation, you can still select it using the drop down.
00:30For this drop down, I will introduce how to make it like this, just place it, click data, then data tool, validation data, from
00:42For any value, we select list, then source.
00:46Select the source for the data, for example I will take a drop down list for transportation mode 1, then enter,
00:58click ok.
01:00So he appeared here.
01:06Just delete it.
01:11To change the choice of transportation mode, it is in the data, here, you can see, what I highlighted is the name box for the mode.
01:22transport.
01:23Then the one below this, the second mode of transport, if it is to be deleted, it cannot be deleted carelessly, because it is related to
01:34which is in this formula.
01:36The first one in E3, I show in notepad, this is formula 1 that you have to change, if you change the datasheet.
01:49Then the second one, we copy this, this is the data that you also have to change, and the third one, C51.
02:11Well, so I suggest you not to change it, but if for example you still want to change it, then it has to be adjusted.
02:20For example here, there is data that will be removed.
02:29Select sell out, this one will automatically sell out too.
02:42Note that what we deleted earlier was sheet 33, so when we delete sheet 33, we have to delete this one too.
02:56The brackets delete 1, then this one is also deleted, the brackets are also deleted by 1.
03:13This one also needs to be changed.
03:15We notice here, the source which was previously A2 to 17, has now been changed to 16.
03:26Yes, it's quite complicated.
03:28If you are not used to it, you will probably slip.
03:34So, from here, we copy, insert it into TC.
03:42This one, this one is gone, right?
03:48Even if it's pasted, it still disappears.
03:55Let's try to check.
04:00C45.
04:04That's right.
04:06Well, here.
04:08Because it's already gone.
04:11So, we have to change this one.
04:15For example 32, yes.
04:19This is still not recommended.
04:21So we have to change this first.
04:34He just appeared.
04:37Since it is quite difficult, please follow the special tutorial to change it.
04:42I'm not going to dwell on this, and I'm going to undo this.
04:56So, the data is still the same as before, namely there is bus 33, and this medium bus 33 is also still appearing.
05:06So, we don't need to change this formula.
05:17We return to 30.
05:21Already correct.
05:23Already correct.
05:25Already correct.
05:26This is okay.
05:28This is okay.
05:31Continue to transfer using Grab or hotel car.
05:37Here, you can change the formula, friends.
05:41So, the number of peksi is divided by 2, multiplied by 50 thousand.
05:45What this means is that, on average, the maximum price for an online taxi from Tugu to the city is 50 thousand.
05:54If you want to replace it, please do so here.
05:57Just change 50 to 70 for example.
05:59Just in case.
06:02And this is also the same.
06:04Change 70.
06:06If selected, yes or no.
06:10Then for toll roads, there are none in Jogja, so the value is 0.
06:16And please feel free to adjust this component yourself.
06:20This one is also automatic.
06:23You don't need to fiddle with it, because it's auto-filled here.
06:30All you need to change is here.
06:32Price by default.
06:35Meanwhile, to change the JIP, why does the number 10 appear? You are on the data.
06:41Let's see here.
06:43JIP reksi.
06:45For students, maybe 4.
06:49Please just change it.
06:50In accordance with company policy.
06:53This I will change to 3.
06:56So, for example, if there is a VW Safari here.
07:00For example, yes.
07:01I just wrote it randomly.
07:09He will appear VW Safari number 10.
07:13But if this is a VW Safari we change it to 4.
07:19So the total is 8.
07:2330.
07:28Divided by 4.
07:31The output is 7.5.
07:33It's impossible for us, right?
07:35Renting a VW Safari 7.5 car.
07:40So here is the TCC V26 round up.
07:45The formula is here.
07:47Use the selling formula.
07:48Please pay attention.
07:55For tool leaders and others, please adjust them accordingly.
07:59If using a guide.
08:03Yes or no.
08:04This fee is also adjusted.
08:07Likewise for documentation and supporting units.
08:11Yes or no.
08:14For this runner it is clear.
08:16The formula is as follows.
08:18Price 500.
08:20Plus the amount that's here.
08:30Let's continue.
08:32For other expenses.
08:34Please arrange it yourself.
08:36How many are there here?
08:38Don't forget to type manually.
08:40From here out.
08:41Let's check, okay?
08:44In this way.
08:46To ensure that all the rings in the addition are highlighted.
08:51This means we have to be careful.
08:53Make sure there are no cells that are not included in this ring table.
08:58If it's safe.
09:03You can also just type the amount manually here.
09:10And this is once again what I explained yesterday in the previous video.
09:15This is automatic, right?
09:1710-10.
09:17So this is 10-10.
09:25Food and beverage is clear.
09:27We don't need to discuss it.
09:31But here I need to explain that this fruit basket room is usually for the pig boss.
09:38Or the committee chairman.
09:40We give an appreciation.
09:42So I suggest just write it as Y.
09:46Because when we are given sustenance.
09:48It would be nice if we gave them some appreciation in their room.
09:53This means the one who gave your order.
09:55It was in a fruit basket in the room.
09:58The delay can be adjusted.
10:01150 for example.
10:04And please just write the others.
10:08If there are other needs or other requests, they can also be written manually.
10:13Well, from here we can see.
10:15Check first.
10:17Everything is in the spotlight.
10:19But here.
10:21Dance 1 is the table that is here.
10:27Tour Activity.
10:29We check for M.
10:32Everything is in.
10:34It means safe.
10:36Well, that's where it's going to start.
10:38You can look for this.
10:40Just the similarities, okay?
10:42The equation of the total cost is here.
10:44Then.
10:46For the hotel.
10:48We can see.
10:50It's all highlighted.
10:56Food and Beverage.
10:58Safe.
11:02Tour Activity.
11:07Safe.
11:12Other Complement.
11:14This looks safe.
11:18Other Services.
11:21Still empty.
11:22Safe.
11:22Well, from here.
11:25Total cost.
11:26What is the profit margin.
11:28Please specify.
11:30Become a net sale.
11:32Because there is no FOC.
11:34So the value is 0.
11:35But if there is FOC.
11:39So.
11:41Cost for free of charge.
11:44It will appear automatically in.
11:47This worksheet.
11:49A total of 3 million or so.
11:51So the price after.
11:54FOC.
11:55The value is this much.
11:56Because there are no commission agents.
11:580.
11:59But if asked.
12:01Please just write.
12:02For example 3%.
12:04Then we will add.
12:07From this total cost.
12:08Plus this.
12:09The results are as follows.
12:11Tax.
12:12Do not forget.
12:131.1.
12:15Income Tax.
12:17Now.
12:18It's finally here.
12:19We share.
12:20Price per person.
12:213,4,5,6.
12:23It's rounded up.
12:25On the itinerary.
12:26Become.
12:273,4,5,7.
12:30This is automatic, right?
12:33And for the price.
12:34It's okay here too.
12:37Later.
12:38In the next material.
12:39We will discuss.
12:40How to fix.
12:43Seed itinerary.
12:44Because before.
12:45Soft description.
12:47Now it becomes a long description.
12:50Back to TC.
12:53Take note.
12:55Total net sales.
12:57What we receive.
12:59It's the same.
13:01When we total the revenue.
13:03This amount.
13:06Less FOC.
13:08Minus agent.
13:10Reduce taxes.
13:11We still get a net revenue of 96.2.
13:17And this is the same.
13:22If there isn't any.
13:24Let's just set it to zero, okay?
13:25Let the price be the most affordable price.
13:29Please follow the next material.
13:31To edit the itinerary.
13:35When green.
13:37Why?
13:39Thank You.
13:40Thank You.
Comments