Hello i need help with the following problem, it needs to be done in Excel so if somebody can help me out and send it to my email: emo_hewitt@yahoo.com that would be great ! I need separate files (bills) for each hotel room ! The problem is: 1. Company name JerkQzine Carribean Grille a. # of persons - 12 b. # of nights 3 c. # of rooms 6 d. Room charge - $159/night e. Room tax charges: i. 6% State tax ii. 7% City tax iii. 2% County tax iv. 2% Sports Authority tax f. Route all room and tax charges to a Master folio, the company will be direct billed. g. Bill all other charges to INDIVIDUAL incidental folios. Each participant is responsible for paying their own charges. h. Breakfast $7.00 per person; ALL persons had breakfast every day. i. Movies - $15 each j. Long distance calls @ $2.20/minute k. Room 101 Sally & Jane l. Room 102 - Jack & John m. Room 103 Sarah & Dawn n. Room 104 Roy & Rich o. Room 105 Mr. & Mrs. E. Dawson p. Room 106 Mr. & Mrs. R. Soman q. Jane: 4 long-distance calls lasted 12 min, 15 min, 10 min, 4 min one call made every day; 2 movies on two separate nights; room service $32.00 on 2nd day. r. Sally : Long-distance call for 42 minutes on 2nd day; room service $43.00 on 3rd day; spa - $65.00 on 2nd day. s. Sarah: Lunch twice @ 15.00/person; spa - $75.00 on 2nd day; dinner twice @ 23.00/day. t. Dawn: Dinner every day @ $17.00/person; 1 movie on 1st night. u. Jack & John: Dinner every day @ $22/person; bar charges $35.00 & $43.00 respectively on 2nd night. v. Roy: Dinner every day@ $24.00/person; Bar charges $32.00 on 2nd night; 2 movies on two separate nights. w. Rich: Bar charges @ $52.00; Dinner every day@23.00/person. x. Mr. & Mrs. Dawson: Dinner every day @ $22.00/person; spa charges $52.00 on 2nd day; 2 movies on two separate nights. y. Mr. & Mrs. Soman: Dinner every day @ $17.00/person; spa charges $75.00 on 2nd day; Room service $32.00 on 2nd day. Payments will be made as follows: i. Room and tax billed to company ii. Room 101 VISA CARD from both occupants iii. Room 102 Jack: AMERICAN EXPRESS: John: MASTERCARD iv. Room 103 Dawn: CASH; Sarah: DISCOVER CARD v. Room 104 Roy: TRAVELERS CHECKS; Rich: DINERS CLUB CARD vi. Room 105 AMERICAN EXPRESS vii. Room 106 - DISCOVER