prepare a worksheet for a manufacturing firm. second pic is how sheet should look. please help!

irections Record each of the transactions in general journal form. , Uniee alaries, $3,000 Problem 25-2A Objective: To prepare a work sheet for a manufacturing firm The following data are the account balances for Yale Corporation as of June 30, 2 Account Cash Raw Materials Inventory (July 1, 20X1) Work-in-Process Inventory (July 1, 20X1) Finished Goods Inventory (July 1, 20X1) Other Current Assets Plant Assets (net) Current Liabilities Long-Term Liabilities Common Stock Retained Earnings Sales Sales Discounts Sales Returns and Allowances Raw Materials Purchases Raw Materials Purchases Discounts Raw Materials Purchases Returns and Allowances Direct Labor Factory Overhead Control Selling Expense Control General Expense Control 0x2: Balance $ 47,500 24,500 51,800 31,400 77,000 210,000 56,700 180,000 200,000 37,340 956,200 11,240 8,300 472,300 7,900 11,600 240,000 144,000 87,300 44,400 Inventories on June 30, 20X2, are as follows: Raw materials Work-in-process Finished goods $13,200 41,400 21,900 Directions: Use the data presented to prepare a work shet for the year ended 20X2. l Inroduction to Manufcuring Accounting 1115 Chapter 25 P25-2A