Costs for the three jobs worked on in April: Job 306 Job 307 Job 308 April Total Balances on March 31 Direct materials Direct labor Applied overhead Beginning work in process 31,000 22,000 11,000 64,000 39,000 15,000 7,500 61,500 125,500 Costs during April Direct materials Direct labor Applied overhead Total costs added in September Total costs Status on Apr 30 April 30 Cost included in: 133,000 103,000 200,000 151,000 110,000 102,000 51,500 287,500 351,500 $ 75,500 426,500 488,000 $ 443,000 356,000 178,000 977,000 263,000 1,102,500 51,000 263,000S Finished (Sold) Finished (Unsold) In process Cost of goods soldFinished goods inventory Work in process inventory Where applicable, all numbers should be cell references or formulas (ie SUM). Full credit will not be given for numbers typed into cells. Proper formatting should also be applied ie. Numbers are formatted as "accounting", underlines and double underlines should be utilized where applicable Data for Perez Mfg: Predetermined OH Rate based on DL cost 50% TAB INSTRUCTIONS: (1) Determine the total of each production cost incurred for April (DL, DMand applied overhead) (2) Determine the total cost assigned to each job (including balances from March 31) (3) Indicate what account thejob costs are in at April 30 Sales Cost of Goods Sold Gross Profit TAB INSTRUCTIONS (1) Compute gross profit for April 2) Show how to present the inventories on the April 30 balance sheat Raw materials Finished goods (Job 307 Total inventories Where applicable, all numbers should be cell references or formulas (ie SUM), Full credit will not be eiven for numbers typed into cells Proper formatting should also be applied ie. Numbers are formatted as "accounting, underlines and double underlines should be utilized where applicable. Data for Perez Mfg Raw material inventory, March 31 Raw material purchases Factory payroll cost April overhead cost 82,000 10,000 78,000 (April) April) Indirect materials Indirect labor Factory rent Factory utilities Depreciation Factory equip 52,000 22,000 36,000 23,000 58,000 Predetermined OH Rate based on DL cost Job 306 is sold in April for cash 50% 690,000