Excelsior Company manufactures three products in a joint process that costs $235,000. Initial processing results in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Excelsior Company manufactures three products in a joint process that costs $235,000. Initial processing results in the following number of units of each product: Product A 2,700 units Product B 1,600 units Product C 2,100 units At the initial split off point the products can be sold for the prices below: Product A Product B Product C $47 per unit $40 per unit $35 per unit Instead of selling the products at split off, Excelsior could spend an additional $55,000 to process Product A further, which would result in a new sales price for Product A of $70 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 $80 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). (3 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? (3 points) 3. Complete the schedule provided to compute the total profit earned if units are sold as Indicated by your answer to question #2. (4 points) Remaining 5 points are for having a working spreadsheet that recalculates if one of the given variables is changed. Excelsior Company manufactures three products in a joint process that costs $235,000. Initial processing results in the following number of units of each product: Product A 2,700 units Product B 1,600 units Product C 2,100 units At the initial split off point the products can be sold for the prices below: Product A Product B Product C $47 per unit $40 per unit $35 per unit Instead of selling the products at split off, Excelsior could spend an additional $55,000 to process Product A further, which would result in a new sales price for Product A of $70 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 $80 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). (3 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? (3 points) 3. Complete the schedule provided to compute the total profit earned if units are sold as Indicated by your answer to question #2. (4 points) Remaining 5 points are for having a working spreadsheet that recalculates if one of the given variables is changed.
Expert Answer:
Answer rating: 100% (QA)
1 Create a table with columns for Product Initial Units Initial Sales Price Further Processing Cost ... View the full answer
Related Book For
Intermediate Algebra
ISBN: 9780134895987
13th Edition
Authors: Margaret Lial, John Hornsby, Terry McGinnis
Posted Date:
Students also viewed these accounting questions
-
"internet radios" for streaming audio, and personal video recorders and players. Describe design and evaluation processes that could be used by a start-up company to improve the usability of such...
-
In February 2015, Majdy I. was appointed as a Chief Executive Manager of the Manufacturing Company by Mamoun N., President. Majdy had wide executive experience in the manufacturing sector with high...
-
Four people, each with a mass of 72.4 kg, are in a car with a mass of 1 130 kg. An earthquake strikes. The driver manages to pull off the road and stop, as the vertical oscillations of the ground...
-
Management of a soft-drink bottling company has the business objective of developing a method for allocating delivery costs to customers. Although one cost clearly relates to travel time within a...
-
a. A corporation is planning to sell its 90-day commercial paper to investors offering an 8.4 percent yield. If the three-month T-bill's annualized rate is 7 percent, the default risk premium is...
-
A piece of cloth is discovered in a burial pit in the southwestern United States. A tiny sample of the cloth is burned to CO 2 , and the 14 C/ 12 C ratio is 0.250 times the ratio in todays...
-
(Stockholders Equity Section of Balance Sheet) The following is a summary of all relevant transactions of Vicario Corporation since it was organized in 2010. In 2010, 15,000 shares were authorized...
-
Q. In order to attain economic progress, humans use the natural resources of the planet. Nature is fashioned into products for human consumption. This economic activity is needed to create jobs and...
-
A structural formula of a monosaccharide is shown below: HOH2C- HO a. Classify this monosaccharide (e.g., ketotetrose) b. Does it have the D or L configuration?. c. Specify the type of ring this...
-
Under what circumstances does a firm violate the basic relationship underlying the percent of sales forecast method?
-
What features of common stock indicate ownership in the corporation versus preferred stock or bonds?
-
Why is it difficult to measure future cash flows?
-
How is a cash budget used in financial planning?
-
What provisions are available to protect a preferred stockholder?
-
1. What are the four types of externality? 2. Give an example of each type of externality that is different from the ones described above. 3. How are the externalities that youve described addressed,...
-
How has the too-big-to-fail policy been limited in the FDICIA legislation? How might limiting the too-big-to-fail policy help reduce the risk of a future banking crisis?
-
Write the fourth term of the expansion of (3a + 2b) 19 .
-
Evaluate. 5 log 5 36
-
Solve each equation. V6+ 2x 1 = 7 - 2x
-
Is Fairmont in compliance with company policy that requires explicit approval of all hours of eighty hours or more.
-
d that Fairmont is not in complianThe forensic audit has determinece with Federal withholding requirements for FICA and Medicare because FICA and Medicare were not withheld from employee paychecks...
-
Which of the following is not a technique to conceal inventory shrinkage? 1. Counting and valuing the physical inventory at the end of each year 2. Writing off inventory after physical inventory...
Study smarter with the SolutionInn App