Concept explainers
TM Office Supplies, Inc., is a wholesale distributor of office supplies. It sells pencils and pens, paper goods (including computer paper and forms), staplers, calendars, and other items, excluding furniture and other major items such as copy machines that you would expect to find in an office. Sales have been growing at 5 percent per year during the past several years. Mr. Marina, the president of TM Office Supplies, recently attended a national office supplies convention. In conversations during that convention, he discovered that sales for TM Office Supplies’ competitors have been growing at 15 percent per year. Arriving back home, he did a quick investigation and discovered the following:
- TM Office Supplies’ customer turnover is significantly higher than the industry average.
- TM Office Supplies’ vendor turnover is significantly lower than the industry average.
- The new market analysis system was supposed to be ready two years ago but has been delayed for more than one year in systems development.
- A staff position, reporting to the president, for a person to prepare and analyze cash budgets was created two years ago but has never been filled.
Mr. Marina has called on you to conduct a systems survey of this situation. You are to assume that a request for systems development has been prepared and approved. The information system at TM Office Supplies is much like that depicted in Chapters 10 through 16.
Make and describe all assumptions that you believe are necessary to solve any of the following:
- a. What are the specific tasks of this systems survey?
- b. Indicate specific quantifiable benefits and costs that should be examined in assessing the economic feasibility of any solutions that might be proposed. Explain how you would go about quantifying each benefit or cost.
- c. Propose and explain three different scopes for the systems analysis. Use a context diagram to describe each scope alternative. Hint: What subsystems might be involved in an analysis?
Trending nowThis is a popular solution!
Chapter 17 Solutions
Accounting Information Systems
- Elliott, Inc., has four salaried clerks to process purchase orders. Each clerk is paid a salary of 25,750 and is capable of processing as many as 6,500 purchase orders per year. Each clerk uses a PC and laser printer in processing orders. Time available on each PC system is sufficient to process 6,500 orders per year. The cost of each PC system is 1,100 per year. In addition to the salaries, Elliott spends 27,560 for forms, postage, and other supplies (assuming 26,000 purchase orders are processed). During the year, 25,350 orders were processed. Required: 1. Classify the resources associated with purchasing as (1) flexible or (2) committed. 2. Compute the total activity availability, and break this into activity usage and unused activity. 3. Calculate the total cost of resources supplied (activity cost), and break this into the cost of activity used and the cost of unused activity. 4. (a) Suppose that a large special order will cause an additional 500 purchase orders. What purchasing costs are relevant? By how much will purchasing costs increase if the order is accepted? (b) Suppose that the special order causes 700 additional purchase orders. How will your answer to (a) change?arrow_forwardRae Philippe was a warehouse manager for Atkins Oilfield Supply, a business that operated across eight Western states. She was an old pro and had known most of the other warehouse managers for many years. Around December each year, auditors would come to do a physical count of the inventory at each warehouse. Recently, Rae’s brother started his own drilling company and persuaded Rae to “loan” him 80 joints of 5-inch drill pipe to use for his first well. He promised to have it back to Rae by December, but the well-encountered problems and the pipe were still in the ground. Rae knew the auditors were on the way, so she called her friend Andy, who ran another Atkins warehouse. “Send me over 80 joints of 5-inch pipe tomorrow, and I’ll get them back to you ASAP,” said Rae. When the auditors came, all the pipe on the books was accounted for, and they filed a “no-exception” report. Requirements Is there anything the company or the auditors could do in the future to detect this kind of…arrow_forwardABC Co is a small mail order company, which sells direct to established customer on its mailling list (using catalogúe and leaflets). And to a new customers via newspaper adversting. The range of its prooducts covers men's and women's leisurewear, games, toys. Over the last few years the company has built up a mailing lists of several thousand, to whom leissurewear catalogúe and leaflets are sent from time to time. An opportunity has risen to buy from a market research company either one or two customer lists, each on costing $20,000. The directors estimate that, if the two list were bought, sales could be average or low, again with equal chances If neither list were bought, it is estimated that sales could be average or low, with the odds 4:1 in favour low sales. Whenever sales turn out to be low, the directors have a contingency plan, in which they could decide whether or not to place advertisement in newspaper, at a cost $9,000, offering "special purchase" The chances of high,…arrow_forward
- Odle Company manufactures a popular brand of cat repellant known as Cat-B-Gone, which it sells in gallon-size bottles with a spray attachment. The majority of Odie's business comes from orders placed by homeowners who are trying to keep neighborhood cats out of their yards. Odie's operating information for the first six months of the year follows: Month January February March April May June Number of Bottles Sold 1,000 1,100 1,300 2,000 2,400 3,000 Operating Cost $ 8,000 7,700 9,900 14,000 17,250 20,000 Required: 3. Using the high-low method, calculate Odie's total fixed operating costs and variable operating cost per bottle. 4. Perform a least-squares regression analysis on Odie's data. 5. Determine how well this regression analysis explains the data. 6. Using the regression output, create a linear equation (y a+ bx) for estimating Odie's operating costs.arrow_forwardHeavenly Chocolates manufactures and sells quality chocolate products at its plant and retail store located in Saratoga Springs, New York. Two years ago, the company developed a web site and began selling its products over the Internet. Web-site sales have exceeded the company’s expectations, and management is now considering strategies to increase sales even further. To learn more about the web-site customers, a sample of 50 Heavenly Chocolate transactions was selected from the previous month’s sales. Data showing the day of the week each transaction was made, the type of browser the customer used, the time spent on the web site, the number of web pages viewed, and the amount spent by each of the 50 customers are contained in the file named Heavenly Chocolates. A portion of the data is shown in the table that follows: Heavenly Chocolates would like to use the sample data to determine whether online shoppers who spend more time and view more pages also spend more money during their visit to the web site. The company would also like to investigate the effect that the day of the week and the type of browser have on sales. Managerial Report Use the methods of descriptive statistics to learn about the customers who visit the Heavenly Chocolates web site. Include the following in your report. Graphical and numerical summaries for the length of time the shopper spends on the web site, the number of pages viewed, and the mean amount spent per transaction. Discuss what you learn about Heavenly Chocolates’ online shoppers from these numerical summaries. Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each day of week. Discuss the observations you can make about Heavenly Chocolates’ business based on the day of the week? Summarize the frequency, the total dollars spent, and the mean amount spent per transaction for each type of browser. Discuss the observations you can make about Heavenly Chocolates’ business based on the type of browser? Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the dollar amount spent. Use the horizontal axis for the time spent on the web site. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the number of web pages viewed and the amount spent. Use the horizontal axis for the number of web pages viewed. Discuss your findings. Develop a scatter diagram, and compute the sample correlation coefficient to explore the relationship between the time spent on the web site and the number of pages viewed. Use the horizontal axis to represent the number of pages viewed. Discuss your findings.arrow_forwardWheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products—they manage relationships with the bicycle shops to enable them to better meet consumers’ needs. The company’s sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 1,000 bicycle shops. To do so, however, the company would have to hire more salespeople. Each salesperson earns $40,000 plus 2 percent commission on all sales annually. Another alternative is to use the services of sales agents instead of its own sales force. Sales agents would be paid 5 percent of sales. At what level of sales would it be more cost efficient for Wheels to use to sales agents compared with its own sales force? To determine this, consider the fixed and variable costs for each alternative. What are…arrow_forward
- Wheels, Inc. manufactures bicycles sold through retail bicycle shops in the southeastern United States. The company has two salespeople that do more than just sell the products—they manage relationships with the bicycle shops to enable them to better meet consumers’ needs. The company’s sales reps visit the shops several times per year, often for hours at a time. The owner of Wheels is considering expanding to the rest of the country and would like to have distribution through 1,000 bicycle shops. To do so, however, the company would have to hire more salespeople. Each salesperson earns $40,000 plus 2 percent commission on all sales annually. Another alternative is to use the services of sales agents instead of its own sales force. Sales agents would be paid 5 percent of sales. Determine the number of salespeople Wheels needs if it has 1,000 bicycle shop accounts that need to be called on four times per year. Each sales call lasts approximately 2.5 hours, and each sales rep has…arrow_forwardJerry is a personnel manager for a large retail department store. He justreceived a memo stating that the company will build three new stores inPhoenix over the next 5 years, with one store opening in 24 months, oneopening in 36 months, and one opening in 60 months. The memo thatJerry received relates to what type of business plan? If Jerry is directedto develop a personnel plan for Phoenix, what type of planning will Jerrybe doing?arrow_forwardDogarrow_forward
- Jodi's Chop Shop is a retail chain specializing in salon-quality hair-care products. During the year, Jodi's Chop Shop had sales of $39,235,000. The company began the year with $3,500,000 of merchandise inventory and ended the year with $4,445,000 of inventory. During the year, Jodi's Chop Shop purchased $24,215,000 of merchandise inventory. The company's selling, general, and administrative expenses totaled $7,185,000 for the year. Prepare Jodi's Chop Shop's income statement for the year. Begin by calculating Jodi's Chop Shop's cost of goods sold using the table below. Jodi's Chop Shop Calculation of Cost of Goods Sold For the Year Ended Beginning inventory Purchases Plus: Cost of goods available for sale Less: Ending inventory Cost of goods soldarrow_forwardWith the goal of attracting as much customers as possible in the CALABARZON, Jhet Company engaged in a customer satisfaction program and marketing strategy for two of their major lines of products: (1) electrical appliances and (2) household and office furniture. All branches in the region are participating in the company’s promotions. In the customer satisfaction program, Jhet provides one-year warranty replacement of parts and labor of the electrical appliances sold. Based on past experience, the estimated warranty cost is 3% of sales. During 2021, total sales of electrical appliances was ₱7,200,000. Replacement parts and labor for warranty work totaled ₱184,000 during 2021. In the company’s marketing strategy for the household and office furniture section, customers are given a coupon for every ₱1,000 spent on these items. Customers may exchange 10 coupons plus ₱500 for a “hot and cold” water dispenser. Each water dispenser cost ₱1,200 and estimates that 40% of the coupons given to…arrow_forwardBodow is an entertainment complex located in Trinidad & Tobago. It offers various activitiessuch as music, rides, slides, and souvenir shopping, and customers pay a fixed fee to enter.The complex has been in operation for the past seven years and remains open throughout theyear. However, weather-related issues often lead to a significant decrease in customerattendance, usually by 50%, on approximately 30 days each year.Bodow has experienced substantial success, with customer numbers increasing byapproximately 15% annually. Sales at Bodow are categorized as cash sales and credit cardsales. All ticket sales are recorded on a computer, including the amount of each sale and thenumber of tickets issued. This information is electronically transferred to the accounts office.Cash collected from each ticket office is counted by two accounts clerks and two securityguards before being banked daily. The total cash from each ticket office is reconciled with thesales information transferred from…arrow_forward
- Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE LEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningAuditing: A Risk Based-Approach (MindTap Course L...AccountingISBN:9781337619455Author:Karla M Johnstone, Audrey A. Gramling, Larry E. RittenbergPublisher:Cengage Learning
- Principles of Accounting Volume 1AccountingISBN:9781947172685Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning