Need Excel help! Would appreciate some steps :)

A A B B C D E 1 Dee's Ice Cream Carts 3 2 Cart # City 3 1 CA 4 2 LB 5 3 LB 6 4 CA 7 5 CA 8 6 ED 9 7 LB 10 8 ED 11 9 CA 12 10 CA 13 11 ED 14 12 CA 15 13 ED 16 14 LB 17 15 LB 18 16 CA 19 17 ED 20 18 ED 21 19 ED 22 20 CA 23 21 CA 24 22 ED 25 23 ED 26 24 ED 27 25 LB 28 26 LB 29 27 CA 30 28 ED 31 29 CA 32 30 ED 33 31 ED 34 32 CA 35 33 LB Sales Per Day Fixed Cost Variable Cost 1100 $101,573 $1.53 1138 $114,895 $1.58 1138 $114,895 $1.59 1500 $118,216 $1.63 1773 $118,490 $1.79 1773 $121,490 $1.76 1010 $122,500 $1.39 1587 $123,308 $1.58 1200 $125,573 $1.52 1587 $125,968 $1.59 1475 $128,216 $1.63 1495 $130,400 $1.74 1587 $131,988 $1.58 1200 $132,883 $1.52 1403 $132,999 $1.69 1587 $133,968 $1.57 1600 $138,450 $1.64 1576 $138,450 $1.65 1487 $138,772 $1.51 1600 $139,450 $1.63 1487 $139,772 $1.53 1420 $141,056 $1.58 1405 $141,056 $1.59 1399 $141,056 $1.59 1380 $141,056 $1.58 1399 $141,056 $1.59 1590 $141,150 $1.63 1495 $141,400 $1.74 1425 $142,056 $1.62 1824 $142,300 $1.73 1500 $142,440 $1.74 1399 $142,800 $1.60 1399 $144,055 $1.58 Problem 1: Dee's Ice Cream owns 64 ice cream carts in Calgary (CA), Edmonton (ED), and Lethbridge. (LB) The average price of a frozen treat is $2.30 at each of these carts. Answer the following on the Dee's Ice Cream worksheet in the Exercise 4 workbook. Label each part of the question. a) Determine the annual profit for each of the carts, assuming they work for 180 days each year. b) Using the Countif function, determine the number of carts in Calgary, Edmonton, and Lethbridge. c) Using database functions (where possible) calculate the total profit (assume all the carts are operating), the average daily sales, the average fixed cost, the average variable cost, and the number of carts with a negative profit for each city. Format the results in an appropriate manner. d) Using the vlookup command, with a lookup table, divide all the carts into categories Busy, Medium, and Slow, based on the number of Sales per day: Carts with the number of Sales per day between zero and 1450 are in category Slow. Carts with the number of Sales per day between 1451 and 1750 are in category Medium, and carts with more than 1750 are in category Busy. e) Using prices of $1.90, $2.00, $2.10, $2.15, $2.20, $2.25, $2.30, and $2.35 derive the annual supply schedule for Dee's frozen treats (the annual number of sales at each price). Assume carts with negative profits will not produce. A A B B C D E 1 Dee's Ice Cream Carts 3 2 Cart # City 3 1 CA 4 2 LB 5 3 LB 6 4 CA 7 5 CA 8 6 ED 9 7 LB 10 8 ED 11 9 CA 12 10 CA 13 11 ED 14 12 CA 15 13 ED 16 14 LB 17 15 LB 18 16 CA 19 17 ED 20 18 ED 21 19 ED 22 20 CA 23 21 CA 24 22 ED 25 23 ED 26 24 ED 27 25 LB 28 26 LB 29 27 CA 30 28 ED 31 29 CA 32 30 ED 33 31 ED 34 32 CA 35 33 LB Sales Per Day Fixed Cost Variable Cost 1100 $101,573 $1.53 1138 $114,895 $1.58 1138 $114,895 $1.59 1500 $118,216 $1.63 1773 $118,490 $1.79 1773 $121,490 $1.76 1010 $122,500 $1.39 1587 $123,308 $1.58 1200 $125,573 $1.52 1587 $125,968 $1.59 1475 $128,216 $1.63 1495 $130,400 $1.74 1587 $131,988 $1.58 1200 $132,883 $1.52 1403 $132,999 $1.69 1587 $133,968 $1.57 1600 $138,450 $1.64 1576 $138,450 $1.65 1487 $138,772 $1.51 1600 $139,450 $1.63 1487 $139,772 $1.53 1420 $141,056 $1.58 1405 $141,056 $1.59 1399 $141,056 $1.59 1380 $141,056 $1.58 1399 $141,056 $1.59 1590 $141,150 $1.63 1495 $141,400 $1.74 1425 $142,056 $1.62 1824 $142,300 $1.73 1500 $142,440 $1.74 1399 $142,800 $1.60 1399 $144,055 $1.58 Problem 1: Dee's Ice Cream owns 64 ice cream carts in Calgary (CA), Edmonton (ED), and Lethbridge. (LB) The average price of a frozen treat is $2.30 at each of these carts. Answer the following on the Dee's Ice Cream worksheet in the Exercise 4 workbook. Label each part of the question. a) Determine the annual profit for each of the carts, assuming they work for 180 days each year. b) Using the Countif function, determine the number of carts in Calgary, Edmonton, and Lethbridge. c) Using database functions (where possible) calculate the total profit (assume all the carts are operating), the average daily sales, the average fixed cost, the average variable cost, and the number of carts with a negative profit for each city. Format the results in an appropriate manner. d) Using the vlookup command, with a lookup table, divide all the carts into categories Busy, Medium, and Slow, based on the number of Sales per day: Carts with the number of Sales per day between zero and 1450 are in category Slow. Carts with the number of Sales per day between 1451 and 1750 are in category Medium, and carts with more than 1750 are in category Busy. e) Using prices of $1.90, $2.00, $2.10, $2.15, $2.20, $2.25, $2.30, and $2.35 derive the annual supply schedule for Dee's frozen treats (the annual number of sales at each price). Assume carts with negative profits will not produce