Assignment 2

.pdf

School

Lamar University *

*We aren’t endorsed by this school

Course

3300

Subject

Management

Date

Feb 20, 2024

Type

pdf

Pages

4

Uploaded by litzyg2004

Report
Garcia | 1 Litzy Garcia Mr. Howell MGMT_3300 February 1, 2024 BUSI 2300 Assignment 2 Dr. Kakoli Bandyopadhyay Total Points: 25 Submit a word document with answers (fill in the tables with data) and relevant screenshots to the questions asked in pages 2-3 of the assignment. Global Electronics is a multinational manufacturer and distributor of portable electronic devices, such as cell phones, tablet computers, and game consoles. Global recently introduced its newest product, the Hawk 5G smartphone. The product rollout has been a huge international success, largely because the Hawk has a unique feature – it can automatically translate text messages from other Hawk phones into any language the user wants. The Hawk has been rolled out on five continents from distribution centers in Atlanta, Nigeria, Brazil, Japan, and Germany. The smartphone is being manufactured at four different facilities in Phoenix, China, Mexico, and Belgium. Tommy Wong, the president and the CEO of Global Electronics, is pleased with the success of the Hawk’s introduction, but is concerned that Global might not be optimizing the assignment of production from the manufacturing sites to the distribution centers. Currently, his planners are assigning production manually based on the distances between manufacturing and distribution. He thinks that transportation costs from the part suppliers and the manufacturing costs at each site are not being taken into account using the current method. We will use the Tableau software to work on this assignment. Tableau is used to perform visual analysis for spreadsheets and databases. We will connect to the spreadsheet Global manufacturer given below (An excel file: Global Electronics Updated will be made available). Use the Assignment 2 Data Tab. The total operating cost of each distribution center for the production assigned is given below: Production Assigned From: Manufacturing Site Total Total Freight Total Cost To: Distribution Center: Phoenix Shanghai Monterrey Brussels Subtotal Mfg Cost Out Cost by Destination Atlanta, U.S. 41225 56600 100000 28165 225990 $22,000,465 $86,359 $22,086,825 Lagos, Nigeria 768 8776 50000 121454 180998 $17,620,427 $94,545 $17,714,972 Rio De Janeiro, Brazil 643 76658 50000 88788 216089 $21,036,588 $197,586 $21,234,174 Osaka, Japan 76000 100000 67000 84000 327000 $31,833,941 $179,617 $32,013,558 Frankfurt, Germany 59225 11655 100000 29765 200645 $19,533,092 $116,403 $19,649,495 Subtotal 177861 253689 367000 352172 $112,024,513 $674,511 $112,699,023 Things to do: Using Tableau answer the following questions: 1. A. Which distribution center (U.S./Nigeria/Brazil/Japan/Germany) incurs the maximum total destination cost ? (4 points)
Garcia | 2 Hint: drag and drop distribution centers from dimensions to columns and drag and drop destination costs from the measures to rows. Go to Label > Show Mark Labels. Distribution Center Maximum Destination Cost Japan $32.,013558 B. Copy and Paste the relevant bar graph from Tableau here (2 points) 2. A. Which distribution center (U.S./Nigeria/Brazil/Japan/Germany) incurs the minimum destination costs ? (4 points) Hint: drag and drop distribution center from dimensions to columns and drag and drop destination cost from the measures to rows. Go to Label > Show Mark Labels. Distribution Center Minimum Destination Cost Nigeria $17,714972 B. Copy and Paste the relevant bar graph from Tableau here (2 points)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help