Please try and answer the whole thing. Thanks in advance

7 4 7 A B D 6 Enter the last 4 non-zero digits of your student ID number: 2 7 Use the matched letters and numbers to fill in the missing numbers below. 8 9 Save this file in EXCEL FORMAT as: P1Lastname 10 Using Excel functions is part of the grade for this project. 11 Round all answers to 2 decimal places. 12 Do not change rows or colums on this spreadsheet. Input areas are in yellow. 13 14 You are the owner of a small manufacturing firm that makes custom, appliqued flags. You operate 15 out of a rented building and currently employ 8 production workers: 2 that measure and mark the fabric, 2 that 16 cut the fabric, and four sewing machine operators. 17 18 Part I. Manufacturing Overhead: 19 At the beginning of the year it was estimated that manufacturing overhead would consist of the following: 20 21 The production supervisor earns $4,200 per month. 22 Rent on the manufacturing building is $1,400 per month. 23 Utilities per month: $ 71 4 7 25 Fabric markers cost $2.80 and last 20 hours. (Only one employee at a time marks the fabric.) 26 Depreciation on cutting and sewing machinery per year: $ 2 B 28 Each flag uses $.80 of thread. 29 30 You estimate that 12,000 flags will be produced in the coming year and your 8 production workers will each work 2,000 31 hours each during the coming year. You have selected direct labor hours as your MOH allocation base. 32 33 1. Calculate total estimated manufacturing overhead for the year: Manufacturing Total Annual Overhead Costs Estimate Production supervisor salary Rent Utilities Fabric markers Depreciation Thread Total 24 D 7 41 7 27 D 34 35 36 37 38 39 40 41 42 43 44 2. Calculate the predetermined overhead rate per direct labor hour for the year. Show your work in the space provided. 45 46 47 POHR