Free Essay

Chp 1 Premiere Products

In:

Submitted By thesoxbox
Words 361
Pages 2
Answer each of the following questions using the Premiere Products data shown in Figure 1-5. No computer work is required.

1. List the names of all customers that have a credit limit less than $10,000.

Al’s Appliance and Sport | Ferguson’s | The Everything Shop | Lee’s Sport and Appliance | Deerfield’s Four Seasons | All Season |

2. List the descriptions of all parts in item class AP and located in warehouse number 3.

Microwave Oven | Gas Range | Washer | Dryer | Dishwasher |

3. List the order numbers for orders placed by customer number 608 on October 23, 2013.

21617 | 21623 |

4. List the part number, part description, and on-hand value (OnHand * Price) for each part in item class SG.

PartNum | Description | OnHand | Price | OnHand Value | BV06 | Home Gym | 45 | 794.95 | 35,772.75 | KV29 | Treadmill | 9 | 1,390.00 | 12,510.00 |

5. List the name of each customer that placed an order for two different parts in the same order.

Ferguson’s | Johnson’s Department Store |

6. List the name of each customer that has a credit limit of $5,000 and is represented by Richard Hull.

The Everything Shop | Lee’s Sport and Appliance |

7. Find the sum of the balances for all customers represented by Juan Perez.

5,785.00 | 3,412.00 | 2,106.00 | 11,303.00 |

8. For each order, list the order number, order date, customer number, and customer name.

21608 | 10/20/2013 | 148 | Al’s Appliance and Sport | 21610 | 10/20/2013 | 356 | Ferguson’s | 21613 | 10/21/2013 | 408 | The Everything Shop | 21614 | 10/21/2013 | 282 | Brookings Direct | 21617 | 10/23/2013 | 608 | Johnson’s Department Store | 21619 | 10/23/2013 | 148 | Al’s Appliance and Sport | 21623 | 10/23/2013 | 608 | Johnson’s Department Store |

9. For each order placed on October 21, 2013, list the order number, order date, customer number, and customer name.

21613 | 10/21/2013 | 408 | The Everything Shop | 21614 | 10/21/2013 | 282 | Brookings Direct |

10. For each order placed on October 20, 2013, list the order number and customer name, along with the name of the rep who represents the customer.

21608 | Al’s Appliance and Sport | Valerie Kaiser | 21610 | Ferguson’s | Juan Perez |

Similar Documents

Free Essay

Frnch Grammer

...Salford NATIVE SPEAKER CONSULTANT Marie-Noëlle Lamy Senior Lecturer, Open University A member of the Hodder Headline Group LONDON Contents Guide for the user Glossary of key grammatical terms Acknowledgements Acknowledgements for the second edition xi xiv xx xxi 1 Nouns 1.1 Types of noun 1.2 Gender 1.3 Number 2 Determiners 2.1 Articles 2.2 Typical use of the definite article 2.3 Typical use of the indefinite article 2.4 The partitive article: du, de l', de la, des 2.5 Use of indefinite and partitive articles after the negative forms ne... pas, ne... jamais, ne... plus, ne... guère 2.6 Omission of the article 2.7 Demonstrative determiners 2.8 Possessive determiners 3 Personal and impersonal pronouns 3.1 Subject pronouns 3.2 Object pronouns 3.3 Stressed pronouns 3.4 Demonstrative pronouns 3.5 Possessive pronouns 4 Adjectives 4.1 Adjectives modifying the noun 4.2 Adjectives which follow verbs or verbal expressions 4.3 Adjectives with complements 4.4 Indefinite and negative noun phrases with adjective complements 4.5 Adjectives used as nouns 4.6 Adjectives used as adverbs 4.7 Masculine and feminine forms of adjectives 4.8 Plural forms of adjectives 4.9 Adjective agreement with nouns 1 1 5 17 23 23 24 29 32 33 34 37 39 40 40 53 71 75 76 78 78 83 84 85 85 86 86 89 91 vi Contents 4.10 4.11 4.12 4.13 4.14 Invariable adjectives Compound adjectives Comparative and superlative forms of adjectives Subjunctive versus indicative in clauses dependent on a superlative adjective...

Words: 184852 - Pages: 740

Free Essay

Daimler Case

