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

# Level of Detail Calculation I Think

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

• ###### 1. Re: Level of Detail Calculation I Think

Hi

first THANK YOU for posting a fun and interesting model

now see the attached and Yes - it is an lod (there are probably several different to do this

the cost per hour is

and the reimbursement is

it will return this

It is important to note that the tuition is a fixed value across all golfers - that's the way parameters - if you choose to vary the tuition it would either be an added dimension in the data or a separate file that you would join with the base data

Jim

If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

1 of 1 people found this helpful
• ###### 2. Re: Level of Detail Calculation I Think

Yes! Thank you. I can learn a lot from this.