New Perspectives Excel 365 | Module 8: SAM Project B Quench Drinkware скачать в хорошем качестве

New Perspectives Excel 365 | Module 8: SAM Project B Quench Drinkware

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 B Quench Drinkware PROJECT STEPS Jermaine Hooper is a financial analyst for Quench Drinkware, a manufacturer of insulated mugs in Baltimore, Maryland. He is developing a workbook to analyze the profitability of a new series of drinkware for outdoor enthusiasts. He asks you to help analyze the sales data to determine how the company can increase profits. Go to the Expedition Income Analysis worksheet, which lists the revenue and expenses for the Expedition series of drinkware and calculates the net income. Create a one-variable data table as follows to calculate the revenue, expenses, and net income based on units sold: In cell E6, enter a formula without using a function that references the Units_sold cell, which is the expected number of Expedition units sold. In cell F6, enter a formula without using a function that references the Total_revenue cell, which is the expected total sales for the Expedition mugs. In cell G6, enter a formula without using a function that references the Total_expenses cell, which is the expected total expenses for the Expedition mugs. In cell H6, 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 E6:H16 and then complete the one-variable data table, using cell C6 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 E5:G16). Resize and position the chart so it covers the range I4:N16. Clarify the purpose of the chart and focus on the areas containing data as follows: Use Break Even as the chart title. Change the Minimum bound of the horizontal axis to 40,000 and let the Maximum bound adjust automatically. Change the Minimum bound of the vertical axis to 1,700,000 and let the Maximum bound adjust automatically. Jermaine also wants you to examine how varying the sales price and volume affects net income for the Expedition products. He has already entered the net income in cell E20 and sales prices in the range F20:J20. Create a two-variable data table as follows to calculate the net income based on the sales price and units sold: For the range E20:J30, create a two-variable data table using the price per unit (cell C7) as the Row input cell. Use the number of units sold (cell C6) as the Column input cell. Apply a custom format to cell E20 to display the text Units/Price in place of the cell value Jermaine has created two scenarios in the Expedition 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. 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: Higher Price Scenario Values Provide a report on the scenarios for Jermaine as follows: Use the Scenario Manager to create a Scenario Summary report that summarizes the effect of the Current, Lower Price, and Higher Price scenarios. Use the total revenue, total expenses, and net income in the range C25:C27 as the result cells. Go to the Scenario Summary worksheet and delete column D, which repeats the current values. Return to the Expedition Income Analysis worksheet. Create a Scenario PivotTable report of the three scenarios displaying the total revenue, total expenses, and net income (the range C25:C27) 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. Remove the filter from the PivotTable. Jermaine asks you to compare the three scenarios in a chart. Create a PivotChart as follows: Create a Clustered Column #samproject1b #samprojects #cengageassignments #NP_EX365_8b #NP_EXCEL #excel_assignments #excel_sam_projects #Module8SamProjectb #quench_drinkware #new_perspectives_excel #NP_EX365_8b_FirstLastName_1.xlsx #NP_EX365_8b_FirstLastName_2.xlsx