Do I average the 3 years to get annual? demand? I need help number of orders annual cost holding, annual cost of ordering, total cost of inventory. Those are most important.I want to know how to do it not just the answer

Executive Summary Bama Burger Buggy is a local food truck company. They currently have multiple trucks serving meals in the local area. Bama Burger Buggy also has a central storage and kitchen facility that preps everything for the day. Inventory is held at the central storage facility and administrative duties are done there. Bama Burger prides themselves on fresh, homemade products. Everything they sell is handmade in their central kitchen facility. The current inventory policy for hamburger patties is to place an order for 750 patties to be made when the inventory levels get below 200 units. However, they would like to move to an inventory policy that would minimize their holding and ordering costs. Project Description Bama Burger has noticed that their inventory costs are high after they benchmarked their performance against Aubie Roadkill, a rival food truck company. Bama Burger did an ABC Analysis on the entire inventory they order. They have found that Ground Beef, Buns, and Coffee Beans account for 78% of their overall Annual Dollar Volume. Therefore, they want to focus on these three products. Their current policy has their total inventory costs around $36,108 for the ground beef, buns, and coffee beans. This is $14,932 in holding costs and $21,176 in ordering costs. These two costs are their only inventory costs. Bama Burger believes there is a better way to order their inventory to minimize their annual inventory costs. They have hired you, an outside consultant, to find this better way. The inventory holding costs and ordering costs are below for each item. Holding costs for their Ground Beef consists of refrigeration costs of $1.75 per oz. per year, operating costs of $0.50 per oz. per year, and $0.40 for warehousing. The ordering costs for the Ground Beef is $15.00 per order. Holding costs for their Buns consists of operating costs of $0.58 per bun per year and $0.46 for warehousing. The ordering costs for the Buns is $3.00. Holding costs for their Coffee Beans consists of operating costs of $1.24 per pound of coffee per year and $0.59 for warehousing. The ordering costs for the Coffee Beans is $25.00. You have the daily demand data for the past 3 years. Deliverables Bama Burger has provided daily consumption of their Ground Beef, Buns, and Coffee Beans. Bama Burger has asked you to calculate how many ounces of Ground Beef they should order at a time, Buns they should order at a time, and Coffee Beans they should order at a time. Furthermore, they would like to know how many times they should plan on ordering so they can ensure they have enough space. They would like a short paragraph that describes how much money your ordering plan will save them and why Bama Burger should deploy your plan. Assignment Download the "BBB - Inv Student file" from Blackboard to your computer. Rename the file "BamalD_Inv Extra Credit (example: jenortham_Inv Extra Credit) before you submit your completed assignment. Please keep it as an Excel file (.xlsx) or (.xlsm). Other spreadsheet file types will not be accepted. Do not change the names on the tabs. "Documentation" Sheet - Type your name in Cell B3 as the Author. Type the date in B4. "Inventory Data" Sheet - You may manipulate the data as you see fit on this page. Each column holds informatio you may find helpful in your analysis. The following is a data dictionary for the listed information: "Date" - Date of Usage "Day" - Day of the week (Monday - Sunday) "Open" - Bama Burger Buggy is not open 7 days per week. 1 = "Yes, we are open.", 0 = "Closed" "Ground Beef Consumed (oz.)"- How many ounces of ground beef were used on this day "Buns Consumed"-How many buns were used for Hamburgers and Cheeseburgers on this day "Coffee Beans Consumed"-How many pounds were used for Coffee Beans on this day "Deliverables" Sheet - 1. Calculate the Annual Demand (C6, C18, and C30) for each item 2. Calculate the Ordering Cost (C7, C19, and C31) for each item 3. Input the Holding Cost (C8, C20, and C32) for each item 4. Calculate the optimal ordering quantity (C10, C22, and C34) for each item 5. Calculate the expected number of orders (C11, C23, C35) per year 6. Calculate the annual cost of holding (C12, C24, C36) 7. Calculate the annual cost of ordering ( C13,C25,C37) 8. Calculate the annual cost of inventory (C14, C26, C38) 9. Input the original total inventory costs prior to your analysis (F6) 10. Calculate the new total inventory costs with what your analysis came up with (F7) 11. Calculate the total savings with the new inventory ordering quantities in terms of Total Inventory Cost. (F10) 12. Give your Observation and Recommendation in the merged cells E19:037. You must have information in all of the Deliverables and Documentation sheet places listed above. If you do not, credit will be given. Bama Burger Buddy Inventory Analysis Executive Summary Bama Burger Buggy is a local food truck company. They currently have multiple trucks serving meals in the local area. Bama Burger Buggy also has a central storage and kitchen facility that preps everything for the day. Inventory is held at the central storage facility and administrative duties are done there. Bama Burger prides themselves on fresh, homemade products. Everything they sell is handmade in their central kitchen facility. The current inventory policy for hamburger patties is to place an order for 750 patties to be made when the inventory levels get below 200 units. However, they would like to move to an inventory policy that would minimize their holding and ordering costs. Project Description Bama Burger has noticed that their inventory costs are high after they benchmarked their performance against Aubie Roadkill, a rival food truck company. Bama Burger did an ABC Analysis on the entire inventory they order. They have found that Ground Beef, Buns, and Coffee Beans account for 78% of their overall Annual Dollar Volume. Therefore, they want to focus on these three products. Their current policy has their total inventory costs around $36,108 for the ground beef, buns, and coffee beans. This is $14,932 in holding costs and $21,176 in ordering costs. These two costs are their only inventory costs. Bama Burger believes there is a better way to order their inventory to minimize their annual inventory costs. They have hired you, an outside consultant, to find this better way. The inventory holding costs and ordering costs are below for each item. Holding costs for their Ground Beef consists of refrigeration costs of $1.75 per oz. per year, operating costs of $0.50 per oz. per year, and $0.40 for warehousing. The ordering costs for the Ground Beef is $15.00 per order. Holding costs for their Buns consists of operating costs of $0.58 per bun per year and $0.46 for warehousing. The ordering costs for the Buns is $3.00. Holding costs for their Coffee Beans consists of operating costs of $1.24 per pound of coffee per year and $0.59 for warehousing. The ordering costs for the Coffee Beans is $25.00. You have the daily demand data for the past 3 years. Deliverables Bama Burger has provided daily consumption of their Ground Beef, Buns, and Coffee Beans. Bama Burger has asked you to calculate how many ounces of Ground Beef they should order at a time, Buns they should order at a time, and Coffee Beans they should order at a time. Furthermore, they would like to know how many times they should plan on ordering so they can ensure they have enough space. They would like a short paragraph that describes how much money your ordering plan will save them and why Bama Burger should deploy your plan. Assignment Download the "BBB - Inv Student file" from Blackboard to your computer. Rename the file "BamalD_Inv Extra Credit (example: jenortham_Inv Extra Credit) before you submit your completed assignment. Please keep it as an Excel file (.xlsx) or (.xlsm). Other spreadsheet file types will not be accepted. Do not change the names on the tabs. "Documentation" Sheet - Type your name in Cell B3 as the Author. Type the date in B4. "Inventory Data" Sheet - You may manipulate the data as you see fit on this page. Each column holds informatio you may find helpful in your analysis. The following is a data dictionary for the listed information: "Date" - Date of Usage "Day" - Day of the week (Monday - Sunday) "Open" - Bama Burger Buggy is not open 7 days per week. 1 = "Yes, we are open.", 0 = "Closed" "Ground Beef Consumed (oz.)"- How many ounces of ground beef were used on this day "Buns Consumed"-How many buns were used for Hamburgers and Cheeseburgers on this day "Coffee Beans Consumed"-How many pounds were used for Coffee Beans on this day "Deliverables" Sheet - 1. Calculate the Annual Demand (C6, C18, and C30) for each item 2. Calculate the Ordering Cost (C7, C19, and C31) for each item 3. Input the Holding Cost (C8, C20, and C32) for each item 4. Calculate the optimal ordering quantity (C10, C22, and C34) for each item 5. Calculate the expected number of orders (C11, C23, C35) per year 6. Calculate the annual cost of holding (C12, C24, C36) 7. Calculate the annual cost of ordering ( C13,C25,C37) 8. Calculate the annual cost of inventory (C14, C26, C38) 9. Input the original total inventory costs prior to your analysis (F6) 10. Calculate the new total inventory costs with what your analysis came up with (F7) 11. Calculate the total savings with the new inventory ordering quantities in terms of Total Inventory Cost. (F10) 12. Give your Observation and Recommendation in the merged cells E19:037. You must have information in all of the Deliverables and Documentation sheet places listed above. If you do not, credit will be given. Bama Burger Buddy Inventory Analysis