As an economic consultant at Lightning Volt Automotive, your task is to calculate production costs and identify the various production costs that illustrate total cost curves as well as average and marginal cost curves. Then you will determine the firm's current profit maximizing price and quantity. Instructions Use the Excel template linked here to complete the following tasks. All work must be shown to receive credit. Submit the completed spreadsheet.

Calculate the total revenue, marginal revenue, profits or losses, and production costs. Create line plot that shows total costs, total fixed costs, and total variable costs. Create line plot that shows production costs. Include AFC, AVC, ATC, and MC. Identify the profit maximizing price and quantity. Explain your answer.

Output, Total Marginal Product of Labor, Average Product of Capital, Labor, Product of MPL = Change in q / Labor, Change in K L Labor q Change in L Product of PL = 9/L 10 O 0 10 1 10 10 2 41 10 3 81 10 4 125 10 5 140 10 6 115 10 90