1. The objective in this project is for the Marketing Department to determine the quantity of each item in the product line included in the beginning inventory.

2. How many items were included in the beginning inventory in the tutorial.

3. The beginning inventory appears on the Income Statement

4. If we are a new business, the cost of goods sold number is

5. To find the cost of each item

6. To find the sum of a column whose top cell is c3 and the bottom is c33, use the following formula

7. Formulas in Excel cannot be copied and pasted.

8. Total value is calculated by

9. =Sum(J6:J39) does what?

10. Cells that contain dollars and cents should be formated as General?

11 Remember the total beginning inventory must equal?

12. The perpetual inventory spread sheet has a formula for each product that adds the amount on hand with purchases and deducts sales of items to give a final quantity

13. In the template, the final _______ is multiplied by the cost price to get the total value for the inventory item.

14. Remember, that each month you must decide on which items to purchase.

15. After open houses, trade fairs and your grand opening, key into the template?

First Name

Last Name

Score