Question
I need help answering the 10 questions for my Excel Lab HW 4: Fox Lake Networking. Here is a link to the google drive folder
I need help answering the 10 questions for my Excel Lab HW 4: Fox Lake Networking. Here is a link to the google drive folder that has all the documents and excel that you would need for the assignment. (https://drive.google.com/drive/folders/1sSjoZrFYqC08dYBW1zKK_vilCjBXlCuu?usp=sharing)
1. How many buildings are considered "High Priced?"
2. What is the Cost of New Cable for the Dining Hall?
3. What is the Total Estimated Cost of Network for all buildings combined?
4. What is the total Discount given for all buildings combined?
5. Which building had the highest Additional Equipment Cost?
6. Which building received the largest discount?
7. How many buildings have a Total Estimated Cost of Network = $0.00?
8. Currently, the cost for not having Existing Equipment is $40.What does it need to be for the Total Estimated Cost of Network for all buildings combined to equal $45,000?
9. What would be the Total Estimated Cost of Network for all buildings combined if, in Step 2, the cost for not having network equipment is decreased to $35.00 per foot?
10. With the cost for not having Existing Equipmentchanged back to $40, what is the total Discount for all buildings combined if the discount % dropped from 10% to 8.5% for all buildings that had an Estimated Cost of Network before Discount >= $17000?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started