Please provide answer by also showing work in excel.

Exercise 9.1 Date Barnaby's Hideaway Daily Cumulative Cost Record Directs 1-Oct 2-Oct 3-Oct 4-Oct 5-Oct $ $ $ $ $ 200.00 100.00 120.00 150.00 80.00 Stores $ $ $ $ $ 750.00 950.00 920.00 965.00 655.00 Adjustments Total Cost Beverage Food to Today To Date to Food Beverage $ $ $ $ 25.00 $ 20.00 $ 40.00 $ 15.00 $ 35.00 30.00 50.00 30.00 Total Sales Today To Date $ 2,875.00 $ 2,950.00 $ 3,050.00 $ 3,120.00 $ 2,125.00 Food Cost % Today To Date Exercise 9.2 Date Barnaby's Hideaway Cost Report to Management 3-Oct Today Food Sales Food Cost Cost % Same Day Last Week To Date This Week Last Week $ 2,975.00 $ 1,017.00 34.18% $ 8,345.00 $ 2,963.00 35.5% $ $ $ $ $ 410.00 $ 2,573.00 $ 35.00 $ 55.00 Cost Breakdown Directs Stores Beverage to Food Food to Beverage 110.00 917.00 10.00 20.00 Date 1-Feb 2-Feb 3-Feb 4-Feb 5-Feb Date 1-Feb 2-Feb 3-Feb 4-Feb 5-Feb Exercise 9.3 Daily Cumulative Cost Record Showing Costs Subdivided into Categories of Food Vegetables Fruits Dairy Bakery Total Directs Beef and Veal Poultry Seafood Pork $ $ $ $ $ 128.03 244.24 102.00 220.21 111.33 $ $ $ $ $ 84.86 75.70 66.43 89.90 44.89 Provisions Stores $ $ $ $ $ 33.45 45.33 25.05 28.75 55.75 $ 224.99 $ 351.05 $ 274.56 $ 214.22 $ 265.35 $ $ $ $ $ 52.25 44.75 60.35 57.05 48.75 $ $ $ $ $ 335.95 425.87 395.55 378.65 411.15 Adjustments Total Cost Added to Subtracted Today To Date Cost from Cost $ 57.20 $ 255.30 $ 86.20 $ 253.40 $ 88.60 $ 177.80 $ 120.00 $ 220.00 $ 90.00 $ 170.00 $ $ $ $ $ 89.43 93.44 88.42 55.95 102.45 $ 248.60 $ 289.50 $ 269.46 $ 299.01 $ 328.70 Total Sales Today To Date $ 3,323.28 $ 3,455.88 $ 3,544.55 $ 3,622.12 $ 3,828.90 $129.43 $178.40 $223.56 $211.51 $166.29 Duck $69.64 $66.33 $56.43 $45.95 $75.57 Food Cost % Today To Date