A B C D E F G H | J K L M N 0 P 1 Function: SUM; Cell Referencing 2 3 Using Excel to Record Job Order Costing Entries 4 PROBLEM In March, Stinson Company completes Jobs 10 and 11. On March 31, the 6 company sold Job 10 to the customer for cash. Information concerning the 7 company's jobs during the month of March follows. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use cell references to the Problem area. For amounts not given in the data, use the SUM function with cell references to the Problem data. 8 9 Journalize the entries for the completion of the two jobs and the sale of Job 10. 10 Cost of Job 10 20,000 11 Cost of Job 11 30,000 12 Sales price of Job 10 35,000 Completion of jobs Debit Credit 13 Mar. 31 14 15 16 17 Recognition of revenue 31 18 19 20 Recognition of expenses 21 31 22 23 24 25 26 27 28 29