use cell referencing

B D E F G G H 7 7 8 9 Problem 1 Scores Available 20 Scores Received 0 Bengal Corporation is a manufacturer of cricket bats and have gathered the following information about their manufacturing process: Estimated Estimated Share Activity Level for Activity of MOH December 2021 Cutting 45% 5,000 sq. feet of wood Shaping 3,000 DLH Finishing 15% 4,500 MH Delivery 5% 50 clients Total 100% 10 11 35% 12 13 14 15 16 Estimated total MOH for December Estimated total units to be produced in December $95,000 2,500 17 18 19 20 21 22 23 They have received an order of 1,000 units of cricket bats from NSU Cricket Club with the following requirements: Total DM $10,000 Total DL $0 0 (All labor cost is included in MOH) Required total quantity of wood 2,000 sq. feet Required total DLH 1,200 DLH Required total MH 1,800 MH Part 1.1 Scores Available Scores Received Calculate the predetermined overhead rate for job-order costing. For job-order costing they use number of units produced as their allocation base. 24 25 26 27 28 29 30 Part 1.2 Scores Available 3 Scores Received Calculate the cost of fulfulling NSU's order according to job-order costing, 31 32 33 34 35 Part 1.3 Scores Available Scores Received Distribute the total MOH among the four activities using the percentages given. 36 37 38 39 40 41 4 Scores Received Part 1.4 Scores Available Calculate the acitivity rate for each activity. 42 43 44 45 46 47 6 Part 1.5 Scores Available Scores Received Calculate the cost of fulfilling NSU's order according to activity based costing. 48 49 50 + E Sheet1