Need help on part 3 of the question. Part 1 and 2 will help you answer

o Verizon LTE Spreadsheets Undo Project1(3) Sheet1 Sheet2 Sheet3 30 points Accounting 202: Summer 2017 PROJECT 1-Job Costing ter the last 4 digits of your student ID number the digits corresponding to each letter to fill in the missing numbers Save this file in EXCEL FORMAT as: PILestnome Round all answers to 2 decima paces. Do not change rows or colums on this spreadsheet. Input areas are in yelflow lou are the owner of a small manufacturing fiem that makes custom, appliqued flags. You operate out of a rented building and currently employ 8 production workers: 2 that measure and mark the fabric, 2 that out the fabric, and four sewing machine operators. I. Manufacturing Overhead: the beginning of the year it was estimated that manufacturing overhead would cosist of the following: The production supervsor earns $4,800 per month. Rent on the manufacturing building is $1,000 per month. Utilicies per monthc Fabric markers cost $3.20 and last 20 hours. Depreciation on cutting and sewing machinery per year: Each flag uses $ .80 of thread. You estimate that 10,000 flags will be preduced in the coming year and your 8 production workers will each work 2,00o hours each during the coming year 1. Caloulate total estimated manufacturing overhead for the year Total Annual Overhead Costs Production superviser salary 9,610.80 2. Calcudate the predetermined overhead rate per direct labor hour for the year. Show your work in the space provided 9610,80 Part ll. Job Cost Sheet You have received an order for 60 flags from the local branch of DBA America, a support organization for small business owners. The flags will be given to each new member to proudly drisplay in their businesses REQUIRED: FIl n the missing information below and complete the job cost sheet below for the DBA America order Job Cost Sheet 578 Direct Materials Yards Cost per Yard o Verizon LTE Spreadsheets Undo Project1(3) Sheet1 Sheet2 Sheet3 30 points Accounting 202: Summer 2017 PROJECT 1-Job Costing ter the last 4 digits of your student ID number the digits corresponding to each letter to fill in the missing numbers Save this file in EXCEL FORMAT as: PILestnome Round all answers to 2 decima paces. Do not change rows or colums on this spreadsheet. Input areas are in yelflow lou are the owner of a small manufacturing fiem that makes custom, appliqued flags. You operate out of a rented building and currently employ 8 production workers: 2 that measure and mark the fabric, 2 that out the fabric, and four sewing machine operators. I. Manufacturing Overhead: the beginning of the year it was estimated that manufacturing overhead would cosist of the following: The production supervsor earns $4,800 per month. Rent on the manufacturing building is $1,000 per month. Utilicies per monthc Fabric markers cost $3.20 and last 20 hours. Depreciation on cutting and sewing machinery per year: Each flag uses $ .80 of thread. You estimate that 10,000 flags will be preduced in the coming year and your 8 production workers will each work 2,00o hours each during the coming year 1. Caloulate total estimated manufacturing overhead for the year Total Annual Overhead Costs Production superviser salary 9,610.80 2. Calcudate the predetermined overhead rate per direct labor hour for the year. Show your work in the space provided 9610,80 Part ll. Job Cost Sheet You have received an order for 60 flags from the local branch of DBA America, a support organization for small business owners. The flags will be given to each new member to proudly drisplay in their businesses REQUIRED: FIl n the missing information below and complete the job cost sheet below for the DBA America order Job Cost Sheet 578 Direct Materials Yards Cost per Yard