Butcher Test Questions

Please round to two decimal points

$2.$ The following information, taken from records in the Circle Restaurant, provides the results of butcher tests on $10$ legs of veal, Canada Grade A$1,$ 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 $$967\mathrm{.}23$ for the $10$ legs, which weighed a total of $114\mathrm{.}93$ kilograms as purchased.

Breakdown:

Trimmings: $21\mathrm{.}43$; value per kg: $ $4\mathrm{.}99$

Bones: $25\mathrm{.}62$kg;value per kg$.$: $ $1\mathrm{.}00$

Shanks: $8\mathrm{.}95$kg; value per kg: $ $7\mathrm{.}50$

Fat: $17\mathrm{.}50$kg; value per kg: $ $1\mathrm{.}00$

Loss in cutting $1\mathrm{.}13$ kg

Veal cutlets $($salable meat$)$: $40\mathrm{.}3$ kg

a$.$ Given the preceding information, complete butcher test calculations to determine standard cost of the $150$ gram portion.

b$.$ The owner of the Circle Restaurant wants portion cost for veal cutlet to be $ $3\mathrm{.}15,$ regardless of variations in dealer price. Determine the correct portion size if

$1.$ Dealer price is $ $11\mathrm{.}00/$kg

$2.$ Dealer price is $ $12\mathrm{.}10/$kg

c$.$ How many kilograms of veal leg $($as purchased$)$ will be needed to prepare and serve $175$ gram portions to $250$ people?

d$.$ 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 $175$ gram portions to $300$ people?

e$.$ 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?

f$.$ The restaurant has a banquet for $450$ people scheduled for tonight, and the manager has promised to serve veal cutlet as the entr$$e$.$ 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 $450$ people can be served?

Solve this problem in table format or in excel sheet