AutoSave . Off) ch05 - Questions - B Search (Alt+Q) A Aadi Randev AR X File Home Insert Page Layout Formulas Data Review View Help Comments Share X Cut Arial 10 ~ A" A" AutoSum ap Wrap Text General Paste [ Copy Fill BIUDAY Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Insert Delete Format Sort & Find & Analyze Format Painter Formatting > Table y Styles v v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis A3 X V fx student below. A B C D E F G H J K Product Actual Attainable Efficiency Dollar Percentage 8 Category Cost Cost Ratio Variance Variance 9 Meat $1.15 $1.09 0.95 -$0.06 -$5.50 10 Seafood $0.65 $0.50 0.77 -$0.15 $30.00 11 Fruits $0.45 $0.48 1.07 $0.03 $6.25 12 Vegetables $0.47 $0.46 0.98 -$0.01 -$2.17 13 Dairy products 60.35 $0.34 0.97 -$0.01 -$2.94 14 Desserts $0.45 $0.52 1.16 $0.07 $13.46 Cost per student $3.52 -$3.83 15 (dinner) $3.39 0.96 -$0. 13 16 What was the overall percentage variance for Maxine's dinner cost per student? Is this 18 cause for concern? 19 20 Answer: 21 22 Which product category showed the highest percentage variance? What do you think 23 may have caused this variance? 24 Answer: 25 26 27 28 29 30 31 Q1 Q2 Q3 Q4 05 06 07 98 09 + Edit 100% Type here to search O X OC Cloudy ~ 9 0 (7 () ENG 2:39 PM IN 2/10/2022