Assignment

profilecanada2016
WRDFinMan14e_EX10-12.xlsx
Home>Business & Finance homework help>Accounting homework help>Assignment

Ex. 24(10)-12

Exercise 24(10)-12
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
23
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
Key Code: [Key code here] Total SUM(AD13:AD15)
Instructions 23
Answers are entered in the cells with gray backgrounds. Percentage =(AD16-AD13-AD14)/AD16
Cells with non-gray backgrounds are protected and cannot be edited. 0%
An asterisk (*) will appear to the right of an incorrect entry, or above and below in formulas. Notes:
Enter a zero in cells you would otherwise leave blank. If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " "
If number-entry or blank-entry box is incorrect, returns "*"
A. Differential Analysis If number-entry or blank-entry box is correct, returns single space, " "
Sell Regular (Alt. 1) or Process Further into Decaf (Alt. 2) Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct.
October 6 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Process Futher Differential Effect
Sell Regular Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues
Costs
Income (loss)
B.
The differential revenue from processing further to Decaf Columbian is
the differential cost of processing further. Thus, Rise N' Shine Coffee
process further into Decaf Columbian.
Accounts Receivable
C. Accounts Payable
The decrease in selling price of Decaf Columbian that would cause neither an advantage or
disadvantge for processing further:
Net Advantage of Further Processing = =
cpence: An answer will appear here when both numbers are entered in the formula.
Volume of Decaf Columbian
The current selling price less the decrease would be:
Verify by completing the following differential analysis based on the new selling price:
Sell Process Futher Differential Effect
Regular Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues
Costs
Mark Sears: Enter costs as negative amounts.
Mark Sears: Enter costs as negative amounts.
Income (loss)

Sol

Exercise 24(10)-12
Name: Solution
Section:
Score: ON
Instructions
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
An asterisk (*) will appear to the right of an incorrect entry, or above and below in formulas.
Enter a zero in cells you would otherwise leave blank.
A. Differential Analysis
Sell Regular (Alt. 1) or Process Further into Decaf (Alt. 2)
October 6
Process Futher Differential Effect
Sell Regular Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues $ 55,320 $ 67,716 $ 12,396
Costs (33,000)
Mark Sears: Enter costs as negative amounts.		 (43,230) (10,230)
Income (loss) $ 22,320 $ 24,486 $ 2,166
B.
The differential revenue from processing further to Decaf Columbian is more than
the differential cost of processing further. Thus, Rise N' Shine Coffee should
process further into Decaf Columbian.
C.
Increase in selling price of Decaf Columbian that would cause neither an advantage or
disadvantge for processing further:
Net Advantage of Further Processing = $2,166 = $0.38
cpence: The answer will appear here when the correct numbers are entered in the formula.
Volume of Decaf Columbian 5,700
The current selling price less the decrease would be: $11.50
Verify by completing the following differential analysis based on the new selling price:
Sell Regular Process Futher Differential Effect
Columbian Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues $ 55,320 $ 65,550 $ 10,230
Costs (33,000)
Mark Sears: Enter costs as negative amounts.
Mark Sears: Enter costs as negative amounts.		 (43,230) (10,230)
Income (loss) $ 22,320 $ 22,320 $ -