The final project consists of a Database related to the midterm and the midterm is attached below. Database For this project, 1) your team must design a CHEN ERD model, 2)a data dictionary, and 3)

The final project consists of a Database related to the midterm and the midterm is attached below. Database For this project, 1) your team must design a CHEN ERD model, 2)a data dictionary, and 3)
11 Student Name: Mariama Diallo, Dave Williams Course Name: CIS 200 5001 Date: April 1, 2023 Business Analysis Introduction Recently, there has been a flood of interest in plant-based food items as shoppers become more aware of their well-being and the climate. Consequently, there has been a rising trend toward veganism and vegetarianism, and food manufacturers have responded by providing a greater variety of options based on plants. In this analysis, there will be an evaluation of a new business idea to sell frozen meals made from plants. Carrying out a SWOT analysis, Porter’s Five Forces analysis, and Porter’s Three Generic Strategies analysis is vital. It will determine whether or not this initiative is feasible. SWOT Examination Strength: Increasing demand for foods made from plants: The introduction of plant-based frozen meals presents a significant opportunity due to the growing vegetarianism and veganism movement. Benefits for the environment and health: Plant-based dinners are better and more harmless to the ecosystem than meat-based feasts, which are areas of strength for a point for purchasers. Unique line of products: The company stands out from its rivals by introducing a line of frozen meals made from plants. A robust distribution system: The product will reach a wide range of customers thanks to the company’s robust distribution network. Weaknesses: Inadequate customer awareness: Even though there is a rising demand for plant foods, many people are still unaware of the advantages of a plant-based diet. A lot of competition: There are many established players in the frozen meals market, and the food industry is very competitive. A limited selection of goods: The company’s focus on frozen plant-based meals may limit the variety of its products and prevent it from expanding its market share. Opportunities: Increasing trend toward eating healthily: Plant-based meals can gain popularity as consumers become more health-conscious. Introducing new markets: The company can enter new markets by providing its product line to food service providers and retailers. Association with different brands: The business can collaborate with well-known brands. It will develop new product lines and increase brand recognition. Threats: The decline in the economy: Consumer spending patterns and demand for premium food products can be affected by economic downturns. Turbulence in the supply chain: The availability and quality of the ingredients and the product’s production and distribution can be affected by disruptions in the supply chain. Changes to regulations: Policy and regulation changes can affect product production and distribution. The entry of meal kits delivery services like HelloFresh and Blue Apron into the frozen meals market illustrates the threat posed by new competitors. Meal kits offered by these businesses include premeasured ingredients and instructions for home cooking (Udin et al., 2021). It poses a threat to traditional frozen meal companies, which may see a decrease in sales as more customers choose meal kit delivery services for their convenience. The rising popularity of plant-based food products illustrates a threat to the sector. Companies like Beyond Meat and Impossible Foods have thrown off the traditional meat industry by providing plant-based alternatives to conventional meat products. It threatens frozen meal manufacturers, who might see a drop in sales of meat-based products as more people choose plant-based alternatives. The industry also faces a significant threat from buyers’ bargaining power. For instance, Nestle’s frozen food division experienced a decline in sales in 2017 due to rising competition and shifting consumer preferences. In response, the business launched a line of plant-based meals and shifted its focus to health-conscious customers (Lane et al., 2022). However, despite this change, the company still faces the challenge of competing with meal kit delivery services and other frozen meal manufacturers. Production network disturbances likewise represent a danger to frozen feast organizations. For instance, in 2019, a significant vegetable supplier to frozen food companies filed for bankruptcy, resulting in product shortages and increased costs (Lane et al.,2022). The ability of frozen meal companies to produce and distribute their products was impacted due to this disruption in the supply chain. Budget distribution: Marketing: $50,000 to educate customers about the advantages of a plant-based diet and promote frozen plant-based meals. Development and research: $100,000 to improve existing products and create new plant-based meal options. Distribution: $75,000 to reach more customers by expanding the distribution network. Staffing: $150,000 to recruit additional sales, marketing, and distribution staff. Contingency: $100,000 to prepare for supply chain disruptions and economic downturns. Compliance: $50,000 to ensure compliance with product production and distribution policies and regulations. Analysis of Porter’s Five Forces Threat from Newcomers: There are many established players in the frozen meals market, and the food industry is very competitive. However, the rising demand for plant-based diets presents a chance for new businesses to introduce novel plant-based products. Supplier bargaining power: Suppliers have a relatively weak bargaining position due to the numerous suppliers of plant-based ingredients (Bruijl and Gerard, 2018). Buyers’ bargaining power: In the frozen meals market, buyers have many options, which gives them a lot of leverage in negotiations. Threat from substitutes: Since consumers can select from various meal options, including vegetarian and meat-based options, the threat posed by substitutes is moderate. Competitive rivalry: Due to the numerous established players in the frozen meals market and the industry’s intense competition, there are a lot of rivalries (Islami et al., 2021; Bruijl and Gerard, 2018). The company should use Porter’s Five Forces Analysis for the following reasons: Identify opportunities and trends in the industry: The company can use Porter’s Five Forces Analysis to identify industry trends and opportunities. They can gain a deeper understanding of their industry and identify potential growth areas by evaluating the bargaining power of suppliers, and buyers, the threat of new entrants, the threat of substitutes, and competitive competition. Evaluate the level of competition: Can use Porter’s Five Forces Analysis to determine how competitive the industry is (Bruijl and Gerard, 2018). It can develop strategies to distinguish itself from rivals and gain a competitive advantage by comprehending the level of competition. Assess the sector’s viability: The company can use Porter’s Five Forces Analysis to determine the profitability of its industry. It can develop strategies to enhance its profitability and financial performance by comprehending the underlying factors influencing profitability. Determine any potential dangers: The company can use Porter’s Five Forces Analysis to identify potential threats to its operations. By assessing the danger of new participants, the haggling force of providers, the dealing force of purchasers, the danger of substitutes, and cutthroat competition, organizations can recognize expected dangers and foster systems to alleviate or stay away from them. Develop strategies that work: It can develop efficient strategies using Porter’s Five Forces Analysis. The company can develop strategies tailored to its specific requirements and objectives by comprehending the underlying factors influencing its industry and competitive environment. Porter’s Three Generic Strategies Cost leadership: The company can concentrate on offering its plant-based frozen meals at a lower price than its rivals, which may attract more price-conscious customers. One illustration of an organization in the food business that uses this methodology is Aldi. Aldi is a chain of discount supermarkets that focuses on offering customers low-cost products (Mustafa et al., 2020). Utilizing simple store layouts, offering a limited selection of products, and concentrating on private-label brands are some of the company’s cost-leadership strategies. By offering items at a lower cost than contenders, Aldi has had the option to catch a critical piece of the pie and rival bigger general store chains. Differentiation: Plant-based frozen meals, a one-of-a-kind line of products, has the potential to set the company apart from its rivals and draw in customers looking for food options that are both healthier and better for the environment. Ben & Jerry’s is an example of a food company that employs this strategy. Ben & Jerry’s is a brand of ice cream that stands out from its rivals by using high-quality ingredients and offering distinctive flavors. Additionally, the company is renowned for its environmental and social activism, which has contributed to developing a devoted clientele. Ben & Jerry’s has distinguished itself from other ice cream companies and maintained a strong brand identity by providing a distinctive product and emphasizing its values. Focus: The company can tailor its product line to meet the needs of a specific market segment, such as health-conscious consumers. Whole Foods Market is one company in the food industry that employs this strategy. The entire Food sources Market centers around the well-being of purchasers and offers a scope of regular and natural items. The company emphasizes social responsibility and sustainability, which appeals to its target audience (Udin et al., 2021). Whole Foods Market has successfully established a strong brand identity and retained a loyal customer base by focusing on a specific market segment and tailoring its products and services to meet their requirements. The business can take several steps to ensure compliance with regulations to guarantee success in applying Porter’s recommendation: Stay updated: The company should stay updated on all policies and regulations that affect how the product is made and distributed. It can get accomplished by regularly checking the websites of relevant government agencies, attending industry conferences and events, and subscribing to publications related to the industry. Create and implement procedures and policies: The business should develop and implement policies and procedures that guarantee compliance with regulations (Wilson, 2019). Implementing employee training programs, keeping accurate records, and establishing quality control measures are examples. Make regular checks: Audits should be conducted regularly by the business to check that its policies and procedures get followed and to find areas for improvement. Collaborate with regulatory bodies: The organization should work with administrative offices to guarantee consistency. It may entail responding to any inquiries or requests for information and submitting the necessary documentation. Keep an eye on vendors and suppliers: The business should keep an eye on its suppliers and vendors to see if they are also following the rules. It may entail requiring compliance documentation and certifications from suppliers and vendors. Continually grow: To keep its compliance program effective and up to date with changing regulations, the business should continually evaluate and enhance it. Conclusion The company has a unique chance to profit from the growing preference for plant-based diets by launching a line of frozen plant-based meals. While a few laid-out players are in the frozen feasts market, the extraordinary product offering and spotlight on plant-based fixings can separate the organization from contenders. On the other hand, the business will have to deal with a highly competitive market, a lack of consumer awareness, and the possibility of supply chain disruptions. The company can gain a significant share of the plant-based frozen meals market by concentrating on Porter’s Three Generic Strategies. References Bruijl, D., & Gerard, H. T. (2018). The relevance of Porter’s five forces in today’s innovative and changing business environment. Available at SSRN 3192207. Gallagher, C. T., Hanley, P., & Lane, K. E. (2022). Pattern analysis of vegan eating reveals healthy and unhealthy patterns within the vegan diet. Public Health Nutrition, 25(5), 1310-1320. Islami, X., Mustafa, N., & Topuzovska Latkovikj, M. (2020). Linking Porter’s generic strategies to firm performance. Future Business Journal, 6, 1-15. Jatmiko, B., Udin, U. D. I. N., Raharti, R., Laras, T., & Ardhi, K. F. (2021). Strategies for MSMEs to achieve sustainable competitive advantage: The SWOT analysis method. The Journal of Asian Finance, Economics, and Business, 8(3), 505-515. Wilson, A. V. J. (2019). A critical analysis of the discourse around food, identity, and responsibility from vegan Instagram influencers. Soc. Sci.
The final project consists of a Database related to the midterm and the midterm is attached below. Database For this project, 1) your team must design a CHEN ERD model, 2)a data dictionary, and 3)
BUSINESS ANALYSISSTUDENT NAME: MARIAMA DIALLO, DAVE WILLIAMSCOURSE NAME: CIS 200 5001DATE: APRIL 1,2023 Healthy Eaters ◦Good morning, class. My name is Mariama and Dave is my partner on this project. Dave and I chose a business analysis focusing on plant-based diets. By creating a company of frozen plant-based meals. IntroductionRecently, there has been a flood of interest in plant-based food items as shoppers become more aware of their well-being and the climateConsequently, there has been a rising trend toward veganism and vegetarianism, and food manufacturers have responded by providing a greater variety of options based on plantsIn this analysis, there will be an evaluation of a new business idea to sell frozen meals made from plantsCarrying out a SWOT analysis, Porter’s Five Forces analysis, and Porter’s Three Generic Strategies analysis is vital SWOT EXAMINATION StrengthIncreasing demand for foods made from plantsBenefits for the environment and healthUnique line of productsA robust distribution system WeaknessesInadequate customer awarenessA lot of competitionA limited selection of goods OpportunitiesIncreasing trend toward eating healthily1Introducing new markets2Association with different brands3 THREATSThe decline in the economyTurbulence in the supply chainChanges to regulations Budget DistributionMarketing: $50,000 to educate customers about the advantages of a plant-based diet and promote frozen plant-based mealsDevelopment and research: $100,000 to improve existing products and create new plant-based meal optionsDistribution: $75,000 to reach more customers by expanding the distribution networkStaffing: $150,000 to recruit additional sales, marketing, and distribution staffContingency: $100,000 to prepare for supply chain disruptions and economic downturnsCompliance: $50,000 to ensure compliance with product production and distribution policies and regulations Analysis of Porter’s Five Forces◦Threat from Newcomers: There are many established players in the frozen meals market, and the food industry is very competitive◦Supplier bargaining power: Suppliers have a relatively weak bargaining position due to the numerous suppliers of plant-based ingredients◦Buyers’ bargaining power: In the frozen meals market, buyers have many options, which gives them a lot of leverage in negotiations◦Threat from substitutes: Since consumers can select from various meal options, including vegetarian and meat-based options, the threat posed by substitutes is moderate◦Competitive rivalry: Due to the numerous established players in the frozen meals market and the industry’s intense competition, there are a lot of rivalries Reasons for the Company Using Analysis of Porter’s Five ForcesDevelopDevelop strategies that work: It can develop efficient strategies using Porter’s Five Forces AnalysisDetermineDetermine any potential dangers: The company can use Porter’s Five Forces Analysis to identify potential threats to its operationsAssessAssess the sector’s viability: The company can use Porter’s Five Forces Analysis to determine the profitability of its industryEvaluateEvaluate the level of competition: It can use Porter’s Five Forces Analysis to determine how competitive the industry isIdentifyIdentify opportunities and trends in the industry: The company can use Porter’s Five Forces Analysis to identify industry trends and opportunities Porter’s Generic StrategiesCost leadership: The company can concentrate on offering its plant-based frozen meals at a lower price than its rivals, which may attract more price-conscious customersDifferentiation: Plant-based frozen meals, a one-of-a-kind line of products, has the potential to set the company apart from its rivals and draw in customers looking for food options that are both healthier and better for the environmentFocus: The company can tailor its product line to meet the needs of a specific market segment, such as health-conscious consumers Several Steps to Ensure Compliance with RegulationsCreate and implement procedures and policies: The business should develop and implement policies and procedures that guarantee compliance with regulationsMake regular checks: Audits should be conducted regularly by the business to check that its policies and procedures get followed and to find areas for improvementCollaborate with regulatory bodies: The organization should work with administrative offices to guarantee consistencyKeep an eye on vendors and suppliers: The business should keep an eye on its suppliers and vendors to see if they are also following the rulesContinually grow: To keep its compliance program effective and up to date with changing regulations, the business should continually evaluate and enhance itStay updated: The company should stay updated on all policies and regulations that affect how the product is made and distributed. ConclusionThe company has a unique chance to profit from the growing preference for plant-based diets by launching a line of frozen plant-based mealsOn the other hand, the business will have to deal with a highly competitive market, a lack of consumer awareness, and the possibility of supply chain disruptions ReferencesBruijl, D., & Gerard, H. T. (2018). The relevance of Porter’s five forces in today’s innovative and changing business environment. Available at SSRN 3192207.Gallagher, C. T., Hanley, P., & Lane, K. E. (2022). Pattern analysis of vegan eating reveals healthy and unhealthy patterns within the vegan diet. Public Health Nutrition, 25(5), 1310-1320.Islami, X., Mustafa, N., & Topuzovska Latkovikj, M. (2020). Linking Porter’s generic strategies to firm performance. Future Business Journal, 6, 1-15.Jatmiko, B., Udin, U. D. I. N., Raharti, R., Laras, T., & Ardhi, K. F. (2021). Strategies for MSMEs to achieve sustainable competitive advantage: The SWOT analysis method. The Journal of Asian Finance, Economics and Business, 8(3), 505-515.Wilson, A. V. J. (2019). A critical analysis of the discourse around food, identity and responsibility from vegan Instagram influencers. Soc. Sci.