In excel form:

This is all the information given, please answer all thank you

O Required information [The following information applies to the questions displayed below.) 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 Job 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): Molding Fabrication Estimated total machine-hours used Total Estimated total fixed manufacturing overhead 4,400 2,640 7,040 Estimated variable manufacturing overhead per $ 17,600 $ 26,400 $ 44,000 $ 1.40 $ 2.20 machine-hour Job P Job 0 Direct materials $ 22,888 $ 14,080 Direct labor cost $ 36,960 $ 13,200 Actual machine-hours used: Molding 3,040 Fabrication 1,410 1,060 1,530 Total 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base 1. What were the company's predetermined overhead rates in the Molding Department and the Fabrication Department? (Round your answers to 2 decimal places.) Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Mooing 4,400 $ 17,600 $ 1.40 Fabrication 2,640 $ 26,400 $ 2.20 Total 7,849 $ 44,000 Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base 1. What were the company's predetermined overhead rates in the Molding Department and the Fabrication Department? (Round your answers to 2 decimal places.) Predetermined Overhead Rato Molding Department Fabrication Department per MH per MH Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding 4,400 $ 17,600 $ 1.40 Fabrication 2,640 $ 26,400 $ 2.20 Total 7,040 $ 44,000 Job P Job $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job P included 20 units and Job included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 2. How much manufacturing overhead was applied from the Molding Department to Job P and how much was applied to Job Q? (DO not round intermediate calculations.) Job P Job Manufacturing overhead applied 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 Job 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): Molding Fabrication Total Estimated total machine-hours used 4,400 2,640 Estimated total fixed manufacturing overhead 7,040 $ 17,600 $ 26,400 $ 44,000 Estimated variable manufacturing overhead per machine-hour $ 1.40 $ 2.20 Job p Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 3. How much manufacturing overhead was applied from the Fabrication Department to Job P and how much was applied to Job Q? (Do not round Intermediate calculations.) Job P Job Manufacturing overhead applied Required information [The following information applies to the questions displayed below.) 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 Job 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): Estimated total machine-hours used Molding Fabrication Total 4,400 2,640 7,040 Estimated total fixed manufacturing overhead $ 17,600 $ 26,400 $ 44,000 Estimated variable manufacturing overhead per machine-hour $ 1.40 $ 2.20 Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13, 200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 4. What was the total manufacturing cost assigned to Job P? (Do not round Intermediate calculations.) Total manufacturing cost UU JUU. UVIVU UUTISHUUD UYU MIC ya IV www. data and questions relate to the month of March): Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding Fabrication 4,400 2,640 $ 17,600 $ 26,400 $ 1.40 $ 2.20 Total 7,040 $ 44,000 Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,280 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,840 1,860 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job P included 20 units and Job included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 5. If Job P included 20 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) Unit product cost two manufacturing departments-Moiaing ana radnication Startea, completea, ana soia only IWO JODS Ounng marcn- Job P and Job 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): Estimated total machine-hours used Molding Fabrication Total 4,400 2,640 7,840 Estimated total fixed manufacturing overhead $ 17,600 $ 26,400 $ 44,000 Estimated variable manufacturing overhead per machine-hour $ 1.40 $ 2.20 Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,840 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 6. What was the total manufacturing cost assigned to Job Q? (Do not round intermediate calculations.) Total manufacturing cost wwwyuri MULTUMITI www data and questions relate to the month of March) Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding 4,400 $ 17,600 $ 1.40 Fabrication 2,640 $ 26,400 $ 2.20 Total 7,040 $ 44,000 Job P Job O $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,060 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base 7. 14 Job included 30 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) Unit product cost data and questions relate to the month of March): 15 Estimated total machine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding 4,400 $ 17,600 $ 1.40 Fabrication 2,640 $ 26,400 $ 2.20 Total 7,040 $ 44,000 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job o $ 22,880 $ 14,080 $ 36,960 $ 13,200 3,040 1,410 1,060 1.530 4,100 2,940 Sweeten Company had no underapplied or overapplled manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job P included 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base 8. Assume that Sweeten Company used cost-plus pricing (and a markup percentage of 80% of total manufacturing cost) to establish selling prices for all of its jobs. What selling price would the company have established for Jobs P and Q? What are the selling prices for both jobs when stated on a per unit basis? (Do not round intermediate calculations. Round your final answers to nearest whole dollar) Job P Job Total price for the job Selling price per unit two manufacturing departments-Molding and Fabrication. It started, completed, and sold only two jobs during March- Job P and Job 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): Estimated total machine-hours used Molding Fabrication Total 4,400 2,640 7,840 Estimated total fixed manufacturing overhead $ 17,600 Estimated variable manufacturing overhead per $ 26,400 $ 44,000 machine-hour $ 1.40 $ 2.29 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,200 3,040 1,410 1,060 1,530 4,100 2,940 Sweeten Company had no underappled or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job P Included 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 9. What was Sweeten Company's cost of goods sold for March? (Do not round intermediate calculations.) Cost of goods sold II. . Mwinyje Job P and Job 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): Estimated total machine-hours used Molding Fabrication Total 4,400 2,640 7,040 Estimated total fixed manufacturing overhead $ 17,600 $ 26,400 Estimated variable manufacturing overhead per $ 44,000 machine-hour $ 1.40 $ 2.20 5 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job $ 22,880 $ 14,680 $ 36,960 $ 13,200 3,040 1,410 1,060 1.530 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job P included 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 10. What was the company's plantwide predetermined overhead rate? (Round your answer to 2 decimal places.) Predetermined overhead rate per MH Job P and Job 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): Estimated total machine-hours used Molding Fabrication Total 4,400 2,640 7,840 Estimated total fixed manufacturing overhead $ 17,600 $ 26,400 Estimated variable manufacturing overhead per $ 44,000 machine-hour $ 1.40 $ 2.20 Job P Job O $ 22,880 $ 14,080 $ 36,960 $ 13,200 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total 3,040 1,068 4,100 1,410 1,530 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 11. How much manufacturing overhead was applied to Job P and how much was applied to Job Q? (Do not round intermediate calculations.) Job P Job Manufacturing overhead applied Job P and Job 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); Estimated total machine-hours used Molding Fabrication Total Estimated total fixed manufacturing overhead 4,400 2,640 7,040 Estimated variable manufacturing overhead per $ 17,600 $ 26,400 $ 44,000 machine-hour $ 1.40 $ 2.20 5 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job $ 22,880 $ 14,880 $ 36,968 $ 13, 200 3,040 1,410 1,060 1,530 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job P included 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine hours as the allocation base. 12. If Job Pincluded 20 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) Unit product cost The following information applies to the questions displayed below.) 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 Job 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): Estimated total machine-hours used Molding Fabrication Total Estimated total fixed manufacturing overhead 4,400 2,640 7,040 $ 17,600 Estimated variable manufacturing overhead per $ 26,400 $ 44,000 machine-hour $ 1.40 $ 2.20 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13, 200 3,840 1,410 1,068 1,530 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 13. If Job Q included 30 units, what was its unit product cost? (Do not round intermediate calculations. Round your final answer to nearest whole dollar.) Unit product cost data and questions relate to the month of March): Estimated total nachine-hours used Estimated total fixed manufacturing overhead Estimated variable manufacturing overhead per machine-hour Molding 4,400 $ 17,600 $ 1.40 Fabrication 2,640 $ 26,400 $ 2.20 Total 7,840 $ 44,000 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job O $ 22,880 $ 14,080 $ 36,960 $ 13,280 3,040 1,410 1,060 1,530 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base. 14. Assume that Sweeten Company used cost-plus pricing (and a markup percentage of 80% of total manufacturing cost) to establish selling prices for all of its jobs. What selling price would the company have established for Jobs P and Q? What are the selling prices for both jobs when stated on a per unit basis? (Do not round intermediate calculations. Round your final answers to nearest whole dollar.) Job P Job Q Total price for the job Selling price per unit Required information [The following information applies to the questions displayed below.) 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 Job 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); Estimated total machine-hours used Molding Fabrication Total Estimated total fixed manufacturing overhead 4,400 2,640 7,040 $ 17,600 Estimated variable manufacturing overhead per $ 26,400 $ 44,000 machine-hour $ 1.40 $ 2.20 Direct materials Direct labor cost Actual machine-hours used: Molding Fabrication Total Job P Job 0 $ 22,880 $ 14,080 $ 36,960 $ 13,200 3,040 1,410 1,060 1,530 4,100 2,940 Sweeten Company had no underapplied or overapplied manufacturing overhead costs during the month. Required: For questions 1 to 9, assume that Sweeten Company uses departmental predetermined overhead rates with machine- hours as the allocation base in both departments and Job Pincluded 20 units and Job Q included 30 units. For questions 10 to 15, assume that the company uses a plantwide predetermined overhead rate with machine-hours as the allocation base 15. What was Sweeten Company's cost of goods sold for March? (Do not round intermediate calculations.) Cost of goods sold