Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essays In Economic Sociology

Authors: Max Weber, Richard Swedberg

1st Edition

0691218161, 9780691218168

More Books

Students also viewed these Economics questions

Question

1. Why do we trust one type of information more than another?

Answered: 1 week ago