Create a clustered column chart for the total transactions

Assignment Help Other Subject

Reference no: EM132278798

Assessment Details:

XYZ Company requires a new Transaction Processing System (TPS) to gain competitive advantage in the market. The company is testing four such systems (TPS1, TPS2, TPS3 and TPS4) at four of its sites.The given file Assignment1-Datafile.xlx contains the testing results for these TPSs (X is the last two digits of your student ID). The assignment requires students to analyse the given case study andprovide their recommendation for selection of the TPS for the company. The assignment has twomain parts:

A. Data Analysis with Excel: Analyse the given data in Assignment1-Datafile.xlx aftercompleting the tasks given below.

B. Report: Write a report for XYZ Company that must include following sections:

− Introduction: Discuss the importance of competitive advantage associated with theuse of modern Information Systems.
− Transaction Processing System Selection: Justify the selection of TPS based on theresults generated in the excel sheet. The justification must be based on the graph"Total Transactions" and chart "System Errors".
− Importance of Data representation: Discuss the importance of correctly representingthe data for easy decision making.
− Conclusion: Must summarise the most important parts of the report and shouldinclude recommendations for using information systems for competitive advantage.

Details of Data Analysis with Excel:

Complete the following tasks:

1. In the row labeled "Total Transactions", calculate each TPS net transactions after deducting"Re-Entry Required due to system errors" from "Transactions".

2. In the row labeled "Blocks", calculate each TPS's blocks (Total Transactions divided by 50).

3. In the row labeled "Blocks per hour (8 hr day)", calculate each system's number of Blocksper hour (Record Stacks divided by 8).

4. In column F use the Sum function to give totals (for all systems) for each of the rows (rows 4to 8).

5. In column G determine the lowest value (for all systems) for each of the rows (rows 4 to 8).

6. In column H determine the highest value (for all systems) for each of the rows (rows 4 to 8).

7. In column Q determine the arithmetic mean (for all systems) for each of the rows (rows 4 to8).

8. The daily profit gained from each system is based on completed Blocks per hour for that day.Each working day is 8 hours long. Use a lookup table with a profit that changes according tothe number of Blocks per hour that a system completes - Up to 4 stacks per hour, the morestacks completed, the higher the profit. You will use the range B8 to D8 (Blocks per hour) forthe formulas to calculate daily profit. There is a table on the spreadsheet showing the DailyProfit. Use either the Lookup function or VLookup function to find the daily profit for all thesystems (make sure to use referencing).

9. Create a Clustered Column chart for the Total Transactions. Remember to select the correctranges and ensure the title of the chart is "Total Records Entered".

10. Create a Pie chart showing the column "re-entry required due to system errors". Rememberto select the correct ranges and ensure the title of the chart is "System Errors".

Attachment:- Foundations of Information Systems.rar

Reference no: EM132278798

Questions Cloud

Health care provider to give high-quality care for diabetics : How do statistics show health care providers to give high-quality care for diabetics or alcoholism?

Based training identified as collaborative based culture : Conduct brief research on a growing trend in team-based training identified as “Collaborative Based Culture”.

How might apple better capitalize on nonfinancial factors : How might Apple better capitalize on nonfinancial factors such as market share, reputation, human resources, physical facilities, or patents?

Aggregate and succession planning of critical importance : Why are aggregate and succession planning of critical importance? How might failures in these areas impact an organization's ability to compete?

Create a clustered column chart for the total transactions : ICT100 Foundations of Information Systems - king's own institute - Create a Clustered Column chart for the Total Transactions

Neoclassical model of business fixed investment : In the neoclassical model of business fixed investment, under what conditions will firms find it profitable to add to their capital stock?

Long term effects of unemployment on the economy : What are the consequences of long term unemployment? Should policy makers intervene?

Define the concept standard of living : Identify your most valuable material possession. Define the concept "standard of living". then list the ways in which this possession enhances your standard

Discuss the politics behind policy making : In particular, please explain why some policies got implemented even though they may be against economic principles.

User Account

All Pages