3 Replies Latest reply on Apr 11, 2018 2:03 PM by Jim Dehner

    Level of Detail Calculation I Think

    Sonja Froyen

      I've given this my best shot but I'm new and stumped.

       

      I'm trying to calculate how much to reimburse each college on behalf of these students. Tuition is $4500. That is divided by the total number of credits each student took to get a per credit rate. That rate is applied to the total number of credits taken at each college. So, the first two lines should be:

       

      Tiger Woods took 15 total credits. That's $300 per credit ($4500/15).

      CCE should be reimbursed for four of those credits $300 * 4 = $1200

      CLA should be reimbursed for six credits $300 * 6 = $1800

      EHD should be reimbursed for five credits $300 * 5 = $1500

       

      Phil Mickelson took 22 total credits. That's $250 per credit ($4500/22).

      CLA should be reimbursed for thee of those credits $204.55 * 3 = $613.55

      CSE should be reimbursed for eight credits $204.55 * 8 = $1636.40

      CSOM should be reimbursed for eleven credits $204.55 * 11 = $2250.05