Page 1 of 1

Your assignment for submission: On Blackboard you should submit an Excel spreadsheet. The first tab or sheet should show

Posted: Wed Jul 06, 2022 6:19 am
by answerhappygod
Your Assignment For Submission On Blackboard You Should Submit An Excel Spreadsheet The First Tab Or Sheet Should Show 1
Your Assignment For Submission On Blackboard You Should Submit An Excel Spreadsheet The First Tab Or Sheet Should Show 1 (47.1 KiB) Viewed 11 times
Your assignment for submission: On Blackboard you should submit an Excel spreadsheet. The first tab or sheet should show all of your work replicating everything from this example (above). The second tab should show the same analysis for the following scenario: Demand: Q = 400-2P (Helpful tip: inverse demand is P = 200-½ Q, so start your price column at 200) Total cost: TC= 10,000+ 20Q In a set of cells at the top of your spreadsheet for this scenario, immediately to the right of the columns showing calculations, please clearly identify the following: Optimal (profit maximizing) price: Optimal (profit maximizing) quantity: Total revenue at this price/quantity combination: Total cost at this price/quantity combination: Maximum profit: Verify that MR = MC at this point. 8 00