ACCT 343 - Assignment 5 Parts Inventory Excel tools used (not including formatting): Freezing Rows and columns Conditional formatting Filtering Tables You are the production accountant at Marietta Products, Inc. Part of your job is to give parts information to your supervisor (the production manager) when requested. You have a large database of all parts used in the production of your company's two products (Product 789 and Product 889) for the month of February 2021. You have just updated the data set and are ready to use Excel to help you answer your supervisor's questions. Your supervisor has asked you the following: 1. Which parts are located in Bin G6? 2. Do we have any parts that have a quantity on hand less than 10 but no quantity on order? 3. Which of our parts are used in both products? 4. Do we have any parts used in Product 789 that are located in one of the C bins? 5. Do either Clark or Smith supply us with any parts used in both products? Required: 1. Download the INVENTORY workbook available on Canvas. Save it as INVENTORY_YOUR NAME. (Use your own first initial and last name.) The first worksheet Includes the part inventory data set 2. Copy the data on the LIST worksheet to a new worksheet and name it Format Freeze the top row and the first column. Using conditional formatting, answer your supervisor's first three questions a. Place the conditional formatting for Question 1 in Column C. Use Column E for Question 2. Use Column A for Question 3. b. HINT: You'll need to create new rules for Questions 2 and 3. 3. Copy the data on the LIST worksheet to a new worksheet and name it Filter. Using filtering, ACCT 343 - Assignment 5 Parts Inventory Excel tools used (not including formatting): Freezing Rows and columns Conditional formatting Filtering Tables You are the production accountant at Marietta Products, Inc. Part of your job is to give parts information to your supervisor (the production manager) when requested. You have a large database of all parts used in the production of your company's two products (Product 789 and Product 889) for the month of February 2021. You have just updated the data set and are ready to use Excel to help you answer your supervisor's questions. Your supervisor has asked you the following: 1. Which parts are located in Bin G6? 2. Do we have any parts that have a quantity on hand less than 10 but no quantity on order? 3. Which of our parts are used in both products? 4. Do we have any parts used in Product 789 that are located in one of the C bins? 5. Do either Clark or Smith supply us with any parts used in both products? Required: 1. Download the INVENTORY workbook available on Canvas. Save it as INVENTORY_YOUR NAME. (Use your own first initial and last name.) The first worksheet Includes the part inventory data set 2. Copy the data on the LIST worksheet to a new worksheet and name it Format Freeze the top row and the first column. Using conditional formatting, answer your supervisor's first three questions a. Place the conditional formatting for Question 1 in Column C. Use Column E for Question 2. Use Column A for Question 3. b. HINT: You'll need to create new rules for Questions 2 and 3. 3. Copy the data on the LIST worksheet to a new worksheet and name it Filter. Using filtering
