Beverly Hills Cop II

Beverly Hills Police Captain Andrew Bogomil, Detective Billy Rosewood, and Sergeant John Taggart are trying to figure out who is behind the "Alphabet Crimes," a series of mostly high end store robberies distinguished by their monogrammed envelopes with an alphabetical sequence the assailants leave behind. Complicating matters is the new "political" state of the Beverly Hills Police Department, headed by incompetent and verbally abusive new police chief Harold Lutz, who is doing everything he can to stay on Mayor Ted Egan's good side. Unimpressed when Rosewood calls the FBI to help solve the case, Lutz holds Bogomil responsible as commanding officer and suspends him, despite Bogomil's efforts to convince him that Rosewood was only following a hunch. Lutz also punishes Taggart and Rosewood by placing them on traffic duty. On the way home, Bogomil is shot and injured by Karla Fry, the chief hench-woman of Maxwell Dent, who secretly is the mastermind behind the Alphabet Crimes. Finding out about the shooting by a news report, Axel Foley abandons his current undercover duties and immediately flies out to Beverly Hills to help find out who shot Bogomil. Taggart and Rosewood agree to assist Axel because of Lutz's attempts to find an excuse to get them fired.
Posing as an undercover FBI agent to get past Lutz with the aid of Detective Jeffrey Friedman, Axel soon starts making the connection between the robberies and Dent. He first finds out that the ammunition fired at one of the robberies was designed by Charles Cain, the manager of a gun club owned by Dent. Axel has Bogomil's daughter Jan use her connections as an insurance agent to find out about Dent's financial dealings. Dent is robbing his own businesses on purpose in order to finance firearms transactions with an arms dealer named Nikos Thomopolis and is discreetly using Cain as the front man for his operations. Bogomil was shot because his investigation was on the correct track into the case.
Having foiled a robbery attempt at a bank depot, Axel is able to trick Dent's accountant Sidney Bernstein into using his computer and discovers that Dent and Karla are planning to leave the country. Axel also learns from Jan that all of Dent's businesses have had their insurance coverage canceled and are about to go bankrupt except his race track, which he is convinced is the next target. On the way to the race track, Axel solves the latest riddle sent to the police, and is convinced that this riddle was made easily solvable in order to implicate Cain as the Alphabet Bandit. However, Axel knows Cain is a patsy designed to throw the authorities off Dent's trail.
The three arrive too late to stop the robbery and find Cain, shot by Karla, among those killed. While Lutz announces publicly that the Alphabet Crimes have been solved, Axel notices some red mud at the stables, which leads him, Taggart and Rosewood to Dent's oil field, where Dent is making his final arms deal with Thomopolis. The three get into a shootout with everyone involved in the deal. Dent confronts Axel in the warehouse, but Axel gets distracted by one of Dent's henchmen on the roof above him and Dent gets away. Dent then crashes through the wall in his car and Axel shoots Dent through the windshield, sending his car down a hill and erupting in flames, after running Axel over. Karla appears and is about to kill Axel, but is shot dead by Taggart.
Just as the last thugs are about to flee, the police arrive upon the scene and arrest the rest of Dent's thugs and Thomopolis. Lutz and Mayor Egan arrive at the scene. Lutz tries to fire Rosewood and Taggart for their insubordination, and also tries to arrest Axel. However, both Taggart and Rosewood stand up to Lutz this time and prove that Dent was the real Alphabet Bandit and the rest of the alphabet crimes were about an arms deal. They are also able to convince Mayor Egan of Lutz's incompetence, (since Lutz would have gotten in the way had he known about their activities, due to his intentionally ignoring the truth from other cops) and the Mayor personally fires Lutz because he is tired of his abusive attitude towards his own men.
Mayor Egan chooses Bogomil to replace Lutz as the new Police Chief. Axel returns to Detroit, but not before he gets chewed out by Inspector Todd over the phone, after Egan called Todd to congratulate him on allowing Axel to assist them on this case.

Question: Who shot and killed Cain?
Answer: Karla