Question
You are the Economic Prime Minister of the island nation of Trombetta. You will be making a formal presentation about your Economic ideas concerning the
You are the Economic Prime Minister of the island nation of Trombetta. You will be making a formal presentation about your Economic ideas concerning the Production Possibilities Frontier (PPF) of Trombetta during the years 1997 - 2017 to the Prime Minister. Trombetta produces only four goods - men's shoes, flat screen computer monitors, automobile engines, and cell phones. However, you will be focusing on the automobiles engines market and the cell phone market. Engines are measured in 10,000's of units and cell phones are measured in millions of units. Trombetta uses the British Pound as it's currency and it is measured on 100's of units. The PPF you will be using is the fourth graph in your presentation. The title of your formal presentation is "A PPF Analysis of Trombetta's Production." All your data was collected from Glenn Suskin's article "The Econometrics of Island Nations," published in the October 2019 edition of the American Economic Review, volume 77, pages 38-44. The PPF data is below:
Auto Engines: 0 15 30 45 60 75
Cell Phones: 110 90 70 50 30 10
A-Clearly and accurately construct a line graph using Excel based on all the information above.
. B- Calculate and interpret the slope of the line you have graphed. Pick any two points. Assume the line between your two points is straight for part b of this assignment. Show all work.
C-. Referring only to this graph, how does this PPF exhibit opportunity cost and increasing opportunity? Be specific. (10 pts). Graphs for this assignment must be properly constructed and created using Excel. do assignment as a Word document with embedded Excel charts. Number each step of the assignment
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started