Cost and Revenue Assignment (accounts for 10% of course grade):
Organizational management teams are provided the task of controlling facility costs and
expenditures. Utilize the chart below and address the following management inventory problems:
Inventory Analysis
Stock Number Item Name Annual Revenue $ Loss Charges
J24 Ventilators 1,638,500 26.2%
R26 IV pumps 719,000 23.3%
L02 WoundVac 483,200 18.8%
M12 WalkingCane 51,550 15.8%
P33 Band-Aids 92,654 12.3%
T72 Saline syringes 83,458 39%
S67 Alcohol Pads 217,000 41.4%
? Place all items on a spreadsheet. Calculate amount of revenue lost for each item.
? Create a chart from the spreadsheet to display the stock name, item name, annual revenue,
loss charges, and the amount of revenue lost per item. Your spreadsheet should include 5
columns
? Use color to make your chart easy to read.
? Create a detailed plan on how to decrease the loss of revenue by decreasing loss charges for
any 3 items.
? Include a plan on how you will track charges for the 3 items for 6 months to prevent
future lost charges.
? The plan should include a title page, body, and reference page. The body should be a
minimum of a ½ page and maximum of 1-page in length (excluding title or reference
page). Plan should be in APA format, free of grammar, spelling, and punctuation errors
and uses in-text citations.
? At minimum two references should be used to support your plan.
? Your submission should include a title page, spreadsheet, chart, plan, and reference page.
? When submitting your documents to Canvas, do not submit the assignment three times
to upload all documents. Instead, use the Canvas upload option when submitting to add
an additional document. The spreadsheet and chart may be submitted in one submission if
preferred.
? The Cost and Revenue Assignment Rubric will be used to evaluate student submissions.