Question: Complete the below calculations for marginal costs, average variable costs, average total costs and average fixed cost. You may do the computation in Microsoft Excel

  1. Complete the below calculations for marginal costs, average variable costs, average total costs and average fixed cost. You may do the computation in Microsoft Excel and copy the results into the word document which contain your responses.

Complete the below calculations for marginal costs, average variable costs, average total

MID-MODULE EXAM - ECONIC ENVIRONMENT FOR BUSINESS_2022 [Compatibility Mode] - Microsoft Word X Home Insert Page Layout References Mailings Review View Cut Find Calibri 12 - A A 43 3 3 . F 1 2 1 AaBbCcl AaBb( AaBbCcI AaBbCc] AaBbCcI AaBb( AaBbCcI AaBbCci AA Copy Gac Replace Paste Heading 1 1 Normal Subtitle Title 1 List Para... Intense Q... Change Format Painter B I U - abe X2 X' Aa 3 - A Emphasis Strong Styles . Select Clipboard Font Paragraph Styles Editing L QUESTION 3 a) Complete the below calculations for marginal costs, average variable costs, average total costs and average fixed cost. You may do the computation in Microsoft Excel and copy the results into the word document which contain your responses. [12 marks] Output (Q) Total Fixed Cost Total Variable Cost Total Cost Marginal Cost Average Fixed Cost Average Variable Cost Average Total Cost 0 S 50.00 $ 1 50.00 $ 100.00 2 50.00 5 156.00 3 50.00 5 196.00 4 S 50.00 5 224.00 5 50.00 5 260.00 6 50.00 5 300.00 7 50.00 S 350.00 8 50.00 5 408.00 9 5 50.00 5 484.00 10 50.00 5 600.00 11 50.00 5 770.00 b) Use Microsoft Excel to construct the following graphs from the calculations that you have done and copy the results into the Microsoft Word document which contains your responses. i) A graph containing output, total costs, total variable costs and total fixed cost i) A graph containing output, marginal costs, average variable costs and average total cost [3+4] Page: 2 of 2 Words: 353 100% +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!