Chapter 18 Excel Template revi23 (1) - Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Cut Calibri - 12 - AA ab Wrap Text Copy General Format Painter BIU - - BA- E Merge & Center $ % " Condi Format Clipboard Font Alignment Number v fx A B C D E G H K L MNO Process Costing Jsing Excel to prepare a production cost report Salish Craft Beers provides the following information for the Malting Department for the month of August 2024: Units Costs Beginning Work-in-Process Inventory 2,200 2,800 * Started in Production in August 36,000 68,000 * * Total to Account For 38,200 70,800 Completed and Transferred to Packaging Department during August 30,000 Ending Work-in-Process Inventory, 35% complete for direct materials and 65% complete for conversion costs. 8,200 Total Accounted For 38,200 70,800 * Includes $1,200 direct materials (DM) and $1,600 conversion costs (CC). ** Includes $23,000 direct materials (DM) and $45,000 conversion costs (CC) Use the blue shaded areas on the ENTER-ANSWERS tab for inputs. ALWAYS use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instruction tab you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or Requirement 1. Complete a production cost report for the Malting Department for the month of August 2024 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process 0 Inventory. Assume Salish Craft Beers uses the weighted-average method. Fill in any headings missing from 1 2. Post the appropriate amounts to the Work In Process T-account. 2 3. Identify the Cost of Goods Manufactured and Work in Process Ending Inventory balance for the Malting Department for August. 23 Instructions ENTERANSWERS Ready Accessibility: Investigate 87-F Q Search Partly sunny X C FB F4 F7 F9 F10 F2 F3 F5 F6 FI22 Wrap Text General BIU . . DA- Merge & Center % " Conditic Format Painter Formatti Clipboard Font Alignment Number 10 X V fx A B C D E F G H K L MNO Requirement 1. Complete a production cost report for the Malting Department for the month of August 2024 to determine the cost of the units completed and transferred out, and the cost of the ending Work-in-Process Inventory. Assume Salish Craft Beers uses the weighted-average method. Fill in any headings missing from 2. Post the appropriate amounts to the Work In Process T-account. 3. Identify the Cost of Goods Manufactured and Work in Process Ending Inventory balance for the Malting Department for August. Excel Skills 25 1 Enter numbers into cells. 26 2 Create formulas. 3 Format the cells requiring dollar signs. 28 4 Format the cells requiring a single underline and cells requiring double underlines. 29 30 Saving & Submitting Chapter Excel Assignments 31 1. Save file. 32 a. You may want to create folder on desktop, and label COMPLETED EXCEL PROJECTS 33 b. Name your files: CHnumber_FirstNameLastName (e.g., CH1_RobynVerdery). + 34 2. Upload and submit your file to be graded. 35 a. Click on "Assessments" located on the navigation bar at the top of the page to open the dropdown menu. 36 b. Click on "Assignments." 37 c. Select the assignment for this chapter. 38 d. Upload your file(s). 39 e. Double check you uploaded the right files. 40 f. Submit them. 41 42 Completina Chapter Excel Quizzes Instructions ENTERANSWERS + Ready Accessibility: Investigate 87'F Q Search Partly sunny + X C F6 F7 F8 F9 F10 F11 F1 F2 F3 FA F5 @ S % & O 7 8 2 3 4. 5 6 U O Q W E R T YHome Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Cut Calibri - 11 A A al Wrap Text General Copy Format Painter BIU-A Merge & Center $ % Clipboard Font Alignment Number X V fx B C D E Direct Materials Conversion Costs COSTS (DM) (cc) Total Costs Costs to account for: beginning work -in process So SO SO Costs added during period 23,000 45,000 Total costs to account for 23,000 45,000 Divided by: Total EUP cost per equivalent unit Costs accounted for: Completed and transferred out Ending work-in-process total cost accounted for Requirement 2 Work-in-Process Inventory bal . Requirement 3 Malting Department: Cost of Goods Manufactured (Transferred Out) Ending Work In Process Inventory Balance Instructions ENTERANSWERS + eady Accessibility: Investigate 87'F Partly sunny Q SearchChapter 18 Excel Template revF23 (1) - Ex Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Cut Calibri - 11 ab Wrap Text General Be Copy B IUDA Merge & Center $ ~ % " Condit Format Painter Format Clipboard Font Alignment Number X V fx B C D E Production Cost Report - MALTING DEPARTMENT Month Ended August 31, 2024 Equivalent Units Direct Materials Conversion Costs UNITS Physical Units (DM) (cc) Units to account for: Beginning work-in-process 0 Started in production 36,000 Total units to account for 36,000 Units accounted for: Completed and transferred out 30,000 30,000 30,000 Ending work-in-process 8,200 Total units accounted for 38,200 Direct Materials Conversion Costs COSTS DM (cc) Total Costs Costs to account for: beginning work -in process SO SO SO Costs added during period 23,000 45,000 Total costs to account for 23,000 45,000 Divided by: Total EUP cost per equivalent unit Costs accounted for: Completed and transferred out Ending work-in-process total cost accounted for Instructions ENTERANSWERS + idy Accessibility: Investigate 87'F Partly sunny Q Search CBALSALISH CRAFT BEERS Production Cost Report - Malting Department Month Ended August 31, 2018 Equivalent Units Units Physical Units Direct Materials Conversion Costs Units to account for: Beginning work in process Started in Production 26,000 Total units to account for 26,000 Units account for: Completed and transferred out 21,000 21,000 21,000 Ending work in process 5,000 1,500 3,000 Total units accounted for 26,000 22,500 24,000 Production cost Report Direct Materials Conversion Costs Total Costs to account for Beginning work in process $0 $0 Cost added during period $18,000 $36,000 $54,000 Total costs to accounted for $18,000 $36,000 $54,000 Divided by Total equivalent units 22,500 24,000 Cost per equivalent unit $0.80 $1.50 Costs account for: Completed and transferred out $16,800 $31,500 $48,300 Ending work in process $1,200 $4,500 $5,700 Total Costs account for $18,000 $36,000 $54.000X Home Insert Page Layout Formula Data Review View Acrobat Cut Times New Row - 11 - A A mp Wrap Text General I Autosum - Im Cop paste Merge & Center . Conditional Format Cell Insert Delete Format Sort & Find & Format Painter Formatting * i table - Styles Carr Filter Select Font Alignment timber Soviet Cells Editing A B D F SALISH CRAFT BEERS Production Cost Report - Malting Department Month Ended August 31. 2018 Equivalent Units Units Physical Units Direct Materials Conversion Costs Units to account for Beginning work in process Started in Production 26000 Total units to account for -SUM(CB:C9) Units account for Completed and transferred out 21000 21000 21000 Ending work in process 5000 1500 3000 Total units accounted for -SUM (C13)C14] -SUM(D13:D14) "SUM(E13 614) Production cost Report Direct Materials Conversion Costa Total Costs to account for Beginning work in process -D21+121 Cost added during period 18000 36000 Total costs to accounted for -D21-D22 HE21+E22 Divided by Total equivalent units -D15 -E15 Cost per equivalent unit -D23/D24 -E23/E24 Costs account for Completed and transferred out =D25'D13 #E25 213 -D28-E28 Ending work in process -D14'D25 #E14 825 -D29-E19 Total Costs account for -SUM(D28 029] -SUM [E26.E29) -D30-E30 I'M Sheetl Sheetz CA Ready 9:16 PM Type here to search O