Description

Name:
Class: BCIS 5150
Assignment: Case Study 1: RMS
Option chosen: Excel / MCQ (highlight one)
Questions Responses
Question 1
Given your understanding of inventory levels, what
are the possible areas where RMS should focus.
Suggest opportunities for leveraging IT. [Note. If you
are using the Excel option in your assignment use the
“ABC analysis of the inventory levels.” If you are not
using Excel, then comment based on your
understanding of the case].
Your response should be in two to three statements.
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points
Question 2
Given your understanding of the sales across
categories, what are the possible areas where RMS
should reduce their emphasis. Suggest opportunities
for leveraging IT. [Note. If you are using the Excel
option in your assignment use the “ABC analysis of
sales across categories.” If you are not using Excel,
then comment based on your understanding of the
case].
Your response should be in two to three statements.
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points
Question 3
Comment on the Overall Gross Margin as presented in
the Table 5 of the case study. How can IT be leveraged
to increase reliability in calculating overall gross
margins? [Note. If you are using the Excel option in
your assignment use the “Overall Gross Margin
computed in the Profit_Analysis worksheet (cell I8).” If
you are not using Excel, then comment based on your
understanding of the case].
Your response should be in two to three statements.
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points
Give response in a few bullet points



Question 1

Given your understanding of inventory levels, what are the possible areas where RMS should focus. Suggest opportunities for leveraging IT. [Note. If you are using the Excel option in your assignment use the “ABC analysis of the inventory levels.” If you are not using Excel, then comment based on your understanding of the case].

Your response should be in two to three statements.

Question 2

Given your understanding of the sales across categories, what are the possible areas where RMS should reduce their emphasis. Suggest opportunities for leveraging IT. [Note. If you are using the Excel option in your assignment use the “ABC analysis of sales across categories.” If you are not using Excel, then comment based on your understanding of the case].

Your response should be in two to three statements.

Question 3

Comment on the Overall Gross Margin as presented in the Table 5 of the case study. How can IT be leveraged to increase reliability in calculating overall gross margins? [Note. If you are using the Excel option in your assignment use the “Overall Gross Margin computed in the Profit_Analysis worksheet (cell I8).” If you are not using Excel, then comment based on your understanding of the case].

Your response should be in two to three statements.