Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Below is information for Excel Problem #4. The information has also been input into the spreadsheet provided for you to submit your solution. The
Below is information for Excel Problem #4. The information has also been input into the spreadsheet provided for you to submit your solution. The three questions asked on the spreadsheet are: 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 Product B Product C $25 per unit $10 per unit $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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started