Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do I do this in excel? For Dotober 2 0 2 1 , TruBent Machining's manufacturing activities generated the records shown in the Data
How do I do this in excel?
For Dotober TruBent Machining's manufacturing activities generated
the records shown in the Data sheet. TruBent 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, SubCategory, 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:
Watch video and use the practice data optional if you already know to work with
Excel Tables and PivotTables
Prepare the Data by adding Unit Costs and Item Costs as explained on the Data tab.
Create an Ercel table using the data in the Data tab.
Use the Excel table to create a PivotTable located in the Pivot tab.
Answer the questions given below.
a Some of the questions pertain to the specific job highlighted in Green below. Note
that this job is keyed to your UINN. Therefore be sure that you have entered
your UIN and Name on the "Name & ID tab.
b Some of the questions pertain to the entirety of the data set and not a particular job.
Among the objectives are to determine the total amount of costs added in Dotober to WIP and
to Job No
The Costs per unit for each type of input by category are given in the table below.
Machine costs are treated as overhead. Direct costs pertain to materials and labor.
There are two types of labor, "skilled" and "normal". Each has a separate
cost per labor hour. There are three types of materials used by TruBent.
once again each material is measured in an appropriate input unit and the
cost per unit is with respect to that input unit.
RequiredPart
Questions to pertain only to Job No
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started