Job-Order Cost Sheets, Balance in Work in Process and Finished Goods Prull Company, a job-order costing firm, worked on three jobs in July. Data are as follows: Balance, July 1 Direct materials Direct labor Machine hours Job 86 Job 87 Job 88 $21,240 $6,180 $0 $10,490 $12,300 $16,080 $15,990 $12,190 $24,050 480 310 990 Overhead is applied to jobs at the rate of $17 per machine hour. By July 31, Jobs 86 and 88 were completed. Jobs 82 and 86 were sold. Job 87 remained in process. On July 1, the balance in Finished Goods was $48,970 (consisting of Job 82 for $25,610 and Job 84 for $23,360). Prull prices its jobs at cost plus 30%. During July, variable marketing expenses were 5% of sales, and fixed marketing expenses were $1,970; administrative expenses were $4,790. (Round all amounts to the nearest dollar.) Required: Download Excel spreadsheet 1. Prepare job-order cost sheets for all jobs in process during July, showing all costs through July 31. All amount cells must have an entry; enter zeros as needed.