NEED to know HOW to solve for the blanks using excel.

NEED the question: "Could Herman have computed this figure if he had not taken a physical inventory on April 30th? Why or why not?" explained and answered as well.

St. John's Hospital foodservice director, Herman Zindu, has a problem. He has the following information about his operation for the month of April, but has forgotten how to compute costs of food sold for the month. Use Herman's figures to compute actual cost of food sold and food cost percentage for his operation First, help him calculate the value of his inventory on April 30th Item Inventory Value Unit lb Ib lb lb pound case ga case case case case case loaf bags Item Amount Item Value on April 30th 225 376 489 6 Corned Beef 7 Rib Roast 8 Hamburger 9 Chicken Breasts 10 Sausage Links 11 Bacon 12 Milk 13 Tomatoes (4x5) 14 Bananas 15 Oranges 16 Lemons 17 Lettuce 18 Bread 19 Rice 20 Total 21 22 Inventory March 31 23 24 April Purchases 25 Meats 26 27 Fruits and Vegetables 28 All Others Foods $8.25 $6.75 $2.75 $2.50 $2.40 $62.00 $4.00 $25.00 $15.00 $30.00 $28.00 $26.30 $2.50 $12.00 303 92 138 52 89 60 53 421 59 $22,184.50 $11.501.00 6,300.00 9.641.00 32 384.00 ai Total Purchases 30 1No. of Employees Eating Dail 85 61 25 Ready