2 pts Question 11 Which of the following would create transactional information? Ogenerating payroll reports Oprojecting future sales growth Omaking an airline reservation Ohiring part-time employees for the holiday season
Added by Julie J.
Close
Step 1
Step 1: Transactional information is data that is created as a result of a business transaction. Show more…
Show all steps
Your feedback will help us improve your experience
Jennifer Stoner and 57 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
In which of the following scenarios would a stored procedure be beneficial?Select one or more:a. An application running on a remote client needs to calculate and store an employee's salary which is obtained by multiplying the number of hours he has worked with the rate he is paid. Both the number of hours and rate are also stored in a table in the databse.b. An application running on a remote client needs to collect three input values, perform a calculation using the values provided, and store the input data, along with the results of the calculation in two different base tablesc. An application running on a remote client needs to track every modification made to a table that contains sensitive datad. An application running on a remote client needs to ensure that every new employee that joins the company is assigned a unique, sequential employee number when his information is stored in the database.e. All of the given answers
Jennifer S.
The Catalog Company is a mail and phone order company that sells generic brands of houseware items and clothing. Approximately 95% of customer orders are received by phone; the remaining 5% are received in the mail. Phone orders are accepted at Catalog Company's toll-free number, 800-SAVE-NOW. The toll-free number is available for 9 hours per day (8 A.M. to 5 P.M.), five days a week. Sarah Walter, a recent graduate of UND Business School, has just been hired by Catalog to improve its operations. Sarah would like to impress her boss, Ben Gleason, the president of Catalog Company, with some ideas that would quickly improve the company's bottom line. After spending a week learning about Catalog's operations, Sarah feels that a closer evaluation can make a substantial impact on the phone order system. Currently, Catalog employs a single full-time operator to take orders over the phone. Sarah wonders whether additional operators should be hired to take phone orders. Ben feels that Sarah's time might be better spent studying the catalog mailing lists. Ben reasons that the mailing lists are where customers are generated, and improving the list will bring in more revenue. And besides, Ben says, "Catalog's phone operator, Betty Wrangle, seems to be doing nothing more than half of the time that I walk by. Hiring more operators to do nothing will just waste more money." Although Sarah knows the mailing lists are essential, she thinks that a study of the mailing lists will take far more time than a quick evaluation of the phone order system. Moving ahead, Sarah discovered the following information about the phone order system. The phone operator, Betty Wrangle, is paid $9 per hour in wages and benefits. The average cost to Catalog for a completed 800 number call is $1.50. With only one phone line, any incoming calls that arrive when Betty is on the phone with another customer get a busy signal. The cost of the phone line is $40 per month. The phone company can immediately add up to four additional phone lines using the same 800 number, each at the cost of $40 per month per line. Catalog's phone system is such that it cannot be upgraded in the near future to allow incoming calls to be placed on hold. The average profit on an order (not including the cost of the operator or phone call) is 40% of the amount of the order. For example, an order of $100 brings a profit of $40 to Catalog. Sarah decided that additional information needed to be collected about the frequency of incoming calls, the length of the calls, and so on. After talking to the phone company, Sarah learned that she could borrow equipment for one day that could detect when a call was coming in, even when Betty was on the phone. The caller would still get a busy signal and be lost, but Sarah would know that a call had been attempted. Sarah collected almost nine hours of data the next day; these data are presented in Excel Spreadsheet (Catalog.XLS). Sarah believes that most of the callers who receive a busy signal take their business elsewhere and are totally lost to Catalog. Sarah does not feel that extending the hours of operation of the 800 number would be beneficial because the hours of operation are printed prominently in all of the catalogs. The first call arrives at 0.036 hours into the day. It takes Betty 0.054 hours to process the call and record the order for $65.21 worth of merchandise. Callers 5 and 6 get busy signals when they call because Betty was still processing caller 4. Because calls 5 and 6 were lost, no call length information was available, and no orders were placed. Data collection was stopped at call number 80. Discussion Questions: Use the information in the file Catalog.data to answer the following questions. Would you recommend that Catalog acquire additional phone lines and operators? If so, how many? If not, why not? S (Number of service Person) 1 2 3 Ps Revenue/Hour Profit/Hour Wages/Hour Phone line cost / Hour Phone calls cost / Hour Net Profit / Hour Suppose S = 1, What is the net profit per hour? Suppose S = 2, What is the net profit per hour? Suppose S = 3, What is the net profit per hour? Your recommendation.
Jerelyn N.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD