15 A B D E F G Function: SUM; Cell Referencing 2 4 Using Excel to Record Job Order Costing Entries PROBLEM 5 In March, Stinson Company completes Jobs 10 and 11. On 6 March 31, the company sold Job 10 to the customer for cash. 7 Information concerning the company's jobs during the month 8 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. Journalize the entries for the completion of the two jobs and the sale of Job 10. 9 10 Cost of Job 10 20,000 11 Cost of Job 11 30,000 12 Sales price of Job 10 35,000 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 26 29 30 31 32 33 34 35 36 37 30 Completion of jobs Debit Credit Mar. 31 Finished Goods Inventory (50,000) Work in Process Inventory 50,000 Recognition of revenue 31 Cash (35,000) Sales Revenue 35,000 Recognition of expenses 31 Cost of Goods Sold (20,000) Finished Goods Inventory 20,000 +