Lab 3.3 - returns a specified number of the leftmost...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Comments Page 1 Comments - Sales Discount Model The Discounts worksheet in this model contains a list of product codes for items sold in a  store, a status code for that product (D means discontinued and C means current), the quantity of the product in stock and the average number sold daily for the product. The store wants to hold a sale to get rid of old stock or stock that is not selling well. The aim of this model is to decide which items to put on sale at a large discount (25% for Discontinu and which to put on sale at a smaller discount (10%). This calculation will involve the use of additional logical functions - the AND and OR  functions for example, and it will also involve the use of a text function - the LEFT function, which
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: returns a specified number of the leftmost characters in a text string. Alternately discount slow moving Women's Clothing by 25%. Comments Page 2 ued or overstocked items) Faseeh Riaz Student#210867588 Discounts Discount Percentage Alternative Discount Percent CM_03C 400 255 10% HA_20C 35 4 10% CW_41C 250 41 10% HF_04C 15 0.5 25% HW_28C 355 230 10% CM_10C 732 325 10% CM_08C 205 41 10% CW_08C 1135 30 25% 25 HA_13D 52 4 25% HS_19C 255 24 10% HS_06C 114 21 10% HS_15D 35 3 25% HA_37C 22 2 10% HF_10C 11 0.5 25% CW_29D 78 5 25% 25 CW_30C 94 12 10% CM_18C 125 21 10% HA_20C 58 3 25% Prod uct Cod e Pro duct Stat us Stoc k Qua ntity age Dail y Sale s...
View Full Document

This note was uploaded on 02/05/2011 for the course ECON 1000 taught by Professor Paschakis during the Spring '08 term at York University.

Page1 / 3

Lab 3.3 - returns a specified number of the leftmost...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online