Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Spend Analysis Item List Appendix A Item Description Annual Usage Qty / unit Unit Price Syringes, disposable, 1 0 cc 7 0 0 cs /
Spend Analysis Item List Appendix A
Item Description Annual Usage Qtyunit Unit Price
Syringes, disposable, cc cs $ cs
Needle, single sample, G cscs
Needle, multisample, G CsCS
Saline Solution, NaCl cscs
Intraocular Lens, various diopters each ea
Gauze Sponges, xsterile cscs
Gauze Sponges, x bulk cscs
Petri Dish, blank, mm cscs
Total Hip Implant each ea
Total Knee Implant each ea
Surgeons Gown, disposable, large cscs
Surgeons Gown, disposable, small cscs
Test Reagent Kit, HCl bxbx
Sensitivity Disc, multi pkpk
Dish, TSA Blood Plate, mm ctnctn
Suture, Chromic Gut, O bxbx
Suture, Silk, taper needle bxbx
Staple, surgical, EndoGIA, reload bxbx
Collector, Specimen, urine, Mexican Hat cscs
Catheter, male, silicone, shortterm bxbx
SECTION
Use Excel or a similar database to create a spreadsheet for the attached information describing healthcare products. The spreadsheet should have column headings similar to the data sheet, expanded to include columns like those on the attached Spend Analysis Template. As you proceed through the sections of this assignment, calculate the described steps for each product before proceeding to the next section.
Extend the Annual Usage and the Unit Cost for each item to determine the Total Annual Spend for each item. Annual Usage x Unit Price Total Annual Spend per item
When all line items have been calculated, use the spreadsheet feature to Sum the Total Cumulative Annual Spend for all items.
SECTION
Rearrange the order of items, listing the largest individual total as line item then listing each consecutive item total in descending order. That is the second largest total spend becomes line item the third largest is next, and so on All twenty products should be arranged until the lowest total spend is listed as line item With the product listing rearranged in descending order, it is now possible to determine the ABC classification of the products.
SECTION
In your worksheet, place a SubTotal marker after the required number of A items. Remember A Class items represent of line items, so that should be items from a list of Do the same for the B group, and the remaining items will represent the C items.
Calculate a subtotal for the A Class items, then for the B Class items, and finally for the C Class Group.
Compare your results to the expected range A Class should represent about of the total cumulative spend; B Class subtotal should be about a further of the total cumulative spend; the C Class group will represent about as little as of the overall total.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started