cost accounting, how to calculate the cost roll up for the previous two months combined for the given products.
A B D E F. G H I K L M N O 1 2 3 Per Unit Information, predicted Finished Good DL Hours D 02 0.05 D 03 0.06 Cream Cheese 18 Cherries 3 Flour 1.5 2.5 Eggs 6 4 Cakes per Month 3,300 4,800 0 22 4 5 6 7 8 Material Moves Per Batch Information, predicted Finished Good Machine Setups D 02 2 D_03 1 Cleanups 7 1 Final corporation is in the business of producing desserts. Final sells these desserts to retailers. These are produced from raw material inputs. Information related to the operations are provided in the table. Actual production for the lines was 3,300 Cheesecakes and 4,800 Pies. Predicted and Actual Per Batch Information are the same. 5 1 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 All Labor is paid Social Security at 6.2% and Medicaid at 1.45%. All employees' wages are subject to these amounts. The Head Baker is expected to spend 1/2 of her time on each of the product lines. The assistants are expected to spend 40% of their time on Cheesecakes and the rest on Pies. Employees did not earn overtime. The company begins the month with no WIP for the inventory items and expects input costs to stay constant during the two month period. All input inventory is used FIFO. Beginning Inventory for raw materials is purchased on 1/1. Other than fixed equipment, the only overhead that the company has is $4,000 in rent. Fixed Equipment is depreciated using the Straight Line method over 20 years. G H 1 J K L M z N o Q R 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 B D E F Requisition Date Material Req. No. Line ID Input Item ID Count 1/2/2022 RQ_0021 D_02 INV_001 19,000 1/2/2022 RQ_0022 D_02 INV_002 4,000 1/2/2022 RQ_0023 D_02 INV_003 3,000 1/2/2022 RQ_0024 D_02 INV_004 8,000 1/9/2022 RQ_0025 D_03 INV_002 40,000 1/9/2022 RQ_0026 D_03 INV_003 4,000 1/9/2022 RQ_0027 D_03 INV_004 6,000 1/16/2022 RQ_0028 D_02 INV_001 21,000 1/16/2022 RQ_0029 D_02 INV_002 3,900 1/16/2022 RQ_0030 D_02 INV_003 2,500 1/16/2022 RQ_0031 D_02 INV_004 8,000 1/23/2022 RQ_0032 D_03 INV_002 35,000 1/23/2022 RQ_0033 D_03 INV_003 3,000 1/23/2022 RQ_0034 D_03 INV_004 6,000 2/1/2022 RQ_0035 D_02 INV_001 20,000 2/1/2022 RQ_0036 D_02 INV_002 6,000 2/1/2022 RQ_0037 D 02 INV_003 5,000 2/1/2022 RQ_0038 D_02 INV_004 12,000 2/5/2022 RQ_0039 D 03 INV_002 42,000 2/5/2022 RQ_0040 D 03 INV_003 6,000 2/5/2022 RQ_0041 D 03 INV_004 8,000 2/13/2022 RQ_0042 D_02 INV_001 26,000 2/13/2022 RQ_0043 D 02 INV_002 4,000 2/13/2022 RQ_0044 D 02 INV_003 3,200 2/13/2022 RQ_0045 D 02 INV_004 12,000 2/20/2022 RQ_0046 D 03 INV_002 40,000 2/20/2022 RQ_0047 D 03 INV_003 4,500 2/20/2022 RQ_0048 D 03 INV_004 8,000 Rollup Calculations Info Materials Reas Input Purchases Time sheets Codebook > > V Format Painter Formatting lable Styles Filter Sele Clipboard Font Alignment Number Styles Cells Editing G22 fic A B C D E F G H J K L M M N. N o Q 1 Item nm wordOEM oga Date 1/1/2022 1/1/2022 1/1/2022 1/1/2022 1/15/2022 1/15/2022 1/15/2022 1/15/2022 2/1/2022 2/1/2022 2/1/2022 2/1/2022 2/13/2022 2/13/2022 2/13/2022 2/13/2022 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 Units 20,000 $ 55,000 $ 12,000 $ 15,000 $ 45,000 $ 40,000 $ 6,000 $ 20,000 $ 35,000 $ 65,000 $ 8,500 $ 19,000 $ 5,000 $ 55,000 $ 6,500 $ 19,500 $ Price per Unit 0.8800 0.3300 0.0250 0.1000 0.8900 0.3400 0.0270 0.1100 0.8900 0.3400 0.0300 0.1100 0.9000 0.3400 0.0300 0.1100 12 13 14 15 16 17 18 19 20 21 Paste B I U Ini Il M Insert Delete Format $ % -09 Merge & Center Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Format Painter Clipboard Font Alignment Number Cells Editing Analysis Sensitivity 129 X fic E M 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 B Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 D B_001 A. Alexander Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 F Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 . E_001 B. Bradley Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 K L E_002 C. Christiansen Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 N Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 P E_003 D. Duvall Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D 02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID TS_33247 Time Sheet ID TS_33248 Time Sheet ID Rollup Calculations TS_33245 Materials Reqs Time Sheet ID Input Purchases TS_33246 Codebook Info Time sheets + B D E F G H J K L M M N O 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2/16/2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33245 B_001 A. Alexander Hours Worked Desert Line 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D 02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2/16/2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33246 E_001 B. Bradley Hours Worked Desert Line 8 D 02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D 03 8 D_03 8 D_03 8 D_02 8 D_02 8 D 02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33247 E_002 C. Christiansen Hours Worked Desert Line 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33248 E_003 D. Duvall Hours Worked Desert Line 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D 02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Rollun Calculations Info Materials Reas Innut Purchases Time sheets Codebook Clipboard Font Alignment Number 27 Styles Cells Editing Analysis H22 fx B E F G H - J K L M 2 3 4 Unit of Measure Ounces D Materials Inventory Inventory Description Base for Cheese Cake Used for flavor in Cheesecake and filling for Cherry Pies Used for crusts in both Cheesecakes and Pies Ingredient used in Pie Crusts and Cheesecake Filling Input Item ID INV_001 INV_002 INV_003 INV 004 5 Input Name Cream Cheese Cherries Flour Eggs 6 Ounces Cups Unit 7 8 9 10 11 12 13 14 15 16 Employee ID B_001 E_001 E_002 E_003 Employee Name A. Alexander B. Bradley C. Christiansen D. Duvall Employee Information Employee Role Head Baker Baking Assistant Baking Assistant Baking Assistant Wage Rate $ 40.00 $ 20.00 $ 18.00 $ 17.50 17 18 19 20 21 22 Finished Good ID D_01 D_02 D_03 Finished Goods Inventory Finished Good Name Finished Good Description Cherry Cake Discontinued due to lack of Demand Cheese Cake Dessert made of Cream Cheese, Eggs, and Cherries Cherry Pie Dessert made of Cherries, Eggs, and Flour Salvage 10,000 23 24 25 26 27 28 29 Equipment ID EQ_001 EQ_002 EQ_003 EQ_004 Equipment Name Ovens Freezers Coolers Mixers Equipment Equipment Description Ovens for baking cheesecakes For storing finished goods after baking For storing inputs before baking For mixing ingredients in preparation for baking Historical Cost $ 120,000 $ $ 180,000 $ $ 135,000 $ $ 10,000 $ 5,000 1,000 D20 fic B D E F G H K L M N O Q 1 Cheesecake Pie TOTAL COST per Cheesecake, predicted TOTAL COST per Cheesecake, actual TOTAL COST per Pie, predicted TOTAL COST per Pie, actual Predicted DL per Cheesecake Actual DL per Cheesecake Predicted DL per Pie Actual DL per Pie For the given products, do the cost roll up for the previous two months combined. Input the required information the the provided space here. Predicted DM per Cheesecake Actual DM per Cheesecake Predicted DM per Pie Actual DM per Pie Predicted OH per Cheesecake Actual OH per Cheesecake Predicted OH per Pie Actual OH per Pie 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Rollup Calculations Info Materials Reqs Input Purchases Time sheets Codebook + Dond a M A B D E F. G H I K L M N O 1 2 3 Per Unit Information, predicted Finished Good DL Hours D 02 0.05 D 03 0.06 Cream Cheese 18 Cherries 3 Flour 1.5 2.5 Eggs 6 4 Cakes per Month 3,300 4,800 0 22 4 5 6 7 8 Material Moves Per Batch Information, predicted Finished Good Machine Setups D 02 2 D_03 1 Cleanups 7 1 Final corporation is in the business of producing desserts. Final sells these desserts to retailers. These are produced from raw material inputs. Information related to the operations are provided in the table. Actual production for the lines was 3,300 Cheesecakes and 4,800 Pies. Predicted and Actual Per Batch Information are the same. 5 1 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 All Labor is paid Social Security at 6.2% and Medicaid at 1.45%. All employees' wages are subject to these amounts. The Head Baker is expected to spend 1/2 of her time on each of the product lines. The assistants are expected to spend 40% of their time on Cheesecakes and the rest on Pies. Employees did not earn overtime. The company begins the month with no WIP for the inventory items and expects input costs to stay constant during the two month period. All input inventory is used FIFO. Beginning Inventory for raw materials is purchased on 1/1. Other than fixed equipment, the only overhead that the company has is $4,000 in rent. Fixed Equipment is depreciated using the Straight Line method over 20 years. G H 1 J K L M z N o Q R 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 B D E F Requisition Date Material Req. No. Line ID Input Item ID Count 1/2/2022 RQ_0021 D_02 INV_001 19,000 1/2/2022 RQ_0022 D_02 INV_002 4,000 1/2/2022 RQ_0023 D_02 INV_003 3,000 1/2/2022 RQ_0024 D_02 INV_004 8,000 1/9/2022 RQ_0025 D_03 INV_002 40,000 1/9/2022 RQ_0026 D_03 INV_003 4,000 1/9/2022 RQ_0027 D_03 INV_004 6,000 1/16/2022 RQ_0028 D_02 INV_001 21,000 1/16/2022 RQ_0029 D_02 INV_002 3,900 1/16/2022 RQ_0030 D_02 INV_003 2,500 1/16/2022 RQ_0031 D_02 INV_004 8,000 1/23/2022 RQ_0032 D_03 INV_002 35,000 1/23/2022 RQ_0033 D_03 INV_003 3,000 1/23/2022 RQ_0034 D_03 INV_004 6,000 2/1/2022 RQ_0035 D_02 INV_001 20,000 2/1/2022 RQ_0036 D_02 INV_002 6,000 2/1/2022 RQ_0037 D 02 INV_003 5,000 2/1/2022 RQ_0038 D_02 INV_004 12,000 2/5/2022 RQ_0039 D 03 INV_002 42,000 2/5/2022 RQ_0040 D 03 INV_003 6,000 2/5/2022 RQ_0041 D 03 INV_004 8,000 2/13/2022 RQ_0042 D_02 INV_001 26,000 2/13/2022 RQ_0043 D 02 INV_002 4,000 2/13/2022 RQ_0044 D 02 INV_003 3,200 2/13/2022 RQ_0045 D 02 INV_004 12,000 2/20/2022 RQ_0046 D 03 INV_002 40,000 2/20/2022 RQ_0047 D 03 INV_003 4,500 2/20/2022 RQ_0048 D 03 INV_004 8,000 Rollup Calculations Info Materials Reas Input Purchases Time sheets Codebook > > V Format Painter Formatting lable Styles Filter Sele Clipboard Font Alignment Number Styles Cells Editing G22 fic A B C D E F G H J K L M M N. N o Q 1 Item nm wordOEM oga Date 1/1/2022 1/1/2022 1/1/2022 1/1/2022 1/15/2022 1/15/2022 1/15/2022 1/15/2022 2/1/2022 2/1/2022 2/1/2022 2/1/2022 2/13/2022 2/13/2022 2/13/2022 2/13/2022 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 INV_001 INV_002 INV_003 INV_004 Units 20,000 $ 55,000 $ 12,000 $ 15,000 $ 45,000 $ 40,000 $ 6,000 $ 20,000 $ 35,000 $ 65,000 $ 8,500 $ 19,000 $ 5,000 $ 55,000 $ 6,500 $ 19,500 $ Price per Unit 0.8800 0.3300 0.0250 0.1000 0.8900 0.3400 0.0270 0.1100 0.8900 0.3400 0.0300 0.1100 0.9000 0.3400 0.0300 0.1100 12 13 14 15 16 17 18 19 20 21 Paste B I U Ini Il M Insert Delete Format $ % -09 Merge & Center Sensitivity Clear Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Analyze Data Format Painter Clipboard Font Alignment Number Cells Editing Analysis Sensitivity 129 X fic E M 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 B Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 D B_001 A. Alexander Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 F Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 . E_001 B. Bradley Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 K L E_002 C. Christiansen Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 N Employee ID Employee Name Date 1/1/2022 1/2/2022 1/3/2022 1/4/2022 1/5/2022 1/8/2022 1/9/2022 1/10/2022 1/11/2022 1/12/2022 1/15/2022 1/16/2022 1/17/2022 1/18/2022 1/19/2022 1/22/2022 1/23/2022 1/24/2022 1/25/2022 1/26/2022 1/29/2022 1/30/2022 1/31/2022 P E_003 D. Duvall Hours Worked Desert Line 8 D_02 8 D_02 8 D_02 8 D 02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID TS_33247 Time Sheet ID TS_33248 Time Sheet ID Rollup Calculations TS_33245 Materials Reqs Time Sheet ID Input Purchases TS_33246 Codebook Info Time sheets + B D E F G H J K L M M N O 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2/16/2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33245 B_001 A. Alexander Hours Worked Desert Line 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D 02 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2/16/2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33246 E_001 B. Bradley Hours Worked Desert Line 8 D 02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D 03 8 D_03 8 D_03 8 D_02 8 D_02 8 D 02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 2022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33247 E_002 C. Christiansen Hours Worked Desert Line 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Time Sheet ID Employee ID Employee Name Date 2/1/2022 2/2/2022 2/5/2022 2/6/2022 2/7/2022 2/8/2022 2/9/2022 2/12/2022 2/13/2022 2/14/2022 2/15/2022 022 2/19/2022 2/20/2022 2/21/2022 2/22/2022 2/23/2022 2/26/2022 2/27/2022 2/28/2022 TS_33248 E_003 D. Duvall Hours Worked Desert Line 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D 02 8 D_02 8 D_02 8 D_02 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_03 8 D_02 8 D_02 8 D_02 Rollun Calculations Info Materials Reas Innut Purchases Time sheets Codebook Clipboard Font Alignment Number 27 Styles Cells Editing Analysis H22 fx B E F G H - J K L M 2 3 4 Unit of Measure Ounces D Materials Inventory Inventory Description Base for Cheese Cake Used for flavor in Cheesecake and filling for Cherry Pies Used for crusts in both Cheesecakes and Pies Ingredient used in Pie Crusts and Cheesecake Filling Input Item ID INV_001 INV_002 INV_003 INV 004 5 Input Name Cream Cheese Cherries Flour Eggs 6 Ounces Cups Unit 7 8 9 10 11 12 13 14 15 16 Employee ID B_001 E_001 E_002 E_003 Employee Name A. Alexander B. Bradley C. Christiansen D. Duvall Employee Information Employee Role Head Baker Baking Assistant Baking Assistant Baking Assistant Wage Rate $ 40.00 $ 20.00 $ 18.00 $ 17.50 17 18 19 20 21 22 Finished Good ID D_01 D_02 D_03 Finished Goods Inventory Finished Good Name Finished Good Description Cherry Cake Discontinued due to lack of Demand Cheese Cake Dessert made of Cream Cheese, Eggs, and Cherries Cherry Pie Dessert made of Cherries, Eggs, and Flour Salvage 10,000 23 24 25 26 27 28 29 Equipment ID EQ_001 EQ_002 EQ_003 EQ_004 Equipment Name Ovens Freezers Coolers Mixers Equipment Equipment Description Ovens for baking cheesecakes For storing finished goods after baking For storing inputs before baking For mixing ingredients in preparation for baking Historical Cost $ 120,000 $ $ 180,000 $ $ 135,000 $ $ 10,000 $ 5,000 1,000 D20 fic B D E F G H K L M N O Q 1 Cheesecake Pie TOTAL COST per Cheesecake, predicted TOTAL COST per Cheesecake, actual TOTAL COST per Pie, predicted TOTAL COST per Pie, actual Predicted DL per Cheesecake Actual DL per Cheesecake Predicted DL per Pie Actual DL per Pie For the given products, do the cost roll up for the previous two months combined. Input the required information the the provided space here. Predicted DM per Cheesecake Actual DM per Cheesecake Predicted DM per Pie Actual DM per Pie Predicted OH per Cheesecake Actual OH per Cheesecake Predicted OH per Pie Actual OH per Pie 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 Rollup Calculations Info Materials Reqs Input Purchases Time sheets Codebook + Dond a M
