Question
I do not understand what to do? Use excel Question: In which year will China need to start importing metal from Colombia? Requirement: Build a
I do not understand what to do?
Use excel
Question: In which year will China need to start importing metal from Colombia?
Requirement: Build a simple model to answer the above question
Assumptions China's demand is either met through domestic production or imports. The preference is listed below and based on price and existing relationship
1. Domestic
2. India
3. South Africa
In 2018 China consumed 20, 40 and 55 tons from these sources, respectively
The maximum outputs are 20, 45 and 75 tons for each of these sources, respectively
Chinese demand for metal is expected to increase at 5% p.a. going forward
Imports from India grow by a year-on-year maximum of the overall demand growth i.e., 5%
Any shortfall in supply is made up by the next country in order of preference. For example, if India reaches its maximum output, South Africa makes up the difference (if not at maximum output as well)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started