Let: TC=4+6q+.4q^2 P=20-.04q Using SOLVER, find the profit max P and Q using a single spreadsheet...

Question

Question

Let: TC=4+6q+.4q^2
P=20-.04q

Using SOLVER, find the profit max P and Q using a single spreadsheet showing work. please display functions and formulas

business economics

Answer 1

Answer #1

Answer 2

Similar Homework Help Questions

Monopoly: Assume: P = 16 – 2Q TC = 3Q^2 + 4Q + 3 Find: P,Q,...

Monopoly: Assume: P = 16 – 2Q TC = 3Q^2 + 4Q + 3 Find: P,Q, TR,TC, profit, and elasticity at profit max. Please show all your work
Let q* = 9(P,v,w) be the solution to the firm's profit maximization problem max P.9-TC(q,v,w) OMC(q,v,w)...

Let q* = 9(P,v,w) be the solution to the firm's profit maximization problem max P.9-TC(q,v,w) OMC(q,v,w) Derive the formula for Oq(P,v, w) in 2 in terms of (among other things) Og
TR P Q TC MC ATC profit&nbs

TR P Q TC MC ATC profit 120 120 1 130 / 130 -10 satisfies 180 90 2 150 20 75 30 fair 180 60 3 180 30 60 0 profit max 160 40 4 220 40 55 -60 prod eff 150 30 5 270 50 54 -120 alloc eff 120 20 6 330 60 55 -210 nothing satisfied Under discrimination Q = 4, so TC = 220 while TR equals 120 + 90 + 40+ 60 = 310 and...

A competitive firm's cost of producing q units of output is C = 18 + 4q + q^2 Its corresponding m...

A competitive firm's cost of producing q units of output is C = 18 + 4q + q^2 Its corresponding marginal cost is MC = 4 + 2q. a. The firm faces a market price p = $24. Create a spreadsheet with q = 0, 1, 2, ..... 15, where the columns are q, R, C, VC, AVC, MC, and profit. Determine the profit-maximizing output for the firm and the corresponding profit. Should the firm produce this level of output...
Please show work. There are 40 companies with a weekly TC = 232 + 4q +...

Please show work. There are 40 companies with a weekly TC = 232 + 4q + q2where q is bags of candy. Inverse market demand for candy is P = 76 - 25 QD. (aka 76 minus two-fifths of Q) . 1. what's the equilibrium price of candy market 2. what's the total quantity produced by each of the 40 companies and in total? 3. what's the profit and/or Loss of each company? 4. How many companies can be in...
Fill in the Table for a monopoly. Q P TR TC Profit MR MC 10 $20...

Fill in the Table for a monopoly. Q P TR TC Profit MR MC 10 $20 $150 11 19 155 12 18 161 13 17 170 14 16 185 39 15 15 210 What is the highest profit possible? What is the profit maximizing level of output? What is the profit maximizing price? Draw the graph for a monopoly below, find the profit maximizing level of output Q*, the profit maximizing price P*, the average total cost ATC*, the profit...

Demand: P= 120 - 0.5 Q Total Cost: TC= 1 Q 2 Part 1: Find the...

Demand: P= 120 - 0.5 Q Total Cost: TC= 1 Q 2 Part 1: Find the profit-Maximizing Q of the Monopoly Part 2: Find The profit-Maximizing price of the Monopoly Part 3: Find the Total Profit at the profit maximizing quantity Part 4: Find the amount of consumer surplus at the profit maximizing quantity Part 5: Find the deadweight loss at the profit maximizing quantity
P=100 TC= 2q+q^2 1) Find q* 2) Find ATC, MC 3) Plot MR, ATC, MC, d...

P=100 TC= 2q+q^2 1) Find q* 2) Find ATC, MC 3) Plot MR, ATC, MC, d and show profit 4) Based on profit what do you expect to happen as a result?
Question 2 [20 marks] = Given that the price of the product is P(Q) 4000 –...

Question 2 [20 marks] = Given that the price of the product is P(Q) 4000 – 33Q and the Marginal Cost function of producing the same product is C' = 602 – 6Q + 400. Assuming Q> 0. a) Find the revenue and marginal revenue function of the production in term of Q. (3 Marks) b) Find the total cost function if the fixed cost of the production is RM5000. (4 Marks) c) Interpret the result of the marginal profit...

Consider a competitive rm with total costs given by TC(q) = 100 + 10q + q^2,...

Consider a competitive rm with total costs given by TC(q) = 100 + 10q + q^2, The firm faces a market price p = 50. (a) Write expressions for total revenue TR and marginal revenue MR as functions of output q. (b) Write expressions for average total cost ATC, average variable cost AVC, and marginal cost MC as functions of output q. (c) For what value of output is ATC minimized? (d) Find the profit maximizing level of output q...