Acct 315 Ai + Excel Practice Submission

Overview In this activity, you will use the provided Excel file to practice two important business data preparation tasks: 1. Create a new item code by removing the term “AG” from the beginning of the current Item ID and adding “AGI-” to the front. 2. Separate the data into Finished Goods and Components so the file can be used in Bill of Material (BOM) creation. You are encouraged to use AI as a support tool to help you think through the formula and organization of the data. Your job is not just to get an answer, but to understand why the formula works and how the data should be grouped for manufacturing purposes. Learning Objectives By the end of this activity, you should be able to: • Use AI to help develop and explain an Excel formula • Modify item codes using text functions in Excel • Organize data for manufacturing and BOM preparation • Distinguish between Finished Goods and Components based on item characteristics Your Tasks Part 1: Create a New Item Code Add a new column called New Item Code. In this column, create a formula that: • removes AG from the beginning of the current Item ID but NOT from any other place in the field • adds AGI- to the front of the remaining code Example If the original Item is: AGLFR112-COATING the new item code should become: AGI-LFR112-COATING Part 2: Use AI to Help Build the Formula Use an AI tool to help you determine an Excel formula that will complete the item code update. You should ask AI a question similar to this: I have an Excel column called Item. Each item begins with AG. I need an Excel formula that removes AG from the beginning of the item code and adds AGI- in front of the remaining text. For example, AGLFR112-COATING should become AGI-LFR112-COATING. After AI gives you a suggestion, test it in Excel and make sure it works correctly. This formula assumes the original Item value is in A2. It works by: • counting the total number of characters • removing the first 2 characters (AG) • adding AGI- to the front You may also find another correct formula using AI. If so, that is acceptable as long as it works correctly.