Content X Bb 21490278 X Computer exercise 2.docx X Lab 2 - Marginal Analysis X & https://learn-us-east-1-prod-fleet02-xythos.content.blackboardcdn.com/5cc71db6522fe/21490278?X-... To To G Discussion Presenta.. E (ST PLUGINS-DO.. Practice Dashboard... C 6 Given that Hy = x... G Syphax | Military Wi... Sylenth1 (Win) - VS... Output - Exhale (K. Other favorites Exercise 1. Using the Revenue, Inverse Demand, and Cost equations below, please complete the following Revenue = P*Q P = 225 - 20Q Cost = 100 + 50Q a) Create a profit table in Excel for selling quantity from 0 to 10. Use formulas appropriately b) Format your Table to match Table 1 below. The numbers in the table are for demonstration only; they are not the "correct" answers for the problem. Table 1. Table 1. Profit and Marginal Profit Quantity Price Revenue Cost Profit Marginal Marginal Lots (000s) ($000s) ($000) ($000s) ($000s) Revenue Cost 0 $170 $0 $100 -$100 $150 $150 $138 $12 $150 $38 $130 $260 $176 $84 $110 $38 W N $110 $330 $214 $116 $70 $38 4 $90 $360 $252 $10 $30 $38 $70 $350 $290 $60 -$10 $38 6 $50 $300 $328 $28 -$50 $38 $30 $210 $366 -$156 -$90 $38 $10 $80 $404 -$324 -$130 $38 You can freeze the panes so that the first row is fixed. To do this, click on Cell 16, go to View, under Windows tab, click on Freeze panes, and Freeze Panes again. Type here to search O 59 E ? 2:05 PM 11/28/2021