Need help preparing 4 set of queries. - A bit of an Accounting Expertises 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).  

 

$30 tip awarded up completion the right way.

Will be posting the right values and tips for guidance.

10 hour Extension will be applied if needed. 

 

store codeyearmonthmonthly_sales_budgetAtla20131$50,000Atla20132$55,000Atla20133$60,000Balt20131$65,000Balt20132$50,000Balt20133$50,000Bost20131$65,000Bost20132$65,000Bost20133$50,000Char20131$50,000Char20132$55,000Char20133$60,000Dayt20131$65,000Dayt20132$55,000Dayt20133$60,000Myrt20131$60,000Myrt20132$60,000Myrt20133$55,000Newy20131$50,000Newy20132$45,000Newy20133$65,000Port20131$55,000Port20132$65,000Port20133$65,000

Attachments:

• 1495586947-AISProjectCH08Sy_Fish_Data_for_Students 1.xlsx