I’m working on a Nursing question and need a reference to help me learn.

Supply Inventory Assignment

MAERB Standards

VI.C.10List steps involved in completing an inventoryVI.P.9Perform an inventory with documentation

TASK: Take on the role of the medical employee responsible for ensuring the medical facility includes all required inventory to ensure quality patient care and business operations. 

Part 1: 

1. Open the same previously completed workbook from the Service Log activity
2. Click on the worksheet: Supply Inventory
3. In cell B2  Step #- label each step (see sample in workbook)
4. In cell C2 through E2: key in the words to complete the step
5. List all the steps that are necessary for completing an inventory. This is a written assignment –  adjust cells to view all text
6. GUM, CUPS, and APA apply

Part 2: 

1. On the same excel worksheet create an inventory of three (3) different administrative office supplies.   (i.e. paper, paperclips, binders, erasers, staples, tape, pens, pencils, print cartridges, etc. . .)
2. create an inventory of three different clinical supplies  (i.e. gown gloves, masks, table paper, alcohol, 4 X 4 gauze, sanitizer, cleaning products, etc. . . )
3. Key in  how many the office  should have for the particular supply
4. Key current number in stock
5. Key reorder timeline
6. Inventory examples include Paper, paperclips, binders, erasers, staples, tape, pens, pencils, etc.  . . 
7. GUM, CUPS, and APA apply 
8. Save the excel workbook as Student First name Last Name First and Inventory VI.P.9, VI.C.10
9. Upload completed workbook here for manual grading
10. View Scoring Guide 10 pts. Included three different administrative and three different clinical supplies, # required, in stock, and reorder.

Sample Inventory

Inventory ItemRequiredCurrent inventoryReorder TimelineFile Folder Labels3 boxes2 boxesWhen the last box opened9 x 12 Envelopes1 box of 10040 envelopes30 envelopes

Rubric

Supply Inventory Control

Supply Inventory Control

CriteriaRatingsPts

This criterion is linked to a Learning OutcomeCreated formatted, and saved an Excel workbook

2.0 pts

Completely created, formatted, and saved excel workbook error free

0.0 pts

Either partially created, formatted, saved with errors, and/or missing submission

2.0 pts

This criterion is linked to a Learning OutcomeThoroughly addressed supply steps

2.0 pts

Thoroughly addressed supply steps free of GUM, CUPS, and/or APA errors

1.0 pts

Either partially addressed supply steps and/or includes GUM, CUPS, and/or APA errors

0.0 pts

No submission

2.0 pts

This criterion is linked to a Learning OutcomeIncluded three different administrative and three different clinical supplies

2.0 pts

Included 3 different administrative and clinical supplies, free of GUM & CUPS

0.0 pts

Either partially Included 3 different administrative and clinical supplies, and/or included GUM or CUPS errors and/or missing submission

2.0 pts

This criterion is linked to a Learning OutcomeAccurately included inventory required and current inventory number

2.0 pts

Accurately included inventory required and current inventory number free of GUM and CUPS

0.0 pts

Either partially included inventory required and current inventory number and/or with GUM or CUPS and/or no submission

2.0 pts

This criterion is linked to a Learning OutcomeAccurately included reorder timeline

2.0 pts

Accurately included reorder timeline error free

0.0 pts

Either partially included reorder timeline and/or included errors, and/or no submission

2.0 pts

Total Points: 10.0