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 C of $25 per unit.

PLEASE INCLUDE EACH EXCEL FORMULA NEEDED TO INPUT FOR EACH ANSWER.

THE STUDENT ID YOU USE FOR PRODUCT C IS 18010

THANK YOU!

44 - Joint Processing o Search (Alt+Q) File Home Insert Draw Page Layout Formulas Data Review View Help X G Calibri 11 A al General Y Paste BIUR v CA Conditional Formatting Format as Table E $ % ) V Undo Clipboard N Font Cell Styles V 3 .00 00 > Number Alignment R M12 Styles D D E F G A B HC Problem Data 2 2 Joint Costs H H K EL M N 0 P P $90,000 R 5 POINTS) 20 4 Product Units produced Selling price at split off Selling price after further processing 5 Product A Additional processing costs 5,000 $25 $50 5 Products 3,000 $150,000 $10 7 $40 Product S45.000 4,000 $ $15 $25 A Input last 5 dieits of student ID in yellow highlighted cell 9 REQUIRED 30 11 1 complete the chart below (example on page 535 of text) to illustrate the financial advantage of disadvantage of further processing of each product. Be sure disadvantages appear as negative nunbers. 12 Product Product Product 13 Total Sales value after further processing 141 Less Sales value at splil off 15 incremental revenue from further processing 16 Less cost of further processing UT 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? Sold at split off (1 POINT) Processed further 21 Product A 22 Product B 23 Product C 24 25 3 Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question ? (6 POINTS) 26 27 Total Sales 28 Total loint costs 29 Total further processing costs 30 Profit 21 32 33 Sheet1 + Ready Accessibility: Good to go P 47F Mostly cloudy FH MO Q Wides 288