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.
1.
Retail Store in Bonds on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Costs to operate retail store
Cost of equipment less residual value
Income (loss)
The proposal to operate the retail store should be
3.
Total estimated revenue from operating store
Total estimated expenses to operate store:
Cost to operate store, excluding depreciation
Cost of store equipment less residual value
Total estimated income from operating store
Estimated Income from Operations
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Retail Store or Invest in Bonds
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.
1.
Retail Store in Bonds on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 1,264,000$ 172,800$ (1,091,200)$
Costs:
2.
The proposal to operate the retail store should be rejected
3.
Total estimated revenue from operating store 1,264,000$
Total estimated expenses to operate store:
Estimated Income from Operations
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Retail Store or Invest in Bonds
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Warehouse in Bonds on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues
Costs:
Costs to operate warehouse
Cost of equipment less residual value
Income (loss)
The proposal to operate the warehouse should be
3.
Total estimated revenue from operating warehouse
Total estimated expenses to operate warehouse:
Cost to operate warehouse, excluding depreciation
Cost of equipment less residual value
Total estimated income from operating warehouse
Answers are entered in the cells with gray backgrounds.
Estimated Income from Operations
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Warehouse or Invest in Bonds
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Warehouse in Bonds on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 3,640,000$ 518,000$ (3,122,000)$
Costs:
2.
The proposal to operate the warehouse should be accepted
3.
Total estimated revenue from operating warehouse 3,640,000$
Total estimated expenses to operate warehouse:
Answers are entered in the cells with gray backgrounds.
Operate Warehouse or Invest in Bonds
Estimated Income from Operations
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.
1.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Proceeds from sale of old machine
Costs:
Annual manufacturing costs (6 yrs.)
Income (loss)
The proposal to replace the machine should be
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Continue with Old Machine or Replace with New Machine
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.
1.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Proceeds from sale of old machine –$ 29,700$ 29,700$
Costs:
Other factors to be considered include:
a. Are there any improvements in the quality of work turned out by the new machine?
b. What effect does the federal income tax have on the decision?
c. What opportunities are available for the use of the $90,000 of funds ($119,700 less $29,700 proceeds
from the old machine) that are required to purchase the new machine??
Continue with Old Machine or Replace with New Machine
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.
1.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Proceeds from sale of old machine
Costs:
Annual manufacturing costs (6 yrs.)
Income (loss)
The proposal to replace the machine should be
Answers are entered in the cells with gray backgrounds.
Cells with non-gray backgrounds are protected and cannot be edited.
Continue with Old Machine or Replace Old Machine
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.
1.
Old Machine Old Machine on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues:
Proceeds from sale of old machine –$ 12,900$ 12,900$
Other factors to be considered include:
a. Are there any improvements in the quality of work turned out by the new machine?
b. What effect does the federal income tax have on the decision?
c. What opportunities are available for the use of the $44,100 of funds ($57,000 less $12,900 proceeds
from the old machine) that are required to purchase the new machine?
Continue with Old Machine or Replace Old Machine
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.
1.
Moisturizer Perfume on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Variable factory overhead
Variable operating expenses
Income (loss)
Parisian should promote the
2.
Answers are entered in the cells with gray backgrounds.
Promote Moisturizer or Promote Perfume
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.
1.
Moisturizer Perfume on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 1,210,000$ 1,200,000$ (10,000)$
Costs:
(198,000) (280,000) (82,000)
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
The sales manager’s tentative decision should be opposed. The sales manager erroneously
considered the full unit costs instead of the differential (additional) revenue and differential
Promote Moisturizer or Promote Perfume
Variable factory overhead
Sales promotion
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.
1.
Tennis Shoe Walking Shoe on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Variable factory overhead
Variable operating expenses
Income (loss)
Sole Mates should promote
2.
Answers are entered in the cells with gray backgrounds.
Promote Tennis Shoe or Promote Walking Shoe
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.
1.
Tennis Shoe Walking Shoe on Income
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 595,000$ 700,000$ 105,000$
Costs:
(133,000) (224,000) (91,000)
Direct labor (56,000) (84,000) (28,000)
Answers are entered in the cells with gray backgrounds.
The sales manager’s tentative decision should be opposed. The sales manager erroneously considered
Promote Tennis Shoe or Promote Walking Shoe
Cells with non-gray backgrounds are protected and cannot be edited.
Variable factory overhead
Sales promotion
An asterisk (*) will appear to the right of an incorrect entry. The essay answer will not be graded.
1. High Good Regular
Selling price
Variable conversion cost per unit
Direct materials cost per unit
Total cost per unit
Contribution margin
2. High Good Regular
Contribution margin per unit
Divided by furnace (bottleneck) hours per unit
Contribution margin per furnace hour
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.
1. High Good Regular
Selling price 280$ 270$ 250$
Variable conversion cost per unit 180$ 165$ 150$
2. High Good Regular
Contribution margin per unit 10.00$ 21.00$ 20.00$
Answers are entered in the cells with gray backgrounds.
The Good Grade steel has the largest contribution margin per unit ($21); however, the Regular grade has
the largest contribution margin per furnace hour ($8). Thus, using production bottleneck analysis
Cells with non-gray backgrounds are protected and cannot be edited.