Sheet1CH 8, 9Excel Asst 3 Part 1First Name and Last Name ______________ID # ___________TEST RulesYou MUST use EXCEL formulas in ALL cells, if possibleSave all under FileName = ...

do my assignment


Sheet1 CH 8, 9Excel Asst 3 Part 1First Name and Last Name ______________ID # ___________TEST RulesYou MUST use EXCEL formulas in ALL cells, if possible Save all under FileName = YOUR_NAME_ASST4. STOP :Scroll down to cell A21 and READ (and follow) ALL the Assignment RULES listed there BEFORE starting this Assignment Complete the Chart by filling in the empty spaces, using EXCEL ( with = sign formulas) **= Use ALL decimal places; do NOT round up PORTION UNIT COSTTOTAL size COST APQ ConvertApplies EPCEdible Applies to Edible Price As Purchased1000 g /kg APQYieldYield EPQto Price per TotalPortionColumn MPortionFactor #QuantityKg or lbor 16 oz /lbg. or oz. Convertedg. or oz. Factor% in g or oz.Column Igram/ oz.EPC $Sizeg. or oz. Cost 120Kg1000g20000g0.85__________g$0.0030_____200g._________________ 210Kg1000g___________g_________________g$0.0159_____500g_________1.3333 315lb16oz___________oz0.8__________oz$2.1875_____4oz_________________ Assignment Rules 1Assignments must be completed and submitted during scheduled Class Time. Assignments submitted after END of scheduled Class time will be considered LATE and subject to a Penalty 2EXCEL Assignments must be completed using EXCEL Formulas, almost exclusively 3EXCEL Assignments must be completed using ONLY the EXCEL Formulas taught in Our Math Class 4EXCEL Assignments need to be opened using Google CHROME, and NOT Micosoft Edge 5EXCEL Assignments need to be SAVED in an Excel file using .xls or .xlsx file extension 6EXCEL Assignments Must NOT be completed in Google Docs or Google Sheets or MAC numbers OR Sharepoint 7EXCEL Assignments completed on a MAC laptop MUST be converted to a file readable by Non-MAC laptops 8Assignments must NOT be Submitted via Mobile phones or via Screen shots. 9Assignments must have the STUDENT's FIRST and LAST NAME and their ID Number typed in the TOP Row. 10It is Recommended that you SAVE your Assignment every 5 or 10 minutes, just in case you somehow lose your file 11Your File Should be Saved IN Excel with the File Name being Your_Name_ Asst4 STOP AGAIN : Assignment CHECKLIST - to be done BEFORE Submitting your Assignment via GBC email to YOUR Professor 1REVIEW that YOUR First and Last Name and Your GBC ID # are typed in the TOP row 2Review that YOUR Saved File name meets the Assignment Rules 3Review Your Entire Spreadsheet for LOGIC 4ALL Yield factors should be Equal to or LESS than 1.0 5ALL Price Factors should be Equal to or GREATER than 1.0 6UNIT Cost per gram/ oz. must BE LESS than the Portion Cost Sheet1 CH 10Excel Asst 3 Part 2First Name and Last Name _________________ID # ______________ Save under ….........FileName = Your_Name_Asst.5 STOP : Scroll down to cell A49 and READ (and follow) ALL the Assignment RULES listed there HOTEL AALL Percentages (%) HAVE ALREADY been converted to their decimal equivalents PLEASE remember that F & B cost percentages are connected to their respective revenues, while everything else is presented as a percentage of Total Revenue. with = signwith = sign EXCELEXCEL RED numbers are GIVENFormulaFormula HOTEL A$(decimal) SALES** FOOD0.6 BEVERAGE56000 TOTAL COSTSFOOD28560 BEVERAGE16800 TOTAL GROSS PROFIT PAYROLL0.39 OTH. EXP0.12 NET PROFIT HOTEL BRED numbers are GIVENwith = signwith = sign EXCELEXCEL FormulaFormula HOTEL B$(decimal) SALESFOOD BEVERAGE0.35 TOTAL COSTSFOOD0.34 BEVERAGE TOTAL0.326 GROSS PROFIT PAYROLL660000.3 OTH. EXP23400 NET PROFIT Assignment Rules 1Assignments must be completed and submitted during scheduled Class Time. Assignments submitted after END of scheduled Class time will be considered LATE and subject to a Penalty 2EXCEL Assignments must be completed using EXCEL Formulas, almost exclusively. 3EXCEL Assignments must be completed using ONLY the EXCEL Formulas taught in Our Math Class 4EXCEL Assignments need to be opened using Google CHROME, and NOT Micosoft Edge 4EXCEL Assignments need to be SAVED in an Excel file using .xls or .xlsx file extension 5EXCEL Assignments Must NOT be completed in Google Docs or Google Sheets or MAC numbers, or Sharepoint 6EXCEL Assignments may be completed on a MAC, BUT MUST be converted to a file readable by Non-MAC laptops 7Assignments must NOT be Submitted via Mobile phones or via Screen shots. 8Assignments must have the STUDENT's FIRST and LAST NAME and their ID Number typed in the TOP Row. 9It is Recommended that you SAVE your Assigment every 5 or 10 minutes, just in case you somehow lose your file 10Your File Should be Saved IN Excel with the File Name being Your_Name_ AsstX STOP Again Assignment CHECKLIST - to be done BEFORE Submitting your Assignment via GBC email to professor 1REVIEW that YOUR First and Last Name and Your GBC ID # are typed in theTOP row 2Review that YOUR Saved File name meets the Assignment Rules listed above 3Review for LOGIC 4The Food Revenue % and Beverage Revenue % must equal 100% 5The Food Cost % and the Beverage Cost % CANNOT equal 100% 6The Net Profit must be LESS than the Gross Profit 7NONE of the Percentages can be NEGATIVE 8NONE of the $ Amounts can be NEGATIVE. Sheet2 Sheet1 CH 7 +Excel Assign. 2First Name and Last Name__________________________ID # ______________ Save under …....FileName = YOUR_NAME_ASST3.ANSWER send via Bb STOP : Scroll down to cell A34 and READ (and follow) ALL the Assignment RULES listed there RULE :Do NOT Remove the xxx in Cells ; this means you do NOT need to Fill CH 7Hospitality Statistics Complete the "Chart" by filling in the missing numbers, using Excel Formulas (rows 15, 17, 19, 21) Be sure to use NUMBER (DECIMAL) format for Occupancy Rate, Achievement Factor AND (Management) Yield Part 1AIn this TOP Part, Use EXCEL Formulas to generate the Actual Numbers(Management) TotalRoomsOcc. RateRackxxxRoomxxxAchievementxxYield RoomsSold(decimal)RateRateFactorFactor ex. 1500$100.00xxx$60.00xxxxxx0.3 ex. 22000$200.00xxx$140.00xxxxxx0.42 ex. 321000.70xxx$270.00xxx0.9xxx ex. 440000.80$400.00xxxxxx0.75xxx CH8 All Percentages have already been converted into decimals for easier Calculation. TrimTrimmingCookingCookingCookedYieldPriceCookedPortionNumber of APQLossLoss inTrimmedLossLoss inWeightWasteYieldFactorFactorWeightSizePortions in in lbs./Kg(decimal)lbs. or Kg.Weight(decimal)lbs. or Kg.in lbs. / Kg.%%(decimal)(decimal)in oz. / g.in oz. / g.oz. or g . ex. 5200lbs0.100.24oz. ex. 6100Kg0.150.25150g Assignment Rules 1Assignments must be completed and submitted during scheduled Class Time. Assignments submitted after END of scheduled Class time will be considered LATE and subject to a Penalty 2EXCEL Assignments must be completed using EXCEL Formulas, almost exclusively (Part A) and With NO = Sign (Part B) 3EXCEL Assignments must be completed using ONLY the EXCEL Formulas taught in Our Math Class 4EXCEL Assignments need to be opened using Google CHROME, and NOT Micosoft Edge 5EXCEL Assignments need to be SAVED in an Excel file using .xls or .xlsx file extension 6EXCEL Assignments Must NOT be completed in Google Docs or Google Sheets or MAC numbers, or Sharepoint 7EXCEL Assignments may be completed on a MAC, BUT MUST be converted to a file readable by Non-MAC laptops 8Assignments must NOT be Submitted via Mobile phones or via Screen shots. 9Assignments must have the STUDENT's FIRST and LAST NAME and their ID Number typed in the TOP Row. 10It is Recommended that you SAVE your Assigment every 5 or 10 minutes, just in case you somehow lose your file 11Your File Should be Saved IN Excel with the File Name being Your_Name_ Asst3 STOP Again 1REVIEW that YOUR First and Last Name and Your GBC ID # are typed in theTOP row 2Review that YOUR Saved File name meets the Assignment Rules listed above 3Review entire Sheet for LOGIC. CH 7 4The Rooms Sold must be LESS than Total Rooms (in Hotel) 5The Rooms Occupancy CANNOT be greater than 100% (or greater than 1.0) 6The Room Rate must be LESS than the RACK rate. 7The Achievement Factor CANNOT be greater than 1.0 8The (Management) Yield Factor CANNOT be greater than 1.0 CH 8 9The Yield Factor should be LESS Than 1.0 10The Price Factor should be GREATER than 1.0