This project demonstrates how Excel can be used to create a variety of useful documents for small businesses.

a. Read the article “A Do-It-Yourself Automated Invoicing System,” by Jacob M. Rose, which appeared in the April 2004 issue of the Journal of Accountancy. A copy of the article can be downloaded from the Journal’s archives at the AICPA’s Web site (www.aicpa.org).

b. Adapt the steps described in the article to create a Purchase Order instead of a sales invoice.

c. Add appropriate input edit controls to ensure compliance with the following objectives. Your controls should display an informative error message that clearly explains the problem:

1. All product numbers should fall within the range 101-999.

2. Purchases cannot exceed 1,000 units for any item.