I need to help to complete this excel spread sheet, and I need formula as well. Here is the info needed to complete.

Dear Mr. Vice President of Operations,

I need your help determining the cost of food sold for the three (3) Too Jays in the Orlando area during the first quarter. Total sales for the 3 restaurants (Dr. Philips, Colonial Market Plaza, Waterford Lakes) were $4,010,672 for the first quarter. I was able to gather the combined inventory and purchases figures for the 3 units in orlando.

We also know the following:

The restaurants in Orlando transferred 22,000 Lb. of Challah Bread to the Tampa Region. Each Lb. of Challah has a cost of $2.50

A total of 33,000 employee meals were served. Seventy Five percent of the employee meals are for lunch at a cost of $4.50 per meal. The other meals are for dinner at $4.75 a meal.

The marketing department ran a free food promotion for happy hours and the total cost of the promotion was 3% of combined sales of the 3 restaurants for the quarter.

The Orlando area restaurants are pilot testing a new recycling program. All the used oil is sold for diesel at $0.99 a Gallon. The restaurants recycled a total of 429 Gal. in the quarter.

During the quarter the employees took advantage of a special offered by the company and purchased a total of 500Lb. of Mini Black & Whites Cookies, this are considered a legendary shortbread cookies smothered in chocolate and vanilla icing. Each pound of Cookie typically sold for $4.00 a Lb., however employees only paid for the actual cost of the cookies, the FC% for 1 lb. of cookies is 25%

Please tell me the actual Cost of Food Issued, Cost of Food Consumed, and Cost of Food Sold in dollars ($$) and as a percentage (%) for the Orlando Region during the quarter?

Thanks and looking forward to hear from you.....

Mitch

AutoSave ON Home Insert Draw Page Layout Formulas Data Review View Tell me LG 11 Calibri (Body) v ' a Wrap T Paste BIU a. Av E Merged Font Alignment Clipboard A9 + x V fx B D E F G Purchases 1 2 Produce 3 Meats 4 Dairy 5 Canned Food 6 Bakery Items 7 8 Beginning Inventory $319,125 $655,604 $163,588 $111,677 $73,614 $344,655 $708,009 $176,813 $120,647 $61,884 Ending Inventory $271,256 $557,210 $139,150 $94,858 $52,877 9 10 11 12 13 14 15 16 17 18 19 + 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41