What factors determine monthly purchases in the cash budget?
> Create a Financial Analysis for What SUP, Inc. as of December 31, 2019. You are to create this financial analysis as of December 31, 2019, from the information found on file ch3-02.xls. This file contains three worksheets, which are labeled Income Statem
> a. Edit Query 1 by adding the field Postal-Code from the Supplier Table and deleting the field Stateor-Province. Save this query as Ch 11 Assignment 3a before you print it. b. Edit Query 2 to include the field Category Name and to include only the catego
> a. Create and print a select query that lists the product name, quantity, supplier contact name, and supplier phone number for any Inflatable SUPs. Save this query as Ch 11 Assignment 2a before you print it. b. Create and print a select query that lists
> a. Create and print a select query that lists the buyer name, buyer phone number, and product name of product number 234. (Hint: The product number should not appear on your printed query if you answered the question correctly.) Save this query as Ch 11
> Change the structure of the What SUP database (Use the Ch10-02 file; do not use the file you just updated in Assignment 1 or 2.) a. Add the following product to the Product table. Product-ID: 117; Product-Name: LadyG; Length: 8.5; Supplier-ID: 6; Categor
> Add pictures to the What SUP database (use the Ch10-02 file; do not use the file you just updated in Assignment 1) a. Add pictures for the remaining products in the Product table using the picture files provided. Each product has a picture associated wit
> Add, change, and delete records to the What SUP database (use the Ch10-02 file) a. Add the following record to the Buyers table: BuyerID 605, Farley, 555-7187. b. Add G as a CategoryID with a CategoryName of Women’s as a category to the Category table. c
> Explain the difference between a worksheet and a workbook.
> Why would you use conditional formatting?
> Refer to the front matter at the beginning of this text and then identify some new features in the 2016 version of Excel.
> Which tool is used to establish relationships between tables?
> Identify and describe the first three steps followed in the creation of a database.
> How do you switch between the Design view and the Layout view when creating reports?
> What are the five steps necessary to create a report?
> Create and edit tables for What SUP (use the Ch9-02 file) a. Create a new table for What SUP that includes fields BuyerID, BuyerName, and BuyerPhone. The first field (BuyerID) is a Number data type; the rest are Short Text data types. All should have cap
> What questions does the Report Wizard ask?
> To be useful, how should reports be organized?
> What are reports?
> What questions does the Simple Form Wizard ask?
> Are headers and footers also a part of the record source?
> Why isn’t all information entered into a single table?
> What is the quickest way to access help while in Access?
> What and where is the navigation pane?
> Describe the Ribbon.
> What and where is the Quick Access Toolbar?
> Create new reports for What SUP (use the Ch9-02 file) a. Create and print a report for What SUP that lists the supplier ID, supplier name, and city from the supplier table. (Use the supplier table to locate field names.) The report should have no groupin
> Why would you use the File menu in Access?
> Identify some new features in the 2016 version of Access.
> How are tables related?
> What is a relational database?
> Describe ways in which Access is used in Accounting.
> What is a DBMS?
> Describe how Excel can be used to calculate an allowance for uncollectible accounts using the aging method.
> Describe how Excel can be used to calculate an allowance for uncollectible accounts using the percent of sales method.
> Describe how to create a trend line for a chart.
> Describe the Excel functions used in the Least Squares/Regression method of predicting costs.
> Create new forms for What SUP (use the Ch9-02 file) a. Create and print a form for What SUP that lists all fields from the supplier table in a columnar format. (Note: Once again, use the supplier table to locate field names.) Save the form as Supplier Fo
> Describe the Excel functions used in the Hi-Lo method of predicting costs.
> Describe the FV function in Excel and its arguments.
> Describe the PMT function in Excel and its arguments.
> Describe the PV function in Excel and its arguments.
> Compare the percent of sales and aging methods of determining uncollectible accounts expense and the ending allowance for the uncollectible accounts balance.
> Identify the five variables in present value problems.
> How is the goal seeking feature used in this chapter?
> What information is provided in the financing activities portion of the cash budget?
> What information is provided in the investing activities portion of the cash budget?
> Why does the typical cash budget spread payment of purchases over more than one month?
> Create new queries for What SUP (use the Ch9-02 file) a. Create and print a query for What SUP that lists the supplier name, contact name, and phone number of every supplier. (Note: Be sure to use the supplier table to locate field names.) Save the query
> Modify What SUP Sales Worksheet Using the student file Ch2-04.xlsx, add appropriate formulas to the existing Fanatic SUP Sales worksheet to calculate price, total sales for each SUP for the week, and total sales for all Fanatic SUP. Complete this workshe
> What information is provided in the operating cash payments portion of the cash budget?
> Why does the typical cash budget spread collection of sales revenue over more than one month?
> What information is provided in the operating cash receipts portion of the cash budget?
> How is grouping used with the cash budget?
> Why should you locate budget assumptions in a special section of the worksheet?
> Describe the goal seek process.
> Describe the formula computing interest expense each period for a bond.
> What function is used to calculate bond proceeds, and what arguments does that function take?
> Describe the formula for computing interest expense each period for a loan.
> Create a new What SUP Allowance for Uncollectible Accounts Analysis a. Using the ch7-03 file to start your work, create a worksheet to do the following: i. Calculate uncollectible accounts expense and the allowance for uncollectible accounts using the pe
> What does a loan amortization schedule do?
> Why does the payment function result in a negative number?
> What arguments does the loan payment function take?
> What function is used to calculate a loan payment?
> Describe the Scenario Manager.
> Explain the difference between a loan and a bond.
> How do you add a new series of data to an existing chart?
> What additional argument is added for these depreciation functions?
> What other depreciation functions are built into Excel?
> What is the purpose of a depreciation summary?
> Create a new What SUP Cost Analysis a. Using the ch7-02 file to start your work, create a worksheet to do the following: i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost. ii. Predicted expense under the Hi-Lo Method assuming 2,000 ope
> Should references used as arguments to the SLN function be absolute or relative?
> Why should the arguments in the SLN function be values or references?
> Should the arguments in the SLN function be values or references?
> What arguments does the SLN function take?
> Describe the shape of the three lines in a depreciation comparison chart depicting straight-line, double declining balance, and sum-of-the-year’s digits depreciation.
> What function is built-into Excel to help you calculate straight-line depreciation?
> Which ratios are usually formatted as percentages?
> Why is the point-and-click method of cell referencing easier than typing references directly into worksheet cells?
> What do solvency ratios represent?
> What do liquidity ratios represent?
> Create a new What SUP Present Value Analysis a. Using the ch7-01 file to start your work, modify that worksheet to do the following: i. Calculate the annuity payment required at the end of each year for the next 4 years at 4 percent such that the value i
> What do profitability ratios represent?
> What base amount is used for horizontal analysis of both income statements and balance sheets? Give an example.
> What base amount is used for vertical analysis of a balance sheet?
> What base amount is used for vertical analysis of an income statement?
> Which ratios are usually formatted as numbers?
> What is another term for vertical analysis?
> Explain the importance of parentheses in formulas.
> Explain the arguments used in the SUM function.
> How are formulas written in Excel?
> What does the Format Painter tool do?
> Create a new What SUP Operating Cash Payments Budget Using the ch6-03 file to start your work, create a worksheet similar to the one created in this chapter to budget operating cash payments by month for 3 months. Place assumption information in the cell
> How do you control the appearance of data in a worksheet?
> Explain the process for changing column width or row height.
> What does it mean when a cell or cells in a worksheet include a series of # signs?
> Identify the difference between labels and values.
> How does the AutoFill feature of Excel help the worksheet user?
> Explain how information is entered into an Excel worksheet.
> What is the recommended procedure for printing a workbook or worksheet?
> How do you change the name of a sheet in a workbook?
