(Solved) : Newly Employed Prominent Multinational Fast Moving Consumer Good Fmcg Company Company S Pr Q27719895 . . . .

You have newly been employed by a prominent multinationalFast-Moving Consumer Good (FMCG) company. The company’s productsincludes foods, beverages, personal care products and cleaningagents. You were asked to develop a framework in Excel to calculatethe final total cost of products purchased based on differentdelivery method, discount levels and price guide of productspurchased by distributors.

Consider and study the three tables below carefully, the firsttable is the PRICING TABLE, the second table isthe DELIVERY TABLE and the third table is theSALES TABLE.

You have newly been employed by a prominent multinationalFast-Moving Consumer Good (FMCG) company. The company’s productsincludes foods, beverages, personal care products and