Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer it. Thank you JAP JAP Seafood Supply is the main supplier of seafood products to Japanese restaurants in Metro Manila. Using the data given

image text in transcribed

image text in transcribed

image text in transcribed

Answer it. Thank you

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

JAP JAP Seafood Supply is the main supplier of seafood products to Japanese restaurants in Metro Manila. Using the data given in Table 3 and Table 4, complete the information needed in Table 1 and answer the questions in Table 2. 0 7 8 Table 1: Sales and Cost of Sales (Complete the table. 30 pts.) 9 B D Product 0 1 ID Product Name Sales Cost of Sales 1 2 10 Ikura 2 3 13 Konbu 3 4 18 Carnarvon Tigers 4 5 30 Nord-Ost Matjeshering 5 6 36 Inlagd Sill 6 7 37 Gravad lax 27 8 40 Boston Crab Meat 28 9 41 Jack's New England Clam Chowder 29 10 45 Rgede sild 30 11 46 Spegesild 31 12 58 Escargots de Bourgogne 13 73 Rd Kaviar Cost of Sales Table 1. Sales and Cost of Sales (Complete the table. 30 pts. C Product ID Product Name Sales 10 Ikura 13 Konbu 18 Camarvon Tigers 5 30 Nord-Ost Matjeshering 6 36 Inlagd Sill 7 37 Gravad lax 8 40 Boston Crab Meat 9 41 Jack's New England Clam Chowder 10 45 Rgede sild 11 46 Spegesild 12 58 Escargots de Bourgogne 13 73 Rd Kaviar 14 Totals 3 1 2 3 14 TO ate na 33 34 35 Table 2. Various Items Complete the table. 15 pts. each) 1. When did the company experienced sales at its lowest? 36 2. How much is the highest recorded sales in a day? 37 3. That is the top selling product in terms of quantity? 38 4. How much gross profit were made from January 1 to January 15? 39 5. How many units Konbu, Rgede sild and Spegesild were sold? 40 Table 3: SALES REGISTER: 39 B 2 3 4 5 6 D 7 18 2 9 3 10 4 11 15 12 16 13 17 14 18 15 19 16 20 17 21 18 22 19 23 20 24 21 25 22 26 23 Date Product ID Particulars 01/01/16 18 Camarvon Tigers 01/02/16 46 Spegesild 01/02/16 58 Escargots de Bourgogne 01/02/16 18 Carnarvon Tigers 01/03/16 36 Inlagd Sill 01/03/16 58 Escargots de Bourgogne 01/03/16 41 Jack's New England Clam Chowder 01/04/16 37 Gravad lax 01/05/16 13 Konbu 01/05/16 41 Jack's New England Clam Chowder 01/06/16 46 Spegesild 01/07/16 30 Nord-Ost Matjeshering 01/07/16 36 Inlagd Sill 01/07/16 13 Konbu 01/07/16 41 Jack's New England Clam Chowder 01/08/16 41 Jack's New England Clam Chowder 01/09/16 36 Inlagd Sill 01/09/16 10 Ikura 01/09/16 30 Nord-Ost Matjeshering 01/09/16 10 lkura 01/09/16 41 Jack's New England Clam Chowder 01/10/16 46 Spegesild Quantity Sold 40 70 80 40 30 30 20 20 50 50 10 90 60 30 40 70 100 10 100 20 50 co C A 1 24 25 26 27 28 2 29 3 30 4 31 5 32 36 33 37 34 38 35 39 36 40 37 41 38 4239 43 40 44 41 45 42 46 43 47 44 48 45 4946 50 47 51 48 5249 B 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/11/16 01711/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 46 Spegesild 45 Rgede sild 40 Boston Crab Meat 58 Escargots de Bourgogne 73 Rd Kaviar 46 Spegesild 40 Boston Crab Meat 46 Spegesild 46 Spegesild 36 Inlagd Sill 30 Nord-Ost Matjeshering 10 Ikura 46 Spegesild 10 lkura 58 Escargots de Bourgogne 46 Spegesild 30 Nord-Ost Matjeshering 37 Gravad lax 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 73 Rd Kaviar 36 Inlagd Sill 73 Rd Kaviar 45 Rogede sild 37 Gravad lax 41 Jack's New England Clam Choud 6 2 3 80 70 100 70 20 90 60 90 90 30 100 30 70 100 40 50 20 90 80 90 50 90 40 80 90 80 149 50 151 52 53 54 55 356 0 57 1 58 2 59 3 60 34 61 55 62 56 63 67 64 68 65 69 66 70 67 71 68 7269 73 70 74 71 75 72 76 73 TT TA 78 75 B 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/16/16 01/16/16 01/16/16 01/17/16 01/18/16 D 41 Jack's New England Clam Chowder 36 Inlagd Sill 40 Boston Crab Meat 73 Rd Kaviar 73 Rd Kaviar 45 Rgede sild 36 Inlagd Sill 30 Nord-Ost Matjeshering 18 Carnarvon Tigers 45 Rgede sild 45 Rgede sild 36 Inlagd Sill 73 Rd Kaviar 73 Rd Kaviar 13 Konbu 10 Ikura 10|ikura 58 Escargots de Bourgogne 10 kura 73 Rd Kaviar 10|ikura 40 Boston Crab Meat 13 Konbu 10 ikura 36 Inlagd Sill 40 Boston Crab Meat 36 Inlagd Sill 30 90 40 70 20 10 40 60 20 30 10 20 40 90 80 E A 101 98 102 99 103 100 104 101 105 102 106 103 107 104 108 105 109 106 110 107 111 108 112 109 113 110 114 111 115 112 116 113 117 114 118 115 119 116 120 117 121 118 122 119 123 120 124 121 125 126 127 B 01/23/16 01/23/16 01/24/16 01/24/16 01/24/16 01/24/16 01/24/16 01/24/16 01/25/16 01/26/16 01/27/16 01/27/16 01/27/16 01/27/16 01/27/16 01/28/16 01/29/16 01/29/16 01/30/16 01/30/16 01/30/16 01/31/16 01/31/16 01/31/16 D 58 Escargots de Bourgogne 46 Spegesild 13 Konbu 40 Boston Crab Meat 40 Boston Crab Meat 58 Escargots de Bourgogne 18 Carnarvon Tigers 30 Nord-Ost Matjeshering 37 Gravad lax 30 Nord-Ost Matjeshering 45 Rgede sild 36 Inlagd Sill 37 Gravad lax 45 Rgede sild 58 Escargots de Bourgogne 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 37 Gravad lax 58 Escargots de Bourgogne 10|lkura 13 Konbu 46 Spegesild 41 Jack's New England Clam Chowder 10 Ikura 71 60 40 30 10 90 70 90 70 50 90 50 10 80 70 20 60 50 60 50 40 10 20 40 JAP JAP Seafood Supply is the main supplier of seafood products to Japanese restaurants in Metro Manila. Using the data given in Table 3 and Table 4, complete the information needed in Table 1 and answer the questions in Table 2. 0 7 8 Table 1: Sales and Cost of Sales (Complete the table. 30 pts.) 9 B D Product 0 1 ID Product Name Sales Cost of Sales 1 2 10 Ikura 2 3 13 Konbu 3 4 18 Carnarvon Tigers 4 5 30 Nord-Ost Matjeshering 5 6 36 Inlagd Sill 6 7 37 Gravad lax 27 8 40 Boston Crab Meat 28 9 41 Jack's New England Clam Chowder 29 10 45 Rgede sild 30 11 46 Spegesild 31 12 58 Escargots de Bourgogne 13 73 Rd Kaviar Cost of Sales Table 1. Sales and Cost of Sales (Complete the table. 30 pts. C Product ID Product Name Sales 10 Ikura 13 Konbu 18 Camarvon Tigers 5 30 Nord-Ost Matjeshering 6 36 Inlagd Sill 7 37 Gravad lax 8 40 Boston Crab Meat 9 41 Jack's New England Clam Chowder 10 45 Rgede sild 11 46 Spegesild 12 58 Escargots de Bourgogne 13 73 Rd Kaviar 14 Totals 3 1 2 3 14 TO ate na 33 34 35 Table 2. Various Items Complete the table. 15 pts. each) 1. When did the company experienced sales at its lowest? 36 2. How much is the highest recorded sales in a day? 37 3. That is the top selling product in terms of quantity? 38 4. How much gross profit were made from January 1 to January 15? 39 5. How many units Konbu, Rgede sild and Spegesild were sold? 40 Table 3: SALES REGISTER: 39 B 2 3 4 5 6 D 7 18 2 9 3 10 4 11 15 12 16 13 17 14 18 15 19 16 20 17 21 18 22 19 23 20 24 21 25 22 26 23 Date Product ID Particulars 01/01/16 18 Camarvon Tigers 01/02/16 46 Spegesild 01/02/16 58 Escargots de Bourgogne 01/02/16 18 Carnarvon Tigers 01/03/16 36 Inlagd Sill 01/03/16 58 Escargots de Bourgogne 01/03/16 41 Jack's New England Clam Chowder 01/04/16 37 Gravad lax 01/05/16 13 Konbu 01/05/16 41 Jack's New England Clam Chowder 01/06/16 46 Spegesild 01/07/16 30 Nord-Ost Matjeshering 01/07/16 36 Inlagd Sill 01/07/16 13 Konbu 01/07/16 41 Jack's New England Clam Chowder 01/08/16 41 Jack's New England Clam Chowder 01/09/16 36 Inlagd Sill 01/09/16 10 Ikura 01/09/16 30 Nord-Ost Matjeshering 01/09/16 10 lkura 01/09/16 41 Jack's New England Clam Chowder 01/10/16 46 Spegesild Quantity Sold 40 70 80 40 30 30 20 20 50 50 10 90 60 30 40 70 100 10 100 20 50 co C A 1 24 25 26 27 28 2 29 3 30 4 31 5 32 36 33 37 34 38 35 39 36 40 37 41 38 4239 43 40 44 41 45 42 46 43 47 44 48 45 4946 50 47 51 48 5249 B 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/10/16 01/11/16 01711/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/12/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 46 Spegesild 45 Rgede sild 40 Boston Crab Meat 58 Escargots de Bourgogne 73 Rd Kaviar 46 Spegesild 40 Boston Crab Meat 46 Spegesild 46 Spegesild 36 Inlagd Sill 30 Nord-Ost Matjeshering 10 Ikura 46 Spegesild 10 lkura 58 Escargots de Bourgogne 46 Spegesild 30 Nord-Ost Matjeshering 37 Gravad lax 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 73 Rd Kaviar 36 Inlagd Sill 73 Rd Kaviar 45 Rogede sild 37 Gravad lax 41 Jack's New England Clam Choud 6 2 3 80 70 100 70 20 90 60 90 90 30 100 30 70 100 40 50 20 90 80 90 50 90 40 80 90 80 149 50 151 52 53 54 55 356 0 57 1 58 2 59 3 60 34 61 55 62 56 63 67 64 68 65 69 66 70 67 71 68 7269 73 70 74 71 75 72 76 73 TT TA 78 75 B 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/13/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/14/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/15/16 01/16/16 01/16/16 01/16/16 01/17/16 01/18/16 D 41 Jack's New England Clam Chowder 36 Inlagd Sill 40 Boston Crab Meat 73 Rd Kaviar 73 Rd Kaviar 45 Rgede sild 36 Inlagd Sill 30 Nord-Ost Matjeshering 18 Carnarvon Tigers 45 Rgede sild 45 Rgede sild 36 Inlagd Sill 73 Rd Kaviar 73 Rd Kaviar 13 Konbu 10 Ikura 10|ikura 58 Escargots de Bourgogne 10 kura 73 Rd Kaviar 10|ikura 40 Boston Crab Meat 13 Konbu 10 ikura 36 Inlagd Sill 40 Boston Crab Meat 36 Inlagd Sill 30 90 40 70 20 10 40 60 20 30 10 20 40 90 80 E A 101 98 102 99 103 100 104 101 105 102 106 103 107 104 108 105 109 106 110 107 111 108 112 109 113 110 114 111 115 112 116 113 117 114 118 115 119 116 120 117 121 118 122 119 123 120 124 121 125 126 127 B 01/23/16 01/23/16 01/24/16 01/24/16 01/24/16 01/24/16 01/24/16 01/24/16 01/25/16 01/26/16 01/27/16 01/27/16 01/27/16 01/27/16 01/27/16 01/28/16 01/29/16 01/29/16 01/30/16 01/30/16 01/30/16 01/31/16 01/31/16 01/31/16 D 58 Escargots de Bourgogne 46 Spegesild 13 Konbu 40 Boston Crab Meat 40 Boston Crab Meat 58 Escargots de Bourgogne 18 Carnarvon Tigers 30 Nord-Ost Matjeshering 37 Gravad lax 30 Nord-Ost Matjeshering 45 Rgede sild 36 Inlagd Sill 37 Gravad lax 45 Rgede sild 58 Escargots de Bourgogne 30 Nord-Ost Matjeshering 30 Nord-Ost Matjeshering 37 Gravad lax 58 Escargots de Bourgogne 10|lkura 13 Konbu 46 Spegesild 41 Jack's New England Clam Chowder 10 Ikura 71 60 40 30 10 90 70 90 70 50 90 50 10 80 70 20 60 50 60 50 40 10 20 40

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 24 - The Auditors??? Opinion

Authors: Kate Mooney

2nd Edition

0071719466, 9780071719469

More Books

Students also viewed these Accounting questions

Question

who is considered the navigator for the promotion process

Answered: 1 week ago