please if you could help me woth this the same way in excel

Sweeten Company had no jobs in progress at the beginning of March and no beginning inventories. The company has two manufacturing departments-Molding and Fabrication. It started, completed, and sold only two jobs during March --Job P and Jot Q. The following additional information is available for the company as a whole and for Jobs P and Q (all data and questions relate to the month of March): Estimatod total machine-hours used Estimated total fixed manufacturing overhoad Estimatod variablo manufacturing overhead per machine-hour Molding 2.500 $10,000 Fabrication 1,500 $15,000 Total 4,000 $25,000 $140 $2 20 Job P $13,000 $21,000 Job $8,000 $7,500 Direct materials Direct labor cost Actual machino-hours used Molding Fabrication Total 800 1,700 600 2.300 900 1,700 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1-8, assume that Sweeten Company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. For questions 9-15, assume that the company uses departmental predetermined overhead rates with machine-bours as the allocation base in both departments. Student Name: 1. What was the company's plantwide predetermined overhead rate? Molding: Estimated fixed manufacturing overhead Estimated variable manufacturing overhead Estimated total mfg. OH - Molding Fabrication: Estimated fixed manufacturing overhead Estimated variable manufacturing overhead Estimated total mfg. OH - Fabrication 5 6 7 Estimated total manufacturing overhead (a) (Molding and Fabrication) Estimated total machine hours (b) Predetermined overhead rate (a) (b) 8 19 20 21 22 23 24 A B K D E G 1 H F 2. How much manufacturing overhead was applied to Job P and how much was applied to Job Q? 2 3 Job P Job 4 5 Actual machine-hours worked (a) Predetermined overhead rate per machine hour (b) Manufacturing overhead applied (a) x (b) 6 7 8 9 10 11 12 13 B D E F G H 3. What was the total manufacturing cost assigned to Job P? Job P 5 6 Direct materials Direct labor Manufacturing overhead applies Total manufacturing cost 7 8 9 10 19 3 1 4. If Job P included 20 units, what was its unit product cost? 2. Job P Total manufacturing cost - see Q3 (a) Number of units (b) Unit product cost (a) (b) 4 5 6 7 8 9