Chapter 5, Problem 3CA

You work for a beverage company that sells coffee and tea. Your boss has asked you to help set up thecompany’s new database using Microsoft Access and then perform some queries in Access to determineinformation that your boss needs to give to the senior management. You are given a flat file(Beverage_Co_Sp25.xls) with the company’s sales information. When you open the file, you notice that it is notset up in efficient tables. You must create efficient tables in Excel before importing the data into MicrosoftAccess. Then, you need to run queries to gather the information your boss needs.Excel InstructionsYou will need to create 5 efficient tables from the one worksheet in the Excel file you have been given:Customers, Employees, Sales, Inventory, and SalesItems. You will need to determine which columns need to beincluded in each table and delete any duplicates and blank rows in the tables.Furthermore, once you have created the Sales table, make sure to change the name of the…

Provide correct answer general accounting question

Meric Mining Inc. recently reported $16,300 of sales, $7,900 in operating costs other than depreciation, and $1,600 in depreciation. The company had no amortization charges, it had outstanding $6,550 of bonds that carry a 6.50% interest rate, and its federal-plus-state income tax rate was 40%. How much was the firm's net income after taxes? Meric uses the same depreciation expense for tax and stockholder reporting purposes.