3-5 in google sheet or excel doc please

1 clared for the month Prepare a schedule of contestood cold for the month. Assume the underapplied or ovetup plied overhead is closed to Cost of Goods Sold of Good EXERCISE 3-4 Underapplied and Overapplied Overhead LO3-6 overhead for an estimated activity level of 12.000 direct labor-hours Osborn Manufacturing uses a predetermined overhead rate of $18.20 per direct labor-bour. This of total manufacturing The company actually incurred $215,000 of manufacturing overhead and 11.500 direct labor hours during the period. Arquired 1 period. 2 Determine the amount of underapplied or overapplied manufacturing overhead for the Assume that the company's underapplied or overapplied overhead is closed to Cost of Goods Sold. Would the journal entry to dispose of the underapplied or overapplied overhead increase or decrease the company's gross margin? Hy how much? direct direct e apany EXERCISE 3-5 Journal Entries and T-accounts 03-1, LC3-2 The Polaris Company uses a job-order costing system. The following transactions occurred in October 11 Raw materials purchased on account, $210,000. Raw materials used in production, $190.000 (5178.000 direct materials and $12.000 indirect materials) Accrued direct labor cost of $90,000 and indirect labor cost of $110.000 d. Depreciation recorded on factory equipment, S40,000 Other manufacturing overhead costs accrued during October, $70,000 f. The company applies manufacturing overhead cost to production using a predetermined rate of 58 per machine-hour. A total of 30,000 machine-bours were used in October Jobs costing SS20,000) according to their job cost sheets were completed during October and transferred to Finished Goods h. Jobs that had cost $480,000 to complete according to their job cost sheets were shipped to customers during the month. These jobs were sold on account at 25% above cost. Required: 1 Prepare journal entries to record the transactions given above. 2. Prepare T-accounts for Manufacturing Overhead and Work in Process Post the relevant trans actions from above to each account. Compute the ending balance in each account, assuming that Work in Process has a beginning balance of $42,000 irect = for ede. EXERCISE 3-6 Schedules of Cost of Goods Manufactured and cost of Goods Sold; Income Statement LO3-3 The following data from the just completed year are taken from the accounting records of Mason Company: Sales Direct labor cost Raw material purchases Selling expenses Administrative expenses Manufacturing overhead applied to work in process Actual manufacturing overhead costs. $524,000 $70,000 $118,000 $140,000 $63.000 $90,000 $80.000 Inventorles Raw materials. Work in process. Finished goods Beginning $7,000 $10,000 $20,000 Ending $15.000 $5,000 $35.000