Hi I am working on a spreadsheet but have stumbled on the question 2 and I am at a loss as to how to create a formula for this one. Is anyone able to help please?
The spreadsheet attached represents data downloaded from a company’s SAP system. This is the raw data that is produced from running a report. It contains all the relevant information to calculate the packaging handled by the member company, but unfortunately the company in question does not have the technical knowledge to analyse the data.
Please complete the test using the following information:
The spreadsheet attached represents data downloaded from a company’s SAP system. This is the raw data that is produced from running a report. It contains all the relevant information to calculate the packaging handled by the member company, but unfortunately the company in question does not have the technical knowledge to analyse the data.
Please complete the test using the following information:
- SAP has produced a number of rows of data per Item Code. For example Item Code A001 represents bottles of Pepsi. In 2012, the company sold 1000 bottles of Pepsi. The company places 10 bottles of Pepsi into a multipack box, therefore selling 100 boxes during 2012. The company places 10 of these boxes onto a pallet for transport. Therefore the company can fit 100 primary sales per pallet, resulting in 10 pallets being used for Product A001. Firstly, calculate the how much of each Packaging type (primary, secondary or transit) was sold during 2012.
- Now that we have the totals of Packaging Sold, we then need to apply this to the packaging weights that were produced from SAP and calculate the total weight for each packaging item handled. I have performed these calculations manually for A001, however some datasets can be more than 10,000 rows. We need to think of a better way to produce the calculations from Column I to Column Q. Complete the rest of the spreadsheet providing details of the formula(e) used.