For Q2-Q4, all relevant data is here:

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

Save the "Fish Market Sea Bass.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 sea bass during one month. open the Fish Market Sea Bass.txt file located at the Business Analytics website: http://www.small-big-data.com/ The data shows the weights of sea bass, in pounds, delivered to Joseph's fish market during one month. For the whole monthly delivery, the supplier charged Joseph $24,951.90. Joseph would like to find the "right price" for the fish. Joseph estimates that only about 80 percent of the delivered fish are sold to customers while the remaining 20 percent are "lost on the way." 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 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 $12. Joseph is considering a profit margin of 35 percent