Emad Almaiz is considering the purchase of an existing fast$-$food store in one of $10$ surrounding counties.

He is reviewing financial data of $200$ stores. In particular, he is comparing contribution margins and income from operations for one month.

The Data worksheet contains a list of operating data for the month of June.

Each row provides information about one store, including county, sales amount, variable costs, and fixed costs.

Required:

X$$

Open spreadsheet

Complete two columns on the Data worksheet: Contribution margin ratio and Income from operations.

R$1.$ Cell G$2$: Enter a formula that results in the store's contribution margin ratio, as a percentage, for June.

$\%$

R$2.$ Cell H$2$: Enter a formula that results in the store's income from operations for June

R$3.$ Copy down the entries in cells G$2$ and H$2$ to all other rows with data.

Steps to create a pivot table:

S$1.$ Select a cell in the data on the Data worksheet.

$52.$ Select Insert $/$ PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear.

S$3.$ In the window, under "Choose where you want the PivotTable report to be placed", select "New Worksheet". A new worksheet should appear with the PivotTable,

Questions:

Use the information on the Data worksheet and pivot tables, formulas, and$/$or functions to answer the following questions.

Q$1.$ How many stores in Kannapolis, Waxhaw, and Nightdale counties combined have a contribution margin greater than $56\%?$

Q$3.$ If Store $32\text{'}$s sales increase by $$62,200$ in the coming year, with no change in contribution margin ratio or fixed costs, by what amount would its income from operations increase?

S

Q$4.$ How much more would Store $46\text{'}$s income from operations be if its contribution margin ratio equaled the highest contribution margin ratio of any other store in Apex County?