I need help with the red x's please!!

Search Nilsen Mgrl4 - Excel AutoSave Ol Data Review View Formulas Help Home Insert Draw Page Layout 10 GT Ink to Shape Touch Convert Drawing Tools H Exercise Your Co, sells two products (1 & 2), and two departments serve factory workers (materials dept & support dept.). To follow are various production data. Expected Usage Product 1 800 Product 2 200 Activity Purchasing & receiving Materials Storage of materials Moving materials Expected Cost $10,000 $5,000 $7,500 Driver Purchase orders Square feet storage Parts Total 1,000 1,000 300 400 600 100 200 3,000 Machine maintenance Support Cleaning workspace Factory security $15,000 $2,500 $10,000 Machine hours Square feet production Square feet production 1,000 3,000 3,000 2,000 2,000 2,000 5,000 5,000 Assuming Your Co uses the ABC method to assign overhead, calculate the following ABC rates: per PO a) Purchasing & receiving b) Storage of materials c) Moving materials d) Machine maintenance e) Cleaning workspace f) Factory security $10.00 $5.00 $25.00 $5.00 $0.50 $2.00 per sq. ft storage per part per mach.hr per sq. ft production per sq. ft production Calculate the overhead assigned to products 1 & 2 from each cost pool: 8) Purchasing & receiving h) Storage of materials i) Moving materials i) Machine maintenance k) Cleaning workspace 1) Factory security m) Total overhead Product 1 $8,000.00 $2,000.00 $2,500.00 $5,000.00 $1,500.00 $6,000.00 $25,000.00 Product 2 $2,000.00 $3,000.00 $5,000.00 $10,000.00 $1,000.00 $4,000.00 $25,000.00 Assume 1,000 units of product 1 and 500 units of product 2 were produced. 1-3 4-5 6 DO OS EX PR In-class Problem Class tes + ady Type here to search W File Home Insert Draw Page Layout Formulas Data Review View Help abc 0 Translate Delete Spelling Thesaurus Workbook Statistics Check Accessibility Smart Lookup New Comment Previous Next Comment Comme Proofing Accessibility Insights Language Comments C54 G H A E F 34 Assume 1,000 units of product 1 and 500 units of product 2 were produced. 35 36 Product 1 Product 2 37 p) Overhead cost per unit $25.00 $50.00 38 Exercise 5 Your Co sells two products (1 & 2), and two departments serve factory workers (materials 30 dept. & support dept.). To follow are various production data. 40 41 Expected Usage 42 Expected -43 Activity Cost Driver Product 1 Product 2 Purchasing & receiving $10,000 Purchase orders 800 200 45 Materials Storage of materials $5,000 Square feet storage 600 46 Moving materials $7,500 Parts 100 200 Total 400 1,000 1,000 300 8 1,000 Machine maintenance Support Cleaning workspace Factory security $15,000 $2,500 $10,000 Machine hours Square feet production Square feet production 3,000 3,000 2,000 2,000 2,000 3,000 5,000 5,000 2 Determine the departmental overhead rates assuming the Materials Dept assigns overhead based on purchase orders and the Support Dept assigns overhead based on square feet used in production. a) Materials Dept OH Rate b) Support Dept OH Rate Iper PO per sq. ft production Calculate total overhead assigned to products 1 & 2 and overhead per unit assuming you made 1,000 units of product 1 produced and 500 units of product 2. Product 1 Product 2 c) Materials OH assigned d) Support OH assigned e) Total X Product 1 Product 2 1-3 4-5 6 DO QS EX PR In-class Problem Class Notes eady Type here to search i abc Translate Delete Spelling Thesaurus Workbook Statistics Smart Lookup Check Accessibility New Comment Previous Next Show Comment Comment Comments Comments Proofing Accessibility Language Insights 054 F G H 1 A D A 49 E 3,000 3,000 C $2,500 $10,000 Support Cleaning workspace Factory security Square feet production Square feet production 2,000 2,000 5,000 5,000 50 51 Determine the departmental overhead rates assuming the Materials Dept assigns overhead based on purchase orders and the Support Dept assigns overhead based on square feet used in production. 53 54 a) Materials Dept OH Rate b) Support Dept OH Rate Iper PO per sq. ft production 55 56 Calculate total overhead assigned to products 1 & 2 and overhead per unit assuming you made 1,000 units of product 1 produced and 500 units of product 2. 57 58 59 Product 1 Product 2 X x 60 X X 61 c) Materials OH assigned d) Support OH assigned e) Total X 62 63 64 Product 1 Product 2 65 f) Overhead cost per unit %s ssssssa & a d 68m8s 2nZB 66 67 68 69 70 71 72 73 74 75 76 77 78 79