{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab 3, exercise 3.2 PRINT

lab 3, exercise 3.2 PRINT - returns a specified number of...

Info icon This 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
Image of page 1

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

View Full Document Right Arrow Icon
Image of page 2
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) Lab 3 Exercise 3.2 Raafia Siddiqui 211098936 Discounts (formula view) Discount Percent CM_03 C 400 255 10% HA_20 C 35 4 10% CW_4 C 250 41 10% HF_04 C 15 0.5 25% HW_2 C 355 230 10% CM_10 C 732 325 10% CM_08 C 205 41 10% CW_0 C 1135 30 25% 25% HA_13 D 52 4 25% HS_19 C 255 24 10% HS_06 C 114 21 10% HS_15 D 35 3 25% HA_37 C 22 2 10% HF_10 C 11 0.5 25% CW_2 D 78 5 25% 25% CW_3 C 94 12 10% CM_18 C 125 21 10% HA_20 C 58 3 25% Pro duct Cod e Prod uct Stat us Stoc k Qua ntity Aver age Daily Sales Alternative Discount Percent...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern