Module 8: End of Module Project 1 | Four Winds Energy | PERFORM WHAT-IF ANALYSES #newperspectives

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here,

Whatsapp Contact Link:
[ Ссылка ]

Whatsapp Number:
+919116641093
+918005564456

Gmail Id:
assignmentstutorial@gmail.com

We are providing help in all Online Courses, Computer Science, Business and Management, Business Math, Business and Finance, Business and Accounting, Human Resource Management, History, English.

1. "Madhu Patel is a sales analyst for Four Winds Energy, a manufacturer of wind energy products, in San Antonio, Texas. Madhu is developing a workbook to analyze the profitability of the company's wind turbines. She asks you to help her analyze the sales data to determine how the company can increase profits.
Go to the Income Analysis worksheet, which lists the revenue and expenses for the Boreas wind turbine and calculates the net income. Madhu wants to compare the financial outcomes for varying amounts of turbines sold and identify the number of units the company needs to sell to break even. Madhu has already entered formulas in the range E5:H5 to extract data from the income analysis in the range B4:C26. In the range E5:H14, create a one-variable data table using cell C5 as the Column input cell, to calculate the revenue, expenses, and net income based on units sold."
Create a one-variable data table.
2. Madhu asks you to provide a visual representation of the break-even data. Create a Scatter with Straight Lines chart based on the units sold, revenue, and expenses in the data table (range E4:G14). Resize and position the chart so it covers the range I3:N15.
Insert a chart.
The Income Analysis worksheet should contain a scatter with straight lines chart based on the values in the range E4:G14.
Resize and reposition a chart.
3. Madhu wants to clarify the purpose of the chart and focus on the areas containing data. Use Break-Even Point as the chart title. Change the Minimum bound of the horizontal axis to 2,500 and let the Maximum bound adjust automatically. Change the Minimum bound of the vertical axis to 2,000,000 and let the Maximum bound adjust automatically.
Insert a chart title.
Change the minimum bounds of an axis.
Change the minimum bounds of an axis.
4. Madhu also wants to examine how varying sales price and volume affects net income from wind turbines. She has already entered the net income in cell E18 and sales prices in the range F18:J18. For the range E18:J27, create a two-variable data table using the price per unit (cell C6) as the Row input cell and the units sold (cell C5) as the Column input cell. In cell E18, create a custom number format that displays "Units Sold" instead of the net income value.
Create a two-variable data table.
Change the number format.
5. Madhu has also created two scenarios in the Income Analysis worksheet. The Current scenario assumes the current values for units sold, price, and fixed expenses (salaries and benefits, distribution, and miscellaneous). The Lower Price scenario assumes more units sold at a lower price. She also wants to create a scenario that assumes fewer units sold at a higher price. Create a scenario using the data shown in bold in Table 1 without applying any scenarios.
Create a scenario.
Set the input cell values for a scenario.
6. Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Lower Price, and Raise Price scenarios. Use the total revenue, total expenses, and net income in the range C24:C26 as the result cells. Go to the Scenario Summary worksheet and delete column D, which repeats the current values.
Create a Scenario Summary report.
Delete a column.
7. Return to the Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income (range C24:C26) for each scenario.

new perspectives module 8: end of module project 1, four winds energy, project end project, new perspectives module 8: end of module project 1 four winds energy, four winds energy project, project sam project four winds, shelly cashman project 1 four winds energy, shelly cashman project 1, project 1 four winds energy, Module 1-4 sam capstone project 1c, Module 7 sam project 1b, Module 5 end of module project 2

свернуть