use excel to create graphs

fresh, delicious donuts and other pastries ever since. The Donuts House now has one store in Columbus, and plan to have a second one at Phenix City, also. In order to make better business decisions, Steve invited a group of talented business students to help him conduct a series of analyses. As a return, the students get a chance to eat FREE donuts at Dr. Donuts House once a month until they graduate from CSU. As such, please read the below information provided by Steve and do what-if analysis, sensitivity. analysis, goal-seeking analysis, and optimization analysis, respectively. 1) The sales revenue of the Donut House in 2018 is $150,000 and the growth rate is expected at 125% (increased by 25% ) in 2019 . Steve also wants to know the sales in 2019 if the growth rate ranges from 100% to 300%, ie 100%,125%,150%275%,300% (what-if analysis). 2) Dr. Donuts sold about 150,000 donuts per year and the average price per donut is $1. The cost of each donut is about $0.20. The annual store rent is $45,000 and payroll is about $60,000 per year. Specifically, Steve wants to know the impact of price ( i=0.5,1.0,1.5,2.0,2.5) and units sold (i.e. 140,000,150,000,160,000,170,000, and 180,000 ) on the net profit (sensitivity analysis). 3) Envisioning huge potential of his donut business, Steve hope to earn $20,000 profits in 2019. Considering price unchanged, how many donuts should Dr. Donuts sell this year. Use the information in 2) such as cost of each donut, annual store ren, etc. as well. (gaal-seeking analysis). 4) In fact, there are several factors that Dr. Donuts should consider while making more profits. The first one is that due to limited hands, the maximum donuts the House can produce and sell are about 200,000 . Also, the store rent is at least $30,000 in town. In addition, according to relevant federal and state labor laws, the minimum pay for the employees (so far, only two) in the Donuts House is $50,000 per year. Considering the above three constraints, calculate the maximum profit that Dr. Donuts House can make for this year. Use the information in 2) such as cost of each donut, annual store ren, etc. as well. (ontimization analysis). Hints: - Operation profit = Sales (Revenue) - Cost of Goods Sold (COGS) - SG\&A Expenses - Sales = Units Sold * Price per Unit - cogs= Units Sold * Cost per Unit Requirement: Please generate a profeasional report with brief explanations, based on your business analysen using Vacel. What-If Analysis: checks the impact of a change in a variable or assumption on the model. For example, "What will happen to the supply chain if a hurricane in Florida reduces holding inventory from 30% to 10% ?' A user would be able to observe and evaluate any changes that occurred to the values in the model, especially to a variable such as profits. Users repeat this analysis with different variables until they understand all the effects of various situations. Sensitivity Analysis: A special case of what-if analysis, is the study of the impact on other variables when one variable is changed repeatedly. Sensitive analysis is useful when users are uncertain about the assumptions made in estimation the value of certain key variables. For example, repeatedly changing revenue by small increments to determine its effect on other variables would help a manger understand the impact of various revenue levels on their decision factors. Goal-Seeking Analysis: Finds the inputs necessary to achieve a goal such as a desired level of output. It is the reverse of what-if and sensitivity analysis. Instead of observing how changes in a variable affect other variables, goal-seoking analysis sets a target value (a goal) for a variable and then repeatedly changes other variables until the target value is achieved. For example, customers must purchase a new product to increase gross profits to $5 million. Qptimization Analyeis: An Extenaion of goal-seeking analyais, finds the optimum value for a target variable by repeatedly changing other variables, subject to specified constraints. By changing revenue and cost variables in an optimization analysis, mangers can calculate the highest potential profits. Constraints on revenue and cost variables can be taken into consideration, such as limits on the amount of raw materials and the company can afford to purchase and limits on employees available to meet production needs. fresh, delicious donuts and other pastries ever since. The Donuts House now has one store in Columbus, and plan to have a second one at Phenix City, also. In order to make better business decisions, Steve invited a group of talented business students to help him conduct a series of analyses. As a return, the students get a chance to eat FREE donuts at Dr. Donuts House once a month until they graduate from CSU. As such, please read the below information provided by Steve and do what-if analysis, sensitivity. analysis, goal-seeking analysis, and optimization analysis, respectively. 1) The sales revenue of the Donut House in 2018 is $150,000 and the growth rate is expected at 125% (increased by 25% ) in 2019 . Steve also wants to know the sales in 2019 if the growth rate ranges from 100% to 300%, ie 100%,125%,150%275%,300% (what-if analysis). 2) Dr. Donuts sold about 150,000 donuts per year and the average price per donut is $1. The cost of each donut is about $0.20. The annual store rent is $45,000 and payroll is about $60,000 per year. Specifically, Steve wants to know the impact of price ( i=0.5,1.0,1.5,2.0,2.5) and units sold (i.e. 140,000,150,000,160,000,170,000, and 180,000 ) on the net profit (sensitivity analysis). 3) Envisioning huge potential of his donut business, Steve hope to earn $20,000 profits in 2019. Considering price unchanged, how many donuts should Dr. Donuts sell this year. Use the information in 2) such as cost of each donut, annual store ren, etc. as well. (gaal-seeking analysis). 4) In fact, there are several factors that Dr. Donuts should consider while making more profits. The first one is that due to limited hands, the maximum donuts the House can produce and sell are about 200,000 . Also, the store rent is at least $30,000 in town. In addition, according to relevant federal and state labor laws, the minimum pay for the employees (so far, only two) in the Donuts House is $50,000 per year. Considering the above three constraints, calculate the maximum profit that Dr. Donuts House can make for this year. Use the information in 2) such as cost of each donut, annual store ren, etc. as well. (ontimization analysis). Hints: - Operation profit = Sales (Revenue) - Cost of Goods Sold (COGS) - SG\&A Expenses - Sales = Units Sold * Price per Unit - cogs= Units Sold * Cost per Unit Requirement: Please generate a profeasional report with brief explanations, based on your business analysen using Vacel. What-If Analysis: checks the impact of a change in a variable or assumption on the model. For example, "What will happen to the supply chain if a hurricane in Florida reduces holding inventory from 30% to 10% ?' A user would be able to observe and evaluate any changes that occurred to the values in the model, especially to a variable such as profits. Users repeat this analysis with different variables until they understand all the effects of various situations. Sensitivity Analysis: A special case of what-if analysis, is the study of the impact on other variables when one variable is changed repeatedly. Sensitive analysis is useful when users are uncertain about the assumptions made in estimation the value of certain key variables. For example, repeatedly changing revenue by small increments to determine its effect on other variables would help a manger understand the impact of various revenue levels on their decision factors. Goal-Seeking Analysis: Finds the inputs necessary to achieve a goal such as a desired level of output. It is the reverse of what-if and sensitivity analysis. Instead of observing how changes in a variable affect other variables, goal-seoking analysis sets a target value (a goal) for a variable and then repeatedly changes other variables until the target value is achieved. For example, customers must purchase a new product to increase gross profits to $5 million. Qptimization Analyeis: An Extenaion of goal-seeking analyais, finds the optimum value for a target variable by repeatedly changing other variables, subject to specified constraints. By changing revenue and cost variables in an optimization analysis, mangers can calculate the highest potential profits. Constraints on revenue and cost variables can be taken into consideration, such as limits on the amount of raw materials and the company can afford to purchase and limits on employees available to meet production needs