For October 2021, Truent Machining's manufacturing activities generated the records shown in the Data sheet. Truent...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For October 2021, Trußent Machining's manufacturing activities generated the records shown in the Data sheet. Trußent worked on numerous Jobs that month and each data record pertains to the inputs for each job. The records are in chronological order and each record has fields for Year, Month, Day, Job No., Type, Sub-Category, and Quantity (measured in appropriate input units - for example, labor and machine quantities are measured in hours.) In order to complete the assignment you will need to do the following activities: 1. Watch video and use the practice data (optional if you already know to work with Excel Tables and PivotTables). 2. Prepare the Data by adding Unit Costs and item Costs as explained on the Data tab. 3. Create an Excel table using the data in the Data tab. 4. Use the Excel table to create a PivotTable located in the Pivot 2 tab. -S. Answer the questions given below. a. Some of the questions pertain to the specific Job high-lighted in Green below. Note that this job is keyed to your UIN. Therefore be sure that you have entered your UIN and Name on the "Name & ID" tab. Ob. Some of the questions pertain to the entirety of the data set and not a particular job. 2 Among the objectives are to determine the total amount of costs added in October to WIP and 3 to Job No. 4 5 The Costs per unit for each type of input by category are given in the table below. 6 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 7 There are two types of labor, "skilled" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by Trußent, 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. 31 32 6501 Type 33 OH Category Cost per unit Machine T1 35.00 34 Machine T2 42.00 35 Machine T3 45.00 5.25 36 Materials Mat X1 37 Mat X2 7.50 38 Mat X3 13.20 39 Labor Normal 29.00 40 Skilled %24 41.00 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! 6501 Determine the total Direct Material costs added (to WIP) in October Q1 7Determine the total Direct Labor costs added in October Q2 9 Determine the total Machine 1 related OH costs added in October Q3 1 Determine the total Machine 2 related OH costs added in October Q4 3 Determine the total Machine 3 related OH costs added in October 4 55 Determine the total manufacturing costs added in October 56 Required - Part 2 57 Questions 7 to 12 pertain to all work done in October (i.e., include all jobs) 58 Determine the total Direct Material costs added in October 59 60 Determine the total Direct Labor costs added in October 61 62 Determine the total Machine 1 related OH costs added in October Q5 Q6 Q7 Q8 Q9 63 64 Determine the total Machine 2 related OH costs added in October Q10 65 66 Determine the total Machine 3 related OH costs added in October Q11 67 68 Determine the total manufacturing costs added in October 69 Required - Part 3 70 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) 71 Determine the total Direct Material costs added Q12 Q13 72 73 Determine the total Direct Labor costs added Q14 74 75 Determine the total Machine 1 related OH costs added Q15 76 77 Determine the total Machine 2 related OH costs added Q16 78 79 Determine the total Machine 3 related OH costs added Q17 80 81 Determine the total manufacturing costs added 82 Reguired Part 4 Q18 Required- Part 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 140,500 Answer the following two questions regarding the closing of the mfg. overhead 5 accounts for the month. You should create PivotTables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of B overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over O(use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? 3 Use a positive number to indicate that the adjustment is a debit to WIP - Job 6500 4 and a negative number to indicate the adjustment is a credit to WIP - Job 6500 2 Q20 For October 2021, Trußent Machining's manufacturing activities generated the records shown in the Data sheet. Trußent worked on numerous Jobs that month and each data record pertains to the inputs for each job. The records are in chronological order and each record has fields for Year, Month, Day, Job No., Type, Sub-Category, and Quantity (measured in appropriate input units - for example, labor and machine quantities are measured in hours.) In order to complete the assignment you will need to do the following activities: 1. Watch video and use the practice data (optional if you already know to work with Excel Tables and PivotTables). 2. Prepare the Data by adding Unit Costs and item Costs as explained on the Data tab. 3. Create an Excel table using the data in the Data tab. 4. Use the Excel table to create a PivotTable located in the Pivot 2 tab. -S. Answer the questions given below. a. Some of the questions pertain to the specific Job high-lighted in Green below. Note that this job is keyed to your UIN. Therefore be sure that you have entered your UIN and Name on the "Name & ID" tab. Ob. Some of the questions pertain to the entirety of the data set and not a particular job. 2 Among the objectives are to determine the total amount of costs added in October to WIP and 3 to Job No. 4 5 The Costs per unit for each type of input by category are given in the table below. 6 Machine costs are treated as overhead. Direct costs pertain to materials and labor. 7 There are two types of labor, "skilled" and "normal". Each has a separate 28 cost per labor hour. There are three types of materials used by Trußent, 29 once again each material is measured in an appropriate input unit and the 30 cost per unit is with respect to that input unit. 31 32 6501 Type 33 OH Category Cost per unit Machine T1 35.00 34 Machine T2 42.00 35 Machine T3 45.00 5.25 36 Materials Mat X1 37 Mat X2 7.50 38 Mat X3 13.20 39 Labor Normal 29.00 40 Skilled %24 41.00 Required - Part 1 Questions 1 to 6 pertain only to Job No. ===> Enter your answers in the appropriate Yellow shaded cell!!! 6501 Determine the total Direct Material costs added (to WIP) in October Q1 7Determine the total Direct Labor costs added in October Q2 9 Determine the total Machine 1 related OH costs added in October Q3 1 Determine the total Machine 2 related OH costs added in October Q4 3 Determine the total Machine 3 related OH costs added in October 4 55 Determine the total manufacturing costs added in October 56 Required - Part 2 57 Questions 7 to 12 pertain to all work done in October (i.e., include all jobs) 58 Determine the total Direct Material costs added in October 59 60 Determine the total Direct Labor costs added in October 61 62 Determine the total Machine 1 related OH costs added in October Q5 Q6 Q7 Q8 Q9 63 64 Determine the total Machine 2 related OH costs added in October Q10 65 66 Determine the total Machine 3 related OH costs added in October Q11 67 68 Determine the total manufacturing costs added in October 69 Required - Part 3 70 Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive) 71 Determine the total Direct Material costs added Q12 Q13 72 73 Determine the total Direct Labor costs added Q14 74 75 Determine the total Machine 1 related OH costs added Q15 76 77 Determine the total Machine 2 related OH costs added Q16 78 79 Determine the total Machine 3 related OH costs added Q17 80 81 Determine the total manufacturing costs added 82 Reguired Part 4 Q18 Required- Part 4 Questions 19 to 20 Assume the actual overhead for the October is: $ 140,500 Answer the following two questions regarding the closing of the mfg. overhead 5 accounts for the month. You should create PivotTables that show the overhead applied for the month, the amount of overhead applied by job, and the amount of B overhead applied to each job as a percentage of the total OH applied. What is the total amount of overhead under (use a positive number) or over O(use a negative number) applied during the month? Q19 What is the total amount of adjustment required to be made to Job 6500? 3 Use a positive number to indicate that the adjustment is a debit to WIP - Job 6500 4 and a negative number to indicate the adjustment is a credit to WIP - Job 6500 2 Q20
Expert Answer:
Answer rating: 100% (QA)
As Job 40 and Job 41 is completed hence only Job 42 is ... View the full answer
Related Book For
Business Statistics For Contemporary Decision Making
ISBN: 978-1118749647
8th edition
Authors: Black Ken
Posted Date:
Students also viewed these mathematics questions
-
For this assignment, you will need to copy the excel file provided in Project Assignment 1 into your UMSystem Office365 OneDrive. You should have been prompted to do so when you clicked on the link...
-
You will need to do some research via the Internet and/or via articles and papers. Investigate the objectives for 3 organizations, covering one private-sector organization, one in the public sector...
-
1 watch the video lucidchart for next assignment 2 create an er diagram for last's week practice exercise (see below) 3 save the er diagram as a png file and upload the file as your assignment
-
Some observers maintain that not all politicians move toward the middle of the political spectrum in order to obtain votes. They often cite Barry Goldwater in the 1964 presidential election and...
-
Exit polling is a popular technique used to determine the outcome of an election prior to results being tallied. Suppose a referendum to increase funding for education is on the ballot in a large...
-
Is CRM primarily focused on upstream or downstream activities in the supply chain?
-
Refer to Example 16.11. Let \(F(t)\) be the forward rate from 0 to \(t\). By the basic definition of the forward rate, we have the identity \[e^{-F(t) t}=P(r, 0, t)\] Find an explicit formula for...
-
1. If you were representing the Company in this case, what argument (facts and reasons) could you make that the confidentiality agreement had a legitimate business purpose and was applied...
-
The following table shows a data set and the number of times each point is misclassified during a run of the perceptron algorithm (with offset 00). 0 and 60 are initialized to zero. ix (i) y() times...
-
Assume the periodic message signal m(t), shown below, is applied to a phase modulator with a phase sensitivity of kp-2n rad/Volt. Assume a carrier frequency of fe=1 Hz. a) Sketch the phase of the...
-
A product developer is investigating the tensile strength of a new synthetic fiber that will be used to make cloth for mens shirts. Strength is usually affected by the percentage of cotton used in...
-
Which of the following statements about finally blocks are true? (Choose two.) A. Every line of the finally block is guaranteed to be executed. B. The finally block is executed only if the related...
-
What does the following output? A. [a, lamb, had, Mary, little] B. [a] C. [a, a] D. The code does not compile. E. The code throws an exception at runtime. 18: List list List.of( 19: "Mary", "had",...
-
Which exception classes, when inserted into the blank in the Problems class, allow the code to compile? A. Exception B. RuntimeException C. MissingFoodException D. MissingMoneyException,...
-
How many lines of text does the following program print? A. One. B. Two. C. Three. D. The code does not compile. E. None of the above. package bee; class SpellingException extends RuntimeException {}...
-
What is the output of the following application? A. 145 B. 1345 C. 1235 D. The code does not compile. E. The code compiles but throws an exception at runtime. F. None of the above. package game;...
-
Discuss the skills important to a manager when dissolving conflict among his/her team? Have you worked in an environment where a manager was lacking any of these skills? What was the effect on the...
-
What mass of KBr (in grams) should you use to make 350.0 mL of a 1.30 M KBr solution?
-
A community health association is interested in estimating the average number of maternity days women stay in the local hospital. A random sample is taken of 36 women who had babies in the hospital...
-
Use the data in Problem 8.53 to construct a 99% confidence interval to estimate the population variance for the number of diapers used during a 24-hour period for one-month-olds. How could...
-
Use the data in Problem 15.17 to compute a regression model after recoding the data by the first-differences approach. Compute a Durbin-Watson statistic to determine whether significant...
-
How can we effectively analyze a firm's financial ratios?
-
In 2019, Italia Mining Corporation had sales of \($69\) million, total assets of \($45\) million, and total liabilities of \($23\) million. The interest rate on the debt is 6.5 percent, and its tax...
-
Tsingtao Companys balance sheet shows a stockholders equity book value (total common equity) of \($800,500.\) The firms earnings per share were \($3.50,\) resulting in a price/earnings ratio of...
Study smarter with the SolutionInn App