Com alat H Chapter 3 assignment - Excel D A canerer Gororum Yardm Payles Aldamalar Dosya Ging Elde Sayfa Duzeni Formuler Veri Goeden Geir Smart Modeller Pwetableraren bio Resimler Ski Smgeler Pivotale Ekran Gunu . + TAL Eklentileri Edirin 1? - ? Graficke 3 - 1 10 let Overlen Iata PotChart JBinta Yorum Dendem Simge Cingi Strun Kann Min Mini Gatisie Dilimleyici Zeman iya Hreler Mehin sligi WordArt ima Nene Kulu Ali Bilgi Sul. Metin Tablet THE Grati Turar Banklar Single J L M N o P 0 R S T U U v W Topic: Process Costing D E F G H ! 1 CHAPTER 3 Make Decisions at Current Designs 3 4 Topic: Process Costing 5 Excel Functions and Tools: SUM Function and Single Cell-Referencing 6 7 Building a kayak using the composite method is a very labor-intensive process. In the B fabrication department, the kayaks go through several steps as employees carefully 9 9 place layers of Kevlare in a mold and then use resin to fuse together the layers. The 10 excess resin is removed with a vacuum process, and the upper shell and lower shell are 17 removed from the molds and assembled. The seat, hatch, and other components are 12 added in the finishing department. At the beginning of April, Current Designs had 30 kayaks in process in the 13 fabrication department Rick Thrune, the production manager, estimated that about 80% of the material costs had been added to these boats, which were about 50% complete 15 with respect to the conversion costs. The cost of this Inventory had been calculated to 16 be $8,400 in materials and $9,000 in conversion costs. 17 During April, 72 boats were started. At the end of the month, the 35 kayaks in the 18 ending Inventory had 20% of the materials and 40% of the conversion costs already 19 added to them. 20 A review of the accounting records for April showed that materials with a cost of ze $17,500 had been requisitioned by this department and that the conversion costs for the 22 month were $39,600. 23 Required 24 24 Use sheet tab Part 1 Complete a production cost report for April 2017 for the tabocation department using the weighted average method 27 20 WHAT IF? 29 2. Perform what-if analysis to answer the following independent questions: 30 a. Hy how much will the ending work in process inventory change if there are only 32 31 kayaks in process at April 307 Wiat factors caused the change? b. By how much will the cost of ending work in process inventory increase if the original 35 33 kayaks have only 10% of the materials and 20% of the conversion costs complete? 34 What effect will this have on income if all completed kayaks are sold in April? 35 25 1. Complete Problem Statement Part 1 Part 2 Part 2 10 Aramak iin buraya yazin 10 TUR 1623 21.21 Chematik Kaydet Chapter 3 assignment - Excel Caner der 2 Dosya Ging Elde Sayfa Dzeni Formuler Gornum Yardm Paylas Aldamalar Veri Gozden Geir Smelt Modeller Ekran untu . + - TAL RE Pustile earten bio Pivotale Resimler Selle Smgele Eklentileri Ediren 1? -- Graficke 3.1 Overlen Banta Tamalar Pitcher Fentiem Yorum Cingi Sttun Kazan Kayip Mini Galicia Denklem Simge Dilimleyici Zaman iya Hrver Mehin sligi WordArt ima Nene Kulu Ali Bilgi - Sull Tab Grati Tura Banklar Metin Simge G H J K 1 M N 0 P R S U V V - 119 A C D E F 1 Chapter 3: Using Excel to Make Decisions at Current Designs 2 3 Data 4 4 5 Units 6 Units in process, April 1 7 7 Direct materials - percentage complete 8 Conversion costs - percentage complete 9 Units started in production during April 10 Units in process, April 30 11 Direct materials - percentage complete 12 Conversion costs - percentage complete 13 14 Costs 15 Work in process. April 1 16 Direct materials 17 Conversion costs 19 Costs incurred during production in April 20 Direct materials 21 Conversion costs 22 29 24 Required 25 Follow the step-by-step directions to complete the production cost report below. 27 www------------- 28 CURRENT DESIGNS Fabrication Department 30 Production Cost Report 31 For the Month Ended April 30, 2017 32 Equivalent Units Ohlal Problem Statement Part 1 Part 2a Part 2b Herell belrep ENTER tupunane briston Aramak iin buraya yazin Ei 10 10 TUR 16:27 21.21 F Chapter 3 asignment - Excel Caner des 2 Sayfa Dzeni Formuler Wari Guaden Geir Gorunum Yardm Paylas Aldamalar Onomatik Kaydet Dosya Giri Ede A Rekler Temalar Alipler Celtier i Kenar Belulan- Bangla Iseki saya Kravuz igieni Raglicher - Gronom Gorum OF Di EN N Ynlendirme Boyut Yardums Sayfa Arts anders Alan - Sunlan Pur Balik Sapa YAPI Girone A Seim zis Gruplandrino Guil - Gondar - Bulmesi Yerletir Temalar Sadrvak in Olyclonal Sayfa Senin J16 6 B D F F F G H ! 1 J K 1 M M N 0 R S T U U V A 34 QUANTITIES 35 Units to be accounted for 38 Work in process, April 1 37 Started into production 38 Total units 39 40 Units accounted for 41 Transferred out 42 Work in process, April 30 43 Total units 44 Conversion Costs Materials Total 45 COSTS 46 Unit costs 47 Total cost 48 Equivalent units 19 Unit costs 50 51 Costs to be accounted for 52 Work in process, April 53 Started into production 54 Total costs 55 56 Cost Reconciliation Schedule 57 Costs accounted for 59 Transferred out 59 80 Work in process, April 30 61 Materials 62 Conversion costs 53 Total costs 65 68 Problem Statement Part 1 Part 2a Part 2b + 110 Aramak iin buraya yazin Ei 10 TUR 16:29 2.08.2011 5 a vastus Paylas Auklamals DHE Turu Kleu Csiluri Baba vinnom YA Yaad Sula Segerek Bir One Bir Arkaya Seim Hale Gruplarde Dondus Get Geder Holmesi ciles 1 J J L M N 0 P Q R S T T U V W Y Dosya Gris Ekle Sayla Dzeni Formule Goeden Ceci Gorunum Yarum A. Renkler Geriyle 1 wyle A Van Tipleri Valakik: 1 ayla Yonlendirme Buyi Varde Sale A ke Yachme Boslui Alan Sorian Plan Bagidan Cice Tengo Suylapsi Sumak in Okkiendi L13 - A B C D E F G H 1 Chapter 3: Using Excel to Make Decisions at Current Designs Part 2 2 3 Data 4 5 Units 6 Units in process, April 1 7 Direct materials percentage complete B Conversion costs. percentage complete 9 Units started in production during April 10 Units in process, April 30 11 Direct materials percentage complete 12 Conversion costs - percentage complete 13 14 Costs 15 Work in process, Apni 1 16 Direct materials 17 Conversion costs 18 19 Costs incurred during produchon in April 20 Direct materials 21 Conversion and 22 23 24 Required 25 Folow the what-if directions to modify the production cost report below 28 27 28 CURRENT DESIGNS 29 Fabrication Department Production Cost Report 31 For the Month Ended April 30, 2017 22 Equivalent Units Physical Materials Conversion Costs Units 34 QUANTITIES 35 Units to be accounted for 36 Work in process, April 1 97 Startar inte rition Problem Statement Part 1 Part 2 Part 1 + $100 16:11 24.03.2021 H Aramak iin buraya yazn 5 A