...Kommunikation (consulting/editing) TEAMKOM Kommunikation&Design (design) Netfederation GmbH (interactive online report) Photography Bildarchiv Daimler AG, Fotolia (icons p. 18/19) Production l in millions of € 8,116 10,139 10,179 j in millions of € 6,830 8,720 7,290 l Total vehicle sales in millions 2.2 2.35 2.55 j 1,451,569 1,565,563 1,722,561 j Unit sales of Daimler Trucks 461,954 484,211 495,668 j Unit sales of Mercedes-Benz Vans 252,418 270,144 294,594 j 32,088 33,705 33,162 l in millions of € 79,986 83,538 98,967 j in millions of € 2,369 2,471 2,383 l in g CO2/km 140 134 129 l Unit sales of Mercedes-Benz Cars Unit sales of Daimler Buses Contract volume of Daimler Financial Services Product responsibility Dr. Cantz’sche Druckerei Medien GmbH (reprography) Bechtle Druck + Service GmbH und Co. KG (printing) Contact j 10,752 CO2 emissions of the European fleet (vehicles from Mercedes-Benz Cars) Mirjam Bendak 129,872 10,815 Group net income Daimler Sustainability Report 2014. Publications Manager Thomas Fröhlich 117,982 8,820 Research and development expenditure on environmental protection For the publisher Daimler AG, Mercedesstraße 137, 70327 Stuttgart, Germany 114,297 in millions of € Profit before taxes on income1 Publisher in millions of € Operating profit/EBIT1 Operations-related environmental protection Daimler AG, HPC E402 70546 Stuttgart Tel. +49 (0) 711 17-0 (headquarters) Fax +49 (0) 711 17-790-95251...

Words: 50904 - Pages: 204

Free Essay

Economic Sectors

...writing from the publisher. First published in 2013 by SAGE Publications India Pvt Ltd B1/I-1 Mohan Cooperative Industrial Area Mathura Road, New Delhi 110 044, India www.sagepub.in SAGE Publications Inc 2455 Teller Road Thousand Oaks, California 91320, USA SAGE Publications Ltd 1 Oliver’s Yard, 55 City Road London EC1Y 1SP, United Kingdom SAGE Publications Asia-Pacific Pte Ltd 33 Pekin Street #02-01 Far East Square Singapore 048763 Published by Vivek Mehra for SAGE Publications India Pvt Ltd, Phototypeset in 11/13pt Minion Pro by RECTO Graphics, Delhi and printed at Saurabh Printers, New Delhi. Library of Congress Cataloging-in-Publication Data Available ISBN: 978-81-321-1131-3 (PB) The SAGE Team: Rudra Narayan, Archita Mandal, Rajib Chatterjee and Dally Verghese Twelfth Five Year Plan (2012–2017) Economic Sectors Volume II Planning Commission Government of India Thank you for choosing a SAGE product! If you have any comment, observation or feedback, I would like to personally hear from you. Please write to me at contactceo@sagepub.in —Vivek Mehra, Managing Director and CEO, SAGE Publications India Pvt Ltd, New Delhi Bulk Sales SAGE India offers special discounts for purchase of books in bulk. We also make available special imprints and excerpts from our books on demand. For orders and enquiries, write to us at Marketing Department SAGE Publications India Pvt Ltd B1/I-1, Mohan Cooperative Industrial Area Mathura Road, Post Bag 7 New Delhi 110044, India E-mail...

Words: 131771 - Pages: 528

Premium Essay

Managing Information Technology (7th Edition)

...CONTENTS: CASE STUDIES CASE STUDY 1 Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5 Data Governance at InsuraCorp CASE STUDY I-6 H.H. Gregg’s Appliances, Inc.: Deciding on a New Information Technology Platform CASE STUDY I-7 Midsouth Chamber of Commerce (B): Cleaning Up an Information Systems Debacle CASE STUDY II-1 Vendor-Managed Inventory at NIBCO CASE STUDY II-2 Real-Time Business Intelligence at Continental Airlines CASE STUDY II-3 Norfolk Southern Railway: The Business Intelligence Journey CASE STUDY II-4 Mining Data to Increase State Tax Revenues in California CASE STUDY II-5 The Cliptomania™ Web Store: An E-Tailing Start-up Survival Story CASE STUDY II-6 Rock Island Chocolate Company, Inc.: Building a Social Networking Strategy CASE STUDY III-1 Managing a Systems Development Project at Consumer and Industrial Products, Inc. CASE STUDY III-2 A Make-or-Buy Decision at Baxter Manufacturing Company CASE STUDY III-3 ERP Purchase Decision at Benton Manufacturing Company, Inc. CASE STUDY III-4 ...

Words: 239887 - Pages: 960