STEP 2c: Accumulating Manufacturing Costs 4 Points Excel Functions: Formulas; Cell Referencing Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not Complete the Job Cost Sheet for Job 10 Job Cost Sheet Job No. Job 10 Quantity Item Cars Date Requested 1/5/2021 For Mr. Smith Date Completed 1/31/2021 Date Direct Materials Direct Labor Manufacturing Overhead 31-Jan Cell Reference 31-Jan Cell Reference Multiply Total Cost of Completed Job Direct Materials Cell Reference Direct Labor Cell Reference Manufacturing Overhead Cell Reference Total Cost Sum Unit Cost (Sum/2) Divide STEPS 3 and 4: Transfer of Completed Goods to Finished Goods Inventory and Recording of the Sale Function: SUM; Cell Referencing Using Excel to Record Job Order Costing Entries Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Use cell references to In January, Stinson Company completes Jobs 10 and 11. On January 31, the company sold Job 10 to the customer for cash. Information concerning the the Problem area. For amounts not given in the data, use a formula, SUM function, or cell Sales price of Job 10 $ 100,000 Journalize the entries for the completion of the two jobs and the sale of Job 10. Completion of jobs Debit Credit Jan. 31 Add Cell Reference Recognition of revenue 31 Cell Reference Cell Reference Recognition of expenses 31 Cell Reference Cell Reference 6 Points