1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and 27 employees. Currently, the office manager at 3 stores put input their weekly sales results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon. Each week, Pat handles between 120 to 350 records of sales data, and another 100 to 300 records of customer data. Pat would be like to keep track of weekly sales, which customers are associated with each sale, the parts used for each sale, what work was done for each customer at each sale, and which parts were used for each sale. If Pat wants to improve his efficiency and effectiveness, which of the following applications would be the best for collecting and storing Pat’s data? 1) Excel 2) SAP 3) Access 4) Minitab 5) Teams 6) MySQL

1: Pat Jones is the general manager at Denny’s Muffler, which has 3 locations and 27 employees. Currently, the office manager at 3 stores put input their weekly sales results into a spreadsheet and e-mail that spreadsheet to Pat on Friday by noon. Each week, Pat handles between 120 to 350 records of sales data, and another 100 to 300 records of customer data. Pat would be like to keep track of weekly sales, which customers are associated with each sale, the parts used for each sale, what work was done for each customer at each sale, and which parts were used for each sale. If Pat wants to improve his efficiency and effectiveness, which of the following applications would be the best for collecting and storing Pat’s data? 1) Excel 2) SAP 3) Access 4) Minitab 5) Teams 6) MySQL

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 30P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Q4) Jackson Hole Manufacturing is a small manufacturer of plastic products used in theautomotive and computer industries. One of its major contracts is with a large computercompany and involves the production of plastic printer cases for the computer company’sportable printers. The printer cases are produced on two injection molding machines. The M-100machine has a production capacity of 25 printer cases per hour, and the M-200 machine has aproduction capacity of 40 cases per hour. Both machines use the same chemical material to produce the printer cases; the M-100 uses 40 pounds of the raw material per hour and the M-200uses 50 pounds per hour. The computer company asked Jackson Hole to produce as many of thecases during the upcoming week as possible; it will pay $18 for each case Jackson Hole candeliver. However, next week is a regularly scheduled vacation period for most of Jackson Hole’sproduction employees; during this time, annual maintenance is performed for all equipment inthe…
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
Q1) A retail. Store stocks two types of shirts A and B. These are packed in attractive cardboard boxes. During a week the store can sell a maximum of 400 shirts of type A and a maximum of 300 shirts of type B. The storage capacity, however, is limited to a maximum of 600 of both types combined. Type A shirt fetches a profit of SR 2/- per unit and type B a profit of SR. 5/- per unit. (b) Find the optimal solution (How many of each type) that store should stock per week to maximize the total profit. Use Graphical Method.
Q2 The lower daily needs for workers in a manufacturing organization provided in the below table, each worker works for eight hours, the management needs to determine the lower number of workers to maintain the flow and stability of the work in each shaft. Formulate LP model for this problem and suggest (only suggestion) a method to find the optimal solution Shaft
Q1. Hotel manager Mr. Smith and his resourceful assistant, John, run a 26-room hotel in a little town. A combination of Mr. Smith's friendly attitude and the absence of a respectable hotel in the nearby vicinity imply that Mr. Smith enjoys sufficient demand at his low fare of $159 per night. John notes that some customers will walk into the hotel requesting a room for that evening and they are willing to pay a high fare of $325 per night. John knows this demand is variable. (In reality, this demand is U(4,9)) He suggests some rooms should be kept unsold to the low-fare customers so that they can serve the high-fare customers. a) To maximize profits with John's plan, what is the booking limit that should be set for low fare customers? b) Mr Smith does not like the idea of John and says “we will sell to everyone who reserves in advance and ignore the walk-in demand." If Mr Smith has his way, what will be the hotel's expected revenue? C) John replies, "If you are going to forgo the…
Q1 (a) Looking at the Sensitivity table above explain briefly by answering if the demand by any of these the classes is not satisfied. (b) Write down how many bookings the hotel should accept in each rental class?
Q)6. Which of the following is NOT a correct description of the PESTLE model? Group of answer choices “E” in the PESTLE model stands for “Economic”. The factors to consider is the positive or negative impact of the big five forces. “P” in the PESTLE model stands for “Political”. The factors to consider is the positive or negative impact of a given event such as the outcome of an election. “E” in the PESTLE model stands for “Environmental”. The factors to consider is the positive or negative impact of natural environment related concerns. “L” in the PESTLE model stands for “Legal”. The factors to consider is the positive or negative impact of a given change in legislation.
Q1. Mr. John Francois, the owner of John Francois Stores has been operating a successful business since 1977. However, he is not fully aware of what strategic management and planning entails. As a trust worthy employee, Mr. Francois has asked you to host a weekend retreat with him, his family members, and selected members of staff so that you can advise them about what strategic management and planning entails as well as how important it is for the organization to engage in strategic management and planning. What would you say to the members present at the retreat so that they can have a very good understanding of what strategic management and planning entails, and why they should engage in the process so as to maintain the competitive advantage of John Francois Stores?
Question: B) Identify The Economic Order Quanitity And Consider The Implications For Making An Error In Calculating Economic Order Quanitity. This problem has been solved! See the answer b) Identify the economic order quanitity and consider the implications for making an error in calculating economic order quanitity.
Mrs. Peters needed to raise money to bring her class to the Air and Space Museum in Washington, D.C. With only a few weeks left before the deadline, the class was raising an average of $45 every day from online donations. Mrs. Peters was worried they might not raise the last $1,000 in time. That evening, she posted a story about the class trip on an education website, and the donation rate doubled overnight! The new rate stayed the same for the remaining 3 weeks until the deadline, and they raised more than their goal! How much extra did the class raise?