Application Proplem

The systems analyst of the MIS department was contacted one morning by the production manager of the candy bar division.The problem was that the 3-ounce candy bar is sticking to the wrapper. A large percentage of the bars begin to stick to their wrappers after four or five weeks on the grocer's shelf. Consequently, customer complaints have forced a supermarket chain to switch to a competitor's brand.

After a two-week observation of the mixing and wrapping processes and inspection of the wrapper, it was found that the three-year-old mixing unit overheated after 6.5 hours of operation. This caused a sugar ingredient to react slowly to room temperature three to four weeks after production. The mixing machine has five more years of projected life. The alternatives are to modify the present machine at a cost of $79,000 and to replace it with a new (but more reliable) machine that has been successfully used by a competitor. The new machine costs $150,000 plus $14,000 installation charge. It has no salvage value at the end of the eight years.

The next step was to compute the operation costs of both systems. In a meeting with his supervisor, the analyst tried to show how the new system would increase sales of the 3-our second bar and produce reliable production that would easily offset the initial investment in the new machine. The supervisor did not seem impressed. After a lengthy discussion, the analyst was asked to redo the computations and the analysis. .

Assignment

  1. One problem that was pointed out was computing employee wages. What seems to be inaccurate about the salary section in both systems? How would you correct the problem?

   2. With respect to the types of costs incurred in operating either system, did the analyst include all relevant costs? Show where additional costs should be included. What other expenses should the rep0l1 emphasize (if any)?

Application Problem

 A medium-sized bank has decided to automate its trust account service. The vice president of the trust department requested a benefit analysis of a trust package for possible installation. The say analyst first reviewed the cost of operating present trust activities. Vice president and three trust officers earned $64,000 in salaries Inventory and supplies average $.400 each year. Trust account statement asset reviews, and other trust reports are produced on an out system at an annual cost of $400. Overhead (air conditioning, light power, and maintenance) average $2,165 a year.

The analyst then evaluated three software packages design trust work. One package met the user's requirements. The purchase price was $13,980. When implemented, the computerized service reduce payroll by $10,OOO-the salary of a junior trust officer. Inventory and supplies were priced at $1,900. Overhead was calculated at for air conditioning, lighting, power, and maintenance.

When all the information was gathered, a report was drafted foe vice president with these facts and figures. He could see the co t computerized trust package. The operation costs of both systems summarized as follows:

Assignment

In the event the proposed system is implemented, a bro' house that deals with the trust department agreed to under percent of the system charge, or $3,495 per year. So the actual operations costs to the trust department are $69,045.

Assignment

Construct a decision table to help the one in change handle the orders.

10 A major brokerage firm wishes to have (I) a list (call it "odd lot") of all individuals who hold odd lots (less than 100 shares) of Hammermill Ball Bearing stocks, and (2) lists of each of the five types of stockholders who own 100 or more shares of the same issue, as follows:

a. List A to include individual stockholders.
b. List B to include stocks held by a trust fund.
c. List C to include stocks held by an educational institution.
d. List D to include stocks held by a financial institution.
e. List E to include stocks held by a Canadian stockholder

Assignment

Assuming that the master personnel tile of company employees will be used develop a decision table to illustrate the job.

The local chapter of the Data Processing Programming Association is planning an annual picnic in July to be held in the city's main park. To encourage sustained membership, the recreation committee has decided to serve each member according to the number of years he/she has been a member, as follows:

If a member has been with the association for one year or less, he/she is entitled to two hamburgers, one bottle of beer, and one ice cream bar. Those with two years of membership are allowed one hamburger and three bottles of beer. Those with more than three years of membership get one doubleburger and no limit on drinks

Assignment

Prepare a decision table to indicate the warehouse hum which customers call be accommodated.
8 A major manufacturer of floppy disks wants to have a party for employees who have been with the company between one and three months. In addition to a master list of these employees, the public relations department wishes to have a tally of those who are single, married, divorced, and "other

Assignment

Prepare a decision table to indicate the warehouse hum which customers call be accommodated.
8 A major manufacturer of floppy disks wants to have a party for employees who have been with the company between one and three months. In addition to a master list of these employees, the public relations department wishes to have a tally of those who are single, married, divorced, and "other

Assignment

a. Draw a system flowchart to represent the production process.
b. Use the information provided in the case to construct a Gantt chart.
7 Sanford & Sons, Inc., a small manufacturer of electronic calculators, stocks "ready to ship" units in four warehouses (A, B, C. D). Warehouse A handles .All orders received from foreign customers. Warehouse B handles orders received from customers out of the state of Illinois. Warehouse C fills orders received from nongovernment customers that operate within the state of Illinois. Warehouse D handles orders received from state or federal government agencies.

Assignment

a. Develop a decision tree.
b. Represent the information in structured English

A major publisher hired an analyst to study the existing system of producing textbooks. The analyst spent several weeks collecting data regarding. The production process and then prepared a system flowchart. The process is initiated with the receipt of the typewritten manuscript by the book editior. The manuscript consists of the text narrative and art in the form of tables, charts, schematic charts, and figures of machines, buildings, and the like. The editor sends it to the production editor, who officially launches the production process. The steps are as follows:

a. The manuscript is assigned to a copyeditor who corrects grammatical errors ,inconsistencies, and the like. The job normally takes s-even to nine weeks.

b. The copyedited manuscript is sent back to the author for final review. The publisher allows two weeks for this step.

c. When the edited manuscript is retuned, it is released to a compositor who produces a galley. Copies of the galley are sent to the author and the production department for proofreading, Two weeks are allowed for this step.

d. The proofread galley is retuned to the compositor to incorporate final, changes or corrections. Meanwhile, art is released to the art department for preparing the finished work. Five weeks are allowed to complete the job.

e. When the corrected galley and al1 are received, the production department "dummies" the book; that is, the galley is divided into pages that include space for illustrations, photographs, etc. This step normally takes three weeks.

f. The dummied manuscript is page-numbered and the illustrations are actually shown in the space provided. Further proofreading and, checking on the exact location of the art are finalized. This step takes a week.

g. At this stage, the index is prepared, which takes a week. Front matter (preface, acknowledgment page. etc.) is also set in type.

h. The dummied galley, including index and front matter, is sent to the compositor for final production and binding. This major step takes around seven weeks. When the work is completed, the bindery ships the copies to the publisher’s warehouse

Assignment

1. Draw a decision tree based on the statement.
2. Develop a decision table for passenger free ticket.

5 A Virginia-based mail-order house specializes in microcomputers and supplies for various microcomputer makes. It offers discounts based on the number of units ordered. When an order is received, an invoice is generated that includes the quantity, unit cost, discount, and shipping and handling charges. The invoice is decomposed into' the following hierarchy:

Invoice-Total is computed on each line-item. All line-item totals are then added to get invoice total. A line-item is extended by multiplying quantity by unit cost. The product is the line-item total.'

Discount is computed as follows:

If Invoice-Total is $3,000 or over, discount is 20 percent.
If Invoice-Total is between $2,000 and $2,999, discount is 10 percent.
If Invoice-Total is between $1,000 and $1,999, discount is 5 percent.
If Invoice-Total is under $1,000, no discount allowed.

Shipping and handling charges depend on whether the computer is to go by UPS or air freight. If the order specifies UPS, then compute as follows:


if weight is under 35 pounds, shipping/handling rate is $30.
If weight is 35 to SS pounds, shipping/handling rate is $45.
If weight is over SS pounds, multiply excess (over S5) by $2 and add $4S to gel shipping/handling ,'ate.
If the order specil1es air freight, then multiply each pound of weight by $1.85 to get rate.

Assignment

a.Are there flaws in the data flow diagram? If so, what are they? List the corrections.
b.Draw an expanded data flow diagram of bubble 2.
c.Using the information from the safe deposit case and the data flow diagram, draw a data flow diagram to dose a customer's account.

4 An international airline initiated a frequent traveler program designed to encourage passengers to fly regularly and earn awards based on miles flown. The airline policy is specified as follows:

Passengers who fly more than 100,000 miles per calendar year and, in addition, pay cash for tickets or have been flying the airline regularly for more than five years are to receive a free round -trip ticket around the world. Passengers who fly less than 100,000 miles per calendar year and have been flying the airline regularly for more than five years also get a free round -trip ticket around the world.