Скачать или смотреть Illustrated Excel 2019 | Module 12 End of Module Project 1 | Spring Package Express

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

https://wa.me/message/PPXGSJS2TLWUA1

Whatsapp Contact Number:
+91 8114420233

Email ID:
[email protected]

Project Steps:
1. "Winoma Adebayo is a partner in Spring Package Express, a delivery company in Washington, DC. In an Excel workbook, she is tracking expenses and delivery charges for flat-rate packages. She asks for your help in developing scenarios and what-if analyses that identify ways to reduce costs.

Winoma wants to compare the cost to complete a shipment with the current data, increased costs, and decreased costs.
Go to the Flat Rates Worksheet. Create a scenario named Current Rates that includes the current data in cells B4:B6 as the changing cells. Create a second scenario named Increased Costs that includes the same changing cells, but change the values as shown in Table 1. Create a third scenario named Decreased Costs that includes the same changing cells, but change the values as shown in Table 1."
Create a scenario.
Set the input cell values for a scenario.
Create a scenario.
2. Winoma asks you to compare the results of the three scenarios. Create a Scenario Summary Report for result cell B8. On the Scenario Summary worksheet, delete column D to avoid repeating the data shown in column E.
Create a Scenario Summary Report.
3. "Return to the Flat Rates worksheet. Winoma wants to determine how increasing or decreasing labor costs will affect the cost to complete each shipment.
Create a one-variable data table based on the labor cost data in the range D3:E8. Use the labor per hour value (cell B4) as the column input cell. Use a Custom number format to display the text ""Cost per shipment"" in cell E3 instead of the formula result. "
Create a single-variable data table.
Change the number format.
4. In the range A11:B16, Winoma wants to determine what the supplies per shipment cost should be so that the cost to complete each shipment is $30.00. Use Goal Seek to set the cost to complete each shipment (cell B16) to a value of 30. Change the supplies per shipment cost (cell B13) to achieve the goal.
Use Goal Seek.
5. In the range A18:B23, Winoma wants to determine what the labor per hour cost should be so that the cost to complete each shipment is $30.00. Use Goal Seek to set the cost to complete each shipment (cell B23) to a value of 30. Change the labor per hour cost (cell B19) to achieve the goal.
Use Goal Seek.
6. "Go to the Daily Flat-Rate Expenses worksheet. Most of the flat-rate packages the company handles can be delivered within two days, so Winoma knows they can reduce the number of scheduled shipments to as few as 20 per day. She wants to find out how many shipments to schedule to reduce total expenses to $2,100.
Run Solver and set the objective to set total expenses (cell D4) to a target value of $2,100. Use the scheduled shipments (the range B10:D10) as the changing cells. Specify that the scheduled shipments must be greater than or equal to 20 and that the values are integers (int). Make unconstrained variables non-negative and use GRG Nonlinear as the solving method. Run Solver and keep the solution."
Define the objective cell in a Solver model.
Define the changing cells in a Solver model.
Define the constraints in a Solver model.
Define the solving method in a Solver model.
7. "Go to the Employees worksheet. Winoma wants to compare the data on this worksheet with delivery data, stored on the Deliveries worksheet. She wants to analyze the delivery charges by manager.
Add the data in the range A3:D27 to the data model, specifying the table you are creating has headers. Go to the Deliveries worksheet, and then add the data in the range A3:D27 to the data model, specifying the table you are creating has headers.
In Power Pivot, rename Table1 using Employees as the new table name. Rename Table2 using Deliveries as the new table name. Create a PivotTable on a new worksheet named Deliveries by Manager based on the Employees and Deliveries tables."
Create a PivotTable.
8. Modify the PivotTable so that it displays the Location field data from the Employees table as the row headings, the Manager field data from the Employees table as the second row headings, and the Package Type field data from the Deliveries table as the column headings. Display the sum of the Delivery Charge field data as the values. Format the delivery charges as Currency values with 0 decimal places and the $ symbol.
Add fields as rows in a PivotTable.
Add fields as rows in a PivotTable.
Add fields as columns in a PivotTable.
Summarize field values in a PivotTable.
Modify the number format of a PivotTable field.
9. Use Power Pivot to create a relationship between the primary Employee table and the related Deliveries table using EmpID as the column that relates the tables.
Create a relationship between tables.