Sissy's Quick Wok

$\backslash$table$[[$Ifem$,$Food Cost $\%,$Number Sold,Selling Price,Variable Cost $\%,$Goal Value$],[$Beef and broccoli,$0\mathrm{.}25,773,4\mathrm{.}99,0\mathrm{.}35,],[$Sweet and sour pork,$0\mathrm{.}18,321,3\mathrm{.}99,0\mathrm{.}35,],[$General Tao's chicken,$0\mathrm{.}20,640,4\mathrm{.}99,0\mathrm{.}35,],[$Vegetable stir$-$fry,$0\mathrm{.}11,440,4\mathrm{.}49,0\mathrm{.}35,],[$Three$-$item combo,$0\mathrm{.}41,310,6\mathrm{.}99,0\mathrm{.}35,],[$Coconut shrimp,$0\mathrm{.}24,485,5\mathrm{.}99,0\mathrm{.}35,],[$Asian ribs,$0\mathrm{.}30,145,6\mathrm{.}99,0\mathrm{.}35,],[$Overall Menu Goals,$0\mathrm{.}25,445,5\mathrm{.}50,0\mathrm{.}35,]]$

a$.$ Using this type of analysis, which item would be considered Sissy's most profitable item?

b$.$ What is the primary cause of that item's high goal value?

c$.$ Using this type of analysis, which item would be considered Sissy's least profitable item?

d$.$ What is the primary cause of that item's lower goal value?

e$.$ Based on the results of the goal value analysis, identify specific actions you would recommend Sissy take to improve the profitability of her menu items that do not meet her goals.

$($Spreadsheet hint: In order for the table to sort correctly, you must put the ENTIRE goal value formula in each cell of the Goal Value column.$)$