Module 1 - Case EQUILIBRIUM, SUPPLY AND DEMAND Assignment Overview Supply and Demand in the Real World A commodity is the focus of this case which uses real data for price fluctuations over 6 months.

Managerial Economics. Case 1. Part 1. There is an Excel file linked in case one . It contains all the scenarios and data for the entire class . Download and save it. Getting the Commodity Data . Go to the commodities website. 1. Select the commodity listed on the spreadsheet. 2. Highlight the table of data . 3. Copy and paste into Excel . Creating a Line Chart . 1. Highlight the Month and Price Data. 2. Select INSERT on the Menu. 3. Scroll over and Click “Insert Line or Area Chart.” Select a style of Line Chart. Ther e are more Chart Style Options to choose at this step. Click the chart you created . Click the PLUS to update chart elements . Copy and paste the chart into word. Provide a brief description of the chart. Here’s a shortcut for making your second line chart: Highlight the Change Data. Right Click Your Mouse. Copy. Past e over the Price Column and your Chart will Update Automatically . Research and Application . The assignment instructions explain what must be included in this section.