Good Morning Team,

Attached is all the excel resources in 1 workbook. In order I have them:

-Invoice 1

-Invoice 2

-Invoice 3

-2006 Trial Balance

-2007 Trial Balance

-Inventory Lead Schedule

-Inventory Status Report

-Inventory Warehouse Report

Step 1:

There are 7 pages of Bradley's test counts so we can all do 2 and then 1 person does 1 page. Tie sum of the count on the test page to the Inventory Warehouse report then tie that same number to the Quantity for 2007 in the Inventory Status Report. If the numbers do not tie then be sure to show it in the slide, maybe expand on possible reasons why (if any can be found in the minutes)

1. Rachael

2. Rachael

3. Rodney

4. Rodney

5. Robert

6. Robert

7. Samantha

Step 2:

Sample Unit Costs and from recent invoices and tie them to Inventory Status Report. Randomly below I have the selections if you all are cool with it.

Rachael - Mens/Womens Siren (different size from each invoice, mix up genders)

Rodney - Mens/Womens Speaker (different size from each invoice, mix up genders, such as 2 men and 1 womens)

Robert - Mens Spotlight (different size from each invoice)

Samantha - Womens Spotlight (different size from each invoice)

Step 3:

Tie Inventory status Report into the Inventory Lead Schedule. To complete this sum the counts of each shoe in row K (K44+K77+K116) and tie it to cell F8 in the inventory lead schedule.

-Robert, would you mind completing this task?

Step 4:

Tie the Inventory Lead Schedule to the 2007 Trial Balance. This is tying cell F8 in the ILS to the Inventory balance in the Trial Balance.

-Rodney, would you mind completing this portion?

Remember this all has to be in presentation format. It's probably going to look like a lot of math problems, just make sure to label every number :D

See y'all Monday!

Respectfully,

Rachael Toel

Words: 295

Good Morning Team,

Attached is all the excel resources in 1 workbook. In order I have them:

-Invoice 1

-Invoice 2

-Invoice 3

-2006 Trial Balance

-2007 Trial Balance

-Inventory Lead Schedule

-Inventory Status Report

-Inventory Warehouse Report

Step 1:

There are 7 pages of Bradley's test counts so we can all do 2 and then 1 person does 1 page. Tie sum of the count on the test page to the Inventory Warehouse report then tie that same number to the Quantity for 2007 in the Inventory Status Report. If the numbers do not tie then be sure to show it in the slide, maybe expand on possible reasons why (if any can be found in the minutes)

1. Rachael

2. Rachael

3. Rodney

4. Rodney

5. Robert

6. Robert

7. Samantha

Step 2:

Sample Unit Costs and from recent invoices and tie them to Inventory Status Report. Randomly below I have the selections if you all are cool with it.

Rachael - Mens/Womens Siren (different size from each invoice, mix up genders)

Rodney - Mens/Womens Speaker (different size from each invoice, mix up genders, such as 2 men and 1 womens)

Robert - Mens Spotlight (different size from each invoice)

Samantha - Womens Spotlight (different size from each invoice)

Step 3:

Tie Inventory status Report into the Inventory Lead Schedule. To complete this sum the counts of each shoe in row K (K44+K77+K116) and tie it to cell F8 in the inventory lead schedule.

-Robert, would you mind completing this task?

Step 4:

Tie the Inventory Lead Schedule to the 2007 Trial Balance. This is tying cell F8 in the ILS to the Inventory balance in the Trial Balance.

-Rodney, would you mind completing this portion?

Remember this all has to be in presentation format. It's probably going to look like a lot of math problems, just make sure to label every number :D

Please only answer the ones that say Robert only please.

Thank You