Скачать или смотреть Illustrated Excel 365/2021 | Module 12: SAM Project 1b

Illustrated Excel 365/2021 | Module 12: SAM Project 1b #illustratedexcel #module12 #samproject1b

If you directly want to get the project from us then contact us on Whatsapp. Click on link below👇👇
https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

1. "Jessa Torres expanded her quilting hobby into a small part-time business called Avant Quilts, which sells artisan quilts via websites and retail outlets throughout the United States. She has entered the company's revenue and sales data in an Excel workbook, and asks you to help her develop scenarios and what-if analyses that identify ways to increase profits for her products.
Go to the Expenses worksheet. Jessa has created two scenarios on the worksheet, one that includes current values, and the other that reflects an increase in sales. Jessa also wants to know how profits would change if she sold 10 percent fewer quilts of each type. Create a third scenario to provide this information for Jessa as follows:
a. In the Scenario Manager, add a new scenario and use Unit Sales Decrease as the scenario name.
b. Change the values in the range F13:H13.
c. Use the information shown in Table 1 as the values for the changing cells."
Create a scenario.
Set the input cell values for a scenario.
2. "Jessa asks you to compare the results of the three scenarios.
Compare the scenarios as follows:
a. Create a Scenario Summary Report for result cells B9:B11, F14:H14.
b. On the Scenario Summary worksheet, delete column D to avoid repeating the data shown in column E.
c. Delete the contents of the range B16:B18 to remove the notes."
Create a Scenario Summary Report.
Delete a column.
Delete the contents of a range.
3. "Jessa also wants to compare the scenario results.
Create another scenario comparison as follows:
a. Return to the Expenses worksheet. Create a Scenario PivotTable Report for result cells B9:B11, F14:H14.
b. On the Scenario PivotTable worksheet, format all values using the Currency number format with 2 decimal places and the $ symbol.
c. Return to the Expenses worksheet and show the results of the Unit Sales Decrease scenario."
Create a Scenario PivotTable Report.
Modify the number format of a PivotTable field.
View the worksheet using specific scenario values.
4. "Jessa also wants to determine how increasing or decreasing the number of Aspen quilts will affect gross profit.
Go to the Profit Analysis worksheet, and then create a one-variable data table as follows:
a. In cell G8, enter a formula that references the gross profit for Aspen quilts (cell B14).
b. Create a one-variable data table based on the Aspen sales data in the range F8:G13.
c. Use the number of Aspen units sold (cell B13) as the column input cell.
d. Format the range G9:G13 using the Currency number format with 0 decimal places and the $ symbol to match the formatting of cell G8.
"
Create a formula.
Create a single-variable data table.
Change the number format.
5. "Jessa projects that sales of Aspen quilts will increase by 5 percent in the coming year and associated expenses will rise by 1.5 percent. She wants to see the result in profit if sales and expenses change at different rates.
Determine the changes in profit as follows:
a. In cell F18, enter a formula that references the projected profit for Aspen quilts (cell B22).
b. Create a two-variable data table in the range F18:K24.
c. Use the expense increase percentage (cell B21) as the row input cell.
d. Use the projected growth percentage (cell B19) as the column input cell."
Create a formula.
Create a two-variable data table.
6. "Jessa asks you to determine how many Napa quilts the company needs to sell to earn a gross profit of $3000.00.
Provide this information to Jessa as follows:
a. Use Goal Seek to set the gross profit for Napa quilts (cell C14) to a value of 3000.
b. Change the number of units sold (cell C13) to achieve the goal.
"
Use Goal Seek.

shelly cashman excel 2019 | module 1: sam project 1b,new perspectives excel 2019 | module 10: sam project 1b,new perspectives excel 2019 | module 1: end of module project 2,new perspectives excel 2019 | module 2: sam project 1a,new perspectives word 2019 | module 10: sam project 1a,new perspectives excel 2019 module 1 sam project 1a,#shelly cashman excel 2019 | module 1: sam project 1b,excel module 8 sam project,module 5 sam project 1a,module 5: sam project 1a