assign 4 - TFC, MC and ATC and use Excel to work out the...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
A SSIGNMENT 4 Due Monday, February 4 (Questions 1 and 2): Q1. Refer to the following information. What are Jack’s economic costs? $_27,875 __ Jack’s economic profit for the year is $ __17,125 _ Jack turned down the offer of a job at Arby’s for $12,500 a year, deciding to open his own pizza parlor. Jack invested his savings of $3,500 (which had previously been earning interest at 5% a year), in his pizza parlor. Other information for Jack’s business for the first year (2006) is shown below: Total Revenue from sale of pizza to customers $45,000 Wages of pizza delivery boys and other workers $15,000 Jack pays himself a salary $5,000 Wheat, tomatoes, cheese and other ingredients $5,000 Phone and Utilities $200 Q2. Type the following data in an Excel spreadsheet. Then plug in the formulas for TVC,
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: TFC, MC and ATC and use Excel to work out the blank columns. Print out a copy of the results. Also print a copy of the formulas in your spreadsheet : To do this, put the cursor in a cell and hold down the CTRL key and the ~ (tilda) key. You will notice that the formulas are now displayed in your worksheet. Now go to the print menu and print. Make sure your results will fit on one page: you can change the width of the columns to fit the results on a page or you may print in landscape. Quantity TC TVC TFC MC ATC TVC TFC 1,000 1000--1000 1 2,000 1000 1000 1000 1000 1000 1000 2 2,800 1800 1000 800 500 1800 1000 3 3,500 2500 1000 700 333.33 2500 1000 4 4,400 3400 1000 900 250 3400 1000 5 5,500 4500 1000 1100 200 4500 1000 6 6,900 5900 1000 1400 166.67 5900 1000...
View Full Document

This note was uploaded on 04/08/2008 for the course ECON 100 taught by Professor Lobo during the Spring '08 term at Benedictine IL.

Ask a homework question - tutors are online