Question

How does one solve this on exel and on word?

u potn The Prime Company produces two products, X and Y. They are produced jointly so for each X manufactured a unit of Y is also produced The joint cost tunction a TC 50 +2 Q+ 5Q2 where Q represents the number of joint units produced. Assume the company is a proft maximizer Create a spreadsheet with columns for Qx, y Px. Py. MRx. MRy. MOx, and MCy Put the values 1 to 15 in increments of 1 in the Qx column and put the same values in the Oy column. Fill in the appropriate formulas in the other cells The demand equations for the two products are the following: Ox-30- Px-ay-50-2 Py a Copy and paste your spreadsheet here with columns for Qx y Py. MRx MRy, and MO b. How many Ox units should the company produce per period? At what price of Px? cHow many Qy units should the company produce per period? At what price of Py? d What will be the company's total revenue per period? e. What will be the company's total cost per period f What will be the company's profit per period? TTT Arial

Answer 1