Project Project Start Date: \\( \\quad 01 / 01 / 10 \\) Est. Duration (hours): \\( \\quad 300 \\) Completion Date: \\( \\quad 08 / 01 / 10 \\) Total Cost: \\( \\$ 15,000.00 \\) Number of Technicans: Regular Hours: OverTime Hours: Contractor Surcharge: Standard Per-Hour Rate: \\$ 50.00 Over Time Rate: \\$ \\( \\quad 75.00 \\) Regular Cost: \\( \\$ 15,000.00 \\) Over Time Cost: \\( \\$ \\) Total Hours Worked: 300 1 (25\\%). Excel: Customer - PivotTable, IF Conditions, NPV, Solver, Scenario Download \"Customer.xlsx\" file and do the following tasks. Upload the file to Submissions menu in D2L. (a) Create a Pivot Table worksheet that shows \"Rent vs Own\" (horizontal) by \"Region\" (vertical). In the Value part of pivot table, show \"Count of Customers ID\", \"Sum of Total Purchases\" and \"Sum of Num Purchases\". (b) In the Customer data worksheet, use SUMIF result in cell \\( \\mathrm{H} 4 \\) to show Sum of Total Purchases amount (\\$) who Own the house. (c) In the Customer data worksheet, use AVERAGEIF result in cell H5 to show Average of Total Purchases amount (\\$) whose Num Household is 4. (d) In the Customer data worksheet, use COUNTIF result in cell H6 to show Count Number who has more than 4 Household. (e) In the NPV worksheet, calculate the following NPV using Excel financial function and with five interest rates \(5 when you have \\( \\$ 17,000 \\) as initial cost of investment one year from today and return from first year \\( (\\$ 6,000) \\), second year \\( (\\$ 7,000) \\), and third year \\( (\\$ 8,000) \\). (f) In Solver worksheet, complete \"Pony Espresso\" with maximum total revenue. (g) In Scenario worksheet, complete \"Project\" as requested in the Tech Plug-In and show \"Summary\" worksheet, Project Project Start Date: \\( \\quad 01 / 01 / 10 \\) Est. Duration (hours): \\( \\quad 300 \\) Completion Date: \\( \\quad 08 / 01 / 10 \\) Total Cost: \\( \\$ 15,000.00 \\) Number of Technicans: Regular Hours: OverTime Hours: Contractor Surcharge: Standard Per-Hour Rate: \\$ 50.00 Over Time Rate: \\$ \\( \\quad 75.00 \\) Regular Cost: \\( \\$ 15,000.00 \\) Over Time Cost: \\( \\$ \\) Total Hours Worked: 300 1 (25\\%). Excel: Customer - PivotTable, IF Conditions, NPV, Solver, Scenario Download \"Customer.xlsx\" file and do the following tasks. Upload the file to Submissions menu in D2L. (a) Create a Pivot Table worksheet that shows \"Rent vs Own\" (horizontal) by \"Region\" (vertical). In the Value part of pivot table, show \"Count of Customers ID\", \"Sum of Total Purchases\" and \"Sum of Num Purchases\". (b) In the Customer data worksheet, use SUMIF result in cell \\( \\mathrm{H} 4 \\) to show Sum of Total Purchases amount (\\$) who Own the house. (c) In the Customer data worksheet, use AVERAGEIF result in cell H5 to show Average of Total Purchases amount (\\$) whose Num Household is 4. (d) In the Customer data worksheet, use COUNTIF result in cell H6 to show Count Number who has more than 4 Household. (e) In the NPV worksheet, calculate the following NPV using Excel financial function and with five interest rates \(5 when you have \\( \\$ 17,000 \\) as initial cost of investment one year from today and return from first year \\( (\\$ 6,000) \\), second year \\( (\\$ 7,000) \\), and third year \\( (\\$ 8,000) \\). (f) In Solver worksheet, complete \"Pony Espresso\" with maximum total revenue. (g) In Scenario worksheet, complete \"Project\" as requested in the Tech Plug-In and show \"Summary\" worksheet
