i need to know HOW to solve these problems using excel

14 Grilled chicken breasts are on the menu today for lunch in the cafeteria of Grey-Sloan Memorial Hospital. The cafeteria manager, Lamar, is keeping a running inventory for this item. Help him calculate his ideal ending inventory for chicken breasts and determine if there is a variance when compared to his 2 actual ending inventory. 3 Opening inventory 4 Items received 5 ltems sold 5 Adjustments (burned, wasted, e 7 Ideal ending inventory 8 Actual ending inventory 9 Difference (over or short) 0 45 20 50 Is Lamar over or short for chicken breasts? What could account for the difference in ideal and actual ending inventory? What should Lamar do to correct this next time? 4