Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could you please explain the formulas to used on the spread sheet? Scoring STEP 1 STEP 2a STEP 2b STEP 2c STEPS 3 and 4

image text in transcribed

Could you please explain the formulas to used on the spread sheet?

Scoring STEP 1 STEP 2a STEP 2b STEP 2c STEPS 3 and 4 Total Points $ 9 Points ACC-212, Project #2 - Job Order Costing Stinson received two orders (Jobs 10 and 11) to create 2 cars for each job. Manufacturing Costs Raw Materials Purchased 55,000 Factory Labor Costs Wages Payable 50,000 Payroll Taxes Payable (in February) 40,000 Manufacturing Overhead Utilities 10,000 Property Taxes Payable 5,800 Work-In-Process Transfer Job 10 Job 11 Direct Materials $ 25,000 $ 20,000 Indirect Materials 5,000 5,000 Direct Labor 40,000 35,000 Indirect Labor 10,000 5,000 STEP 1: Accumulating Manufacturing Costs Excel Functions: SUM; Cell Referencing Below are transactions related to the manufacturing costs for the two jobs. Journalize the entries for each type of Manufacturing Cost. In the Debit and Credit fields link to the values above and use formulas as necessary 1. On January 4, Stinson purchased $55,000 in raw materials on account. 2. On January 31, Stinson incurs $90,000 of factory labor costs. $50,000 relates to wages payable and $40,000 relates to payroll taxes payable in February 3. On January 31, Stinson estimates having $15,800 in manufacturing overhead, of which $10,000 is utities and $5,800 is for property taxes payable 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 Purchase Raw Materials Jan. 4 Cell Reference Cell Reference Factory Labor Jan. 31 Sum or Add Cell Reference Cell Reference Manufacturing Overhead Jan. 31 Sum or Add Cell Reference Cell Reference Total Debits and Credits Sum Sum Scoring STEP 1 STEP 2a STEP 2b STEP 2c STEPS 3 and 4 Total Points $ 9 Points ACC-212, Project #2 - Job Order Costing Stinson received two orders (Jobs 10 and 11) to create 2 cars for each job. Manufacturing Costs Raw Materials Purchased 55,000 Factory Labor Costs Wages Payable 50,000 Payroll Taxes Payable (in February) 40,000 Manufacturing Overhead Utilities 10,000 Property Taxes Payable 5,800 Work-In-Process Transfer Job 10 Job 11 Direct Materials $ 25,000 $ 20,000 Indirect Materials 5,000 5,000 Direct Labor 40,000 35,000 Indirect Labor 10,000 5,000 STEP 1: Accumulating Manufacturing Costs Excel Functions: SUM; Cell Referencing Below are transactions related to the manufacturing costs for the two jobs. Journalize the entries for each type of Manufacturing Cost. In the Debit and Credit fields link to the values above and use formulas as necessary 1. On January 4, Stinson purchased $55,000 in raw materials on account. 2. On January 31, Stinson incurs $90,000 of factory labor costs. $50,000 relates to wages payable and $40,000 relates to payroll taxes payable in February 3. On January 31, Stinson estimates having $15,800 in manufacturing overhead, of which $10,000 is utities and $5,800 is for property taxes payable 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 Purchase Raw Materials Jan. 4 Cell Reference Cell Reference Factory Labor Jan. 31 Sum or Add Cell Reference Cell Reference Manufacturing Overhead Jan. 31 Sum or Add Cell Reference Cell Reference Total Debits and Credits Sum Sum

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Ch 1-14

Authors: John Wild, Vernon Richardson, Ken Shaw

1st Edition

0073346896, 9780073346892

More Books

Students also viewed these Accounting questions