please finish the schedule cost of goods manufactured. in the format in the firs image beliw please :)
\begin{tabular}{|l|l|r|r|} \hline \multicolumn{3}{|c|}{ Mighty Stars } \\ \hline 2 & \multicolumn{2}{|c|}{ Trial Balance } \\ \hline 3 & \multicolumn{1}{|c|}{ 30-Jun-18 } \\ \hline 4 & \multicolumn{1}{|c|}{ Account } & \multicolumn{1}{c|}{ Debit } & \multicolumn{1}{c|}{ Credit } \\ \hline 5 & Cash & 49,300.00 & \\ \hline 6 & Accounts Receivable & 119,000.00 & \\ \hline 7 & Raw Materials & 24,150.00 & \\ \hline 8 & Work in Process & 38,500.00 & \\ \hline 9 & Finished Goods & 20,400.00 & \\ \hline 10 & Plant Assets & 220,000.00 & \\ \hline 11 & Accumulated Depreciation & & 17,500.00 \\ \hline 12 & Accounts Payable & & 123,200.00 \\ \hline 13 & Wages Payable & & 2,900.00 \\ \hline 14 & Common Stock & & 139,000.00 \\ \hline 15 & Retained Earnings & & 109,800.00 \\ \hline 16 & Sales Revenue & & 104,000.00 \\ \hline 17 & Cost of Goods Sold & & \\ \hline 18 & Selling \& Admin Expenses & & \\ \hline 19 & & & \\ \hline 20 & & & \\ \hline 21 & & & \\ \hline 22 & & & \\ \hline 23 & & & \\ \hline 24 & & & \\ \hline 25 & & & \\ \hline \end{tabular} Mighty Stars produces stars for clementary teachers to reward their studenies Stars't tial balance on June 1 follows: June 1 balances in the subsidiary ledgers were as follows: - Raw Materials Inventory subsidiary ledger: Paper, $4,000; inditect materials, $2,000 - Work-in-Process Inventory subsidiary ledger: Job 120, \$40,000; Job 121, \$0 - Finished Goods Inventory subsidiary ledger: Large Stars, \$9,900; Small Stars, 510,500 June transactions are summarized 25 follows: a. Collections on account, $145,000. b. Selling and administrative expenses incurred and paid, $32,000. c. Payments on account, $39,000. d. Materials purchases on account Paper, $24,000; indirect materiaks, $4,200. c. Marerials requisitioned and used in production: f. Wages incurred during June, $39,000. Labor time records for the month: Job 120 , $3,600; Job 121,$17,000; indirect labor, $18,400. g. Wages paid in June include the balance in Wages Payable at May 31 plus $36,100 of wages incurred during June. h. Depreciation on plant and equipment, $2,500. i. Manufacturing overhead allocated at the predetermined overhead allocation rate of 80% of direct labor costs. j. Jobs completed during the month: Job 120 with 700,000 Large Stars at a total cost of $47,430. k. Sales on account: all of Job 120 for $104,000. 1. Adjusted for overallocated or underallocated manufacturing overhead