For Q1-Q5, all relevant data is here:

http://www.small-big-data.com

Save the Fish Market Sea Bass.txt file, Fish Market Sea Bass Transactions.txt file, Fish Market Sea Bass Beginning Inventory.txt file, and Fish Market Sea Bass Ending Inventory.txt file as txt and import in excel

Thanks!!

Joseph Czerniakow is the owner of a fish market. To better understand his business Joseph asked his assistant, Rachel Hirsh, to record the weights of See Bass delivered to his business during one month. He also asked Rachel to record information about all sales transactions as well as beginning and ending inventory Open Fish Market See Bass.txt, Fish Market See Bass Transactions.txt, Fish Market See Bass Beginning Inventory.txt, and Fish Market See Bass Ending inventory txt files The first data set shows the weights of See Bass, in pounds, delivered to Joseph's fish market during one month. For the whole monthly delivery, the supplier charged Joseph $24,951.90. The second data set gives information about Joseph's sales: for each transaction the weight of the fish sold, in pounds, and the total amount charged in this particular transition, in dollars, are given. The third and fourth data set shows the weights of See Bass, in pounds, that was on inventory at the beginning and end of the month Joseph pays a monthly rent of $2,000 for his store and $1,000 for utilities (electricity, heating, water, sewer, garbage removal, phone, WiFi, etc). The issuance bill is an additional $500. Joseph's monthly salary is $4000 and Rachel's is $2500. In addition, Joseph always employs several part-time sales associates for a total of 200 hours per month at an hourly wage of $12 Joseph would like to find out if his business is profitable. To assess his profitability, Joseph ask Rachel to prepare an internal income statement for his business for one month. This income statement should include 5 rows: Sales Revenue/(Less Cost of Goods Sold/Gross Profit/(Less Operating Expenses/operating Income. Assuming that Joseph paid a constant price of 3.25 per pound for See Bass, the accounting figures need to reflect beginning and ending inventory Joseph Czerniakow is the owner of a fish market. To better understand his business Joseph asked his assistant, Rachel Hirsh, to record the weights of See Bass delivered to his business during one month. He also asked Rachel to record information about all sales transactions as well as beginning and ending inventory Open Fish Market See Bass.txt, Fish Market See Bass Transactions.txt, Fish Market See Bass Beginning Inventory.txt, and Fish Market See Bass Ending inventory txt files The first data set shows the weights of See Bass, in pounds, delivered to Joseph's fish market during one month. For the whole monthly delivery, the supplier charged Joseph $24,951.90. The second data set gives information about Joseph's sales: for each transaction the weight of the fish sold, in pounds, and the total amount charged in this particular transition, in dollars, are given. The third and fourth data set shows the weights of See Bass, in pounds, that was on inventory at the beginning and end of the month Joseph pays a monthly rent of $2,000 for his store and $1,000 for utilities (electricity, heating, water, sewer, garbage removal, phone, WiFi, etc). The issuance bill is an additional $500. Joseph's monthly salary is $4000 and Rachel's is $2500. In addition, Joseph always employs several part-time sales associates for a total of 200 hours per month at an hourly wage of $12 Joseph would like to find out if his business is profitable. To assess his profitability, Joseph ask Rachel to prepare an internal income statement for his business for one month. This income statement should include 5 rows: Sales Revenue/(Less Cost of Goods Sold/Gross Profit/(Less Operating Expenses/operating Income. Assuming that Joseph paid a constant price of 3.25 per pound for See Bass, the accounting figures need to reflect beginning and ending inventory