please enter the information and answer as it should be placed in the excell sheet

PR 1-4A. Manufacturing income statement, statement of cost of goods manufactured Obj. 4. Several items are omitted from the income statement and cost of goods manufactured statement data for two different companies for the month of May: Materials inventory, May 1 Materials inventory, May 31 Materials purchased Rainier Company Yakima Company $ 100,000 $ 48,200 (A) 50,000 710,000 (A) (B) 446,000 2,484,200 2,660,600 176,400 Cost of direct materials used in production Direct labor Factory overhead Total manufacturing costs incurred in May Total manufacturing costs Work in process inventory, May 1 Work in process inventory, May 31 Cost of goods manufactured Finished goods inventory, May 1 Finished goods inventory, May 31 Sales Cost of goods sold Gross profit Operating expenses Net income 950,000 938,500 2,860,000 1,800,000 (B) 5,998,500 400,000 382,000 (C) 615,000 596,500 9,220,000 (D) (E) 1,000,000 (F) (C) 2,491,500 190,000 (D) 4,550,000 2,470,000 (E) (F) 1,500,000 INSTRUCTIONS: 1. For both companies, determine the amounts of the missing items (A) through (F), identifying them by letter. 2. Prepare Yakima Company's statement of cost of goods manufactured for May. 3. Prepare Yakima Company's income statement for May. Enter the appropriate amounts formulas in the shaded (gray) ceds or select from the drop-down list An astensk () will appear in the column to the right of an incorrect answer Enter a decrease to an account balance as a negative number. New balances will be automatically calculated for you. 1. and 2. (4) (b) Bal (c) Bal (d) Bal (e) Bal ( Bal Bat (h) Bal (0) Filetelele Bal (10) Bal (1) Bal (m) Bal Cash Accounts Receivable. Supplies Assets Prepaid Insurance. Truck Catering Equipment Liabilities. Accounts Payable IL Gervais, Capital Owner's Equity B.Gervais, Drawing Revenue Expenses Revenue or Expense Account Affected 3. Proof: Left Side of Equal Sign: Cash Accounts Receivable Supplies Prepaid Insurance Truck Catering Equipment Right Side of Equal Sign: Accounts Payable B. Gervais, Capital B. Gervais, Drawing Revenue Expenses