REQUIRED INGREDIENTS QUANTITIES LABEL WHEAT OATS NUTS BLUEBERRIES STRAWBERRIES RAISINS Nuts Min. 20% Min. 30% Min. 20% N/A N/A N/A Blueberry Min. 20% Min. 30% N/A Min. 20% N/A N/A Strawberry Min. 20% Min. 30% N/A N/A Min. 20% N/A Raisin Min. 20% Min. 30% N/A N/A N/A Min. 20% Original Min. 20% Min. 30% N/A N/A N/A N/A Mixed Min. 20% Min. 30% Minimum 30% (at least some of all fruitut)Standard Quantity Costs per box bags for packaging {large} 0.12 1 boxes for packaging {large} 0.28 1 nuts 1.82 per Kg 0.40 Kg oats 0.92 per Kg 0.30 Kg wheat 0.99 per Kg 0.30 Kg ERP Muesli Nut 1kg Nut $$-F01 500g $$-F11 1kg 20% wheat" 30% oat 20% nut* 1 box / 1 bag minimumnsert formulas and cell references into the "gold" cell below. AERP Muesli Not Nut 35 FO 20% wheat 30% oat" 20 % nut" box / 1 bag" minimum $ 0.00 Standard Costs & Actual Costs from the Standard Cost Variances from the Muesli AG Flexible Budget Muesli AG Flexible Budget E 120,000.00 100.00% E1.20 100.00% 90.00% E 100,000.00 20.00% 90.00% 70.00% E 30,000.00 60.00% E1.00 E 60,000.00 50.00% 20.00% 40.00%% E 40,000.00 30.00%% 70.00% 20.00%% E 20,000.00 60.80 10 00% E0.00 10400%% 60.00% bags for boxes for nuts oats wheat Direct Variable packaging packaging Labor Overhead (large) E0.60 50.00% Price/Spending Variances Efficiency Variances Standard Cost Actual Cast -Total Variance 40.00% - Price/Spending Variances % -Efficiency Variances %% E0.40 30.00% 20.00% E0.20 10.00% 60.00 0.00% bags for boxes for nuts oats wheat Direct Labor Variable packaging packaging Overhear (Large) (large)AutoSave On Case Study Chapter 10-1 . Saved V Search (Alt+Q) Jeremy Lawrence File Home Insert Draw Page Layout Formulas Data Review View Automate Developer Help Ablebits Data Ablebits Tools Calibri 11 Conditional Formatting O di- B I Paste U A A Alignment Number Format as Table Cells diting Analyze Sensitivity Data A Cell Styles ~ Clipboard Font Styles Analysis Sensitivity X14 X V fx B C M N 3 Planned Quantities : 158,400 boxes 1,100 cases Total standard Quantity Quantity per Standard Quantities for Total Cost for Costs per box case Cost per case the Month the Month Nut 5 Direct Materials: 6 bags for packaging (large) CO.12 1 each 144 E 17.28 158,400 Kg E 19,008.00 7 boxes for packaging (large) E 0.28 1 each 144 158,400 KE ( 44,352.00 8 nuts E 1.82 per Kg 0.40 Kg 57.60 104.83 63,360 Kg 115,315.20 Nut 9 oats E0.92 per Kg 0.30 Kg 43.20 ( 39.74 47,520 Kg 43,718.40 10 wheat E 0.99 per Kg 0.30 Kg ( 42.77 47,520 Kg E 47,044.80 11 Total Direct Materials 244.94 materials 269,438.40 20% wheat" 12 Direct Labor E 12.00 per hour 0.3 4.00 labor 367 hours 4,400.00 box / 1 bag 13 Variable Overhead 69.00 per DLH 0.33 E 3.00 VOH 367 DLH C 3,300.00 14 Total Standard Cost 251.94 per case 277,138.40 planned cost 15 16 Actual Production Results: 151,200 boxes 1,050 cases Standard Cost Variances Standard Standard Actual Price/Spend- Efficiency Check Figure Quantity [1] Cost [1] Quantity Actual Cost ng Variances U /F Variances U/F (Total Variance) Check Figure [2]. [3). [4] [5]. [6]. [71 (Actual - Std.) 18 Direct Materials: 151,400 each 16,654.00 60.00 19 bags for packaging (large) 151,200 each 42,336.00 6 0.00 16,654.00 6 0.00 20 boxes for packaging (large) 60,400 Kg 112,000.00 C 42,336.00 6 41,804.80 6 0.00 6090 112,000.00 21 nuts 45,440 Kg E 41,804.80 22 oats 45,360 Kg C 44,906.40 C0.00 E 44,906.40 23 wheat E0.00 257,701.20 0.00 E 257,701.20 4 Total Direct Materials 360 hours (4,284.00 60.00 (4,284.00 25 Direct Labor 360 hours E 3,240.00 0.00 C 3,240.00 26 Variable Overhead C 265,225.20 actual cost 265,225.20 27 Total Standard Cost 28 chapter 10 + Ready Ex Accessibility: Investigate EN W X Acci..