PLEASE ANSWER USING DATA PROVIDED BELOW IN EXCEL. SHOW WORK (I want to see formulas/explanation of how you did it)

1. Conduct an ABC analysis using the data provided on the population of US Metropolitan Statistical Areas and Micropolitan Statistical Areas. Describe how you chose the cutoff points for the categories (A, B, and C). Assume these are values for revenue from the products a company sells rather than population estimates. How would the purchasing requirements differ for products in these different categories? Discuss the make or buy decision, methods of description, forecasting and inventory policy.

Aberdeen, SD Mia Area t RethiehemFastm PA-NI Metm ea 1t atr Berwidk, Mctro Ara Cedar City, UTMian Area Crawfordsville, IN Miau Area lk Cty, OK Miu Are GumonOK Mu Jadan OHMayArca eflenn Qty, M Mcro Arca alpell, M louvilleficttors on Coy, KY-IN Metro Ama Milledgeville, GA Miru Area Nacngindhes, TXMian Ara Oil Cy, PAMan Ama Paraguld, AR Mia Ama acine, Hetro Arca Mhm-ee, KY Miru Are Sh p rChyLAMeto Aa Sterling, COMian Area Vicksl MSMiu Ae Aberdeen, SD Mia Area t RethiehemFastm PA-NI Metm ea 1t atr Berwidk, Mctro Ara Cedar City, UTMian Area Crawfordsville, IN Miau Area lk Cty, OK Miu Are GumonOK Mu Jadan OHMayArca eflenn Qty, M Mcro Arca alpell, M louvilleficttors on Coy, KY-IN Metro Ama Milledgeville, GA Miru Area Nacngindhes, TXMian Ara Oil Cy, PAMan Ama Paraguld, AR Mia Ama acine, Hetro Arca Mhm-ee, KY Miru Are Sh p rChyLAMeto Aa Sterling, COMian Area Vicksl MSMiu Ae