The El Dorado Star is the only newspaper in El Dorado, New Mexico. Certainly, the Star competes with The Wall Street Journal, USA Today, and the New York Times for national news reporting, but the Star offers readers stories of local interest, such as local news, weather, high-school sporting events, and so on. The El Dorado Star faces the revenue and cost schedules shown in the spreadsheet that follows:
Since we are using dollars and cents, be sure to go out two decimal places on your calculations. Add columns to show, respectively, marginal cost (MC), marginal revenue (MR), and total profit.
Create a spreadsheet, and use it to answer the following questions.
Your spreadsheet must include formulas showing how you arrived at the calculations. Also, submit a document showing your step-by-step calculations for each of the cells.
Use the spreadsheet to answer questions 1-6. Explain, in detail, how you arrived at your answers to these questions.