header
Sumproduct 

Tag:
Edit edit   Starstar

Program Information

Name: Sumproduct 
Domain: Numerical program
Functionality: A formula to calculate the number of Specific types of products 
Input: The type of the products, profit of the product 
Output: Specific quantities of the products 

Reference

How can non-technical end users effectively test their spreadsheets?  10.1108/ITP-01-2013-0004 

MR Information

(1)There is an inventory spreadsheet, each row contains information about an item such as item number and description, unit cost, unit price, unit profit (=unit price-unit cost), stock-on-hand, stock-on-order, and a stock movement indicator. The value of the stock movement indicator is either “S” or “F.” The value “S” indicates that the item is “slow-moving.” On the other hand, the value “F” indicates that the item is “fast-moving” and suppose there are 5,000 items for sale in the supermarket. (2)Every item in the supermarket can be classified into one of the following four groups: (i) slow-moving and profitable items (stock movement indicator=“S” and unit profit >0); (ii) slow-moving and non-profitable items (stock movement indicator=“S” and unit profit $\leq$ 0); (iii) fast-moving and profitable items (stock movement indicator=“F”and unit profit >0); and (iv) fast-moving and non-profitable items (stock movement indicator=“F” and unit profit $\leq$ 0), where each of the four groups may be empty 

MR1------

Description:
Property: If we insert a row (between the existing row 2 and row 5,001) into the spreadsheet for storing a new slow-moving and non-profitable item, followed by setting the stock movement indicators of all items to “F,” then the output value of the corresponding variant formula will increase and must be greater than zero 
Source input:
Source output:
Follow-up input:
Follow-up output:
Input relation:
Output relation:
Pattern:

MR2------

Description:
Property: If we insert a row (between the existing row 2 and row 5,001) into the spreadsheet for storing a new fast-moving and profitable item, followed by setting the unit prices of all items to their unit costs so that all the unit profits become zero, then the output value of the corresponding variant formula will increase and must be greater than zero 
Source input:
Source output:
Follow-up input:
Follow-up output:
Input relation:
Output relation:
Pattern:

MR3------

Description:
Property: If we insert m rows (between the existing row 2 and row 5,001) into the spreadsheet for storing m new items so that all these items are fast-moving and non-profitable, then the output value of the corresponding variant formula will increase by m and must be greater than zero 
Source input:
Source output:
Follow-up input:
Follow-up output:
Input relation:
Output relation:
Pattern:
Insert title here