Unlock access to all the studying documents.
View Full Document
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
a.
(Alternative 1) (Alternative 2) (Alternative 2)
Variable cost of goods sold
Variable selling and admin. expenses
Fixed costs
Income (loss)
The Cups line should be since income
would by if the cups were discontinued.
Continue or Discontinue Cups
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.
Enter a zero in cells you would otherwise leave blank.
a.
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 31,300$ –$ (31,300)$
Costs:
b.
The Cups line should be retained since income
Continue or Discontinue Cups
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
a.
Make Carrying Buy Carrying
(Alternative 1) (Alternative 2) (Alternative 2)
Direct materials per unit
Variable factory overhead per unit
Fixed factory overhead per unit
Income (loss)
Assuming there are no better uses for the spare capacity,
the carrying cases should be since costs per unit
would by by doing so.
The fixed factory overhead is to the decision.
Make or Buy Carrying Case
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.
Enter a zero in cells you would otherwise leave blank.
a.
Make Carrying Buy Carrying
(Alternative 1) (Alternative 2) (Alternative 2)
b.
Assuming there are no better uses for the spare capacity,
the carrying cases should be manufactured since costs per unit
Make or Buy Carrying Case
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Direct labor per unit
An asterisk (*) will appear to the right of an incorrect entry. Essay answers will not be graded
Enter a zero in cells you would otherwise leave blank.
a.
Internally Layout Services on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Costs:
Purchase price of layout work
Salaries
Benefits
Supplies
Computer depreciation
Income (loss)
b.
c.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Layout Pages Internally or Purchase Layout Services
An asterisk (*) will appear to the right of an incorrect entry. Essay answers will not be graded.
Enter a zero in cells you would otherwise leave blank.
a.
Internally Layout Services on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Costs:
Purchase price of layout work – (312,000) (312,000)
Salaries (224,000) – 224,000
Layout Pages Internally or Purchase Layout Services
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
The benefit from using an outside service is shown to be $8,000 greater than performing the layout work
Before electing to terminate the five employees, the guild should consider the long-run impact of the
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
a.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Sales (5 years)
Costs:
Purchase price
Direct materials (5 years)
Power and maintenance (5 years)
Taxes, insurance, etc. (5 years)
Selling and admin. expenses (5 years)
Income (loss)
The proposal be accepted.
c.
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. The essay answer will not be graded.
Enter a zero in cells you would otherwise leave blank.
a.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Sales (5 years) 1,025,000$ 1,025,000$ –$
Costs:
Purchase price – (180,000) (180,000)
The proposal should not be accepted.
c.
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
In addition to the factors given, consideration should be given to such factors as: Do both present
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.
Columbian 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.
The decrease in selling price of Decaf Columbian that would cause neither an advantage or
disadvantge for processing further:
The current selling price less the decrease would be:
Verify by completing the following differential analysis based on the new selling price:
Columbian Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues
Costs
Income (loss)
Volume of Decaf Columbian
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Sell Regular Columbian or Process Further into Decaf Columbian
Net Advantage of Further Processing
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.
Columbian Into Decaf on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 55,320$ 67,716$ 12,396$
Increase in selling price of Decaf Columbian that would cause neither an advantage or
disadvantge for processing further:
$2,166
5,700
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Sell Regular Columbian or Process Further into Decaf Columbian
Net Advantage of Further Processing
Volume of Decaf Columbian
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.
Reject Order Accept Order on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues
Costs:
Direct materials
Direct labor
Variable factory overhead
Variable selling and admin. expenses
Shipping costs
Certification costs
Income (loss)
Goodman accept the special order from Euro Motors.
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Differential Income from
Accepting Special Order
Selling Price Offered
by Euro Motors
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.
Reject Order Accept Order on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues –$ 2,320,000$ 2,320,000$
Costs:
Direct materials – (1,120,000) (1,120,000)
2,234,000
20,000
Alternative calculation:
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
An asterisk (*) will appear to the right of an incorrect entry.
a.
Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Fabrication mh mh
Assembly dlh dlh
Setup setups setups
Inspecting insp. insp.
Production scheduling prod. orders prod. orders
Purchasing purch. ord. purch. ord.
Total
Number of units
Activity cost per unit
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.
a.
Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Fabrication 1,680 mh $22 36,960$ 1,070 mh $22 23,540$
Assembly 243 dlh $12 2,916 131 dlh $12 1,572
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.