So, I have some data - Total Cost of all Houses (TC), Average Cost of Houses (AC), Total No of Houses (Type1-T1), Total No of Houses (Type2-T2), Total no of Houses (Type3-T3)
What I dont know is the cost for each type of house (C1, C2, C3)- my equations are: TC= C1*T1 + C2*T2 + C3*T3 and AC = C1*T1 + C2*T2 + C3*T3 / (T1+T2+T3)
Is there a way I can use Solver to calculate the values of C1, C2, and C3?
If it helps I have more than one set of values so:
TC= $573,495, T1 = 530, T2 = 130, T3 = 3, AC= $865
TC= $634,437, T1 = 461, T2 = 10, T3=0 AC= $1,347
Bookmarks