Business Information Systems Case

If prices were to rise, we would order in larger quantities to account for economies of scale. We also believe that the discount rate will not vary beyond ten percent due to the safe risk in the proposed project

Best Deal Electronics

Group 5

BIS 255

Fall Semester 2012

10/31/12

Problem Statement

The problem that we found in Best Deal Electronics is that Stewart asked us to perform many tasks that involved inefficiency in data gathering, which could be much quicker and easier.

Case Questions

Task 1:

Stewart has a Microsoft Excel file containing product data. He has instructed us to open this file and review the contents.

Task 2:

Given in the planning analysis were records that needed to be added to update BDE’s inventory and complete the ABC Inventory Analysis. We copied the records that needed to be updated to Stewart’s existing Excel file from Task 1 and formatted it to match the existing information.

Task 3:

Stewart wants to add the CONTRIB, CONTRIBPCT, TURNOVER, DAYSINV, SALES, PROFIT, and PERCENT columns. He has provided data definitions to assist us with doing this. This data definitions page contains all of the formulas necessary for creating these columns. We added the files Stewart’s product data file.

Task 4:

In this task we are asked to add a header with a title, ABC Analysis, and current date. We are then ask to center them over the entire document. First we added three rows to the top of the document and put in the title of the company and merged and centered it over the entire document. We did the same for the next row, which said, “ABC Analysis” and the same for the date. To add the current date we had to use the TODAY function, =TODAY(), in order to keep it current every time the document was opened.

Task 5:

Stewart has a MANAGEMENT SUMMARY AREA at the bottom of the product data file. We were instructed to add the formulas in to calculate...