problem 13 50 insert your answers in the gray shaded cells enter amounts to be subtr 4328486

Problem 13-50

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.

Administration

Editorial

Department

Base

Percent

Base

Percent

Admin. (A)

$               –  

0.00%

                  5

11.11%

Editorial (E)

           75,000

6.25%

                –  

0.00%

College Texts

        6,00,000

50.00%

                25

55.56%

Prof. Pubs.

        5,25,000

43.75%

                15

33.33%

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

Dept.

Admin.

Editorial

College Texts

Prof. Pubs.

Direct costs

$     2,25,000

$   1,75,000

$ 22,50,000

$   9,50,000

Admin.

      (2,46,142)

         15,384

      1,23,071

      1,07,687

Edit.

           21,154

    (1,90,384)

      1,05,769

         63,461

Total