USE PROPER BUTCHER TEST FORMAT AND EXCEL FORMULAS Using the butcher test template, complete the butcher test calculations for a beef tenderloin. a. Top Butt Purchased: 9.5kg Price per kilo: \$12.30 Filet portion sizes: 300gr Breakdown - Fat: 1.35kg: Trim: .6kg; Cap steak: 1.4kg - value \$9.39/kg; Loss in Cutting: .13kg; Total salable: ? b. If the dealer price for beef tenderloin decreased to $11.65 per kg, what is the new portion cost? C. If you want to provide 300gr portions to 40 people, how much beef tenderloin should be purchased? Hint: Use yield percentage The following information, taken from records in the Circle Restaurant, provides the results of butcher tests on 10 legs of veal, Canada Grade A1, purchased over the last several weeks from George's Meats, Inc. Veal legs are purchased to produce 150 -gram portions of veal cutlets. The restaurant paid $850.41 for the 10 legs, which weighed a total of 119.6 kilograms as purchased. Breakdown: Fat: 18kg; Bones: 25kg; Trimmings: 21.50; Shanks: 8kg; Loss in cutting Veal cutlets (total salable) value per kg : $1.00 value per kg : $1.00 value per kg : $4.99 value per kg : $7.50 1.13kg ??? a. Given the preceding information, complete butcher test calculations (in butcher test format) to determine standard cost of the 150 gram portion. b. The owner of the Circle Restaurant wants portion cost for veal cutlet to be $2.65, regardless of variations in dealer price. Determine the correct portion size if 1. Dealer price is $7.80/kg 2. Dealer price is $8.20/kg C. Develop a chart showing the costs 130gram,155gram, and 180gram portions at dealer prices per kilogram of $8.00,$8.10, and so on in $0.10 increments up to $9.00 per kilogram. d. How many kilograms of veal leg (as purchased) will be needed to prepare and serve 150 gram portions to 250 people? e. Given the weight of the average leg of veal, as determined in the butcher test, how many legs should the steward order to prepare and serve 150 gram portions to 250 people? f. Records show that the Circle Restaurant used 48 legs of veal last month. How many standard 175 gram portions should have been produced from these 48 legs? g. The restaurant has a banquet for 500 people scheduled for tonight, and the manager has promised to serve veal cutlet as the entre. The steward neglected to order veal legs for this specific party, but there are 25 legs of veal in the house and veal cutlet is not on the regular dining room menu for tonight. Using these 25 legs of veal for the party, what size portion should be prepared so that all 500 people can be served