BMGT403 Systems Analysis and Design-Student Winter guide
17. Middleton Associates is a consulting firm that specializes in information systems for constructio... Middleton Associates is a consulting firm that specializes in information systems for construction and landscaping companies. The firm has two offices-one in Toronto and one in Vancouver. The firm classifies the direct costs of consulting jobs as variable costs. A segmented contribution format income statement for the company's most recent year is given below Required: By how much would the company's operating income increase if Vancouver increased its sales by $79,000 per year? Assume no change in cost behaviour patterns a. Refer to the original data. Assume that sales in Toronto increase by $160,000 next year and that sales in Vancouver remain unchanged. Assume no change in fixed costs. Prepare a new segmented income statement for the company. 18. 11) Relational databases represent relationships using ________. A) foreign keys B) file systems C). 11) Relational databases represent relationships using ________. A) foreign keys B) file systems C) metadata D) primary keys 12) Metadata are ________. A) codes used for server-side processing B) error logs of databases C) data that describe data D) data that are encrypted 13) A(n) ________ is a program used to create, process, and administer a database. A) operating system B) database management system C) information system D) database system 14) Which of the following is an example of a database management system? A) MS Excel B) BigData C) NoSQL D) Access 15) Identify anopen source DBMS product. A) MySQL B) DB2 C) Access D) Oracle Database 16) Which of the following is true of MySQL? A) It is a Microsoft product. B) It is license-free for most applications. C) It is a paid and proprietary database product. D) It uses Static Query Language (SQL) to manage database. 17) The data in a database are modified and deleted. These operations of DBMS are known as ________. A) statistical operations B) analytical operations C) administrative operations D) processing operations 18) Which of the following is an international standard language for processing a database? A) Cassandra B) DB2 C) SQL D) MS Access 19) Which of the following is a developmental task of database administration? A) evaluating an application design B) monitoring backup procedures C) conducting training for users D) managing configuration changes in systems 20) Identify the type of task performed by a database administrator when validating the data model to be used in a database management system. A) development B) adaptation C) backup and recovery D) operation 19. Which type of company typically has the longest operating cycle? Which type of company typically has the longest operating cycle? a. Service company. b. Merchandising company. c. Manufacturing company. d. All equal. 20. 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct ma 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct materlals budget, including a schedule of expected cash disbursements for purchases of materlals 3. Prepare a cash budget Cash Budget with Supporting Cash Collections and Disbursements Schedules - Excel Sign In FILE ?OME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 A A Conditional Format as Cell Paste Alignment Number Cells Editing A U Formatting Styles Table T Clipboard Styles Font fox S&P Enterprises needs a cash budget for March. The following information is Al A C E S& P Enterprises needs a cash budget for March. The following information is available 1 2 3 Data Ja??ary February March 4 Actual January and February and expected March sales: 3,750 5,100 S 5 Cash sales 1,600 Sales on account 25,000 30,000 6 40,000 S 26,600 33,750 S 45,100 7 Total Sales Accounts Receivable Collections: Month of sale 15% 10 Month following sale Second month following sale 60% 11 22% 12 Uncollectible 3% 13 14 $10,500 15 Accounts payable for inventory purchases, March 1 balance $23.500 16 Budgeted inventorv purchases in March ? IT 1. Prepare a sales budget, including a schedule of expected cash collections. 2. Prepare a direct materlals budget, Including a schedule of expected cash disbursements for purchases of materlals 3. Prepare a cash budget. X Cash Budget with Supporting Cash Collections and Disbursements Schedules Excel X = FILE REVIEW Sign In HOME INSERT PAGE LAYOUT FORMULAS DATA VIEW A A Calibri % 11 Conditional Format as Cell Alignment Number Paste Cells Editing I U Formatting Table Styles Clipboard Styles Font S&P Enterprises needs a cash budget for March. The following information is Al C E 16 Budgeted inventory purchases in March 17 Inventory payments: $23,500 Month of purchase 60% 18 Month following purchase 40% 19 20 $12,500 21 Total budgeted selling & administrative expenses in March $3,200 Budgeted selling & administrative depreciation in March 22 23 24 Other budgeted cash disbursements in March Equipment purchases Dividends to be paid $14,000 25 $2,000 26 27 28 Minimum cash balance to be maintained 29 March 1 cash balance 30 March 1 outstanding borrowings $10,000 $11,500 $0 31 March 1 interest due $0 ?. T Calibri % 11 A A Conditional Format as Formatting Cell Alignment Number Editing Paste Cells U T Styles Table Clipboard Styles Font S&P Enterprises needs a cash budget for March. The following information is Al A C E 20 $12,500 21 Total budgeted selling & administrative expenses in March $3,200 22 Budgeted selling & administrative depreciation in March 23 24 Other budgeted cash disbursements in March $14,000 Equipment purchases 25 Dividends to be paid $2,000 26 27 $10,000 28 Minimum cash balance to be maintained 29 March 1 cash balance $11,500 $0 30 March 1 outstanding borrowings 31 March 1 interest due 32 33 The company has a line of credit available to bolster the cash balance as needed 34 separate sheet from the actual budget and schedules 35 When preparing budgets, the company maintains their data on a 36 37 Click the Schedules and Cash Budget tab to prepare the following 1. Schedule of expected cash collections for March. 38 2. Schedule of expected cash disbursements for inventory purchases for March 39 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that 40 any interest will not be paid until the following month 41 42 43 44 Schedules and Cash Budget Budget Data ? READY 100% T Clipboard Font Styles Expected cash collections Al A B C D 1 Expected cash collections: 2 March cash collections 3 March collections on account: January sales February sales 4 5 March sales 6 7 Total cash collections 9 Payments to suppliers: 10 Accounts payable for inventory purchases, beginning balance 11 March purchases 12 Total cash payments 13 S& P Enterprises 14 Cash Budget 15 For the Month of March 16 17 18 Cash balance, March 1 19 Add cash receipts Collections from customers 20 21 Total cash available 22 Less disbursements Payments to suppliers 23 Selling and administrative expenses 24 Schedules and Cash Budget Budget Data (+ READY 100% AI ected casn collecuOns A C D 13 S & P Enterprises Cash Budget 14 15 For the Month of March 16 17 18 Cash balance, March 1 19 Add cash receipts: Collections from customers 20 21 Total cash available 22 Less disbursements: Payments to suppliers 23 Selling and administrative expenses 24 Equipment purchases 25 Dividends paid 27 Total disbursements 28 Preliminary cash balance 26 29 Financing: Additional loan 30 Loan repayments 31 Interest 32 33 Total financing 34 Cash balance, March 31 35 36 Schedules and Cash Budget Budget Data (+ READY 1008% .. 21. 1. The process capability measures Cp and Cpk differ because 1. The process capability measures Cp and Cpk differ because A) Only one ensures the process mean is centered within the limits B) Cp values above 1 indicate a capable process; Cpk values above 2 indicate a capable process C) both are identical D) Cp values for a given process will always be greater than or equal to Cpk values E) both A and D 2. A nationwide parcel delivery service keeps track of the number of late deliveries (more than 30 minutes past the time promised to clients) per day. They plan on using a control chart to plot their results. Which type of control chart(s) would you recommend? A) - and R-charts B) p-charts C) c-charts D) -, but not R-charts E) Both p- and c-charts 3. The mean and standard deviation for a process for which we have a substantial history are µ = 120 and If = 2. For the x-bar chart, a sample size of 16 will be used. What is the mean of the sampling distribution? A) 1/8 (0.125) B) 7.5 C) 2 D) 40 E) 120 4. A manager wants to build 3-sigma control limits for a process. The target value for the mean of the process is 10 units, and the standard deviation of the process is 6. If samples of size 9 are to be taken, the UCL and LCL will be A) -8 and 28 B) 16 and 4 C) 12 and 8 D) 4 and 16 E) 8 and 12 5. A process that is assumed to be in control with limits of 89 +/- 2 had sample averages of the following? 87.1, 87, 87.2, 89, 90, 89.5, 88.5, and 88. Is the process in control? A) Yes B) No, one or more averages exceeded the limits. C) Not enough information to tell. D) No, there is a distinguishable trend. E) No, two or more consecutive points are very near the lower (or upper) limit. 6. The specification for a plastic handle calls for a length of 6.0 inches ± .2 inches. The standard deviation of the process is estimated to be 0.05 inches. What are the upper and lower specification limits for this product? The process is known to operate at a mean thickness of 6.1 inches. What is the Cp and Cpk for this process? Answer: LSL = 5.8 inches, USL = 6.2 inches. Cp is 1.33, and Cpk is .67. A) True B) False 22. Cobb Company sells appliance service contracts agreeing to repair appliances for a two-year period... Cobb Company sells appliance service contracts agreeing to repair appliances for a two-year period. Cobb’s past experience is that, of the total dollars spent for repairs on service contracts, 40% is incurred evenly during the first contract year and 60% evenly during the second contract year. Receipts from service contract sales for the two years ended December 31, 2006, are as follows: align="left"> 2005 $500,000 2006 600,000 Receipts from contracts are credited to unearned service contract revenue. Assume that all contract sales are made evenly during the year. What amount should Cobb report as unearned service contract revenue at December 31, 2006? 1. $360,000 2. $470,000 3. $480,000 4. $630,000 23. A trial balance may balance even when each of the following occurs except when none of these are ... A trial balance may balance even when each of the following occurs except when none of these are correct incorrect accounts are used in journalizing. a transaction is not journalized. a transposition error is made. a journal entry is posted twice. 24. How should repayment of a long-term loan comprising repayment of the principal amount and interest... How should repayment of a long-term loan comprising repayment of the principal amount and interest due to date on the loan be treated in a cash flow statement? (a) The repayment of the principal portion of the loan is a cash flow belonging in the “investing activities” section; the interest payment belongs either in the “operating activities” section or the “financing activities” section. (b) The repayment of the principal portion of the loan is a cash flow belonging in the “investing activities” section; the interest payment belongs either in the “operating activities” section or the “investing activities” section. (c) The repayment of the principal portion of the loan is a cash flow belonging in the “investing activities” section; the interest payment belongs in the “operating activities” section (because IAS 7 does not permit any alternatives in case of interest payments). (d) The repayment of the principal portion of the loan is a cash flow belonging in the “investing activities” section; the interest payment should be netted against interest received on bank deposits, and the net amount of interest should be disclosed in the “operating activities” section. 25. QuickBooks Online Accountant allows you to request information from clients. Which of the followi... QuickBooks Online Accountant allows you to request information from clients. Which of the following 3 statements are accurate?(Select all that apply) Selecting Create client request on the Projects screen begins the process Selecting Create client request on the Work screen begins the process Checking the Notify client checkbox means the client will be sent an email To update the status of the request, select your project in the Status drop-down You can’t add attachments to a client request QuickBooks Online Accountant allows you to request information from clients. Which of the following 3 statements are accurate?(Select all that apply) Selecting Create client request on the Projects screen begins the process Selecting Create client request on the Work screen begins the process Checking the Notify client checkbox means the client will be sent an email To update the status of the request, select your project in the Status drop-down You can’t add attachments to a client request Look at these steps for creating a project and a task in QuickBooks Online Accountant: 1. _________________ 2. Select Create project in the top right 3. Name the project Year End 4. Select the Client and enter four weeks from now as the due date 5. Select Save 6. Select your newly added Year End project 7. _________________ 8. Type in the Task name – Bank reconciliation and close books 9. Due date – two weeks from now 10. Select Save Which option identifies the right steps for 1 and 7? 1. Select Work from the left menu; 7. Select Details 1. Select Team from the left menu; 7. Select Add a Task 1. Select Team from the left menu; 7. Select Status 1. Select Work from the left menu; 7. Select Add a Task The Work functionality in QuickBooks Online enables you to increase organization and efficiency. Can you identify 3 ways it does this from the options shown here?(Select all that apply) By showing a birds-eye view of what’s coming up By flagging what’s overdue By allowing you to filter by Client By sharing access to your practice Dashboard with your clients By letting your client assign tasks to you How do you change the status of a project in QuickBooks Online Accountant? Click on the project, select Done in the status drop-down Click on the project, select the edit pencil and select Done Click on the project, click the edit project link in Actions and edit the task status to select Done Click on the project and select the remove task button, select amend status and select Done 26. Analysis of Receivables Method At the end of the current year, Accounts Receivable has a balance ... Analysis of Receivables Method At the end of the current year, Accounts Receivable has a balance of $2,150,000; Allowance for Doubtful Accounts has a debit balance of $10,500; and sales for the year total $51,850,000. Using the aging method, the balance of Allowance for Doubtful Accounts is estimated as $110,000. a. Determine the amount of the adjusting entry for uncollectible accounts. $ b. Determine the adjusted balances of Accounts Receivable, Allowance for Doubtful Accounts, and Bad Debt Expense. Accounts Receivable $ Allowance for Doubtful Accounts $ Bad Debt Expense $ c. Determine the net realizable value of accounts receivable. $ 27. How should unallocated fixed overhead costs be treated? How should unallocated fixed overhead costs be treated? 1. Allocated to finished goods and cost of goods based on ending balances in the accounts. 2. Allocated to raw materials, work in process, and finished goods, based on the ending balances in the accounts. 3. Recognized as an expense in the period in which they are incurred. 4. Allocated to work in process, finished goods, and cost of goods sold based on ending balances in the accounts. 28. Q21. Ultimo Co. operates three production departments as profit centers. The following informatio... Q21. Ultimo Co. operates three production departments as profit centers. The following information is available for its most recent year. Department 2's contribution to overhead in dollars is: Dept. Sales Cost of Goods Sold Direct Expenses Indirect Expenses 1 $1,000,000 $700,000 $100,000 $80,000 2 400,000 150,000 40,000 100,000 3 700,000 300,000 150,000 20,000 a.$210,000. b.$350,000. c.$10,000. d.$260,000. e.$150,000.