I need help, please solve in table form only. Thanks

During 2017, Rooney Manufacturing Company incurred $8,000,000 of research and development (R&D) costs to create a long-life battery to use in computers. In accordance with FASB standards, the entire R&D cost was recognized as an expense in 2017. Manufacturing costs (direct materials, direct labor, and overhead) are expected to be $45 per unit. Packaging, shipping, and sales commissions are expected to be $8 per unit. Rooney expects to sell 2,000,000 batteries before new research renders the battery design technologically obsolete. During 2017, Rooney made 440,000 batteries and sold 400,000 of them. Required a. Identify the upstream and downstream costs. b. Determine the 2017 amount of cost of goods sold and the ending inventory balance that would appear on the financial statements that are prepared in accordance with GAAP c. Determine the sales price assuming that Rooney desires to earn a profit margin that is equal to 25 percent of the total cost of developing, making, and distributing the batteries. d. Prepare a GAAP-based income statement for 2017. Use the sales price developed in Requirement c. Complete this question by entering your answers in the tabs below RequiredARequired B Required C Required D Identify the upstream and downstream costs 1. Research and development 2. Packaging 3. Shipping 4. Sales commissions