Please answer practice problem in excel so I can compare coding to my own.
\fJob No. 9999 a Row Labels Sum of (Int E] Labor 66.25 Normal 55 Skill 11.25 E] Machine 89.25 Machine 1 64.5 Machine 2 3 Machine3 21.75 E] Material 150.5 Mat 1 16.5 Mat 2 94.5 Mat 3 39.5 Grand Total 306 For the month of May, Tru Bent Machining's manufacturing activities generated the records shown in the Data sheet. TruBent worked on ten Jobs that month and each data record pertains to the inputs into each job. The records are in chronological order and each record hasthe fields for : Record No., Job No., Category, Sub-Category, and Quantity (measured in appropriate input units). For example, labor and machine quantities are measured in hours. A pivot table has been created using the data from the Data sheet. In orderto answer the required questionsyou need to format the pivottable and manipulate the results from the pivot table. The objective is to determine the total amount of costs added in May to Job No. 6510 Cost per unit of input for each su b-category are given in the table. Note that these are direct costs only. Machine costs are treated as overhead. There are two types of labor "skill" and "normal". Each has a separate cost per labor hour. There are three types of materials used byTru Bent, once again each material is measured in an appropriate input unit and the cost per unit is w.r.t. that input unit. Sub CategonCost per unit Machine 1 Machine 2 Machine 3 Mat 1 $ 5.25 Mat 2 $ 6.50 Mat 3 $ 13.20 Normal $ 25.00 Skill $ 35.00 Required: Determine the costs added to the job referenced above in May Total Direct Material Costs equal Total Direct Labor Costs equal Tru Bent applies overhead usingtwo pre-determined overhead rates - $40 per direct labor hour and $60 per machine hour. Total overhead applied based on labor hours. Total overhead applied based on machine hours. Total manufacturing costs in May forJob No. 6510 Now return to the pivot table and reset the Job filter to include all jobs Answer the following questions: Total Labor hours for May Total Machine hours for May Total usage of Mat 1 in May Total usage of Mat 2 in May Total usage of Mat 3 in May It has been determined that there was a cut-off error at the end of May and that records 15580 to 15600 represent actionsthat occurred in June. Go to the Data sheet and define an IF function in the Condition column that takes the value 0 for May actions and the value 1 forJune actions. Now in the Data sheet click on the PivotTable to bring up the builder window. In the ribbon click on the PivotTable Analyze tab and then find the REFRESH icon and click on itto update the data used by the pivot table. Make sure the Condition field is added to the list of filters and restrictthe data to the May actions. Revise your answers to these questions Total Labor hours for May Total Machine hours for May Total usage of Mat 1 in May Total usage of Mat 2 in May Total usage of Mat 3 in May
