Question

Create an Excel workbook with two separate sheets in it, each titled appropriately: one for the bookshop’s current inventory, and one for a list of items to restock.

The owner notes that he’s a bit new to digital inventories, but needs to keep track of information like:

Book titles
Acquisition costs
Sale costs
Quantity in stock
Date of publication

Answer 1

To create an Excel workbook for a bookshop's inventory management, you can follow these steps. Below is a guide on how to structure the sheets, as I cannot create the file directly. You can easily replicate this in Excel:

### Step 1: Create a New Excel Workbook
Open Excel and select "New Workbook".

### Step 2: Create the First Sheet - Current Inventory
1. **Rename the first sheet**: Double-click on the tab at the bottom (Sheet1) and rename it to "Current Inventory".
2. **Set up columns**: In the first row, starting from cell A1, enter the following column headers:
- A1: **Book Title**
- B1: **Acquisition Cost**
- C1: **Sale Cost**
- D1: **Quantity in Stock**
- E1: **Date of Publication**

3. **Format the headers**: Bold the text in row 1 and you may want to apply a background color for clarity.
4. **Adjust column widths**: You can widen the columns to ensure all text is visible.

### Example Data (Optional):
You might want to enter some example data below the headers to visualize your inventory. For instance:
```
| Book Title | Acquisition Cost | Sale Cost | Quantity in Stock | Date of Publication |
|-------------------------|------------------|-----------|-------------------|---------------------|
| The Great Gatsby | $10.00 | $15.00 | 5 | 1925-04-10 |
| 1984 | $8.00 | $12.00 | 10 | 1949-06-08 |
| To Kill a Mockingbird | $12.00 | $18.00 | 7 | 1960-07-11 |
```

### Step 3: Create the Second Sheet - Restock List
1. **Add a new sheet**: Click the "+" button next to the first sheet to add a new sheet.
2. **Rename the second sheet**: Change the sheet name to "Restock List".
3. **Set up columns**: In the first row, starting from cell A1, enter the following column headers:
- A1: **Book Title**
- B1: **Acquisition Cost**
- C1: **Sale Cost**
- D1: **Quantity Needed**
- E1: **Reason for Restock**

4. **Format the headers**: Similar to the first sheet, bold the text in row 1 and apply a background color.
5. **Adjust column widths**: Ensure all text is visible.

### Example Data (Optional):
You might add hypothetical items that need restocking:
```
| Book Title | Acquisition Cost | Sale Cost | Quantity Needed | Reason for Restock |
|-------------------------|------------------|-----------|-----------------|---------------------------|
| The Great Gatsby | $10.00 | $15.00 | 3 | Low stock |
| 1984 | $8.00 | $12.00 | 5 | Popularity increase |
```

### Step 4: Save the Workbook
After you finalize the design and data on both sheets, don’t forget to save your workbook. Go to `File > Save As`, choose your desired location, and provide a name for the file (e.g., "Bookshop Inventory.xlsx").

### Step 5: Use Features for Enhancements (Optional)
- **Data Validation**: You can set data validation for the quantity fields to ensure they are numerical.
- **Formulas**: Use formulas to calculate total value in stock (Acquisition Cost * Quantity in Stock).
- **Conditional Formatting**: Highlight rows in the Restock List based on specific criteria (e.g., if Quantity Needed > X).

This structure will help the bookshop owner efficiently manage their inventory and track restocking needs.