ACC-212, Project 12 - Job Order Costing Stinson received twoters 10 and 11) to create cars for each DO STEP 1 STEP STEP STEP STEPS and Manufacturing Costs Raw Materials Purchased Factory Labor Costs $ 55.000 Wars Payable Payroll Taxes Payable in February 50.000 Manufacturing Overhead 40.000 Us 10,000 Property Taxes Payable 5.100 Work in Process Transfer Job 10 Direct Materials Job 11 25,000 $ 20.000 Indirect Materials 5.000 5.000 Direct Labor 40,000 35.000 Indirect Labor 10,000 5.000 STEP 1 Accumuding Manufacturing Costs Excel Function: SUM: Cell Referencing Below are transactions related to the manufacturing costs for the two obis Soumaise the entries for each type of Manufacturing Cont in the Debit and Credit ales in to the values above and se formance 1. On January 4. Stinson purchased $55.000 in raw materials on account 2. On January 11, non incurs $90.000 a factory abor costs 550.000 elites to wages payable and 540.000 wates to carrota payable in February 3. On January 31. Stinson estimates having 51.100 in manufacturing overhead, of which 510.000 notes and 500 ferroperty taxes Date Student Work Area Required Provide input into colated in yellow in this template Use cell references to the Presemans. For Debat Description Date Purchase Raw Mwen Corner Cele Factory Labor Jan 11 Sumart Dance Cerce Jan Sumo Manufacturing Overhead Gerne STEP 2a: Calculate the Pre-Determined Overhead Rate Total Debits and Credits Sum Sum Excel Functions: Formula Calculate the Predetermined Overhead Rate for Stinson using the information below Stinson uses direct labor costs to calculate the Predetermined Overhead Rate Estimated Annual Overhead Costs Expected Direct Labor Cost: 25,000 Student Work Area 100,000 Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not Predetermined Overhead Rate: Divide STEP 2: Accumulating Manufacturing Costs Excel Functions: Formulas; Cell Referencing Below are transactions related to the manufacturing costs for the twojobs Journalize the entries for each type of Manufacturing Cont. In the Debit and Credit fields link to the values above and une formulas as necesary 1. Stinson uses $45,000 of direct materials and $10,000 of indirect materials on January 31, 2. Per the time tickets for the jobs, $75,000 is related to direct labor and $15,000 to indirect labor 3. Using the Predetermined Overhead Rate calculated in Part 2a prepare the entry for applying Manufacturing Overhead to Work in Proces Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not Description Date Debit Credit Assien Raw Materials to WIP Jan. 31 Add Add Sum Assign Factory Labor to WIP lan 31 Add add Add add Sum Multiply Apply Manufacturing Overhead to WIP Call Reference Total Debits and Credits Sum Sum STEP 2C Accumulating Manufacturing Costs Excel Functions: Formulas Cell Referencing Student Work Area Required: Provide input into cells shaded in vellow in this template. Use chil references to the Problem area. For amountant Complete the Job Cot Sheet for job 10 Ion, 31 ACC-212, Project 12 - Job Order Costing Stinson received twoters 10 and 11) to create cars for each DO STEP 1 STEP STEP STEP STEPS and Manufacturing Costs Raw Materials Purchased Factory Labor Costs $ 55.000 Wars Payable Payroll Taxes Payable in February 50.000 Manufacturing Overhead 40.000 Us 10,000 Property Taxes Payable 5.100 Work in Process Transfer Job 10 Direct Materials Job 11 25,000 $ 20.000 Indirect Materials 5.000 5.000 Direct Labor 40,000 35.000 Indirect Labor 10,000 5.000 STEP 1 Accumuding Manufacturing Costs Excel Function: SUM: Cell Referencing Below are transactions related to the manufacturing costs for the two obis Soumaise the entries for each type of Manufacturing Cont in the Debit and Credit ales in to the values above and se formance 1. On January 4. Stinson purchased $55.000 in raw materials on account 2. On January 11, non incurs $90.000 a factory abor costs 550.000 elites to wages payable and 540.000 wates to carrota payable in February 3. On January 31. Stinson estimates having 51.100 in manufacturing overhead, of which 510.000 notes and 500 ferroperty taxes Date Student Work Area Required Provide input into colated in yellow in this template Use cell references to the Presemans. For Debat Description Date Purchase Raw Mwen Corner Cele Factory Labor Jan 11 Sumart Dance Cerce Jan Sumo Manufacturing Overhead Gerne STEP 2a: Calculate the Pre-Determined Overhead Rate Total Debits and Credits Sum Sum Excel Functions: Formula Calculate the Predetermined Overhead Rate for Stinson using the information below Stinson uses direct labor costs to calculate the Predetermined Overhead Rate Estimated Annual Overhead Costs Expected Direct Labor Cost: 25,000 Student Work Area 100,000 Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not Predetermined Overhead Rate: Divide STEP 2: Accumulating Manufacturing Costs Excel Functions: Formulas; Cell Referencing Below are transactions related to the manufacturing costs for the twojobs Journalize the entries for each type of Manufacturing Cont. In the Debit and Credit fields link to the values above and une formulas as necesary 1. Stinson uses $45,000 of direct materials and $10,000 of indirect materials on January 31, 2. Per the time tickets for the jobs, $75,000 is related to direct labor and $15,000 to indirect labor 3. Using the Predetermined Overhead Rate calculated in Part 2a prepare the entry for applying Manufacturing Overhead to Work in Proces Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not Description Date Debit Credit Assien Raw Materials to WIP Jan. 31 Add Add Sum Assign Factory Labor to WIP lan 31 Add add Add add Sum Multiply Apply Manufacturing Overhead to WIP Call Reference Total Debits and Credits Sum Sum STEP 2C Accumulating Manufacturing Costs Excel Functions: Formulas Cell Referencing Student Work Area Required: Provide input into cells shaded in vellow in this template. Use chil references to the Problem area. For amountant Complete the Job Cot Sheet for job 10 Ion, 31