Excel_Excercises_2009

# Excel_Excercises_2009 - 24 EXCEL exercises 1 Suppose a...

This preview shows pages 1–4. Sign up to view the full content.

24 EXCEL exercises 1. Suppose a company which manufactures and sells three products has information available on the costs and revenues relating to each of these products for the quarters of 2008. The managing directors wish to produce a table similar to that given in Table below. Fill in the blanks in the table and create a pie chart to show revenues by product Costs and Revenues for the firm Profit figures (in USD) for 2008 Quarter 1 Quarter 2 Quarter 3 Quarter 4 TOTAL REVENUE: Product 1 100 100 100 100 Product 2 200 250 300 250 Product 3 300 400 300 300 TOTAL REVENUE COSTS: Salaries 200 200 200 200 Rent 150 150 150 150 Product 1 50 50 45 50 Product 2 40 40 35 40 Product 3 45 45 40 45 Miscellaneous 35 30 55 55 TOTAL COSTS Gross Profit: 2. Table below shows the Quantities, Prices and Total costs of a good. Fill in the blanks in the table, identify the maximum point of profit and create a column graph to show profits against quantities. Price Quantity Total Marginal Total Marginal Profit Demanded Revenue Revenue Cost Cost or Loss 1000 1 400 920 3 530 840 6 890 760 8 1200 680 11 1500 600 14 1800 520 15 2200 440 18 2600 350 21 2900 260 23 3000 3. Use MS Excel to calculate the fallowing Table of Price Elasticity of demand for Oil. 1

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Quantity demande d Q (Millions of Barrels per day) Change in Q (Millions of Barrels per day) Price P (Dollars per barrel) Change in P (Q1+Q2)/2 (P1+p2)/2 Ep=(Change in Q/ (Q1+Q2)/2))/(Change in P/ (P1+P2)/2) 1 98 3 80 6 77 8 74 9 70 12 68 14 65 16 60 18 58 20 56 25 45 4. Columns 1 and 2 in the table show the relationship between employment and the price level in the economy. Employment (Millions of Workers) Price Level Unemployment Rate (%) Rate of Inflation (%) 94 1.00 95 1.08 96.6 1.17 97.3 1.28 97.5 1.42 98.2 1.59 98.0 1.81 98.6 2.10 Assume that full employment in the economy occurs when 100 million workers are employed. Compute the column 3 - the unemployment rate at each level of employment. (Hint: Divide the number of workers unemployed by the number that would be employed at full employment.). At each unemployment rate compute and enter in column 4 the rate of inflation by dividing the increase in the price level by the price level. 5. Plot the Nominal and real GDP from 1996 to 2006. The data are given in the table below. 2
Year Nominal GDP (Billions of Dollars Per Year) Price level Index (Base Year 2000=100) Real GDP (Billions of Dollars Per Year in Constant 2000 Dollars) 1995 3,149.6 83.8 1996 3,405.0 87.2 1997 3,777.2 91.0 1998 4,038.7 94.4 1999 4,268.6 96.9 2000 4,539.9 100.0 2001 4,900.4 103.9 2002 5,250.8 108.5 2003 5,222.2 113.2 2004 5,677.5 117.8 2005 5,967.1 121.2 2006 6,158.8 122.9 (Hint: Real GDP = Nominal/Price Index * 100) 6: Table below shows the maximum new loans plus investments that banks can make given the Fed’s deposit of a \$1,000,000 check in Bank 1. The required reserve ratio is 10.1%. Assume that all excess reserves in each bank are used for new loans or investments, Fill in the blanks in the table. BANK

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 03/30/2010 for the course STATISTIC Cq498767 taught by Professor Wade during the Spring '10 term at UCSI.

### Page1 / 9

Excel_Excercises_2009 - 24 EXCEL exercises 1 Suppose a...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online