Fabrikam, Inc., is looking to build a long-term relationship with a trucking company in the city...

 

Transcribed Image Text:

Fabrikam, Inc., is looking to build a long-term relationship with a trucking company in the city that ships the most product purchases within the state of Illinois. You have been asked to identify the city in Illinois with the greatest dollars of purchase costs as the first step to identify one or more shipping companies in that city. Fabrikam has not maintained shipping cost details because all product purchases are FOB destination. The assumption is that the city with the greatest amount of product purchases represents the city with the greatest shipping and distribution costs. Required Which two cities have the greatest amount of product purchases? Hints: Use the Vendors list in SmartList. The only columns you will need are Vendor Name, State, City, and Amount Paid YTD. Export to Excel. Prepare and print out a summary that provides the information requested by management in an easy to read format. Fabrikam, Inc. knows that the majority of its employees reside in the state of Illinois. Management is considering opening up a satellite office in other states where employees who do not reside in Illinois might work. You have been asked to identify employees who reside outside of Illinois and to produce a report that indicates which states these employees live in. Required Which states, other than Illinois, do Fabrikam employees reside in? Which of these states have the greatest concentration of employees? Hints: Use the Employee list in SmartList. The only columns you will need are Last Name, First Name, State. Export to excel and printout a summary (alphabetical by state) that provides the information requested by management in an easy to read format. Fabrikam, Inc., is looking to build a long-term relationship with a trucking company in the city that ships the most product purchases within the state of Illinois. You have been asked to identify the city in Illinois with the greatest dollars of purchase costs as the first step to identify one or more shipping companies in that city. Fabrikam has not maintained shipping cost details because all product purchases are FOB destination. The assumption is that the city with the greatest amount of product purchases represents the city with the greatest shipping and distribution costs. Required Which two cities have the greatest amount of product purchases? Hints: Use the Vendors list in SmartList. The only columns you will need are Vendor Name, State, City, and Amount Paid YTD. Export to Excel. Prepare and print out a summary that provides the information requested by management in an easy to read format. Fabrikam, Inc. knows that the majority of its employees reside in the state of Illinois. Management is considering opening up a satellite office in other states where employees who do not reside in Illinois might work. You have been asked to identify employees who reside outside of Illinois and to produce a report that indicates which states these employees live in. Required Which states, other than Illinois, do Fabrikam employees reside in? Which of these states have the greatest concentration of employees? Hints: Use the Employee list in SmartList. The only columns you will need are Last Name, First Name, State. Export to excel and printout a summary (alphabetical by state) that provides the information requested by management in an easy to read format.

Answer rating: 100% (QA)

Fabrikam Inc is looking to build a longterm relationship with a trucking company in the city that sh... View the full answer