excell required

CASE + PRIORITY EULES AT TRVTECH LATITED Brilleas Carkenca , managing partncr at a Trytecti consulting firm, has rogacelod your mocrt The consulting firm charges a flat rate of 55,000 per day (e.g. If the lcngth of a coesultancy is 9 days, the fee charged to that company =$45.000 (\$5 00093. All eight firma ampose fires foe lateness. Mitville charges a $375-per-day fine for cach day that the completioe of the cunsalking work is past the dae date; Pointech charges a fine of 5400 -per-day fee each dry late; Latevek. charges a fine of 5300 -per-day for each day late; Chem Services charges a fine of S3as-per-day for cach day lake; Zap Rescarch charpes a fine of 5480 -per day for cach day late; Seloct Rio MATH 0203= QUANTTTAINE MATHDDS 3 charges a fine of 5350 -per-day for each day late; Opher A. Sons charpes a fine of 543 -perdedy for cach day late and Axoljhi Girocp charges a fine of 5275 -per-day for cach day late. 1. Prepare alternative schedules based oe the follimine pricrity nules. MOT, FCFS, EDO, STR. CR and another rule-Longest Prosesing Time (LPT). which odeds joks actording to longest assigned first, second-kngest assigned secood, and so on. Coesider latencus as being equivalent to tardincss, thercfoec cvery instance of carfy complation, i.e. How Time Dac Date =0 2. Prepare a stennary table showing cach priority rale, the respective weal lase fiacs and the fotal net income (4otal net itcome * weal inceme - sotal late fines) for cach priorily rult. 3. Which rule provides Bill with the best schodule? iFor the sake of simplicity. mane that CASE + PRIORITY EULES AT TRVTECH LATITED Brilleas Carkenca , managing partncr at a Trytecti consulting firm, has rogacelod your mocrt The consulting firm charges a flat rate of 55,000 per day (e.g. If the lcngth of a coesultancy is 9 days, the fee charged to that company =$45.000 (\$5 00093. All eight firma ampose fires foe lateness. Mitville charges a $375-per-day fine for cach day that the completioe of the cunsalking work is past the dae date; Pointech charges a fine of 5400 -per-day fee each dry late; Latevek. charges a fine of 5300 -per-day for each day late; Chem Services charges a fine of S3as-per-day for cach day lake; Zap Rescarch charpes a fine of 5480 -per day for cach day late; Seloct Rio MATH 0203= QUANTTTAINE MATHDDS 3 charges a fine of 5350 -per-day for each day late; Opher A. Sons charpes a fine of 543 -perdedy for cach day late and Axoljhi Girocp charges a fine of 5275 -per-day for cach day late. 1. Prepare alternative schedules based oe the follimine pricrity nules. MOT, FCFS, EDO, STR. CR and another rule-Longest Prosesing Time (LPT). which odeds joks actording to longest assigned first, second-kngest assigned secood, and so on. Coesider latencus as being equivalent to tardincss, thercfoec cvery instance of carfy complation, i.e. How Time Dac Date =0 2. Prepare a stennary table showing cach priority rale, the respective weal lase fiacs and the fotal net income (4otal net itcome * weal inceme - sotal late fines) for cach priorily rult. 3. Which rule provides Bill with the best schodule? iFor the sake of simplicity. mane that