Chaplu 2 Aik Bad Catchu X Veri Gzden Ger Grdm Yard Resim Biimi Onomat Kaydet 2 Doga Giri Ecle Sayta Dzeni Formuler X ka LO Kopyals - Yapiste KTA 3 om Boyac Pano Yaz Tip 2. Meri Kaya Normal ly Kotu Anima Metre Payla Aldamalar 5 Chomskloplom oldu Sraila ve Hibe ve Dark Temik- lygu Sec - Omenler Duyarlak 27 O Ekle SI Biom Kogutu Tablowa Notr Biimindirme Biimlendir Ila 51 Cher creler J L M N 0 R S T U V w X Picture 7 A B D E F G H 1 1 1 2 Make Decisions at Current Designs 3 4 Topic: Job Order Costing 5 Excel Functions and Tools: Using Mathematical Formulas 6 7 Huegel Hollow Resort has ordered 20 rotomolded kayaks from Current Designs. Each 8 kayak will be formed in the rotomolded oven, cooled, and then the excess plastic 9 trimmed away. Then, the hatches, seat, ropes, and bungees will be attached to the 10 kayak. 11 Dave Thill, the kayak plant manager, knows that manufacturing each kayak 12 requires 54 pounds of polyethylene powder and a finishing kit (rope, seat, hardware, 13 etc.). The polyethylene powder used in these kayaks costs $1.50 per pound, and the 11 finishing kits cost $170 each. Each kayak will use two kinds of labor. 2 hours of more- 15 skilled type I labor from people who run the oven and trim the plastic, and 3 hours of 16 1888-skilled type Il labor from people who attach the hatches and seat and other hardware. The type I employees are paid $15 per hour, and the type II employees are 17 paid $12 per hour. For purposes of this problem, assume that overhead is allocated to 18 all jobs at a rate of 150% of direct labor costs. 19 20' Required 21 Use sheet tab "Work Area'. 22 1. Determine the total cost of the Huegel Hollow order and the cost of each individual 23 kayak in the order 21 WHATHF? 25 2. Perform whal-il analysis lo answer the following independent questions. 26 2. What is the total cost i Huegel Hollow orders 25 kayaks? 27 Suppose Current Designs is able to purchase a higher quality type of polyethylene 29 powder al a cost of $165 por pound, which will cnable to the company to reduce 29 the number of hours of type I labor to 1 hour. What will be the new cost of each kayak? 31 32 Otomatik Kayet 2 Chapter 2 Assignment (2) - Caner door 2 Sayfa Dzeni Formuler Veri Guaden Geir Gornum Yardim Liburan Sara ' == ParaBirmio TRY Dosya Giris Ede X kes Kopyala 3 Bm Bayesi Para 25 Mutri Kaydet 's Birtive Orale Paylas Aldamalar Otomatik Toplam Uldur Srais velite Buive Duyari Uygula - S- Delen Bnik Ayrac Parainmi Kogulu Table Oral Virgul Yuzda Biimde Bilde Ekle SI K TA- A- %99 Biom = = = Ya Tip Himalara Hurple F25 H 1 J L M N O P Q R S T G Part 1 AB D E F 1 Make Decisions at Current Designs 2 3 Data 4 Number of kayaks ordered 20 5 6 Resources required for each kayak 7 Polyethylene powder 54 pounds 8 Finishing kit 1 each 9 Type I labor 2 hours 10 Type Il labor 3 hours 11 Manufacturing overhead 150% of direct labor cost 12 Costs 13 Polyethylene powder $ 1,50 per pound 14 Finishing kits 170,00 each 15 Type I labor rate 15,00 per hour 16 Type Il labor rate 12.00 per hour 17 18 Required 19 Follow the instructions to enter a formula into each cell shaded in yellow below. 20 21 Cost for one kayak: 22 Direct materials 23 Polyethylene powder 24 Finishing kit 25 26 Direct labor 27 Type 1 28 Type II 29 30 Manufacturing overhead 32 Total cost for one kayak 33 Cost for kayak order Problem Statement 12.a 2b + Aramak iin buraya yazin 10 TUR 2033 15.08.2011 F ca X Onomat Kaydet 2 Doga Giris Ecle Sayta Dzen Chapter 2 Assignment (2) Gzden Ger Gorrum Yardm Formular Veri DO 11AA === Matrika GA X ka LO Kopyals - Yapiste 3 cm Bacsi Pano DZ Normal Kosulu Tablo Nutr Biimlendim. Bilendir lyi Kotu Apbloma Mc... Bal Hucre Payla Aldamalar schemahk lopiem Doldu Srala ve Filtre Bulve Dark Temik- Lygula Sogn Denlene Durink SI KTA % Erle 49 Birlehir ve Orale Biom Yazip Ibraima Chler 59 H14 F F H J L L M N P P R S T v W X Part 2 A D D E 1 Make Decisions at Current Designs 2 3 Data 4 4 Number of kayaks ardered 20 5 6 Resources required for each kayak Polyethylene powder 54 pounds B Finishing lot 1 each g Type labor 1 hour 10 Type I labor 3 hours 11 Manufacturing overhead 150% of direct labor cost 12 Corts 13 Polycthylenc powder $ 1,05 per pound 14 Finishing lots | 1 0 0 3;h. 15 Type labor rate 15,00 per hour 16 Tvel labor rate 12,00 per hour 17 18 Required 19 Folow the instructions to enter a formula into each cell shaded in yellow below 20 21 Cost for one kayak 22 Direct materials 23 Polyethylene powder 24 Finishing lot 25 28 Direct labor 27 Type 28 Type 1 29 30 Manufacturing cvethed 32 Totalcar for une kayak 33 34 Cost for kayak order 35 38 37 38 Otomatik kelet Chapter 2 Assignment (2) Caner door 2 Dosya Giris Ede Sayfa Dzeni Formuler Veri Gozden Geir Gornum Yardm Paylas Aldamalar X kas 11AA Gure TEY 27 0 == E2 25 Mutri Kaydet 's Birtive Orale ly Kutu Agaklum Me Bill Hure Yapter Normal Kogulu This Ok Nolt Biimindi Bisikendi a Ekle SI KTA A- 3 mlcsi -% -% Biom Chematik Toplam Uldur Srive litte Ouve Tume Uygula - S- Denne Para HT Shiller Hurt Duyar H14 D E F H 1 J J L L M N R S T V w X. A E 1 1 Make Decisions at Current Designs G Part 2 3 Data 4 Number of kayaks ordered 20 5 6 Resources required for each kaynak 7 Polyethylenc powder 54 pourds 8 8 Finishing lot 1 each Type llobor 1 hour 10 Type I labor 3 hours 11 Manufacturing overlies 150% of direct labor cost 12 Custs 12 Polyethylene powder $ 1,85 per pound 14 Finishing its 170, cach 15 Type laborato 15,00 per hour 16 Type I labor rate 12,00 per hour 17 18 Required 19 Folow the instructions to enter a formula into each cell shaded in yellow below 20 21 Cost for one kayak 22 Direct materials 22 Polyethylene powder 24 Finishing it 25 28 Direct labor 27 Type 28 Type 29 30 Manufacturing overhead JI 32 Total cost for one kayak 32 34 Cost for kayak order 35 38 37 38 39 40 Problem Statement 1 2. 2.b. + Aramak iin buraya yazin CS 10 TUR 20:54 15.08.2011