ECO403 GDB NO1 Solution Autumn 2021-GDB Solutions-VU-Macroeconomics
ECO403 GDB NO1 Solution Autumn 2021-GDB Solutions-VU-Macroeconomics
Transcript
00:00In the name of Allah, the most Gracious, the most Merciful.
00:02Peace be upon you, dear students and viewers.
00:04Welcome to my YouTube channel, DigiLearnerPoints.
00:07In today's video tutorial, we will solve the assignment number 1 of the subject code ECO-403.
00:19By the way, I have given the name of the solution file as GDB.
00:25But, this is an assignment.
00:27So, let's study the case related to our assignment.
00:31Then, we will read out the requirement.
00:33After understanding it, we will move on to the solution.
00:38So, let's start the case study.
00:41The total marks are 10.
00:43The due date is 19 December 2021.
00:47Indonesian economy is one of the important economies in Asia.
00:58Globalization has boosted economic growth as well as per capita income of Indonesian public.
01:16As a result, living standard of the people of Indonesia has been changed due to more trade activities.
01:31Different facts and figures of the economy of Indonesia along with their particular requirements have been given below.
01:40Different facts and figures of the economy of Indonesia along with their particular requirements have been given below.
01:55Suppose, the economy of Indonesia produces only two goods, i.e., sugar and rice.
02:09Vertically, we have mentioned the year.
02:16Horizontally, we have mentioned the price of two goods, i.e., sugar and its quantity respectively.
02:27So, let's read out the things related to it and try to solve it.
02:38The information given in Table 1 is nominal GDP for the year 2015, nominal GDP for the year 2016, and nominal GDP for the year 2017.
02:52This is called Gross Domestic Product.
02:56What is Gross Domestic Product?
02:59It is the GDP of any commodity that has a monetary value.
03:10So, let's start with the requirements.
03:15Let's read it together and solve it together.
03:19Requirements 2. Expose the data regarding nominal GDP and real GDP of Indonesia for the year 2018, 2019, and 2020 has been mentioned in Table 2.
03:31Suppose, the data regarding nominal GDP and real GDP of Indonesia has been mentioned in Table 2 for the year 2018, 2019, and 2020.
03:44Complete the missing values by using the information given in Table 2.
03:50We have to determine the missing values in Table 2 based on the information given in the rest of the table.
03:57We have to determine the missing values in Table 2 based on the information given in the rest of the table.
04:04Requirements 3. Expose the facts and figures of the economy of Indonesia for the year 2010 to 2014.
04:27The facts and figures of the economy of Indonesia have been mentioned in Table 2 for the year 2010 to 2014.
04:38Complete the missing values by using the information given in Table 3.
04:43We have to determine the missing values in Table 3 based on the information given in the rest of the table.
04:54We have the item and the year.
04:56We have to determine the item and the year.
04:58We have to determine the item and the year.
05:00We have to determine the item and the year.
05:02We have to determine the item and the year.
05:04We have to determine the item and the year.
05:06We have to determine the item and the year.
05:08We have to determine the item and the year.
05:10We have to determine the item and the year.
05:12We have to determine the item and the year.
05:14We have to determine the item and the year.
05:16We have to determine the item and the year.
05:18We have to determine the item and the year.
05:20We have to determine the item and the year.
05:22Let's go to the solution.
05:25Let's try to solve it.
05:34I have taken the help of Excel to solve it.
05:38I have taken the help of Excel to solve it.
05:39You can see it.
05:40You can see it.
05:41The purpose of the solution is that we have Part 1, 2015, 2016, 2017.
05:48and as it is
05:50till here
05:52the black portion
05:54i have just inputted it
05:56the solution i have is
05:58nominal GDP
06:00which is the last column
06:02as i told you that GDP in any economy
06:04all the products produced
06:06their monetary value
06:08we call it GDP
06:10as per our case
06:12in indonesian economy
06:14there are only two goods
06:16rice and sugar
06:18so first
06:20in the first column
06:22we have taken the quantity of rice and sugar
06:24in the second column
06:26we have taken the quantity of rice
06:28in the third column
06:30in the respective column
06:32or in the conjective column
06:34or in the next column
06:36now if we take out the nominal GDP
06:38i have used the formula
06:40so you can see
06:42D4 into E4
06:44D4 into E4
06:46plus
06:48F4
06:50which is the price of rice per kg
06:52in rupees
06:54then into G4 which is the quantity
06:56so i have used this parenthesis
06:58so that you can separate it
07:00and after that
07:02when i have entered it
07:04then i have the GDP of 2015
07:06149
07:08after that i have kept it here
07:10and if you see here
07:12if you direct it
07:14then it will automatically
07:16apply the formula
07:18and calculate it
07:20so we have
07:22nominal GDP of 2016
07:24is 225,000
07:26and nominal GDP of 2017
07:28is 267,000
07:30the secret of nominal GDP
07:32is that
07:34the inflation
07:36is included
07:38in the nominal figure
07:40secondly
07:42we have to determine the missing values
07:44GDP is a deep letter
07:46we make any
07:48base
07:50so that we can
07:52find out
07:54the effect of inflation
07:56from the nominal GDP
07:58so we have
08:00nominal GDP so we are making base of 2018
08:02so we do
08:04nominal GDP is
08:06GDP in 2018 which is the base year
08:08so we have
08:10the formula
08:12nominal GDP divided by real GDP
08:14into 100
08:16so when you divide it by 30,000
08:18so we have 100
08:20base year
08:22so this is missing
08:24so i have put the formula
08:26D12
08:28divided by
08:30in parenthesis
08:32E12 into 100
08:34so we have 106
08:36so if i want to tell you the inflation
08:38so i will tell you by adding
08:40so how much was the inflation
08:44so we have
08:466.06%
08:48you can say
08:50we have inflation
08:52so sorry this is the
08:54respective card
08:56we have to go according to the base period
08:58this
09:00so we have 8.11
09:02so what is the
09:04inflation
09:06for 2019
09:08106.06
09:10and for 2020
09:12108.11
09:14in terms of price
09:16in third we have to find the missing values
09:18i will give the missing values
09:20color so that you can
09:22understand easily
09:28sorry
09:34sorry
09:44last one
09:46i am missing something
09:48i think
09:501,2,3
09:58again
10:00sorry
10:02sorry
10:04i have to check
10:0655
10:0817%
10:1020%
10:1255
10:20this one
10:22i have to
10:24score
10:26this one
10:30then we have
10:32this
10:34this
10:40this
10:42this
10:44this
10:48this
10:50this is the missing values
10:52which we have determined
10:54again
10:56i have used the formula
10:58normally what you have to do
11:00in this value
11:02you have to add
11:04x
11:06x is 100,000
11:08minus
11:1015,000
11:1225,000
11:1410,000
11:16i have used this formula
11:18D22 minus
11:20D19 to
11:22D21
11:24then you have
11:2650,000
11:28then what you have to do
11:30you have to click
11:32like table
11:34then
11:36sum
11:38D18 to
11:40D21
11:42D18 to
11:44D21
11:46then you can see
11:48this sum and this sum
11:50like this
11:52similarly, we have
11:54second element
11:56in this
11:58the formula will be different
12:00the first element of formula
12:02E22
12:04D22
12:06E22 minus
12:08sum
12:10there is a gap
12:12which is missing value itself
12:14then what we have to do
12:16E18 comma
12:18then E20
12:2021,000
12:22E21 11,000
12:24now how this comma will come
12:26first you have to select
12:28then you have to press
12:30control button
12:32then you have to select
12:3421,000
12:36then you have to select
12:3811,000
12:40then you have to select
12:4221,000
12:44same technique we have applied
12:46here also comma
12:48and here which technique
12:50we have applied
12:52so this is last one
12:54so you can see
12:56E22 minus sum
12:58G18 to G20
13:00so we have missing value
13:02so we have 2014
13:04all product values
13:06we have
13:08all elements
13:10government expenditure
13:12net export
13:14add up
13:16formula
13:18H18 dash H21
13:20so here
13:22you can see
13:24auto sum
13:26auto sum
13:28so you have to press
13:30then it will auto sum
13:32what is verification
13:34same formula
13:36select
13:38again
13:40square
13:42you can see
13:44convert
13:46drag
13:48last cell
13:50you can see
13:52all values
13:54you can see
13:56gross domestic product
13:58values
14:00match
14:02means
14:04your calculation is correct
14:06here your assignment is over
14:08i hope you understand
14:10if you have any question
14:12you can ask in comment section
14:14if you want to share
14:16your thoughts
14:18knowledge
14:20you can share
14:22thanks for watching
14:24Assalamualaikum