New Perspectives Excel 365 | Module 8: SAM Project A Iris Footwear скачать в хорошем качестве

New Perspectives Excel 365 | Module 8: SAM Project A Iris Footwear

If you directly want to get the project from us then contact us on our Whatsapp. Link is given here, Whatsapp Contact Link: https://api.whatsapp.com/message/4B6NMKKBK... Whatsapp Number: +919116641093 Gmail Id: singhal.agrawal.bharati@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. New Perspectives Excel 365 | Module 8: SAM Project A Iris Footwear PROJECT STEPS Pedro Olmos is a sales analyst for Iris Footwear, an athletic footwear manufacturer in New Orleans, Louisiana. He is developing a workbook to analyze the profitability of a new line made from sustainable materials. He asks you to help analyze sales data to determine how the company can increase profits. Go to the EcoPro Income Analysis worksheet, which lists the revenue and expenses for the EcoPro shoe and calculates the net income. Pedro wants to compare the financial outcomes for varying amounts of shoes sold and identify the number of pairs the company needs to sell to break even. He has already named cells for many values in the range B6:B27. Create a one-variable data table as follows to calculate the revenue, expenses, and net income based on units sold: In cell D6, enter a formula without using a function that references the Units_sold cell, which is the expected number of EcoPro units sold. In cell E6, enter a formula without using a function that references the Total_revenue cell, which is the expected total sales for the EcoPro shoes. In cell F6, enter a formula without using a function that references the Total_expenses cell, which is the expected total expenses for the EcoPro shoes. In cell G6, enter a formula without using a function that references the Net_income cell, which is the expected net income for the product. Select the range D6:G16 and then complete the one-variable data table, using cell B6 as the Column input cell for the data table. Provide a visual representation of the break-even data as follows: Create a Scatter with Straight Lines chart based on the units sold, revenue, and expenses in the data table (the range D5:F16). Resize and position the chart so it covers the range H4:M16. Clarify the purpose of the chart and focus on the areas containing data as follows: Use Break-Even Point as the chart title. Change the Minimum bound of the horizontal axis to 30,000 and let the Maximum bound adjust automatically. Change the Minimum bound of the vertical axis to 2,500,000 and let the Maximum bound adjust automatically. Pedro also wants you to examine how varying the sales price and volume affects net income for the EcoPro shoes. He has already entered the net income in cell D20 and sales prices in the range E20:I20. Create a two-variable data table as follows to calculate the net income based on the sales price and units sold: For the range D20:I30, create a two-variable data table using the price per unit (cell B7) as the Row input cell. Use the number of units sold (cell B6) as the Column input cell. Apply a custom format to cell D20 to display the text Units/Price in place of the cell value. Pedro has created two scenarios in the EcoPro Income Analysis worksheet. The Current scenario assumes the current values for units sold, price, and fixed expenses (salaries and benefits, distribution, and miscellaneous). The Reduced Price scenario assumes more units sold at a lower price. He asks you 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. Table 1: Increased Price Scenario Values Provide a report on the scenarios for Pedro as follows: Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Reduced Price, and Increased Price scenarios. Use the total revenue, total expenses, and net income in the range B25:B27 as the result cells. Go to the Scenario Summary worksheet and delete column D, which repeats the current values. Return to the EcoPro Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income (the range B25:B27) for each scenario. Go to the Scenario PivotTable worksheet. Make the PivotTable easier to interpret as follows: Change the Value Field Settings of the Total_Revenue, Total_Expenses, and Net_Income values to use the Currency number format with 0 decimal places and the $ symbol. Display negative values in red, enclosed in parentheses. Rem #samproject1a #samprojects #cengageassignments #NP_EX365_8a #NP_EXCEL #excel_assignments #excel_sam_projects #Module8SamProjecta #iris_footwear #new_perspectives_excel #NP_EX365_8a_FirstLastName_1.xlsx #NP_EX365_8a_FirstLastName_2.xlsx