Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter AE, Problem AE2.1
Explanation of Solution
a.
Creation of spreadsheet:
Step1: Open the Microsoft Excel and enter the given data in the “Ch02Ex01_U10e.docx” file.
Step2: Compute the difference between current salary and Industry Average Salary.
- The formula for find the difference for Account department is “$B$2 – B7”.
- Then click and drag for finding the remaining rows. Proposed increase is for those who are highlighted in green color.
Screenshot of Excel sheet
The formula for find the difference for Marketing department is “$B$3 – B7”. Then click and drag for finding the remaining rows.
Screenshot of Excel sheet
The formula for find the difference for
Screenshot of Excel sheet
Step3: calculating the percentage to meet Industry Average...
Explanation of Solution
b.
Analysis made in contributing employee salary decision:
The above analysis can be used for making employee salary decision, those who are below the industry average range is recommended for salary rectification...
Explanation of Solution
c.
Three ways the user can share the Access application with another:
Share data by using network folders:
- This is the simplest option and has the least requirement. In this method, the
database file is stored on a shared network drive and all users can use that file at a time. - Advantage – all the users can use that file simultaneously.
- Disadvantage – the original data can be modified because of multiple users use that file simultaneously.
Share a database by using a server:
- This method is store the tables on the network and each user has local copy of a database file which contains links to the tables, along with forms, quires, objects and reports...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Your mission is to visit a "Mam and Pap" convenient store and observe how they do business. Then using your skills and abilities along with all of the spreadsheet functions and formulas you would have learned in this class, decide how best you can help them perform their daily regiments better.
Some ideas to consider are:
1. Better ways of controlling their inventory
1. Marketing strategies
3. Salary payment
4. Labelling and pricing of items/goods.
5. Store layout
Project 2 instructions are as follows:-
Your mission is to visit a "Mam and Pap" convenient store and observe how they do business. Then using your skills and abilities along with all of the spreadsheet functions and formulas you would have learned in this class, decide how best you can help them perform their daily regiments better.
Some ideas to consider are:
1. Better ways of controlling their inventory
1. Marketing strategies
3. Salary payment
4. Labelling and pricing of items/goods.
5. Store layout
What does this mean
2. The information below includes what was sent by the academic advisor (Program Checklist) (York U BSc Honours Computer Science)
Foundational science: six credits from SC/BIOL 1000 3.00, SC/BIOL 1001 3.00, SC/CHEM 1000 3.00, SC/CHEM 1001 3.00, SC/PHYS 1011 3.00, SC/PHYS 1012 3.00, SC/PHYS 1010 6.00, SC/PHYS 1411 3.00, SC/PHYS 1412 3.00, SC/PHYS 1410 6.00, SC/PHYS 1421 3.00
General Education and/or Science Breadth See sections "A" and "C"
A. General Education Requirement:non-science requirement: 12 credits from the approved list of courses and subject areas in your Academic Calendar;mathematics: satisfied within the core requirements;computer science: satisfied by the major requirements;science: satisfied by the BIOL, CHEM, or PHYS labs as stated on your degree checklist
C. Science Breadth:24 credits in science disciplines outside the major, of which three credits must be at the 2000 level or above. 15 of these 24 credits are satisfied by the general…
Describe two ways that you would use a spreadsheet either personally or professionally.
Is it a good practice to plan out your workbook before you create it? Support your response (Yes/No).
Chapter AE Solutions
Using MIS (10th Edition)
Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2Ch. AE - Prob. AE2.1Ch. AE - Prob. AE2.2Ch. AE - Prob. AE3.1Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1Ch. AE - Prob. AE4.2Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2
Knowledge Booster
Similar questions
- The spreadsheet for Drano Plumbing Company was being prepared by Damon Davis. He estimated that the net income would be $50,000 in his calculations. His Total Balance Sheet Columns showed a deficit of $400,000 and a credit of $300,000, which he added together and calculated as follows: Who knows what the most likely reason was for this discrepancy. Shouldn't this be the case, what should he do to identify the source of the problem?arrow_forwardDamon Davis was working on the Drano Plumbing Company's spreadsheet. He estimated a $50,000 net profit. When he added up the column totals on the Balance Sheet, the totals were $400,000 for debit and $300,000 for credit. What was the most likely reason for the disparity? What should he do if this was not the problem?arrow_forwardWhy is it vital for employees to be proficient with spreadsheets given the environment that we are now operating in? I would appreciate it if you could share two examples of how your company makes use of Microsoft Excel in its day-to-day operations.arrow_forward
- As the head buyer for a major supermarket chain, you are constantly being asked by manufacturers and distributors to stock their new products. Over 50 new items are introduced each week. Many times, these products are launched with national advertising campaigns and special promotional allowances to retailers. To add new products, the amount of linear shelf space allocated to existing products must be reduced or items must be eliminated altogether. Develop a simple spreadsheet DSS program that you can use to estimate the change in profits from adding or deleting an item from inventory. Your analysis should include input such as estimated weekly sales in units, the amount of linear shelf space allocated to stock an item (measured in inches), total cost per unit, and sales price per unit. Your analysis should calculate total annual profit by item and then sort the rows in descending order based on total annual profit.arrow_forwardCompare and contrast MS Excel's built-in solver platform and Risk Solver platform. Which of these two do you think is more sophisticated to use and why? 1. In creating the spreadsheet models for the problems, cells in the spreadsheets had to be reserved to represent each of the decision variables in the algebraic models. We reserved these cells in the spreadsheets by entering values of zero in them Why didn't we place some other value or in these cells? Would doing so have made any difference?arrow_forwardNo matter what adjustments are made to the data or the parameters, the formulae in a spreadsheet that has been thoughtfully created will never need to be modified. True Falsearrow_forward
- Suppose a team creates a shared spreadsheet that lists all pending tasks. Each team member picks a task and moves it to a separate worksheet in the file. When that task is completed, its owner moves it to a third worksheet. The team checks in regularly to ensure work is distributed evenly and no task is held up waiting on another. Which methodology is this team using? A)waterfall B) scrum C)Kansan D) extreme programmingarrow_forwardExactly why is it crucial for people to be proficient in spreadsheets in the modern workplace? Please provide two examples of how you have used Microsoft Excel in your work.arrow_forwardWhy is it crucial for employees in the present climate to be proficient with spreadsheets? Please provide us two examples of how your company utilises Microsoft Excel on a regular basis.arrow_forward
- Based on the information in the table, answer the following questions (a – d) and ensureto show your work.a) By using appropriate cell formatting techniques outlined in this module,reproduce the above spreadsheet in Excel. Take a clear screenshot andinsert it into your portfolio as your answer to this question. Ensure you include row and column identifiers in your screenshot, so it is clear thatyou have used Excel to reproduce the table.b) Use Excel or otherwise to find the mean average monthly cost of a SIMonly contract. Please round your answer to the nearest integer.c)i) Use Excel to find the median number of Gigabytes (GB) of data onoffer by the ten mobile networks. Please include the formula youuse.ii) Use Excel to find the mean average of Gigabytes (GB) of data onoffer by the ten mobile networks. Please include the formula you use. iii) Based on your two answers in part i) and ii), which answer wouldgive a better indication of the average number of Gigabytes (GB)of data on offer…arrow_forwardUsing the “Green Savings” worksheet, provide the formulas to calculate the savings for each computer type usage, and corresponding totals. Energy Cost Savings (Green Computing) The below data represents cost (expenses) and savings for Thom-Pierre Consultants (TPC) for all organizational computer use for 2018 and 2019. TPC implemented a green computer initiative in January 2019. Operating Cost Computer type General Computer Use (2018) Green Computer Use (2019) Savings Notebook Dual Core 17490 9500 Notebook Quad Core 21000 12500 PC Dual Core 34500 21200 PC Core Duo 42000 21450 Servers Core Duo 25000 16550 Servers 4 Core Duo 30000 12450 Servers Xeon Quad Core 18500 8500 Totalarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Management Of Information SecurityComputer ScienceISBN:9781337405713Author:WHITMAN, Michael.Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Information Technology Project ManagementComputer ScienceISBN:9781285452340Author:Kathy SchwalbePublisher:Cengage Learning
Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Management Of Information Security
Computer Science
ISBN:9781337405713
Author:WHITMAN, Michael.
Publisher:Cengage Learning,
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781285452340
Author:Kathy Schwalbe
Publisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage