Ready \{? Accessibility: Unavailable

Excel File Edit AutoSave Home Insert Draw Arial Paste Chapter 11 : Applying Excel Data View Insert Format Formulas Tools Data Data Window Help Chapter_11_AppIying_ExceI_Student_Form.xIs Review View Automate Q Tell me Thu Jun 15 7:24 PM - Read-Only - Compatibility Mode Page Layout v 10 ab Wrap Text v Merge & Center v General 0/0 Conditional Formatting Format as Table Cell Styles Insert v Format v Sort & Filter Comments Analyze Data Chapter 11: Applying Excel 11 12 13 14 15 17 19 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 Exhibit 11-7 Santa Maria Wool Cooperative Cost of wool Cost of separation process Sales value of intermediate products at split-off point: Undyed coarse wool 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 Entera formula into each of the cells marked with a ? below Example: Joint Product Costs and the Contribution Approach Analysis of the profitability of the overall operation: Combined final sales value Less costs of producing the end products: Cost of wool Cost of separation process Combined costs of dyein profit Analysis of sell or process further: Final sales value after further processin Less sales value at the split-off point Incremental revenue from further processin Less cost of further processing (dyeing) Financial advantage (disadvantage) of further processing Chapter 1 1 Form Ready Accessibility: Unavailable $200,000 $40,000 $120,000 $150,000 $60,000 $50,000 $60,000 $10,000 $160,000 $240,000 $90,000 Coarse Woo/ Fine Woo/ Superfine Woo/ Find & Select O 1.4 Share Sensitivity + 100%