Explain the difference between a worksheet and a workbook.
> The Wine Depot is contemplating several alternative means of financing their annual acquisition of $70,000 in equipment. One option is to borrow $300,000 from a local bank for 5 years at 11 percent per annum. The bank has asked them to produce a 4-year c
> Kelly’s Boutique is contemplating several means of financing their acquisition of $200,000 in special equipment. One alternative is to borrow $200,000 from a local bank for 10 years at 12 percent per annum. The bank has asked them to produce a 1-year cas
> Rosey’s Roses is considering several alternative means of financing an expansion. One alternative is to borrow $100,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 10-ye
> Snick’s Board Shop is considering several alternative means of financing an expansion. One alternative is to borrow $65,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 2
> Wine Depot is considering several alternative means of financing an expansion. One alternative is to borrow $500,000 from a local bank, but another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 3-year d
> Kelly’s Boutique is contemplating several alternative means of financing an expansion. One alternative is to borrow $425,000 from a local bank; another alternative is to borrow this amount from investors by issuing bonds. Both alternatives involve a 5-ye
> Rosey’s Roses owned the fixed assets shown below as of December 31, 2019: This assignment has no beginning student file. You are to create Rosey’s fixed asset depreciation worksheets using the straight-line depreciatio
> Snick’s Board Shop owned the fixed assets shown below as of December 31, 2018: You are to create Snick’s fixed asset depreciation worksheets using the straight-line depreciation method and based on the information in t
> The Wine Depot owned the following fixed assets as of December 31, 2018: You are to create Wine Depot’s fixed asset depreciation summary and individual depreciation worksheets using the straight-line depreciation method and based on the
> Create a new worksheet to calculate depreciation for a table purchased on August 1, 2017, for $95,000. It has an estimated salvage value of $2,000 and is to be depreciated over 10 years using the straight-line method. Follow the same process used in the
> Kelly’s Boutique owned the following fixed assets as of December 31, 2018: You are to create a fixed asset depreciation summary and individual depreciation worksheets for Kelly’s Boutique using the straight-line deprec
> You are to create a financial analysis for Rosey’s Roses as of December 31, 2022, and December 31, 2023. Following the Chapter 3 examples, use the student file ch3-07.xls to create a vertical analysis of the balance sheet and income statement as of Decem
> You are to create a financial analysis for Snick’s Board Shop as of December 31, 2017, and December 31, 2018. Following the Chapter 3 examples, use the student file ch3-06.xls to create a vertical and horizontal analysis of the balance sheet and income s
> You are to create Wine Depot’s financial analyses as of December 31, 2020, and as of December 31, 2021. Following the Chapter 3 examples, use the student file ch3-05.xls to create a vertical and horizontal analysis of the balance sheet and income stateme
> Use student file ch7-13 to solve 3 of these problems. This file has three worksheets labeled: Present and Future Values, Cost Prediction, and Allowance for Uncollectibles. Complete the file answering the questions below and then save the file as ch7-13_s
> Use student file ch7-13 to solve 3 of these problems. This file has three worksheets labeled: Present and Future Values, Cost Prediction, and Allowance for Uncollectibles. Complete the file answering the questions below and then save the file as ch7-13_s
> Use student file ch7-13 to solve 3 of these problems. This file has three worksheets labeled: Present and Future Values, Cost Prediction, and Allowance for Uncollectibles. Complete the file answering the questions below and then save the file as ch7-13_s
> The company is planning for the future and would like you to prepare a present value analysis. Using the file ch7-10, complete a present value analysis for the following situations. Save the file as ch7-10_student_name (replacing student_name with your n
> During a recent year, Snick’s Board Shop had sales on account of $45,000, collections of $45,500, write-offs of $800, a beginning balance in accounts receivable of $5,000, and a beginning balance in the allowance for uncollectible accounts of $300. At ye
> Snick’s Board Shop is trying to better understand the behavior of their utility expenses. They have accumulated utility expenses over the last 9 months and believe hours open per month are a good predictor of expense behavior. Utility expenses include el
> You are to create a depreciation chart for What SUP for Asset 1003. After completing assignments 1, 2, and 3, and following the steps shown in the chapter, create a new chart comparing straight-line, double declining balance, and sum-of-the-year’s digits
> The Wine Depot is planning for the future and would like you to prepare a present value analysis. Using the file ch7-07, complete a present value analysis for the following situations. Save the file as ch7-07_student_name (replacing student_name with you
> During a recent year, the Wine Depot had sales on account of $1,601,542, collections of $1,523,541, write-offs of $23,487, a beginning balance in accounts receivable of $758,271, and a beginning balance in the allowance for uncollectible accounts of $25,
> The Wine Depot is trying to better understand the behavior of their selling expenses. They have accumulated selling expenses over the last 6 months and believe units sold are a good predictor of expense behavior. Selling expenses include commissions on s
> Kelly is planning for the future and would like you to prepare a present value analysis. Using the file ch7-04 complete a present value analysis for the following situations. Save the file as ch7-04_student_name (replacing student_name with your name). P
> During a recent year Kelly’s Boutique had sales on account of $6,025,000, collections of $5,800,000, write-offs of $50,000, a beginning balance in accounts receivable of $500,000, and a beginning balance in the allowance for uncollectible accounts of $37
> Kelly has a very fluctuating workforce based on seasonal demand. She’s ranged from having 10 employees in one month to 35 employees in another month. Some employees are paid a salary, others are paid hourly. She would like to know more about how these co
> Open the report created in Assignment 2. Change the title of the report to Products by Buyer. Add lines to separate each buyer. Add a line above the grand total amount. Save the new report as Ch 13 Assignment 3. Make sure all values are visible and then
> Create a report using the Buyer Name, Product Name, Quantity, Unit Cost, and Total Cost fields present in the Buyer query. View the data by Buyers Table and group by Buyer Name. Use the summary option feature of Access to the sum Total Cost, showing deta
> Using the Ch13-02 file, create a report using all the fields present in the Buyer Query. View the data by Product Table with no grouping or summarization in a portrait orientation and adjusting the field width so all fields fit on a page. Title and save
> For each buyer name, create a form (using the Forms Wizard) that contains the product name, quantity, and unit price of each product that the buyer is responsible for. Use the sub-form option with a datasheet layout. Save the form as Ch 12 Assignment 7 a
> Create a Financial Analysis for What SUP, Inc. as of December 31, 2020. You are to create What SUP’s financial analysis as of December 31, 2020, from the information found on file ch3-03.xls. This file contains three worksheets, which are labeled Income
> Modify the Products form (not the Ch 12 Assignment 5 form you just created) by changing the Category ID text box control to a special combo box control, listing the choices of Category-ID and Category-Name from the Category table. (Hint: Be sure to first
> Add a new field (Taxable) to the Product Table. Make the field a Yes/ No data type. Add this new field to the Products form (not the Ch 12 Assignment 4 form you just created) to the right of the Reorder Level control. Make Product ID 116 taxable. Save th
> Sales-people earn a 10 percent commission on the price of each sale. Create a new unbound calculated control to compute the possible commission on each product. Modify the Products form (not the Ch 12 Assignment 3 form you just created) by adding a calcu
> Modify the Product form (not the Ch 12 Assignment 2 form you just created) by changing the Category ID text box control to a combo box control that lists choices of A, B, C, D, E, or F. Save the form as Ch 12 Assignment 3. Print the newly created form fo
> Modify the Products form by changing the Category ID text box control to a list box control that lists the choices as A, B, C, D, E, or F. Save the form as Ch 12 Assignment 2. Print the newly created form for Product ID 103.
> Using the Ch12-02 file, modify the Buyers form for What SUP so that it looks like Figure 12.40. Save this form as Ch 12 Assignment 1, and print record 1 using this form. Figure 12.40:
> a. Create and run an update query that increases the unit price for all products by 6 percent. Save this query as Ch 11 Assignment 7a. Create and print an additional query listing the product name and unit price after running the update query. Do not sav
> a. Create and print a select query that calculates the total sales value of all Flatwater SUPs in inventory. (Hint: You’ll need to use your completed query from assignment 5b as the source for this query. If you did not complete 5b, do it now. Format thi
> a. Create and print a select query that lists the product name unit price, unit cost, and unit gross profit for all products. Sorted in descending order by unit gross profit price. (Hint: You’ll need to create a computed field titled Unit Gross Profit wh
> a. Create and print a select query that lists the product name, unit cost, supplier name, and supplier contact name for any unit cost between $100 and $400, sorted in descending order by unit cost. Save this query as Ch 11 Assignment 4a before you print
> 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
> 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 factors determine monthly purchases in the cash budget?
> 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.
