- Your Assignment For Submission On Blackboard You Should Submit An Excel Spreadsheet The First Tab Or Sheet Should Show 1 (47.1 KiB) Viewed 10 times
Your assignment for submission: On Blackboard you should submit an Excel spreadsheet. The first tab or sheet should show
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
Your assignment for submission: On Blackboard you should submit an Excel spreadsheet. The first tab or sheet should show
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