After computing the following goal values, sort $($in descending rank order$)$ by goal value. Be sure to include the overall menu in the appropriate rank order. Spreadsheet hint: Calculate the goal values by placing the ENTIRE goal value formula for each item in the Goal Value column as follows: $(1$ food cost $\%)\backslash$times item popularity $\backslash$times selling price $\backslash$times $(1($variable cost $\%+$ food cost $\%)).$ The table will not sort correctly if partial calculations for goal value exist in columns A$,$ B$,$ C$,$ or D$.$ For example, DO NOT calculate $(1$ food cost $\%)$ in the A column or $(1($variable cost $\%+$ food cost $\%))$ in the D column.

Goal Value Analysis Results

Item $$A$$ Food Cost $\%($in decimal form$)$B$$ Number Sold $$C$$ Selling Price $$D$$ Variable Cost $\%($in decimal form$)$ Goal Value

After analyzing his menu items, Garikai believes he can improve the chalupa dinner by lowering the selling price to $$8\mathrm{.}55.$ He believes that this lower price will increase number of chalupa dinners sold to $150.$ However, the change in price will increase both his food cost percentage and variable cost percentage to $29$ percent for the chalupa dinner.

If he makes these changes, will the chalupa dinner meet or exceed the overall menu goal value? Should Garikai make these changes?

Results of Changes Made to Chalupa Dinner

Item $$A$$ Food Cost $\%($in decimal form$)$B$$ Number Sold $$C$$ Selling Price $$D$$ Variable Cost $\%($in decimal form$)$ Goal Value

Chalupa Dinner