2. In industries that process joint products, the costs of the raw materials inputs and the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final products are often volatile. Change the data area of your worksheet to match the following: 1 Chapter 13: Applying Excel 2 3 4 5 6 7 8 9 10. 11 12 13. 14 15. 16 17 18 Data Exhibit 13-7 Santa Maria Wool Cooperative Cost of wool Cost of separation process Sales value of intermediate products at split-off point: Undyed coarse wool A Undyed fine wool Undyed superfine wool Costs of further processing (dyeing) intermediate products: Undyed coarse wool Undyed fine wool Undyed superfine wool Sales value of end products: Dyed coarse wool Dyed fine wool Dyed superfine wool $ $ Overall profit from processing all intermediate products $ $ $ $ $ $ $ $ $ B 208,000 40.000 134,000 144,000 80,000 50,000 60,000 10,000 159,000 221,000 98,000 If your formulas are correct, you should get the correct answers to the following questions. a. What is the overall profit if all intermediate products are processed into final products? b. What is the financial advantage (disadvantage) from further processing? from further processing undyed coarse wool from further processing undyed fine wool from further processing undyed superfine wool c-1. With these new costs and selling prices, what recommendations would you make concerning the company's operations? Sell as is or process further the intermediate product undyed coarse wool? Sell as is or process further the intermediate product undyed fine wool? Sell as is or process further the intermediate product undyed superfine wool? c-2. If your recommendation in part (c-1) is followed, what would be the company's overall profit? Overall profit from following the plan in part (c) 2. In industries that process joint products, the costs of the raw materials inputs and the sales values of intermediate and final products are often volatile. Change the data area of your worksheet to match the following: 1 Chapter 13: Applying Excel 2 3 4 5 6 7 8 9 10. 11 12 13. 14 15. 16 17 18 Data Exhibit 13-7 Santa Maria Wool Cooperative Cost of wool Cost of separation process Sales value of intermediate products at split-off point: Undyed coarse wool A Undyed fine wool Undyed superfine wool Costs of further processing (dyeing) intermediate products: Undyed coarse wool Undyed fine wool Undyed superfine wool Sales value of end products: Dyed coarse wool Dyed fine wool Dyed superfine wool $ $ Overall profit from processing all intermediate products $ $ $ $ $ $ $ $ $ B 208,000 40.000 134,000 144,000 80,000 50,000 60,000 10,000 159,000 221,000 98,000 If your formulas are correct, you should get the correct answers to the following questions. a. What is the overall profit if all intermediate products are processed into final products? b. What is the financial advantage (disadvantage) from further processing? from further processing undyed coarse wool from further processing undyed fine wool from further processing undyed superfine wool c-1. With these new costs and selling prices, what recommendations would you make concerning the company's operations? Sell as is or process further the intermediate product undyed coarse wool? Sell as is or process further the intermediate product undyed fine wool? Sell as is or process further the intermediate product undyed superfine wool? c-2. If your recommendation in part (c-1) is followed, what would be the company's overall profit? Overall profit from following the plan in part (c)
Expert Answer:
Related Book For
Managerial Accounting for Managers
ISBN: 978-1259578540
4th edition
Authors: Eric Noreen, Peter Brewer, Ray Garrison
Posted Date:
Students also viewed these physics questions
-
The Excel worksheet form that appears below is to be used to recreate an example earlier in the chapter. Download the workbook containing this form from Connect. On the website you will also receive...
-
In industries that process Joint products, the costs of the raw materials inputs and the sales values of intermediate and final products are often volatile. Change the data area of your worksheet to...
-
ok nt ences c-1. With these new costs and selling prices, what recommendations would you make concerning the company's operations? Sell as is or process further the intermediate product undyed coarse...
-
In determining an employee's net pay, which of the following taxes would be deducted? a. FUTA taxes b. SUTA taxes c. FICA taxes d. All of these choices are correct.
-
The following trial balance pertains to Cals Grocery as of January 1, 2013: The following events occurred in 2013. Assume that Cals uses the periodic inventory method. 1. Purchased land for $40,000...
-
When Amazon opened its first brick-and-mortar store in 2015 on the campus of Purdue University in Indiana and then in December announced its first Amazon Go check-out free convenience store in...
-
Concrete expands both horizontally and vertically over time. Measurements of horizontal and vertical expansion (in units of parts per hundred thousand) were made at several locations on a bridge in...
-
Various pension plan information of the Kerem Company for 2010 and 2011 is as follows: Required Fill in the blanks lettered (a) through (k). All the necessary information is listed. It is not...
-
Country A is experiencing a recessionary gap. a. Draw a correctly labeled AD-AS model showing this. Label the recessionary equilibrium price level as PL and current output as Y. b. Draw the...
-
The names of the employees of Matson Office Systems and their regular salaries are shown in the following payroll register. Note that Wayne and Young are paid monthly on the last payday, while all...
-
Stein agrees to pay Choi and Amal $9,700 each for a one-third (33 1/3%) interest in the Choi and Amal partnership. Immediately prior to Stein's admission, each partner had a $29,100 capital balance....
-
Explain how a common-mode output signal is generated.
-
For each of the following P-values, state whether H0 will be rejected at the 0.10 level. a. P = 0.12 b. P = 0.07 c. P = 0.05 d. P = 0.20
-
Explain how a differential-mode output signal is generated.
-
Describe the three stages of a simple BJT operational amplifier.
-
Describe the loading effects of connecting a second stage to the output of a BJT diff-amp.
-
is a useful tool to understand the systematic differences across cultures. a. Similarity- Attraction Phenomenon O b. More satisfied work force c. Hofstede's culture framework O d. Challenges of...
-
A condenser (heat exchanger) brings 1 kg/s water flow at 10 kPa quality 95% to saturated liquid at 10 kPa, as shown in Fig. P4.91. The cooling is done by lake water at 20C that returns to the lake at...
-
The Excel worksheet form that follows is to be used to recreate Example E and Exhibit 8-7. Download the workbook containing this form from Connect. On the website you will also receive instructions...
-
Morrow Corporation had only one job in process during May-Job X32Z-and had no finished goods inventory on May 1. Job X32Z was started in April and finished during May. Data concerning that job appear...
-
The Excel worksheet form that follows is to be used to recreate portions of Review Problem 1. Download the workbook containing this form from Connect. On the website you will also receive...
-
In an ideal gas mixture consisting of components \(A\) and \(B\), the mole fraction of component \(A\) is equal to (a) \(n_{\mathrm{A}}=\frac{p_{\mathrm{A}}+p_{\mathrm{B}}}{P}\) (b)...
-
The availability of a system (a) Depends upon the conditions of the system only (b) Is independent of the conditions of the surroundings (c) Does not depend upon the conditions of the system (d)...
-
In an absorption refrigeration system, the heat energy \(Q_{1}\) is supplied at temperature \(T_{1}\) while the system absorbs heat energy \(Q_{3}\) from a cold space at temperature \(T_{3}\). If the...
Study smarter with the SolutionInn App