Table 2: One-Time Costs

One-Time Costs	Approximate Dollar value
Development Personnel	$100,000
Training	$45,000
Project-Related Technology Purchases	$42,000
Site Preparation	$58,500
Miscellaneous
Conference-Related	$6,000
Supplies	$1,908
Duplication	$3,249

Table 3: Yearly Recurring Costs

Cost	Approximate Dollar Value
Software Maintenance	$50,000
Hardware	$45,000
Supplies	$25,000
IT Positions (1 person)	$58,000
Site Rental	$24,000

Design Specifications

Since the project is in the early stages of development, you want your workbook to be as flexible as possible, so that additional costs and benefits, when identified, are easily added to the Economic Feasibility workbook. You decide that the Economic Feasibility workbook should contain at least five worksheets: Documentation, One-Time Cost, Recurring Cost, Tangible Benefit, and Economic Feasibility Summary. The Documentation worksheet provides information about the creator, each individual worksheet, and the date created. (Your professor will provide additional guidelines for the Documentation worksheet.)

You decide to construct the One-Time Cost, recurring Cost, and Tangible Benefit worksheets first, since these worksheets have a simple design. These worksheets each contain two columns, with the first column identifying the items in the category, and the second column containing the dollar values associated with the items. Each worksheet totals the dollar values; these totals are then used in the Economic Feasibility Summary worksheet.

As Figure 1 shows, the Economic Summary worksheet has a more complex design. Since the Economic Feasibility Summary worksheet is a summary worksheet, it consolidates data from the One-Time Cost, Recurring Cost, and Tangible Benefit worksheets, requiring you to reference specific cells on these worksheets.