Objectives

Question

Create a spreadsheet that tracks inventory.
Directions
Part 1: Create a spreadsheet with the following data.

Item Description Purple Stock White Linen Half Cream Stock 5x7 Greeting
Item Number 0059 0067 0098 1021
Unit Ream Ream 20 Dozen
Current Number of Units 346 456 908 546
Item Description 4x6 Greeting Black Stock 11x14Office 8x10 Office
Item Number 1022 0068 2033 2032
Unit Ream Ream 20 Dozen
Current Number of Units 346 456 908 546
Part 2: Solve Steve's business problem. Add two rows. Label them "Purchased Today" and "Total in Stock." Add formulas to the spreadsheet so that Steve can keep the inventory current by adding new purchases and subtracting orders. (Fill in the "Purchased Today" row with numbers of your choice.)

Question # 1
File Upload
Upload your spreadsheet.

Answer 1

As a text-based AI, I don't have the capability to create or upload files directly. However, I can guide you step-by-step through the process of creating an inventory tracking spreadsheet in a program like Microsoft Excel or Google Sheets.

Step 1: Create the Initial Spreadsheet

1. Open Excel or Google Sheets and create a new spreadsheet.

2. Set up the columns. In the first row, from A1 to G1, type the following headers:

   • Item Description
   • Item Number
   • Unit
   • Current Number of Units
   • Purchased Today
   • Total in Stock

3. Enter the data as follows:

   | Item Description | Item Number | Unit | Current Number of Units | Purchased Today | Total in Stock | |----------------------|-------------|--------|-------------------------|------------------|-----------------| | Purple Stock | 0059 | Ream | 346 | 0 | =D2+E2 | | White Linen | 0067 | Ream | 456 | 0 | =D3+E3 | | Half Cream Stock | 0098 | 20 | 908 | 0 | =D4+E4 | | 5x7 Greeting | 1021 | Dozen | 546 | 0 | =D5+E5 | | 4x6 Greeting | 1022 | Ream | 346 | 0 | =D6+E6 | | Black Stock | 0068 | Ream | 456 | 0 | =D7+E7 | | 11x14 Office | 2033 | 20 | 908 | 0 | =D8+E8 | | 8x10 Office | 2032 | Dozen | 546 | 0 | =D9+E9 |

Step 2: Add "Purchased Today" and "Total in Stock"

4. In the 'Purchased Today' column, enter sample numbers for how many items were purchased:

   • For example, fill in:
     • Purple Stock: 20
     • White Linen: 10
     • Half Cream Stock: 50
     • 5x7 Greeting: 5
     • 4x6 Greeting: 15
     • Black Stock: 12
     • 11x14 Office: 30
     • 8x10 Office: 7

5. Update the 'Total in Stock' column formulas:

   • The formula in the 'Total in Stock' column will be:
     • =D2+E2, =D3+E3, etc., where you need to adjust for each row.

Final Spreadsheet Example

Your spreadsheet should look something like this, assuming the values entered into "Purchased Today" are filled as described:

| Item Description | Item Number | Unit | Current Number of Units | Purchased Today | Total in Stock | |----------------------|-------------|--------|-------------------------|------------------|-----------------| | Purple Stock | 0059 | Ream | 346 | 20 | 366 | | White Linen | 0067 | Ream | 456 | 10 | 466 | | Half Cream Stock | 0098 | 20 | 908 | 50 | 958 | | 5x7 Greeting | 1021 | Dozen | 546 | 5 | 551 | | 4x6 Greeting | 1022 | Ream | 346 | 15 | 361 | | Black Stock | 0068 | Ream | 456 | 12 | 468 | | 11x14 Office | 2033 | 20 | 908 | 30 | 938 | | 8x10 Office | 2032 | Dozen | 546 | 7 | 553 |

Step 3: Save and Upload

6. Save the file. In Excel, go to File -> Save As, choose your desired location and file type (Excel Workbook). In Google Sheets, it automatically saves online, but you can go to File -> Download to download as an Excel file or other formats.

7. Upload the Spreadsheet to your desired location or platform as needed.

If you follow these instructions, you should have a functional inventory tracking spreadsheet! If you need further assistance or specific details, feel free to ask.