A production possibilities frontier is a chart that compares the maximum production of one good given a certain level of production of another related good. In a production possibilities chart, as production of the first good increases you will see a decrease in production of the second good since less labour and capital may be used on the second good. You may use Microsoft Excel to create a simple production possibilities frontier chart with data that you have on relative production of two related goods.
- Skill level:
- Moderately Easy
Other People Are Reading
Open the Microsoft Excel program and create a new Excel workbook.
Type the names of the two production goods that you are comparing in the first two cells in the top row.
Input the production possibilities for the two goods in the cells underneath the labels. Order your entries so that one good is listed in increasing order and the other is listed in decreasing order. You will always observe this increasing-decreasing pattern in a production possibilities curve because producing more of one good will result in less production of the other good.
Highlight all cells on the worksheet that contain data.
Click "Insert" in the menu at the top of the screen and select "Chart".
Select XY (Scatter) from the Chart Type menu and click the Next button twice.
Type in the box labelled "Value (X) axis:" the name of the first good. Type in the box labelled "Value (Y) axis:" the name of the second good.
Click the Legend tab and uncheck the box next to "Show legend."
Click the Next button and select whether you would like your production possibilities chart to be placed in a new worksheet or as an object in an existing worksheet. Click the Finish button to create the chart.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for