urger Chef Lord Jim has three stores named Burger Chef which sells different types of fast food in three different USA cities. Lord Jim$$s bookkeeper has been keeping the sales figures manually. Lord Jim is looking to expand in the future. He has decided that a spreadsheet application can help him keep better tabs on sales and allow him to analyze how well the stores are doing selling each type of fast food in different parts of the country. Burger Chef sells the following items: Product Type Description Hamburger Burger Quarter pound pure beef Cheeseburger Burger Burger with American Cheese French Fries Fries Fried Crinkle cut potatoes Onion Rings Rings Battered round onion slices Hot Dog Hot Dog Quarter pound all beef Taco Taco Ground beef with choice of fixings Soft Drink Drink Different favors one size same price Milk shake Drink Vanilla or Chocolate one size same price $1.$Download the Burger Chef.xlsx worksheet. Name the worksheets Chicago, New York City and Seattle respectively. Lord Jim needs to know the annual sales, cost of goods sold, annual gross profit, profit margin and markup percentage for each item for each store. $2.$ Lord Jim wants to know the sum, average, maximum and minimum for annual sales, cost of goods sold, and annual gross profit for each store. $3.$ Lord Jim wants the worksheet to flag any item that has a markup of $225\%$ or less so he can decide if the price needs readjustment for each store. The formula for Markup is $=($Price$-$Cost$)/$Cost $4.$ Lord Jim wants to identify the top two best selling items for each store. $5.$ Lord Jim wants to see a pie chart showing the percentages each type of fast food makes up of gross profit margin for each store. $6.$ Lord Jim wants a line chart comparing the annual sales of the fast food for each store. $7.$ Lord Jim needs a bar chart that compares Annual Cost Sold with Annual Sales for each store. $8.$ Lord Jim wants a consolidated worksheet that calculates the total number of units sold for each type of fast food, total sales for each type of fast food, total cost for each type of fast food, the total profit for each type of fast food, and the average profit margin for each type of fast food. The worksheet should highlight the two bestselling fast foods. $9.$ Lord Jim wants a bar chart comparing total sales to total costs for each type of fast food. $10.$ What city store is performing the best? What store has the best profit margin? $11.$ Can you think of ways that Lord Jim can refine his offering and types?