On the Cities worksheet, click cell E13. Depending on the city, you will either take a shuttle to/from the airport or rent a car. Insert an IF function that compares to see if Yes or No is located in the Rental Car? Column for a city. If the city contains No, display the value in cell F2. If the city contains Yes, display the value in the Rental Car Total (F4). Copy the function from cell E13 and use the Paste Formulas option to copy the function to the range E14:E18 without removing the border in cell E18.

Bandar industries berhad of malaysia manufactures sporting equipment. one of the company’s products, a football helmet for the north american market, requires a special plastic. during the quarter ending june 30, the company manufactured 35,000 helmets, using 22,500 kilograms of plastic. the plastic cost the company $171,000. according to the standard cost card, each helmet should require 0.6 kilograms of plastic, at a cost of $8 per kilogram. 1. what is the standard quantity of kilograms of plastic (sq) that is allowed to make 35,000 helmets? 2. what is the standard materials cost allowed (sq x sp) to make 35,000 helmets? 3. what is the materials spending variance? 4. what is the materials price variance and the materials quantity variance?