`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
How can non-technical end users effectively test their spreadsheets? 10.1108/ITP-01-2013-0004

(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

`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:`

`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:`

`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:`