AutoSave OFF C... Job Order - Homework 1 Formulas. Review Data View Tell me 11 A A == Wrap Text General AA Merge & Center $ % 9 800 Conditional Format Formatting as Table S Home Insert Draw Page Layout X V Calibri (Body) v Paste B I U K8 x fx A B C D E F G H 4 5 6 2) Factory Labor paid - $31,000 7 3) Manufacturing overhead costs paid - $22,500 8 4) Materials requisitioned and factory labor used by job: 9 10 Job# Materials Factory Labor 11 Job 12 6,500 6,000 12 Job 13 3,250 3,500 13 Job 14 7,000 6,500 14 Job 15 7,500 7,000 15 Job 16 1,500 1,000 16 General factory use 5,000 7,750 17 30,750 31,750 18 19 Transaction Information for XYZ Corporation (uses Job Order Costing) 5) Jobs Finished - # 12, #14, and #15 1) Raw materials purchased on account - $40,000 6) Jobs Sold - #12 for $33,000 and #41 for $31,000 7) Made month end entries for total materials, labor and overhead Note: Overhead application rate is 150% of direct labor. Questions when done: a) Was Factory Overhead Overapplied or Underapplied and by what amount? b) What was gross profit for the month? General Ledger Accounts 20 21 RAW MATERIALS INVENTORY 22 23 24 25 26 FACTORY PAYROLL WORK IN PROCESS INVENTORY FINISHED GOODS INVENTORY COST OF GOODS SOLD 27 28 29 30 EB EB EB 31 FACTORY OVERHEAD SALES 32 33 34 35 30 37 38 Ready Sheet1 Sheet2 esc Sheet3 * 80 000 DOD F1 F2 F3 FA F5 @ # # $ 69 % MacBook Air < F6 & M N EB F7 DII F8