Need help preparing 4 set of queries. - A bit of an Accounting Expertise is needed.
A) Information for Sy's Income Statement. Determine overall sales revenue , gross profit , and corresponding gross profit percentage, general and administrative expenses and net profit for Sy's Fishing Company for the first quarter based on the information available.
B) Information for Sy's balance sheet.Determine balance in assets, liability , and equity accounts at the end of the first quarter.
C) Information for the store's financial performance. Determine which store earned the greatest net profit for the first quarter( Be sure to show all the stores and sort in descending net profit order).
D) Information for accounts receivables. Determine the accounts balance for each customer at the end of the first quarter(Show all customers).
Must get data for the access queries from excel database that the instructor provided. How can I attach excel file to this question?
Recently Asked Questions
- Which of the following generates clones? (a) selfing hermaphrodites (b) parthenogenic females (c) haplodiploid species (d) outcrossing sexuals (e) inbreeding
- 6. In which of the following groups would you find metanephridia and nephrostomes? (a) annelids (b) flatworms (c) nematodes (d) insects (e) crustaceans
- Choose the correct conclusion below: a.) Fail to reject the null hypothesis. There is enough evidence to conclude that grades are dependent on the