expertise and its focus on data analytics and visualization. Miranda asked Megan Martinez, a senior staff accountant at HMC,and Adam Green, a staff acoountant at HMC, to work with D \& A on the project. Megan has been with HMC for two years and has recently relocated to the corporate headquarters in Dearborn, Mich. Megan's corporate transition is almost complete, and she is anxious to move forward in her current position. Adam is a young, aggressive employee who began with the company cight months ago, since he graduated college. He has a good sense of judgment and is eager to make a good impression on upper managersent. Miranda believes the tro employees will provide a good mix of experience, dedication, and teamwoek. D \& A CONSULTING GROUP: BACKGROUND D \& A Coesulting was started by Doug Chan and Arlo Paxton five years ago. Doug and Arlo have been friends simee college, having tradusted with accounting degrees from the same universicy 15 years ako. Although they initially wern to work at differest accounting firms, they boch fotlowed similar carect paths. After becoming managess at their respective firms, Doug and Arlo decided that their real passion was in teaching clienss how 60 ase data to make betier business decisices. They started their omn make betiet bessiness decisicas. Thicy started their own witk cto primary focus: helping clienes bener undersatast their besinesses via the use of desa analytics ind data visualiantion. Thoegh dag alalytive is nes a ney eocept in the buinesis world, the ampunt of duta walable and the number of soarces from which is can te cipraed has shyrockeced. Driven by keret morage ceats wnd mete "ener the amouss of dasa dicy edbest and stoee, Yet finding the HUSKIE MOTOR CORPORATION: OPERATIONS HMC is currently selling in 15 countries in three regions: North America, South America, and Europe. Table 1 provides a breskdown of the countries within eich region. Autemobile masufacturing and sales is a complex and highly competitive business. Though the autemotive industry has a bread global reach, only 15 countries produce 88% of che weeld's vehiclex.' HMC is a faitly new and small player in the autemotive manufacturing market. HMC currently offers ehee brands: Apechete, Jackson, and Tatra. Each brand har several models as detailed in Table 2 The models avaitable fall within seven sefenents of vchicte typex compuct, sub coempact, full-sine, mid-sire, luxury, misivan, and spees utility. Page 3 of 7 Miranda: "Well, there is vehicle data such as beand, model. model year, series, stgment, body style, drive configuration. engine type, and transmission type. We also bave the detal for cach vchicle sold as far as color, trim, and so on, at well as any package cr options purchased." Jan: "Wow! I can sce why the data set is so large!" Miranda: "That is jast the vehicle information. We also capture the region and counery of ale, the number of drys that any given car was on the lot peior to sale, and the type of marketieg, campaiten in place an the time of sale. Il addition to that, we track sales chantel infortration." ten. "Can you give me a lietle mote detail about what you mean by sales channel information?" Meoan: "Sere. We idemify sales wsing three sales chunnel dimenviona. Sales chansel 1 identifies whether the sale was made through our dealers, fleet, or retail operuticns. Salkt channel 2 identifes the tyje of cusomer actount. We bave commencial acceanth, employedpartact probrams, govertment wocounts, noeemployee accounts, and rental accounts. The third sales channel identifies whether the sale was cash, firincing, on leave." Kevis "Okay, wo ide ally we wial wate to we boch the financial aud noefinancial data in eur analyees." Mirmene "Fxacty" Orher pecatially informative dara sounes that we have me social nesia platforms like Facebsek, I wites, and Instapram. We have jest rened colleceing date ferm dhe ne nemes abset ter vekiles, bet we aes sill uring es figue eas the best woy eo analyee ic" ASSIGNMENT Assame yee are Jan Morrison. Kevin hus asked you to do a preliminary anahsits of the data. Spccifically, Kevin has asked you to determine: 1. Overall performance analytics: 1. How is HMIC performirg slobully? b. How are various HNAC brands performine? c. How are the raricus sales channels perfoming? d. What are the most and least proficable models? 2. Finandal analytick: a. What is the cunent contribucion margis (CM) per model? b. What is ehe average variable cose per model, and bow has that changed ever rimor? c. Which model has ele most variability in variable cests? d. What is the curtent CM per channel? 1. Optrations anubeck a. Whur model eptisns we the bop and botrom nelleres? b. How many days are the various medels en ihe for priet be silet? 4. Ferecast Tableas) Qhece you have pecpewed ihe analyb, Retis math the expertise and its focus on data analytics and visualization. Miranda asked Megan Martinez, a senior staff accountant at HMC,and Adam Green, a staff acoountant at HMC, to work with D \& A on the project. Megan has been with HMC for two years and has recently relocated to the corporate headquarters in Dearborn, Mich. Megan's corporate transition is almost complete, and she is anxious to move forward in her current position. Adam is a young, aggressive employee who began with the company cight months ago, since he graduated college. He has a good sense of judgment and is eager to make a good impression on upper managersent. Miranda believes the tro employees will provide a good mix of experience, dedication, and teamwoek. D \& A CONSULTING GROUP: BACKGROUND D \& A Coesulting was started by Doug Chan and Arlo Paxton five years ago. Doug and Arlo have been friends simee college, having tradusted with accounting degrees from the same universicy 15 years ako. Although they initially wern to work at differest accounting firms, they boch fotlowed similar carect paths. After becoming managess at their respective firms, Doug and Arlo decided that their real passion was in teaching clienss how 60 ase data to make betier business decisices. They started their omn make betiet bessiness decisicas. Thicy started their own witk cto primary focus: helping clienes bener undersatast their besinesses via the use of desa analytics ind data visualiantion. Thoegh dag alalytive is nes a ney eocept in the buinesis world, the ampunt of duta walable and the number of soarces from which is can te cipraed has shyrockeced. Driven by keret morage ceats wnd mete "ener the amouss of dasa dicy edbest and stoee, Yet finding the HUSKIE MOTOR CORPORATION: OPERATIONS HMC is currently selling in 15 countries in three regions: North America, South America, and Europe. Table 1 provides a breskdown of the countries within eich region. Autemobile masufacturing and sales is a complex and highly competitive business. Though the autemotive industry has a bread global reach, only 15 countries produce 88% of che weeld's vehiclex.' HMC is a faitly new and small player in the autemotive manufacturing market. HMC currently offers ehee brands: Apechete, Jackson, and Tatra. Each brand har several models as detailed in Table 2 The models avaitable fall within seven sefenents of vchicte typex compuct, sub coempact, full-sine, mid-sire, luxury, misivan, and spees utility. Page 3 of 7 Miranda: "Well, there is vehicle data such as beand, model. model year, series, stgment, body style, drive configuration. engine type, and transmission type. We also bave the detal for cach vchicle sold as far as color, trim, and so on, at well as any package cr options purchased." Jan: "Wow! I can sce why the data set is so large!" Miranda: "That is jast the vehicle information. We also capture the region and counery of ale, the number of drys that any given car was on the lot peior to sale, and the type of marketieg, campaiten in place an the time of sale. Il addition to that, we track sales chantel infortration." ten. "Can you give me a lietle mote detail about what you mean by sales channel information?" Meoan: "Sere. We idemify sales wsing three sales chunnel dimenviona. Sales chansel 1 identifies whether the sale was made through our dealers, fleet, or retail operuticns. Salkt channel 2 identifes the tyje of cusomer actount. We bave commencial acceanth, employedpartact probrams, govertment wocounts, noeemployee accounts, and rental accounts. The third sales channel identifies whether the sale was cash, firincing, on leave." Kevis "Okay, wo ide ally we wial wate to we boch the financial aud noefinancial data in eur analyees." Mirmene "Fxacty" Orher pecatially informative dara sounes that we have me social nesia platforms like Facebsek, I wites, and Instapram. We have jest rened colleceing date ferm dhe ne nemes abset ter vekiles, bet we aes sill uring es figue eas the best woy eo analyee ic" ASSIGNMENT Assame yee are Jan Morrison. Kevin hus asked you to do a preliminary anahsits of the data. Spccifically, Kevin has asked you to determine: 1. Overall performance analytics: 1. How is HMIC performirg slobully? b. How are various HNAC brands performine? c. How are the raricus sales channels perfoming? d. What are the most and least proficable models? 2. Finandal analytick: a. What is the cunent contribucion margis (CM) per model? b. What is ehe average variable cose per model, and bow has that changed ever rimor? c. Which model has ele most variability in variable cests? d. What is the curtent CM per channel? 1. Optrations anubeck a. Whur model eptisns we the bop and botrom nelleres? b. How many days are the various medels en ihe for priet be silet? 4. Ferecast Tableas) Qhece you have pecpewed ihe analyb, Retis math the