Create a excel spreadsheet

Create and upload an Excel spreadsheet that contains answers to each of the following.

1) Using the data shown on Figure 9.1, use Excel to calculate the following values for each quantity shown on the graph (start at Q = 0 and use the price of labor is $10 each and the fixed cost is $30):

• Fixed cost
• Variable cost
• Total cost
• Average fixed cost
• Average variable cost
• Average total cost
• Marginal cost (remember this equals change in total cost / change in quantity)

2) Create a graph showing how fixed costs, variable costs, and total costs change with quantity (Q should be on the x-axis).

3) Create a graph showing how average fixed cost, average variable cost, average total cost and marginal cost change with quantity (Q should be on the x-axis).

NOTE: figure 9.1 is in document attached