Fundamentals of Information Systems
8th Edition
ISBN: 9781305082168
Author: Ralph Stair, George Reynolds
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 6, Problem 3PSE
Program Plan Intro
Develop a DSS program using a spreadsheet to estimate the changes in profit after adding or deleting an itemfrom inventory. Also, find the total annual profit and sort the in descending order of profit.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
1)Modeling: Make a CDM from the following scenario: *
A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region.
- The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement.
2)
In your MCD above, what are the dimension tables? *
3)In your MCD above, what are the fact tables?
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
Chapter 6 Solutions
Fundamentals of Information Systems
Ch. 6 - Prob. 1LOCh. 6 - Prob. 2LOCh. 6 - Prob. 3LOCh. 6 - Prob. 4LOCh. 6 - Prob. 5LOCh. 6 - Prob. 6LOCh. 6 - Prob. 7LOCh. 6 - Prob. 1.1DQCh. 6 - Prob. 1.2DQCh. 6 - Prob. 1.1CTQ
Ch. 6 - Prob. 1.2CTQCh. 6 - Prob. 2.1DQCh. 6 - Prob. 2.2DQCh. 6 - Prob. 2.1CTQCh. 6 - Prob. 2.2CTQCh. 6 - During which stage of the problem-solving process...Ch. 6 - Prob. 2SATCh. 6 - Prob. 3SATCh. 6 - Prob. 4SATCh. 6 - Prob. 5SATCh. 6 - Prob. 6SATCh. 6 - Prob. 7SATCh. 6 - Prob. 8SATCh. 6 - Prob. 9SATCh. 6 - Prob. 10SATCh. 6 - Prob. 11SATCh. 6 - Prob. 12SATCh. 6 - Prob. 13SATCh. 6 - Prob. 14SATCh. 6 - Prob. 1RQCh. 6 - Prob. 2RQCh. 6 - Prob. 3RQCh. 6 - Prob. 4RQCh. 6 - Prob. 5RQCh. 6 - Prob. 6RQCh. 6 - Prob. 7RQCh. 6 - Prob. 8RQCh. 6 - Prob. 9RQCh. 6 - Prob. 10RQCh. 6 - Prob. 11RQCh. 6 - Prob. 12RQCh. 6 - Prob. 13RQCh. 6 - Prob. 14RQCh. 6 - Prob. 15RQCh. 6 - Prob. 16RQCh. 6 - Prob. 17RQCh. 6 - Prob. 1DQCh. 6 - Prob. 2DQCh. 6 - Prob. 3DQCh. 6 - Prob. 4DQCh. 6 - Prob. 5DQCh. 6 - Pick a company and research its human resource...Ch. 6 - Prob. 7DQCh. 6 - Prob. 8DQCh. 6 - Prob. 9DQCh. 6 - Prob. 10DQCh. 6 - Prob. 1PSECh. 6 - Prob. 2PSECh. 6 - Prob. 3PSECh. 6 - Prob. 1WECh. 6 - Prob. 2WECh. 6 - Prob. 3WECh. 6 - Prob. 1CECh. 6 - Prob. 2CECh. 6 - Prob. 1.1CSCh. 6 - Prob. 1.2CSCh. 6 - Prob. 1.1aCSCh. 6 - Prob. 1.2aCSCh. 6 - Prob. 2.1CSCh. 6 - Prob. 2.2CSCh. 6 - Prob. 2.1aCSCh. 6 - Prob. 2.2aCS
Knowledge Booster
Similar questions
- Hi There! I need help with this simulation model problem. I get how to do a basic coin toss using Rand function in excel but am struggling with how to structure this, given the detail in this problem. Help! There are three doors; one of them has a prize behind. A contestant first chooses a door and then the game show host will open one of the “wrong” doors. She will never open the door with the prize behind. Should the contestant a) stay with the originally chosen door, b) switch to the other door or c) flip a coin as there are only two doors left and one has the prize? Set up a simulation model with 500 trials. Here I need to include the percentage of “wins” for each of the three strategies mentioned. I'm so confused!arrow_forwardComputer Science THIS MUST BE ANSWERED USING A UML STRATEGY DIAGRAM. This is a computer science based question. Please follow directions. Question: Draw the UML diagram using a strategy pattern for calculating different types of salaries. For example: - Employees that work by the hour have a different tax rate and salary is calculated based on hours reported - Employees under a contract have a set monthly salary but could still have a different withholding rate - Overhours (for contract and hourly employees) are calculated using a 1.5 multiplier for their salary scale and are paid by the hour - Employees might also receive compensation from a delivery regardless of hours workedarrow_forwardGoal: Create a budget meal for a dayRole: You are an assistant cook in Karinderya.Audience: Teacher, friend, neighbours and loved one.Situation: The store manager give you task to prepare a budget meal for the day,consisting 1 rice, 1 viand, 1 fruit and 1 drink. Available Food: rice (fried and plain), viand (chicken meat, pork meatand vegetables), dessert fruit (banana and apple) and juice (pineapple juiceand mango juice)Product: The expected output must be the following:1. Customer financial capability in ordering food2. Create at least three combination of your budget meal and put a necessaryamount.arrow_forward
- Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forwardMany of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…arrow_forwardProject Optimization and regression: Exact and approximate methods to solve 0-1 Knapsack problem Description The 0/1 Knapsack Problem and Logistics Transportation companies such as TNT and Royal Mail face daily problems in logistics. Consider the following simple logistics problem, which you will solve: An airline cargo company has 1 aeroplane which it flies from the UK to the US on a daily basis to transport some cargo. In advance of a flight, it receives bids for deliveries from (many) customers. Customers state the weight of the cargo item they would like delivered, and the amount they are prepared to pay. The airline is constrained by the total amount of weight the plane is allowed to carry. The company must choose a subset of the packages (bids) to carry in order to make the maximum possible profit, given the weight limit that they must respect. In mathematical form the problem is: Given a set of N items each with weight wi and value vi, for i=1 to N, choose a subset of items…arrow_forward
- Create a spreadsheet to calculate your projected total costs, total revenues, and total profits for giving a seminar on cost estimating. Make the following assumptions: • You will charge $600 per person for a two-day class (i.e., the class fee). • Your fixed costs include $500 total to rent a room for both days, setup fees of $400 for registration, and $300 for designing a postcard for advertising. • You will not include your labor costs for this estimate, but you estimate that you will spend at least 150 hours developing materials, managing the project, and giving the actual class. You would like to know what your time is worth given different scenarios. • You will order 5,000 postcards, mail 4,000, and distribute the rest to friends and colleagues. • Your variable costs include the following: a. $5 per person for registration plus 4 percent of the class fee per person to handle credit card processing; assume that everyone pays by credit card b. $.40 per postcard for printing if you…arrow_forwarda) What actions or steps in Excel will arrange the given spreadsheet in alphabetical and ascending order of Surname?b) What actions or steps in Excel will produce a list/display of those who had a sales revenue of £138,500 or more in the year?c) Write the Excel function to determine the number of salespersons who had a Sales Total above the given “Average Sales Total”?d) Which type of graph will be suitable for representing the above sales revenue by regions? e) In which column(s) might replication have been used? f) What formula was used to arrive at the Company Sales Total?arrow_forwardQuestion #01: Provide the solution for the following open ended problem. Assume you are CEO of a well-known company. You need to create a salary management system for the company in order to check the amount spent on salaries of your employees. Let there be 3 types of employees in the company i.e. Developers, Marketing Teams and Human Resource Your company gives salary on the basis of experience of the employee. Initial salary for the Developers is $800, for the Marketing Team is $700 and for Human Resource is $600. Your program should ask the employee to enter the year of experience in the company, if the experience is more than 2 years an increment of $50 is given. The Salary mentioned above is monthly. Annually two bonuses are given to the employee, Bonus is 10% for the Developers, 86 for the Marketing Team and 6% for Human Resource. Your Program should initially display a menu from which the employee chooses his/her department. Depending on the Department chosen the salary/bonuses…arrow_forward
- Using 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_forwardDevelop a realistic retirement-planning simulation model for your personal situation. If you are currently employed, use as much information as you can gather for your model, including potential salary increases, promotions, contributions, and rates of return based on the actual funds in which you invest. If you are not employed, try to find information about salaries in the industry in which you plan to work in and the retirement benefits that companies in that industry offer for your model. Estimate rates of return based on popular mutual funds used for retirement or average performance of stock market indexes. Clearly state your assumptions and how you arrived at them and fully analyze and explain your model results.arrow_forwardDevelop a realistic retirement-planning simulation model for your personal situation. If you are currently employed, use as much information as you can gather for your model, including potential salary increases, promotions, contributions, and rates of return based on the actual funds in which you invest. If you are not employed, try to find information about salaries in the industry in which you plan to work in and the retirement benefits that companies in that industry offer for your model. Estimate rates of return based on popular mutual funds used for retirement or average performance of stock market indexes. Clearly state your assumptions and how you arrived at them and fully analyze and explain your model results. I NEED A DIFFRENT ANSWERarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Information Technology Project ManagementComputer ScienceISBN:9781337101356Author:Kathy SchwalbePublisher:Cengage Learning
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning