...Part 1 1. What are the Sales Amount by Channel? SELECT DimChannel.ChannelName, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey GROUP BY DimChannel.ChannelName; a. By Channel by Year SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey GROUP BY DimChannel.ChannelName, DimDate.FiscalYear; b. Show the results with the best year at the top SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey GROUP BY DimChannel.ChannelName, DimDate.FiscalYear ORDER BY Sum(FactSales.SalesAmount) DESC; 2. What are the different types of Promotions? SELECT DimPromotion.PromotionName FROM DimPromotion; c. What are the start and end dates for each promotion. Put the oldest start dates first SELECT DimPromotion.PromotionName, DimPromotion.StartDate, DimPromotion.EndDate FROM DimPromotion ORDER BY DimPromotion.StartDate; 3. What are the quantity and the amounts of items returned grouped by Channel then by Manufacturer? SELECT DimChannel.ChannelName, DimProduct.Manufacturer, Sum(FactSales.ReturnQuantity)...
Words: 318 - Pages: 2
...Managerial Economics Unit1 - 2 Mark Quiz Questions 1.Decision-making implies a. Giving judgement on a particular isuue b. Taking a final decision on a particular issue c. Selecting the best out of several alternative course of actions d. Selecting alternative solutions. 2.Forward Planning implies a. A plan to execute current programs b. A Plan prepared in advace for future c. A plan prepared in the background of certainties d. A Plan prepared for past and present 3.Managerial Economics deals with a. Provide alternative solutions to the problems b. Providing solutions to various business and management problems c. Providing tools and techniques to find answers for business and management problems d. Analyzing various business and managerial problems of a firm. 4.Managerial Economics helps a. To optimise abundant resources to maximise profits b. To find answers only for present problems in the background of past events c. To analyse present problems in the background of past d. To find solutions for present and future problems on the basis of past and present environment Unit2 - 2 Mark Quiz Questions 1.A product can be considered as inferior in economics if increase in disposable income of the consumer causes a. Increase in demand b. No change in demand c. Less than proportionate change in demand. d. Decrease in demand 2.Demand Schedule of a firm shows quantities of a commodity a. Purchased at varying prices at different periods of time. b. That can be purchased at varying...
Words: 4053 - Pages: 17
...MKT 310 WK 8 QUIZ 6 CHAPTER 13 & 14 To purchase this visit here: http://www.activitymode.com/product/mkt-310-wk-8-quiz-6-chapter-13-14/ Contact us at: SUPPORT@ACTIVITYMODE.COM MKT 310 WK 8 QUIZ 6 CHAPTER 13 & 14 MKT 310 WK 8 Quiz 6 Chapter 13,14 1) A retailer can list all of its operations to be performed, its characteristics, and its timing in a(n) ________. A) prototype arrangement B) standardized plan C) operations blueprint D) rationalized retailing arrangement 2) Which of the following is not an advantage of an operations blueprint? A) The operations blueprint standardizes activities. B) The operations blueprint helps evaluate personnel needs. C) The operations blueprint determines space needs. D) The operations blueprint isolates weak or failure-prone operations components. 3) Uniform construction, layout, and operations standards are used in ________. A) everyday inventory planning B) prototype stores C) crisis management D) scrambled merchandising 4) Which of these is not a benefit of using prototype stores? A) The stores use custom buildings for each city and town. B) The stores enable a retailer to take advantage of quantity discounts for fixtures and other materials. C) The stores ease the employee interchange among branches. D) The stores help portray a consistent image among franchise and chain store units. 5) Rationalized retailing is often used in conjunction with ________. A) micro-merchandising B) prototype stores C) a top-down...
Words: 1070 - Pages: 5
...Econ 100 Ch 1 & 2 Quiz marks = 35 STUDENT #________________________ Do not write name – ONLY Student # Multiple Choice Questions 1. Tammie makes $150 a day as a bank clerk. She takes off two days of work without pay to fly to another city to attend the concert of her favourite music group. The cost of transportation for the trip is $250. The cost of the concert ticket is $50. The opportunity cost of Tammie's trip to the concert is: A) $300. B) $450. C) $500. D) $600. 2. When a provincial government chooses to build more roads, the required resources are no longer available for spending on public education. This dilemma illustrates the concept of: A) marginal analysis. B) full employment. C) full production. D) opportunity cost. 3. When economists describe "a market," they mean: A) a place where stocks and bonds are traded. B) information networks that allow individuals to keep in touch with each other. C) a hypothetical place where the production of goods and services takes place. D) a mechanism which coordinates actions of consumers and producers to establish equilibrium prices and quantities. 4. The study of economics is primarily concerned with: A) keeping private businesses from losing money. B) demonstrating that capitalistic economies are superior to socialistic economies. C) choices which are made in seeking to use scarce resources efficiently. D) determining the most equitable distribution of society's output. 5. Economics may best...
Words: 1633 - Pages: 7
...CRJ 320 WK 2 QUIZ 2 CHAPTER 2 AND 3 To purchase this visit here: http://www.activitymode.com/product/crj-320-wk-2-quiz-2-chapter-2-and-3/ Contact us at: help@coursehomework.com CRJ 320 WK 2 QUIZ 2 CHAPTER 2 AND 3 CRJ 320 WK 2 Quiz 2 Chapter 2,3 MULTIPLE CHOICE 1. Which are permanent written records of the facts of a case to be used in further investigation, in writing reports and in prosecuting the case? a. field notes c. investigative notes b. tape recordings d. stenographer notes 2. Record all information that helps to answer the questions of a. Who? What? Which? When? How? and Why? b. Who? What? Where? When? How? and Why? c. Which? When? Why? Where? and How many? d. Why? When? and Why or why not? 3. When taking notes, the investigator should a. ignore unimportant items. b. write only the important items. c. learn to select key facts and record them in abbreviated form. d. never take notes but always memorize things verbatim and record them later. 4. One of the disadvantages of photographs is that a. they can be taken immediately and thus the crime scene processors have not prepared the scene. b. they are not selective. c. they are not admissible into court. d. they are only allowed in court if black and white. 5. When taking photographs/videotape, the investigator should a. take the primary points of concern or interest. b. take only those shots wanted by the prosecutor. c. examine the scene from all sides and take only the sides of the crime...
Words: 1876 - Pages: 8
...course materials, and take quizzes and exams. Your "Course ID" is: hervani46262 Make sure that you purchase only the textbook with the ISBN# provided below. Do not buy "Used" textbook or any other textbook with different ISBN#. If you purchase a "Used Textbook", you will not have an "Access Code" or if you purchase a textbook with different ISBN# than listed below, then you will not have a valid "Access Code" and will not be able to register for this course. Your "Access Code" comes from the textbook that you purchase (or purchased separately on line). The website to register is: http://pearsonmylabandmastering.com/ and follow the instructions. REQUIRED TEXTBOOK: Roger LeRoy Miller, Student Value Edition for “Economics Today: The Micro View” plus NEW MEL/ETX SAC, 18/E, (ISBN-13: 9780134004952), Publisher: Prentice Hall, Copyright: 2015. You must also click on the Course Syllabus so that you can have a...
Words: 782 - Pages: 4
...LagunaStatePolytechnicUniversity Siniloan Host Campu, Siniloan, Laguna CollegeofAgriculture Bachelor of Science in agribusiness COURSE SYLLABUS IN social science 4 first semester, a.y. 2013-2014 I. COURSE CODE: SOC.SCI 4 II. COURSE TITLE: GENERAL ECONOMICS WITH TAXATION AND LAND REFORM III. Course Description: This course provides a comprehensive coverage of all major topics in economics. Attention is given to establish student understands of key economic principles with particular emphasis on the Philippine Economic system, its growth and development. The course covers the foundation of economics, demand and supply analysis, the concept of elasticity, the theory of production and the fundamental concept of micro and macroeconomics with the use of simple graphical and mathematical illustrations. Likewise, the course involves topics on taxation and agrarian reform with discussion on issues and problems related to its implementation. IV. CREDIT UNIT: 3HOURS V. TIME ALLOTMENT: 54 hours/ 3 hours per week VI. GENERAL OBJECTIVE: At the end of the course, the students are expected to know the fundamental principles of economics, and their application to everyday life. SOCIAL SCIENCE 4 – GEN. ECON WITH LAND REFORM AND TAXATION Time Allotment |TOPICS/ CONTENT |SPECIFIC OBJECTIVES |TEACHING STRATEGIES |VALUES INFUSED |INSTRUCTIONAL MATERIALS |LEARNING OUTCOMES |EVALUATION TOOLS |...
Words: 1084 - Pages: 5
... PRINCIPLES OF MICRO-ECONOMICS COURSE OUTLINE – FALL 2012 CREDIT HOURS DURATION DEPARTMENT COURSE LEVEL RESOURCE PERSON OFFICE HOURS E-MAIL 3 17 weeks Finance and Business Economics Division Core Prof. Taimoor Qureshi By Appointment taimoor.qureshi@ucp.edu.pk COURSE DESCRIPTION Principles of Microeconomics is an introductory course that teaches the fundamentals of microeconomics. This course introduces microeconomic concepts and analysis, supply and demand analysis, theories of the firm and individual behavior, competition and monopoly, and welfare economics. Students will also be introduced to the use of microeconomic applications to address problems in current economic policy throughout the semester. COURSE OBJECTIVES After studying this course the students should be able to: Understand the basic concepts of the subject. Understand the application of the tools of demand and supply for efficient resource allocation and profit maximization. Identify core economic issues related to business firms. Comprehend the benefits of market efficiency. GRADING PLAN TYPE Quizzes Assignments Final Projects Midterm examination Final term examination Total PERCENTAGE (%) 10 10 10 30 40 100 CALENDER OF ACTIVITIES WEEK 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 CONTENTS TASKS/ACTIVITIES Introduction to Economics • Basic Concepts – I Class Introduction Introduction to Economics • Basic Concepts...
Words: 469 - Pages: 2
...available. Topics include contemporary issues such as inflation, unemployment, economic growth, international dependencies, and how public policy deals with them. | Instructor Contact Information: | Campus Location: | Prestonsburg | Building & Room: | Pike 215D | Office Hours: | N/A | Office Phone Number: | 1-888-641-4132 | Alternate Number: | 886-3863, Ext. 64781 | Best Times to Call: | The best place to communicate with me is in the message area of the blackboard course shell. | KCTCS Email: | Daniel.bell@kctcs.edu | Special Instructions: | N/A | Supervisor Contact Information: | Name: | Kelli Hall | Campus Location: | Pikeville | Building & Room: | N 102 | Office Phone Number: | 606-218-1275 or Ext 81275 | KCTCS Email: | Kelli.Hall@kctcs.edu | Text and Supplies: Macroeconomics, McConnell & Brue, Flynn 19th Edition – Copyright 2012 by McGraw-Hill-Irwin. | | Approved Course Competencies General Education: (KCTCS General Education Competency Statements and General Education Requirements) | I. Communicate Effectively | 1. Read and listen with comprehension. 2. Speak and write clearly using Standard English. 3. Interact cooperatively with others using both verbal and non-verbal means....
Words: 2128 - Pages: 9
...Course Code ECO111 Course Category Course Title MICRO ECONOMICS Courses with conceptual focus Course Planner 12526::Pooja Kansra Lectures 4.0 Tutorials Practicals Credits 1.0 0.0 5.0 TextBooks Sr No T-1 Title Microeconomics Theory and Applications Reference Books Sr No R-1 R-2 R-3 Other Reading Sr No OR-1 OR-2 OR-3 OR-4 OR-5 OR-6 OR-7 Journals articles as Compulsary reading (specific articles, complete reference) Kwang Ng,Yew,Why Is a Financial Crisis Important? The Significance of the Relaxation of the Assumption of Perfect Competition,International Journal of Business and Economics,2009,Vol.8,No.2,91-114 , Roman Indrest and Tommasso Valletti,Price Discrimination in input markets,The Rand Journal of Economics,Vol. 40,No.1,Spring 2009,1-19 , Cordtz,Dan,Car wars: A global report on Auto Industry,FInancial World,August 22,1989;158,17;ABI/INFORM Global , S.k.Mishra,A Brief History of Production Functions,The IUP Journal of Managerial Economics,November,2010,Vol. VIII,No. 4,pp.6-34 , Monika Jain,Paradox of Plenty,with Special Reference to Inelastic Demand for Apples,The IUP Journal of Managerial Economics,May,2011,Vol. IX,No. 2,pp.4455 , Cathy Locke Bee Staff Writer. The Sacramento Bee ,"EID report reveals household water use on rise An analysis of supply, demand recommends holding off on meters" http://search.proquest.com/docview/246565304?accountid=80692 , Yeung; Vincent Mok,Regional monopoly and interregional and intraregional competition :The parallel trade in coca cola between...
Words: 3278 - Pages: 14
...SIOP® LESSON PLAN Date: 12/5/12 | | Zachary SpoonerGrade/Class/Subject: Grade 8, Team A, Science | | Unit/Theme: Introduction to Basic Concepts of Ecology Standards: Region: USA- NAS- Science Education Standards National Academy of Science Type of Standard: Science Content Standards Grade Range: Grades 5-8 Content Standard: Life Science Area- POPULATIONS AND ECOSYSTEMS: A population consists of all individuals of a species that occur together at a given place and time. All populations living together and the physical factors with which they interact compose an ecosystem. Populations of organisms can be categorized by the function they serve in an ecosystem. Plants and some micro-organisms are producers--they make their own food. All animals, including humans, are consumers, which obtain food by eating other organisms. Decomposers, primarily bacteria and fungi, are consumers that use waste materials and dead organisms for food. Food webs identify the relationships among producers, consumers, and decomposers in an ecosystem. For ecosystems, the major source of energy is sunlight. Energy entering ecosystems as sunlight is transferred by producers into chemical energy through photosynthesis. That energy then passes from organism to organism in food webs. The number of organisms an ecosystem can support depends on the resources available and abiotic factors, such as quantity of light and water, range of temperatures...
Words: 1837 - Pages: 8
...Introduction to Economics Course outline Instructor/ teaching assistants details Details | Instructors name | Ayesha Samie | Email address | ayesha_samie@yahoo.com | Counseling hours | | Teaching assistants name | Uroosa Jeelani | Email address | uroosaj@gmail.com | Tutorial timings and days | Thursday 12:45-13:45 | About the course. This course will teach students the basic tools of microeconomics and macroeconomics issues such as price determination, supply and demand, consumer behavior, costs of production and market structures growth, inflation, unemployment, interest rates, exchange rates, technological progress, budget and trade deficits. The course will provide a unified framework to address these issues and to study the impact of different policies, such as monetary and fiscal policies, on the aggregate behavior of individuals. Evaluation of Student Performance: | Weightage in grade | Hourlies | 30% (15% of each hourly) | Final exam | 30% | Assignments/presentations/quizzes | 25% | Class Participation | 15% | Total | 100 | Description of each component: * The term exams (hourlies) and final exam will be conducted as per the rules set by IBA. There will be no makeup exams, unless instructed. All IBA rules of examination apply to undertaking the exam * Assignments will be split in class assignments and home assignments. Class assignments must be handed over to the instructor at the end of the class (unless otherwise)...
Words: 2405 - Pages: 10
...Lesson 01 Quiz Your response has been submitted successfully. [pic] We will record the highest score from these lesson quizzes so feel free to take it again (max 10 access attempts) to score 100%. |Points Awarded | 11 | |Points Missed | 3 | |Percentage | 79% | |1. |In the United States, which is the most popular method for heating homes? | | |A. | | |Electricity | | | | | |B. | | |Fuel Oil | | | | | |C. | | |Natural Gas | | | | | |D. | | |Coal ...
Words: 3715 - Pages: 15
... | |Approved course syllabus signed by Instructor & Program chair | |Objective and Outcome Mapping | |Lesson Plan | |Assessment Scheme and Schedule | |Model Question Paper (Semester End Examination (SEE)) | |Lectures Slides, Tutorials and other Learning Resource provided (See Annexure 1) | |Assignments / Course Projects | |Evaluated samples of Assignments / Course Projects (One sample each from Excellent, Average and Satisfactory Bands) (See | |Annexure 2: Hard Copy of Evaluated Project Reports) | |Quizzes and CAT-I & II question papers and...
Words: 7055 - Pages: 29
... |Office Phone: (305) 348-3466 | |12:30-1:30 p.m. and 3:30-4:00 p.m. | | |Office: DM 281A |E-mail: Use Moodle course mail ONLY! | | |FIU e-mail: shpurikm@fiu.edu | |Teaching Assistant (TA): Jesse Slappey |TA Email: Use Moodle course mail ONLY! | |PSY 2012 Training and Development Center: Room DM 284, phone: 305-348-6892 | |Office hours: Mondays 10 a.m. - 2 p.m. (TA Ben) | |Tuesdays 3.30 - 6.30 p.m. (TA Ben) | |Wednesdays 10.30 a.m. - 1.30 p.m. (TA Brittany) | |Thursdays 8.30 a.m. - 3.30 p.m. (TA Jesse) | |Fridays 10 a.m. - 1 p.m. (TA Ben)...
Words: 4292 - Pages: 18
