Problem 13-56 Name:
Insert your answers in the gray-shaded cells. Enter amounts to be subtracted as
negatives. If an answer is incorrect, the word “wrong” will appear. Answers will
differ slightly than printed solution due to greater precision of Excel.
Base Percent Base Percent
Admin. (A) –$ 0.00% 5 11.11%
Editorial (E) 75,000 6.25% – 0.00%
College Texts 600,000 50.00% 25 55.56%
Prof. Pubs. 525,000 43.75% 15 33.33%
1,200,000$ 100.00% 45 100.00%
Dept. Admin. Editorial
College
Texts
Prof. Pubs.
Direct costs 225,000$ 175,000$ 2,250,000$ 950,000$
Admin. (246,142) 15,384 123,071 107,687
Edit. 21,154 (190,384) 105,769 63,461
Total 12$ –$ 2,478,840$ 1,121,148$
Solution
A = $225,000 + 0.1111E
E = $175,000 + 0.0625A
A = $225,000 + 0.1111($175,000 + 0.0625A)
A = $225,000 + $19,144 + 0.0069A
0.9931A = $244,444
A = $246,142
E = $175,000 + 0.0625($246,142)
E = $175,000 + $15,384
= $190,384
Department
Administration
Editorial
