It’s food and beverage control class in Hospitality Management.Production AssignmentIntroThe purpose of this assignment is to familiarize students with a real life example of calculating food production.Approaches can differ slightly from restaurant to restaurant. This assignment provides an approach that a localrestaurant uses. This particular restaurant’s production is split into three sections: First, meat and seafood; second,produce, dressing & sauces; and third, desserts, grocery & seasonal. For the sake of time and simplicity, we will onlybe completing production for the meat and seafood section.ApproachDuring this assignment you will complete the following:Points Possible1. Calculate the popularity index for all the items on the menu.2 pts.needed8 pts.3. Using the production margin of safety, determine the build up (BU) amount (aka production par) for each day foreach production item. Using the build up (BU) amount and the on hand (OH) amount, calculate the production (PR)amount and the product usage (USE).8 pts.4. Compare the theoretical usage from the menu item sales record and the actual usage from the production to identifyany discrepancies.4 pts.5. On this sheet write at least 5 things you learned from this assignment.3 pts.To complete this assignment, make sure all yellow fields are filled out.Menu Item NameItems Sold Popularity IndexASIAGO BAGUETTE43

BACON CHEESE BURGER48BCN WRAPPED SCALLOPS30BEER BATT SHRIMP40BLACK HALIBUT44BLACK SALMON24BREAD PUDDING25BREADED SCALLOPS16BREWCHEESE25BROWNIE SUNDAY26BRUSCHETTA18CAESAR SALAD3CAESAR WITH CHICKEN52CAJUN SHRIMP LING22CALAMARI44CHEESE BURGER64CHEESE FRIES28CHEESE PIZZA6CHICKEN ‘N CHIPS56CHICKEN NACHOS62CHICKEN PESTO PIZZA38CHICKEN PICATTA56CHICKEN QUESADILLA34CLAM CHOWDER BOWL52CLAM CHOWDER CUP88COBB SALAD99COCONUT SHRIMP33COD FISH & CHIPS30COOKIE47CRAB CAKES43D/FISH TACOS34DINNER GLAZED SALMON35FRIED SHRIMP10FRIED ZUCCHINI27GARLIC BURGER115GRILLED CHICKEN SAL41GRILLED HALIBUT37GRILLED SALMON21GRILLED TUNA90HALIBUT F&C177HALIBUT SAND37HAMBURGER26HOPPERS CHIX SAND62KID BURGER29KID CHICKEN34KID CORN DOG12KID GRILLED CHEESE21KID PIZZA47KID QUESADILLA5KIDS FISH AND CHIPS9L/ HALIBUT F&C109L/COD FISH & CHIPS35L/FISH TACOS33L/SALMON F&C1LUNCH BLACK HALIBUT30LUNCH BLACK SALMON13LUNCH GARLIC BURGER5LUNCH GLAZED SALMON10MARGHERITE PIZZA28NEW YORK STEAK85NY CHEESECAKE22ONION RINGS26ONION STACK SIRLOIN28OSCAR BENEDICT8PUB CLUB97QUESADILLAS14RED CRAB CLAWS18S&1/2S BLT12S&1/2S HOT HAM & CH7S&1/2S TURK AVO TOM36SALMON F&C1SAMPLER45SAUSAGE PEPPERONI31SHRIMP LING17SHRIMP SALAD42SMOKED CHICKEN PIZZA28SNOW CRAB 1 LB.25SOUP W/ SALAD58STEAK SANDWICH71STEAMED CLAMS6SUPREME DREAM36TRADITIONAL SALAD134TRADITIONAL WINGS101TURKEY AVO TOM SANDWIC113TURKEY DIP71VANILLA ICE CREAM143475TotalTotal Guest CountItems Sold to Guest Count Rati28541.218Menu Item ForecastGuest Count% of Total Weekly Guest CountMonday30110.5%ASIAGO BAGUETTEBACON CHEESE BURGERBCN WRAPPED SCALLOPSBEER BATT SHRIMPBLACK HALIBUTBLACK SALMONBREAD PUDDINGBREADED SCALLOPSBREWCHEESEBROWNIE SUNDAYBRUSCHETTACAESAR SALADCAESAR WITH CHICKENCAJUN SHRIMP LINGCALAMARICHEESE BURGERCHEESE FRIESCHEESE PIZZACHICKEN ‘N CHIPSCHICKEN NACHOSCHICKEN PESTO PIZZACHICKEN PICATTACHICKEN QUESADILLACLAM CHOWDER BOWLCLAM CHOWDER CUPCOBB SALADCOCONUT SHRIMPCOD FISH & CHIPSCOOKIECRAB CAKESD/FISH TACOSDINNER GLAZED SALMONFRIED SHRIMPFRIED ZUCCHINIGARLIC BURGERGRILLED CHICKEN SALGRILLED HALIBUTGRILLED SALMONGRILLED TUNAHALIBUT F&CHALIBUT SANDHAMBURGERHOPPERS CHIX SANDKID BURGERKID CHICKENKID CORN DOGKID GRILLED CHEESEKID PIZZAKID QUESADILLAKIDS FISH AND CHIPSL/ HALIBUT F&CL/COD FISH & CHIPSL/FISH TACOSL/SALMON F&CLUNCH BLACK HALIBUTLUNCH BLACK SALMONLUNCH GARLIC BURGERLUNCH GLAZED SALMONMARGHERITE PIZZANEW YORK STEAKNY CHEESECAKEONION RINGSONION STACK SIRLOINOSCAR BENEDICTPUB CLUBQUESADILLASRED CRAB CLAWSS&1/2S BLTS&1/2S HOT HAM & CHS&1/2S TURK AVO TOMSALMON F&CSAMPLERSAUSAGE PEPPERONISHRIMP LINGSHRIMP SALADSMOKED CHICKEN PIZZASNOW CRAB 1 LB.SOUP W/ SALADSTEAK SANDWICHSTEAMED CLAMSSUPREME DREAMTRADITIONAL SALADTRADITIONAL WINGSTURKEY AVO TOM SANDWICHTURKEY DIPVANILLA ICE CREAMForecasted Guest CountItems Sold to Guest Count RatiTuesday33611.8%Wednesday35712.5%Thursday43515.2%Seafood & Meat Production Item ForecastFriday60521.2%Saturday56219.7%Sunday2589.0%Total2854100.0%MondayAHI 8OZCALAMARI 14OZCALAMARI 5OZCLAM PACKS 16OZCOD F & C 3X2OZCRAB CAKES 3X2OZHALIBUT SAND 4OZHALIBUT 6OZHALIBUT 8OZHALIBUT F & C 3X2OZSALMON 6OZSALMON 8OZSALMON CHUNKS 6 OZSCALLOP K-BOBS 4EASHRIMP 13/15 5EASHRIMP 51/60 6OZSHRIMP, BAY 2.5OZTUNA 5OZRED CRAB CLAWS 16 OZSCALLOPS, BREADED 6OZSNOW CRAB 16OZNEW YORK 12OZTOP SIRLOIN 11OZTOP SIRLOIN 6OZCHICKEN & CHIPS 4X2OZCHICKEN PICATTA 2X5OZCHICKEN WINGS 12EAGARLIC BURGERS 8OZPEPPERONI PORTIONS 30ZSAUSAGE PORTIONS 4OZSMOKED CHICKEN 5OZTURKEY PACKS 3OZTURKEY PACKS 4OZTURKEY PACKS 6OZTuesdayWednesday ThursdayFridayProductioSaturdaySundayProduction ItemAHI 8OZGRILLED TUNACALAMARI 14OZCALAMARICALAMARI 5OZSAMPLERCLAM PACKS 16OZSTEAMED CLAMSCOD F & C 3X2OZCOD FISH & CHIPSCRAB CAKES 3X2OZCRAB CAKESHALIBUT SAND 4OZHALIBUT SANDHALIBUT 6OZLUNCH BLACK HALIBUTHALIBUT 8OZBLACK HALIBUTHALIBUT F & C 3X2OZHALIBUT F&CSALMON 6OZL/SALMON F&CSALMON 8OZBLACK SALMONSALMON CHUNKS 6 OZD/FISH TACOSSCALLOP K-BOBS 4EABCN WRAPPED SCALLOPSSHRIMP 13/15 5EABEER BATT SHRIMPSHRIMP 51/60 6OZCAJUN SHRIMP LINGSHRIMP, BAY 2.5OZSHRIMP SALADTUNA 5OZGRILLED TUNARED CRAB CLAWS 16 OZ RED CRAB CLAWSSCALLOPS, BREADED 6OZ BREADED SCALLOPSSNOW CRAB 16OZSNOW CRAB 1 LB.NEW YORK 12OZNEW YORK STEAKTOP SIRLOIN 11OZONION STACK SIRLOINTOP SIRLOIN 6OZSTEAK SANDWICHCHICKEN & CHIPS 4X2OZ CHICKEN ‘N CHIPSCHICKEN PICATTA 2X5OZ CHICKEN PICATTACHICKEN WINGS 12EATRADITIONAL WINGSGARLIC BURGERS 8OZGARLIC BURGERPEPPERONI PORTIONS 30ZSAUSAGE PEPPERONISAUSAGE PORTIONS 4OZ SAUSAGE PEPPERONISMOKED CHICKEN 5OZSMOKED CHICKEN PIZZATURKEY PACKS 3OZS&1/2S TURK AVO TOMTURKEY PACKS 4OZPUB CLUBTURKEY PACKS 6OZTURKEY AVO TOM SANDWICHints:Daily menu item sales = % of total weekly guest count * popularity index * forecasted guest count * items sold to guest count ratioUse production item key to determine which menu items to include in the production item forecast. Those that include multiple items need to be added together30121.218ction Item KeyAssociated Menu ItemsKIDS FISH AND CHIPSL/COD FISH & CHIPSGRILLED HALIBUTL/ HALIBUT F&CLUNCH BLACK SALMON LUNCH GLAZED SALMONSALMON F&CDINNER GLAZED SALMONGRILLED SALMONL/FISH TACOSSHRIMP LINGLUNCH GARLIC BURGERTURKEY DIPSEAFOOD AND MEATJanuaryITEMMonday1Tuesday2Wednesday3Thursday4Friday5Saturday6Sunday7BU OH PR USE BU OH PR USE BU OH PR USE BU OH PR USE BU OH PR USE BU OH PR USE BU OH PR USEAHI 8OZ1111133CALAMARI 14OZ0121011CALAMARI 5OZ1211022CLAM PACKS 16OZ1111111COD F & C 3X2OZ4311433CRAB CAKES 3X2OZ2232122HALIBUT SAND 4OZ1000000HALIBUT 6OZ2110110HALIBUT 8OZ1120111HALIBUT F & C 3X2OZ2840099SALMON 6OZ1213122SALMON 8OZ1320223SALMON CHUNKS 6 OZ3211322SCALLOP K-BOBS 4EA2211122SHRIMP 13/15 5EA1120111SHRIMP 51/60 6OZ3211222SHRIMP, BAY 2.5OZ2111111TUNA 5OZ0333333RED CRAB CLAWS 16 OZ1102211SCALLOPS, BREADED 6OZ1112111SNOW CRAB 16OZ1212122NEW YORK 12OZ2100011TOP SIRLOIN 11OZ0112111TOP SIRLOIN 6OZ1210022CHICKEN & CHIPS 4X2OZ2003111CHICKEN PICATTA 2X5OZ1302132CHICKEN WINGS 12EA2230022GARLIC BURGERS 8OZ2233412PEPPERONI PORTIONS 30Z0111111SAUSAGE PORTIONS 4OZ1111111SMOKED CHICKEN 5OZ1121011TURKEY PACKS 3OZ2131111TURKEY PACKS 4OZ1122111TURKEY PACKS 6OZ5100211Menu Item Sales RecordGuest CountMonday310Tuesday Wednesday Thursday352362441Theoretical Usage (Total Menu Item Sales)Friday602Saturday578Sunday274Total2919ASIAGO BAGUETTEBACON CHEESE BURGERBCN WRAPPED SCALLOPSBEER BATT SHRIMPBLACK HALIBUTBLACK SALMONBREAD PUDDINGBREADED SCALLOPSBREWCHEESEBROWNIE SUNDAYBRUSCHETTACAESAR SALADCAESAR WITH CHICKENCAJUN SHRIMP LINGCALAMARICHEESE BURGERCHEESE FRIESCHEESE PIZZACHICKEN ‘N CHIPSCHICKEN NACHOSCHICKEN PESTO PIZZACHICKEN PICATTACHICKEN QUESADILLACLAM CHOWDER BOWLCLAM CHOWDER CUPCOBB SALADCOCONUT SHRIMPCOD FISH & CHIPSCOOKIECRAB CAKESD/FISH TACOSDINNER GLAZED SALMON653552323220725831784546811436444584453424320635731895848111654644457477341342083684168574712114465556856944344318391251101061058141464775591010710463664113510137110168119121522871210889106101165355311047166110156127921208511106545334322322052463056454478335433445335425125281628261835722467031656723858375488102383053443534FRIED SHRIMPFRIED ZUCCHINIGARLIC BURGERGRILLED CHICKEN SALGRILLED HALIBUTGRILLED SALMONGRILLED TUNAHALIBUT F&CHALIBUT SANDHAMBURGERHOPPERS CHIX SANDKID BURGERKID CHICKENKID CORN DOGKID GRILLED CHEESEKID PIZZAKID QUESADILLAKIDS FISH AND CHIPSL/ HALIBUT F&CL/COD FISH & CHIPSL/FISH TACOSL/SALMON F&CLUNCH BLACK HALIBUTLUNCH BLACK SALMONLUNCH GARLIC BURGERLUNCH GLAZED SALMONMARGHERITE PIZZANEW YORK STEAKNY CHEESECAKEONION RINGSONION STACK SIRLOINOSCAR BENEDICTPUB CLUBQUESADILLASRED CRAB CLAWSS&1/2S BLTS&1/2S HOT HAM & CH1412552913528341241113330411131022311222112313553101963744135111655042113123441112321131455411256495323611155405111313333113221115167541333741045149111755052125163451173221252710952146851466241112256507312716466223332225268752227751159341112199608312619553220243113103411116424341250111440310126233191211102811843402497179432563303511225169116373203613610299222272791051518128404425327714181113923851.24306425339915161117824441.2650642643711151515141324641.2860953764813162218171425731.30709657751216172218221547511.25607638841014173520311447191.24404314327513141010713261.193504532184234236075737142103124801736621.25S&1/2S TURK AVO TOMSALMON F&CSAMPLERSAUSAGE PEPPERONISHRIMP LINGSHRIMP SALADSMOKED CHICKEN PIZZASNOW CRAB 1 LB.SOUP W/ SALADSTEAK SANDWICHSTEAMED CLAMSSUPREME DREAMTRADITIONAL SALADTRADITIONAL WINGSTURKEY AVO TOM SANDWICTURKEY DIPVANILLA ICE CREAMTotal Items SoldItems Sold to Guest Count RatiMondayTuesdayWednesday ThursdayFridayProduction Item KeySaturdayTotalProduction ItemAHI 8OZGRILLED TUNACALAMARI 14OZCALAMARICALAMARI 5OZSAMPLERCLAM PACKS 16OZSTEAMED CLAMSCOD F & C 3X2OZCOD FISH & CHIPSCRAB CAKES 3X2OZCRAB CAKESHALIBUT SAND 4OZHALIBUT SANDHALIBUT 6OZLUNCH BLACK HALIBUTHALIBUT 8OZBLACK HALIBUTHALIBUT F & C 3X2OZHALIBUT F&CSALMON 6OZL/SALMON F&CSALMON 8OZBLACK SALMONSALMON CHUNKS 6 OZD/FISH TACOSSCALLOP K-BOBS 4EABCN WRAPPED SCALLOPSSHRIMP 13/15 5EABEER BATT SHRIMPSHRIMP 51/60 6OZCAJUN SHRIMP LINGSHRIMP, BAY 2.5OZSHRIMP SALADTUNA 5OZGRILLED TUNARED CRAB CLAWS 16 OZ RED CRAB CLAWSSCALLOPS, BREADED 6OZ BREADED SCALLOPSSNOW CRAB 16OZSNOW CRAB 1 LB.NEW YORK 12OZNEW YORK STEAKTOP SIRLOIN 11OZONION STACK SIRLOINTOP SIRLOIN 6OZSTEAK SANDWICHCHICKEN & CHIPS 4X2OZ CHICKEN ‘N CHIPSCHICKEN PICATTA 2X5OZ CHICKEN PICATTACHICKEN WINGS 12EATRADITIONAL WINGSGARLIC BURGERS 8OZGARLIC BURGERPEPPERONI PORTIONS 30ZSAUSAGE PEPPERONISAUSAGE PORTIONS 4OZ SAUSAGE PEPPERONISMOKED CHICKEN 5OZSMOKED CHICKEN PIZZATURKEY PACKS 3OZS&1/2S TURK AVO TOMTURKEY PACKS 4OZPUB CLUBTURKEY PACKS 6OZTURKEY AVO TOM SANDWICSaturdayTotalHintsCopy M3:AN36 from sheet 2 to M3:AN36 of this sheet to quickly calculate the theoreRecerence the USE columns in sheet 3 fill in the actual usageAHI 8OZCALAMARI 14OZCALAMARI 5OZCLAM PACKS 16OZCOD F & C 3X2OZCRAB CAKES 3X2OZHALIBUT SAND 4OZHALIBUT 6OZHALIBUT 8OZHALIBUT F & C 3X2OZSALMON 6OZSALMON 8OZSALMON CHUNKS 6 OZSCALLOP K-BOBS 4EASHRIMP 13/15 5EASHRIMP 51/60 6OZSHRIMP, BAY 2.5OZTUNA 5OZRED CRAB CLAWS 16 OZSCALLOPS, BREADED 6OZSNOW CRAB 16OZNEW YORK 12OZTOP SIRLOIN 11OZTOP SIRLOIN 6OZCHICKEN & CHIPS 4X2OZCHICKEN PICATTA 2X5OZCHICKEN WINGS 12EAGARLIC BURGERS 8OZPEPPERONI PORTIONS 30ZSAUSAGE PORTIONS 4OZSMOKED CHICKEN 5OZTURKEY PACKS 3OZTURKEY PACKS 4OZTURKEY PACKS 6OZAssociated MeActual Usage (Usage from Production)MondayTuesdayWednesday ThursdayFridayAHI 8OZCALAMARI 14OZCALAMARI 5OZCLAM PACKS 16OZCOD F & C 3X2OZCRAB CAKES 3X2OZHALIBUT SAND 4OZHALIBUT 6OZHALIBUT 8OZHALIBUT F & C 3X2OZSALMON 6OZSALMON 8OZSALMON CHUNKS 6 OZSCALLOP K-BOBS 4EASHRIMP 13/15 5EASHRIMP 51/60 6OZSHRIMP, BAY 2.5OZTUNA 5OZRED CRAB CLAWS 16 OZSCALLOPS, BREADED 6OZSNOW CRAB 16OZNEW YORK 12OZTOP SIRLOIN 11OZTOP SIRLOIN 6OZCHICKEN & CHIPS 4X2OZCHICKEN PICATTA 2X5OZCHICKEN WINGS 12EAGARLIC BURGERS 8OZPEPPERONI PORTIONS 30ZSAUSAGE PORTIONS 4OZSMOKED CHICKEN 5OZTURKEY PACKS 3OZTURKEY PACKS 4OZTURKEY PACKS 6OZSales to Actual Use Variance (Actual Use – Unit Sales)MondayAHI 8OZCALAMARI 14OZCALAMARI 5OZCLAM PACKS 16OZCOD F & C 3X2OZCRAB CAKES 3X2OZHALIBUT SAND 4OZHALIBUT 6OZHALIBUT 8OZHALIBUT F & C 3X2OZSALMON 6OZSALMON 8OZSALMON CHUNKS 6 OZSCALLOP K-BOBS 4EASHRIMP 13/15 5EASHRIMP 51/60 6OZSHRIMP, BAY 2.5OZTUNA 5OZRED CRAB CLAWS 16 OZSCALLOPS, BREADED 6OZSNOW CRAB 16OZNEW YORK 12OZTOP SIRLOIN 11OZTOP SIRLOIN 6OZTuesdayWednesday ThursdayFridaySaturdayTotalCHICKEN & CHIPS 4X2OZCHICKEN PICATTA 2X5OZCHICKEN WINGS 12EAGARLIC BURGERS 8OZPEPPERONI PORTIONS 30ZSAUSAGE PORTIONS 4OZSMOKED CHICKEN 5OZTURKEY PACKS 3OZTURKEY PACKS 4OZTURKEY PACKS 6OZWhich item(s) require additional investigation? What could be the potential cause?ction Item KeyAssociated Menu ItemsKIDS FISH AND CHIPSL/COD FISH & CHIPSGRILLED HALIBUTL/ HALIBUT F&CLUNCH BLACK SALMON LUNCH GLAZED SALMONSALMON F&CDINNER GLAZED SALMONGRILLED SALMONL/FISH TACOSSHRIMP LINGLUNCH GARLIC BURGERTURKEY DIPkly calculate the theoretical usageeIn the space provided below, list atleast 5 things you learned from this assignment