what is the answer?

ACCTG 231 - Spring 2022 EXCEL PROBLEM \# 4 - JOINT PROCESSING Below is information for Excel Problem \#4. The information has also been input into the spreadsheet provided for you to submit your solution. Excelsior Company manufactures three products in a joint process that costs $210,000. Initial processing results in the following number of units of each produc: At the initial split off point the products can be sold for the prices below: Instead of selling the products at split off, Excelsior could spend an additional $50,000 to process Product A further, which would result in a new sales price for Product A of $75 per unit. Excelsior could also process Product B further at a cost of $70,000, which would result in a new sales price for Product B of $90 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 $45 per unit. The three tasks to complete in the spreadsheet are: 1. Complete the schedule provided to illustrate the financial advantage or disadvantage of further processing each of the products (be sure disadvantages appear as negative numbers). (2 points) 2. Based on your schedule in question #1, put an X in the relevant cell to indicate which product(s) should be sold at split-off and which processed further? (1 point) 3. Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question #2. ( 2 points) Remaining 5 points are for having a working spreadsheet that recalculates if one of the given variables is changed. Complete the schedule belew to ithustrate the financlal advantage or disadvantage of further procesing of each product. Be sure disadvantages appear as ne gative numbers. Based on wour chart in ave stion 1 , put an X in the relevant cell for each of the products to indicate whetherit should be sold at spli 3. Complete the whe dule provided to compute the tot al prost earned if units are sold at indicated by your answer to que stion 2 ACCTG 231 - Spring 2022 EXCEL PROBLEM \# 4 - JOINT PROCESSING Below is information for Excel Problem \#4. The information has also been input into the spreadsheet provided for you to submit your solution. Excelsior Company manufactures three products in a joint process that costs $210,000. Initial processing results in the following number of units of each produc: At the initial split off point the products can be sold for the prices below: Instead of selling the products at split off, Excelsior could spend an additional $50,000 to process Product A further, which would result in a new sales price for Product A of $75 per unit. Excelsior could also process Product B further at a cost of $70,000, which would result in a new sales price for Product B of $90 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 $45 per unit. The three tasks to complete in the spreadsheet are: 1. Complete the schedule provided to illustrate the financial advantage or disadvantage of further processing each of the products (be sure disadvantages appear as negative numbers). (2 points) 2. Based on your schedule in question #1, put an X in the relevant cell to indicate which product(s) should be sold at split-off and which processed further? (1 point) 3. Complete the schedule provided to compute the total profit earned if units are sold as indicated by your answer to question #2. ( 2 points) Remaining 5 points are for having a working spreadsheet that recalculates if one of the given variables is changed. Complete the schedule belew to ithustrate the financlal advantage or disadvantage of further procesing of each product. Be sure disadvantages appear as ne gative numbers. Based on wour chart in ave stion 1 , put an X in the relevant cell for each of the products to indicate whetherit should be sold at spli 3. Complete the whe dule provided to compute the tot al prost earned if units are sold at indicated by your answer to que stion 2