Use 12345 as product C additional processing cost

plz show excel formulas !!!

1. Complete chart provided (similar to the example in the text on page 535) to illustrate the financial advantage or disadvantage of further processing of each product (be sure disadvantages appear as negative numbers). (3 points) 2. Based on the chart in question #1 which product(s) should be sold at split-off and which processed further? (1 point) 3. Complete the schedule provided to compute the total profits earned if units are sold as indicated by your answer to question #2. (6 points) Excelsior Company manufactures three products in a joint process that costs $90,000. Initial processing results in the following number of units of each product: Product A 5,000 units Product B 3,000 units Product C 4,000 units At the initial split off point the products can be sold for the prices below: Product A $25 per unit Product B $10 per unit Product C $15 per unit Instead of selling the products at split off, Excelsior could spend an additional $150,000 to process Product A further, which would result in a new sales price for Product A of $50 per unit. Excelsior could also process Product B further at a cost of $45,000, which would result in a new sales price for Product B of $40 per unit and could process Product C further at a cost of (use the last five digits of your student ID for the cost of further processing Product C), resulting in a new sales price for Product Cof $25 per unit. | [G Format as Table Cells Paste Number Editing Font EN IN Alignment Analyze Data Cell Styles K M S22 xfx A B D E G H 1 1 Problem Data 2 Joint Costs $90,000 3 4 Product Units produced Selling price at split off Additional processing costs Selling price after further processing 5 Product A 5,000 $25 $50 $150,000 6 Product B 3,000 $10 $45,000 $40 7 Product 4,000 $15 $25 12345 8 9 REQUIRED 10 11 1 Complete the chart below example on page 535 of text) to illustrate the financial advantage or disadvantage of further processing of each product. Be sur 12 Product A Product B Product 13 Total Sales value after further processing 14 Less sales value at split off 15 Incremental revenue from further processing 16 Less cost of further procesuing 17 Financial advantage (disadvantage of further processing 18 19 2 Based on your chart in question 1, which of the product(s) should be sold at the split off point and which processed further? 20 Sold at split of Processed further 21 Product 22 Products 23 Product 24 25 3 Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question 2 26 27 Total Sales 28 Total joint costs 39 Total further processing costs 30 Profit 31 32 33 34 35 36 37 38 39