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:
3.
Total estimated revenue from operating store 1,264,000$
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Retail Store or Invest in Bonds
Estimated Income from Operations
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.
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
Estimated Income from Operations
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Warehouse 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.
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:
Estimated Income from Operations
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.
Operate Warehouse or Invest in Bonds
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
Continue with Old Machine or Replace with New Machine
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. 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:
Cells with non-gray backgrounds are protected and cannot be edited.
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?
Continue with Old Machine or Replace with New Machine
Answers are entered in the cells with gray backgrounds.
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
Continue with Old Machine or Replace Old Machine
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. 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$
Costs:
Cells with non-gray backgrounds are protected and cannot be edited.
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?
Continue with Old Machine or Replace Old Machine
Answers are entered in the cells with gray backgrounds.
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)
Answers are entered in the cells with gray backgrounds.
The sales manager’s tentative decision should be opposed. The sales manager erroneously
Promote Moisturizer or Promote Perfume
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.
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.
Promote Tennis Shoe or Promote Walking Shoe
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. 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:
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 (additional) costs. An
Promote Tennis Shoe or Promote Walking Shoe
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
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. The essay answer will not be graded.
1. High Good Regular
Selling price 280$ 270$ 250$
2. High Good Regular
Contribution margin per unit 10.00$ 21.00$ 20.00$
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. The essay answer will not be graded.
Selling price
Variable conversion cost per unit
Direct materials cost per unit
Total cost per unit
Contribution margin per unit
2.
Ethylene Butane Ester
Contribution margin per unit
Divided by reactor (bottleneck) hours per unit
Contribution margin per reactor hour
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. The essay answer will not be graded.
Selling price 170$ 155$ 130$
Variable conversion cost per unit 40$ 40$ 30$
Ethylene Butane Ester
Contribution margin per unit 15$ 27$ 15$
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. The essay answer will not be graded.
1. Production Setup Inspection Shipping Cust. Serv.
Total activity cost
Divided by total activity base mh setups inspections cust. orders requests
Activity rate
2.
Activity Activity Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Production mh mh mh
Setup setups setups setups
Inspection insp. insp. insp.
Shipping cust. orders cust. orders cust. orders
Customer service requests requests requests
Total
Number of units
Activity cost per unit
3.
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. Production Setup Inspection Shipping Cust. Serv.
2.
Activity Activity Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Production 2,000 mh $55 110,000$ 1,250 mh $55 68,750$ 1,250 mh $55 68,750$
3.
The unit costs are different even though each product requires 0.25 machine hour
because the products consume many activities in ratios different from the volume. For
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. The essay answer will not be graded.
1. Production Setup Moving Shipping
Total activity cost
Divided by total activity base mh setups moves cust. orders test runs
Activity rate
2.
Activity Activity Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Production mh mh mh
Setup setups setups setups
Moving moves moves moves
Shipping cust. orders cust. orders cust. orders
Product engineering test runs test runs test runs
Total
Number of units
Activity cost per unit
3.
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. Production Setup Moving Shipping Prod. Engineering
Total activity cost 220,000$ 117,000$ 21,000$ 105,000$ 102,000$
2.
Activity Activity Activity Activity Activity Activity
Activity
Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost Activity Base Usage Rate =Cost
Production 400 mh $200 80,000$ 500 mh $200 100,000$ 200 mh $200 40,000$
Setup 80 setups $450 36,000 30 setups $450 13,500 150 setups $450 67,500
3.
The unit costs are different even though each product requires 0.4 machine hour
because the products consume many activities in ratios different from the volume. For
Cells with non-gray backgrounds are protected and cannot be edited.
Answers are entered in the cells with gray backgrounds.