1 Data Block: 2 3 ASPIRE FOOD GROUP 4 Brooding Department 5 FIFO Cost Processing 6 For the Month Ended July 31, 2020 7 8 Production data Units in process, beginning 10 Units started into production 11 Units completed & transfered 12 Untis in process, onding 13 12 15 Prior Pere Percent Current Period Percent Materials Conversion Materes Converson 70% 40% ? 2 6.000 23,000 ? 9,000 100% 75% 100% 45% 17. Costdata: Materials Conversion 13 Work in process inventory beginning $ 38,015 S 7700 19 Total cost as of beginning of the period 20 21 Cost added during month: S 166,870 551.527 24 25 26 23 30 32 33 14 5 37 38 39 40 41 42 43 45 46 Data Block Production Report + 1 2 Type Company Name Here or link from Data Block 3 Type Name of Report Here or link from Data Block 4 Type which process costing method is being used or link from Data Block 5 Type Time Period Report Covers Here or link from Data Block 6 7 Quantity Schedule and Equivalent Units $ 9 Quantity 10 Schedule 11 Units to be accounted for: 12 Work in process, beginning 13 Started into production 14 Total units 15 16 Equivalent Units (EU 17 Materials Conversion 18 Units accounted for as follows: 19 Transferred to packaging: 20 From beginning inventory 21 Started & completed this month 22 Work in process, ending 23 Total units and equivalent 24 units of production 25 26 Costs per Equivalent Unit Total Cost Materials Conversion Whole Unit 28 29 Work in process, beginning 30 Cost added by the department 31 Total cost 32 33 Equivalent units of production 34 Cost per equivalent unit F il 35 - Cost Reconciliation M Equivalent Units (above) Production Report Data Block L M N 0 P Q 36 Cost Reconciliation 37 Equivalent Units (above) 38 Total Cost Materials Conversion 39 Cost accounted for as follows: 40 Transferred to packaging: 41 From the beginning inventory: 42 Cost in the beginning inventor 43 Cost to complete these units: Materials 45 Conversion 46 Total cost 47 Started and completed this month 48 Total cost transferred 49 Work in process, ending: 50 Materials 51 Conversion 52 Total work in process 5 Total cost accounted for 54 55 56 57 38 59 61 63 54 65 66 + 019 71 72 73 74 75 Data Block Production Report Ready * or * * * Headings on all financial statements - merge and center across all columns of data (merge and center button on the tool bar). Do not merge and center beyond the last column of data in your spreadsheet. Indent when appropriate (Indent using the space bar there are also buttons on the tool bar for indenting) For underlines (single and double underlines) in the financial statements, click on Border in the tool bar and then click on the border that shows the bottom of the cell underlined. Do not use the document underline option on your tool bar for data cells. Numbers should be in accounting format with zero decimals (Number/under category choose accounting - then change to 0 decimals and no symbol, you will only need to use the dollar sign on certain cells see next item) unless otherwise noted in the instructions. Dollar signs need only appear in the first cell of each column and at the solution (Number/under category choose accounting - then change to 0 decimals and choose the dollar sign symbol). Do not use Currency." Remember to use the correct dates - especially when printing the What If. No numbers should be entered directly into the cells on the statements. All numbers should be entered in the data block page. On the statements there should only be cell references and formulas in the cells. Try to not put any irrelevant data in the data block. If you don't use it in your statementsthen you probably don't need it! Therefore, it should not be in your Data Block page. On the graph page the percentages should be carried to one decimal place unless otherwise noted in the instructions. Check your figures with the ones given in the excel instructions. There will be at least one check figure given for the original data and for the What If data. Don't forget the footer with your name and section. Center the statement on the page horizontally (Print/Print Preview/Page Setup/Margins/Center horizontally hafnm * * 1 Data Block: 2 3 ASPIRE FOOD GROUP 4 Brooding Department 5 FIFO Cost Processing 6 For the Month Ended July 31, 2020 7 8 Production data Units in process, beginning 10 Units started into production 11 Units completed & transfered 12 Untis in process, onding 13 12 15 Prior Pere Percent Current Period Percent Materials Conversion Materes Converson 70% 40% ? 2 6.000 23,000 ? 9,000 100% 75% 100% 45% 17. Costdata: Materials Conversion 13 Work in process inventory beginning $ 38,015 S 7700 19 Total cost as of beginning of the period 20 21 Cost added during month: S 166,870 551.527 24 25 26 23 30 32 33 14 5 37 38 39 40 41 42 43 45 46 Data Block Production Report + 1 2 Type Company Name Here or link from Data Block 3 Type Name of Report Here or link from Data Block 4 Type which process costing method is being used or link from Data Block 5 Type Time Period Report Covers Here or link from Data Block 6 7 Quantity Schedule and Equivalent Units $ 9 Quantity 10 Schedule 11 Units to be accounted for: 12 Work in process, beginning 13 Started into production 14 Total units 15 16 Equivalent Units (EU 17 Materials Conversion 18 Units accounted for as follows: 19 Transferred to packaging: 20 From beginning inventory 21 Started & completed this month 22 Work in process, ending 23 Total units and equivalent 24 units of production 25 26 Costs per Equivalent Unit Total Cost Materials Conversion Whole Unit 28 29 Work in process, beginning 30 Cost added by the department 31 Total cost 32 33 Equivalent units of production 34 Cost per equivalent unit F il 35 - Cost Reconciliation M Equivalent Units (above) Production Report Data Block L M N 0 P Q 36 Cost Reconciliation 37 Equivalent Units (above) 38 Total Cost Materials Conversion 39 Cost accounted for as follows: 40 Transferred to packaging: 41 From the beginning inventory: 42 Cost in the beginning inventor 43 Cost to complete these units: Materials 45 Conversion 46 Total cost 47 Started and completed this month 48 Total cost transferred 49 Work in process, ending: 50 Materials 51 Conversion 52 Total work in process 5 Total cost accounted for 54 55 56 57 38 59 61 63 54 65 66 + 019 71 72 73 74 75 Data Block Production Report Ready * or * * * Headings on all financial statements - merge and center across all columns of data (merge and center button on the tool bar). Do not merge and center beyond the last column of data in your spreadsheet. Indent when appropriate (Indent using the space bar there are also buttons on the tool bar for indenting) For underlines (single and double underlines) in the financial statements, click on Border in the tool bar and then click on the border that shows the bottom of the cell underlined. Do not use the document underline option on your tool bar for data cells. Numbers should be in accounting format with zero decimals (Number/under category choose accounting - then change to 0 decimals and no symbol, you will only need to use the dollar sign on certain cells see next item) unless otherwise noted in the instructions. Dollar signs need only appear in the first cell of each column and at the solution (Number/under category choose accounting - then change to 0 decimals and choose the dollar sign symbol). Do not use Currency." Remember to use the correct dates - especially when printing the What If. No numbers should be entered directly into the cells on the statements. All numbers should be entered in the data block page. On the statements there should only be cell references and formulas in the cells. Try to not put any irrelevant data in the data block. If you don't use it in your statementsthen you probably don't need it! Therefore, it should not be in your Data Block page. On the graph page the percentages should be carried to one decimal place unless otherwise noted in the instructions. Check your figures with the ones given in the excel instructions. There will be at least one check figure given for the original data and for the What If data. Don't forget the footer with your name and section. Center the statement on the page horizontally (Print/Print Preview/Page Setup/Margins/Center horizontally hafnm * *