MM Health Solutions manages procurement for clinics and a central warehouse. The analyst is building a spend analysis spreadsheet for medical consumables to support a category review. When the transactions are grouped, the analyst finds that “disposable gloves” were bought from three suppliers. In contrast, one supplier appears under both “consumables” and “cleaning and hygiene” because it invoices gloves, masks, and disinfectants. The analyst must decide whether this is a data error or a normal pattern that the spend analysis should retain for decision-making. Identify the interpretation that is consistent with how a spend analysis spreadsheet should be read.

Question

Answer

Multiple suppliers can exist in one category and one supplier can appear in multiple categories, so the spreadsheet should accommodate these relationships rather than forcing one-to-one mapping.

Answer

The spreadsheet should remove supplier-level detail and keep only category totals, because supplier overlap creates duplication risk in analysis.

Answer

A spend analysis spreadsheet should show one supplier per category, so multiple suppliers in one category indicate the data should be forced into a single-supplier mapping.

Answer

The analyst should split the data into separate spreadsheets per stakeholder group so supplier overlap does not create disagreements about category boundaries.

Crowdly

MM Health Solutions manages procurement for clinics and a central warehouse. The...

Want instant access to all verified answers on mymodules.dtls.unisa.ac.za?