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.
Operate Invest Differential
Warehouse in Bonds Effects
Costs:
Costs to operate warehouse
Cost of equipment less residual value
Profit (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 expenses
Total estimated income from operating warehouse
Answers are entered in the cells with gray backgrounds.
Estimated Operating Income
Cells with non-gray backgrounds are protected and cannot be edited.
Operate Warehouse (Alt. 1) or Invest in Bonds (Alt. 2)
An asterisk (*) will appear to the right of an incorrect entry.
Enter a zero in cells you would otherwise leave blank.
1.
Operate Invest Differential
Warehouse in Bonds Effects
(Alternative 1) (Alternative 2) (Alternative 2)
Revenues 3,640,000$ 518,000$ (3,122,000)$
3.
Answers are entered in the cells with gray backgrounds.
Operate Warehouse (Alt. 1) or Invest in Bonds (Alt. 2)
Estimated Operating Income
Cells with non-gray backgrounds are protected and cannot be edited.