Product classification exercise | Management homework help


Team Case Assignment: Product Classification for Spend Analysis


A volunteer Humanitarian Assistance operation, Iraq Displaced Relief (IDR), has been operating in Balad, Iraq since the beginning of the year supporting displaced people in Iraq. IDR is a relatively new non-profit organization focused on providing basic medical supplies and healthcare to refugees in war-torn countries. The organization’s venture into Iraq is a new experience in the complexities of running a complicated supply chain, even on a very small scale. You have been asked to help analyze Iraq Displaced Relief’s expenditures to see if there are ways that their supply chain can be simplified so that IDR may better leverage their total spend. Your analysis will form the basis of a report to be shared not only with the leadership of IDR but also with many of their key charitable contributors.

The group’s health and welfare expenses — the day-to-day needs required to live in an austere environment such as Balad — are all funded through charitable donations of cash or commodities from church groups located across the United States. In Balad, Iraq Displaced Relief distributes medical supplies from the donated warehouse and office space. IDR purchases necessary medical supplies and distributes configured packages to a number of local Iraqi agencies. The local agencies deliver the items to villages throughout central Iraq. The majority of funding for the medical supplies comes from a number of charitable trusts from the Midwest United States. Although automation support is severely limited, the group does keep track of its expenditures using a rudimentary excel spreadsheet. IDR’s Director of Purchasing, a volunteer herself, has provided you with an Excel spreadsheet listing the top expenditures for the last month.

Details on the spreadsheet:

The spreadsheet lists the top expenditures for medical supplies for the month of August 2009. The table includes information on the Source of the Material, the Part number that is used to track the item, a short Product description, the number of purchases and the total dollar value spent on that item for the month.

The Stock-keeping unit or Part Number used by IDR is an internally derived number, which represents the Vendor’s Identification number. Although an alpha character was originally designed to signify a specific vendor, the alpha character now is only used to signify the type of material. SKUs starting with A through E represent items generally considered to be medical or surgical in nature — covering everything from bandages to surgical gloves to sutures. SKUs starting with F are generally regarded as pharmaceutical items. SKUs starting with M characterize either durable items (items that can be reused many times) or equipment items.

The alpha characters are not shown in the spreadsheet for your team exercise. For your team assignment, categorize the items listed according to the scheme suggested in the previous bullet point. Add an alpha character to identify a product category as described above. You may have approximately five groups (A through E) representing items generally considered to be medical or surgical in nature. Please note that the “correct” solution has five categories.

Identify pharmaceutical items with an F and durable items or equipment with M. For example, Allegra-D, identified by 00088-1090-47 would be categorized F00088-1090-47, and so on for all of the other items.

The Vendor, Product Nomenclature (although often undecipherable except by IDR volunteers), the numbers of purchases, and the total value of purchases are generally considered to be accurate data.

 Spreadsheet Download  Solution Template File. This file should be used for this assignment.

Assignment Deliverable

Deliverable: The deliverable for this assignment is a spreadsheet file with your item classifications, labeled by an alpha character. Please turn in the spreadsheet sorted by SKU number.

Submit Assignment: Please have one team member submit your team’s file into the M3L1 Dropbox: Team Project: Product Classification Exercise by clicking on the “Next” button at the bottom of this content page. Include your team number in the file name.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Australia Assessments
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Several grammar issues identified.
Customer 462821, April 6th, 2022
Finance/Acc related
Great job!
Customer 460073, August 14th, 2022
Good job
Customer 456821, November 13th, 2022
Business and administrative studies
Thank you!
Customer 453187, February 21st, 2022
Political science
Great job God bless you
Customer 453983, February 4th, 2020
Business and administrative studies
Thank you!
Customer 453187, April 3rd, 2022
Business and administrative studies
Customer 459947, April 6th, 2022
good job
Customer 456821, June 11th, 2022
Nice. Be keen on instructions.
Customer 462787, April 1st, 2022
Fav writer
Customer 454223, June 15th, 2020
Excellent work. Looking forward to working with you in the future.
Customer 463467, November 2nd, 2022
Customer 452441, April 19th, 2022
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat