AutoSave O ABC Project - Protected View Search File Home Insert Draw Page Layout Formulas Data Review Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. View Enable Editing B16 f 40000 G H J A B E F 1 Quality Upholstery Company estimated the following costs and activities for its two products, stools and pads for 2018: 2 3 Cost Activity 4 Direct Materials $ 135,000 9,000 yards at $15 per yard 5 Direct Labor $ 102,000 5100 hours @ $20 per hour 6 Machine Setup $ 60,500 320 setup hours 7 Materials Handling $ 88.200 4200 loads of material moved 8 Electric Power $ 40,000 20000 kilowatt hours 9 10 Quality Upholstery applies overhead based on direct labor hours 11 The following information pertains to the actual production of stolls and pads: 12 13 Stools Pads 14 Units produced 5,000 20,000 15 Direct Materials $ 75,000 $ 61,200 16 Direct Labor $ 40,000 $ 60,000 17 Machine Setup $ 30.240 $ 26,460 18 Materials Handling $ 20,500 $ 61,500 19 Electric Power $ 35,000 $ 4,140 20 Actual Direct Labor Hours 2,000 3,000 21 Setup Hours 160 140 22 Loads of Materials Moved 1.000 3,000 23 Kilowatt hours consumed 17.000 2.000 24 25 Need to answer items A. through I. 26 27 A. What would be the POHR using direct labor hours 26 29 30 31 32 B.What would be the total cost of one stool using POHR? 33 34 35 36 37 38 39 C. What would be the total cost of one pad using POHR? 40 Sheet1 Type here to search 0 C Autore ABC Project - Protected View File Home Insert Draw Page Layout Formulas Data Review View Help PROTECTED VIEW Be careful--les from the Internet can contain uses Unless you need to edit it's safer to stay in Protected View B16 f 40000 Enabledning D E F G H B 46 47 D. What is the Consumption Rate per activity driver for ABC? 48 49 50 51 53 54 55 E. Will pay to use ABC? Why or why not? 56 57 59 60 F What would be the activity rates using ABC? 61 62 63 64 65 66 67 G. What would be the total cost of one stool using ABC? 62 69 70 71 72 73 74 75 76 TT 78 79 80 81 82 H. What would be the total cost of one pad using ABC? 83 84 05 Sheet H Type here to search o c DI F& FS F Home @ % $ 4 & 7 3 5 3 0 .1 32 H. What would be the total cost of one pad using ABC? 83 84 85 86 87 88 89 90 91 92 93 94 95 L. What kind of problem could using ABC solve for this company? Sheet1 Task View Type here to search o o C Esc 10) F2 DI FS F6 # 2 3 3 % 5 4 6 e W E R T