Premium Essay

Demand Estimation and Excel Assignment

In:

Submitted By Nekishawa
Words 1086
Pages 5
Demand Estimation
Nekishawa Ellis
Strayer University

Demand Estimation
For this assignment, one is to imagine that they work for the maker of a leading brand of low calorie, frozen microwavable food. The maker estimates a demand equation for its product. They use data from twenty-six supermarkets around the country for the month of April. To get a better understanding of how to solve the equation, one must first have a better understanding of demand estimation.
Demand estimation is a process that involves coming up with an estimate of the amount of demand for a product or service. One of the reasons that companies use demand estimation is to assist with pricing. When one has an idea of what the demand would be for the product, one knows approximately how much they have to price the product. With demand estimation, a company can gauge how much to produce and make other important decisions.
As one moves forward with tackling the assignment, one will first find that the elasticity must be computed for each independent variable. With the regression analysis, quality demand (QD) represents the equation QD = -5200 – 42P + 20PX + 5.211 + .20A + .25M. The product price (P) can have a negative relation to quality demand as well. The price of the leading competitor is represented by (PX). As price changes demand, this is the result (PX). Income is represented by (I). (A) stands for monthly advertising. As one advertises, the end result would be more sells. (M) represents the number of microwaves sold.
Within the equation, the price (P) is 500 (five hundred), (PX) is 600 (six hundred), the income (I) is 5,500 (five thousand five hundred), advertise (A) is 10,000 (ten thousand), and (M) is 5,000 (five thousand). After swapping the values and variables, the quality demand is utilized to solve in hopes of finding the total for quality demand. QD = -5200 – 42 (500) + 20

Similar Documents

Premium Essay

Assignment 1

...Assignment 1: Demand Estimation Becky Boom ECO 550 Demand Estimation for Low Calorie Frozen - Microwavable Food Using data from 26 supermarkets around the country for the month of April, the following regression equation was generated. Please note, standard errors are in parentheses for the demand for widgets. QD = -5200 - 42P + 20PX +5.2I +.20A +.25M (2.002) (17.5) (6.2) (2.5) (0.09) (0.21) R2 = 0.55 n = 26 F = 4.88 Computed elasticities for each independent variable has been requested assuming the following values for the independent variables: Q = Quantity demanded of 3-pack units P (in cents) = Price of the product = 500 cents per 3-pack unit PX (in cents) = Price of leading competitor’s product = 600 cents per 3-pack unit I (in dollars) = Per capita income of the standard metropolitan statistical area (SMSA) in which the supermarkets are located = $5,500 A (in dollars) = Monthly advertising expenditures = $10,000 M = Number of microwave ovens sold in the SMSA in which the supermarkets are located = 5,000 1. Attached is the excel spreadsheet where you will find...

Words: 1241 - Pages: 5

Premium Essay

Management

...standard costing, etc. 2. Course Duration The course will have 45 sessions of 60minutes duration. 3. Course Contents Assignment of sessions to the modules of course is as follows: Module No. | Modules/ Sub modules | Sessions | Marks (Uni. Exam) | I | Cost Management and Cost EstimationCost and Management Accounting OverviewVarious Cost Concepts. Cost Estimation approaches, tools and techniques | 9 | 20 | II | Cost allocation and Job/ batch CostingCost Allocation, Activity Based and Target CostingJob and Batch Costing Introduction to the concept of operating costs | 9 | 20 | III | Costing MethodsOperating Costing. Process Costing and Joint and By product Costing. | 9 | 20 | IV | Management ApplicationsMarginal (Variable) Costing and Absorption Costing Decision Involving Alternative Choices and Pricing DecisionsMake-or-Buy | 9 | 20 | V | Planning, Control and Decision MakingBudgeting and Budgetary Control SystemStandard Costing and Variance AnalysisContemporary Issues like Kaizen Costing, Target Costing, Life Cycle Costing, and Cost Audit and Cost Accounting Standards | 9 | 20 | 4. Teaching Pedagogy: The course will use the following pedagogical tools: (a) Case discussion covering a cross section of decision situations. (b) Discussions on issues and techniques (c) Projects/ Assignments/...

Words: 4490 - Pages: 18

Premium Essay

Eco 550

...Assignment 1: Demand Estimation Student’s Name Course Tutor Date Assignment 1: Demand Estimation Compute the elasticities for each independent variable. Note: Write down all of your calculations Elasticity refers to the degree of responsiveness in quantity demanded in relation to the changes in factors that affect demand, for instance, price (McGuigan, 2014). The independent variables in the equation include price of the product, price of competitor’s product, income in the area, and advertising expenditure. Therefore, the elasticities include price elasticity, cross elasticity, income elasticity, and advertising elasticity respectively. The values below indicate the equation and formula that will be used to compute the elasticities of each of the independent variable. Equation: QD = -5200 – 42P + 20PX + 5.2I + 0.20A + 0.25M Elasticity = (% Change in Quantity)/ (% Change in Price) N/B: % Change = (Amount of Change)/ (Initial Level) Price Elasticity (Ep) = ΔQd/ ΔP * P/Qd ΔQd/ ΔP = - 42 P/Qd = 500/5000 = 0.1 Ep = - 42 * 0.1 = - 4.2 Cross Elasticity (Epx) = ΔQd/ ΔPX * PX/Qd ΔQd/ ΔPX = 20 PX/Qd = 600/5000 = 0.12 Epx = 20 * 0.12 = 2.4 Income Elasticity (EI) = ΔQd/ ΔI * I/Qd ΔQd/ ΔI = 5.2 PX/Qd = 5,500/5000 = 1.1 EI = 5.2 * 1.1 = 5.72 Advertising Elasticity (EA) = ΔQd/ ΔA * A/Qd ΔQd/ ΔA = 0.20 A/Qd = 10,000/5000 = 2 EA = 2 * 0.20 = 0.4 Determine the implications for each of the computed elasticities for the business in terms of short-term and...

Words: 1227 - Pages: 5

Premium Essay

A Case Study on Managing Growth at Sportstuff.Com

...surplus equipment from manufacturers over the Internet. Sanjay received enough capital from venture capitalists and could offer a wide variety of products. As the demand began to grow rapidly, Sanjay had to come up with new strategies for warehousing. Initially starting with one warehouse in St. Louis, he had to lease more space within the same warehouse to meet the demand. Demand has been growing rapidly since 1999 and Sanjay needed a new plan. He has a few options including leasing more warehouse space in St. Louis or finding other potential locations across the United States. The next 3 years were predicted to have a growth rate of about 80% per year. A serious supply chain redesign was needed soon; otherwise costs would far exceed the growing demand and revenues. Leasing a warehouse involves fixed and variable costs. Fixed costs are based on the size of the warehouse itself. Variable costs depend on the actual quantity that was shipped through the warehouse. Additionally, he can rent small and large warehouses in various locations, which have different costs. Costs for inbound shipment from suppliers were considered to be the same for any warehouse configuration. The four potential locations selected were Seattle, Denver, Atlanta and Philadelphia (in addition to St. Louis). In this case study, a cost-capacities-demand model of these locations is studied to determine the...

Words: 1249 - Pages: 5

Premium Essay

It- 3rd Year

...Secret Key Encryption, Public Key Encryption, Virtual Private Network (VPM), Implementation Management Issues. UNIT - IV Electronic Payments Overview of Electronics payments, Digital Token based Electronics payment System, Smart Cards, Credit Card I Debit Card based EPS, Emerging financial Instruments, Home Banking, Online Banking. UNIT-V Net Commerce EDA, EDI Application in Business, Legal requirement in E -Commerce, Introduction to supply Chain Management, CRM, issues in Customer Relationship Management. References: 1. Greenstein and Feinman, “E-Commerce”, TMH 2. Ravi Kalakota, Andrew Whinston, “Frontiers of Electronic Commerce”, Addision Wesley 3. Denieal Amor, “ The E-Business Revolution”, Addision Wesley 4. Diwan, Sharma, “E-Commerce” Excel 5. Bajaj & Nag, “E-Commerce: The Cutting Edge of Business”, TMH INFORMATION SYSTEMS (TIT-502) Unit-I Foundation of Information Systems: Introduction to information system in business, fundamentals of information systems, solving...

Words: 2913 - Pages: 12

Premium Essay

Gujarat Technological University Syllabus for New Mba Program Effective from Academic Year 2011-12 Mba I Semester I

...Gujarat Technological University Syllabus for New MBA Program effective from Academic Year 2011-12 MBA I Semester I Accounting for Managers (AFM) 1. Course Objective: The objective of the course is to acquaint the students with the language of Accounting and to develop in them the ability to evaluate and use accounting data as an aid to decision making. The main purpose is to assist the students in developing skills in problem solving and decision making in the financial area. Emphasis is laid on analysis and utilization of financial and accounting data for planning and control. 2. Course Duration: The course duration is of 36 sessions of 75 minutes each i.e. 45 hours. 3. Course Contents: Module No: Module Content No. of Sessions 70 Marks (External Evaluation) 17 I II Fundamentals of Accounting Basic understanding of accounting, Accounting Concepts, Conceptual framework of financial statements, Accounting Policies, Journal Entries and preparation of accounts - Trial Balance to Balance sheet and profit and loss Account, Recognition of Income and Expenses, Provisions, Contingent Liabilities Accounting Standards and Applicability: Disclosure of Accounting Policies (AS-1), Valuation of Inventories (AS-2), Depreciation Accounting (AS-6), Income Recognition & Accrual Income (AS-9), Accounting of Fixed Assets (AS-10), Accounting for Intangible Assets (AS-26), Accounting for Investments (AS-13), 7 7 17 III IV V Preparing and Understanding Financial Statements...

Words: 5698 - Pages: 23

Premium Essay

Eco550 Assignment 1

...Assignment 1: Making Decisions Based on Demand and Forecasting Managerial Economics and Globalization, ECO550 Making Decisions Based on Demand and Forecasting A market demand analysis is used to help understand how much consumer demand there is for a given product or service. This type of analysis will help determine if a business can successfully enter a market and generate enough revenue and profit to maintain the business. One must identify the market and the growth potential. Domino’s Pizza was incorporated in 1963 and has been franchising since 1967. A traditional Domino’s store is located in shopping centers and/or strip malls with appropriate parking for delivery vehicles and walk-in customers for carry-out services. The initial investment of a traditional store is approximately $119,500 (low estimation). To determine if a Domino’s Pizza can be opened in Morehead City, North Carolina one must estimate consumer demand for this area. Some of the variables that can be considered are population, price of pizza, and income per household. The population of Morehead City is 8,780 people; let’s assume that 40% are eating pizza, so the demand will be 3,512 people want pizza. Considering there are 365 days in a year we can assume that nine households are eating pizza each day, with an average of 3 people in the household let’s assume they normally order two pizzas, a total of 18 pizzas per day. The average income of a household in Morehead...

Words: 1156 - Pages: 5

Free Essay

With the Development of Technology, More and More Robots Are Used in Various Fields,

...University of Mumbai B.E Information Technology Scheme of Instruction and Evaluation Third Year -Semester VI Scheme of Instructions Sr. Subjects Lect/ No 1 Information and Network Security Middleware and Enterprise Integration Technologies Software Engineering Data Base Technologies Programming for Mobile and Remote Computers Information Technology for Management of Enterprise TOTAL Week 4 Scheme of Examinations Theory T/W Practical Oral Total Hours Marks Marks Marks Marks Marks 3 100 25 -25 150 Pract/ Week 2 Tut/ Week -- 2 4 2 -- 3 100 25 -- 25 150 3 4 5 4 4 4 2 2 2 ---- 3 3 3 100 100 100 25 25 25 --25 25 25 -- 150 150 150 6 4 24 10 1 1 3 -- 100 600 25 150 -25 25 125 150 900 INFORMATION AND NETWORK SECURITY CLASS T.E. ( INFORMATION TECHNOLOGY) HOURS PER LECTURES : WEEK TUTORIALS : PRACTICALS EVALUATION SYSTEM: THEORY PRACTICAL ORAL TERM WORK : SEMESTER VI 04 -02 HOURS 3 ---- MARKS 100 25 25 1. Introduction What is Information Security? Security Goals. 2. Cryptography Crypto Basic, Classic Cryptography, Symmetric Key Cryptography: Stream Ciphers, A5/1, RC4, Block Ciphers, Feistel Cipher, DES, Triple DES, AES, Public Key Cryptography: Kanpsack, RSA, Defiie-Hellman, use of public key crypto- Signature and Non-repudiation, Confidentiality and Non-repudiation, Public Key Infrastructure, Hash Function: The Birthday Problem, MD5, SHA-1, Tiger Hash, Use of Hash Function. 3. Access...

Words: 3868 - Pages: 16

Free Essay

Abcd

...Shanti Business School PGDM Batch 2015-17 Semester II Course Outline 1 Shanti Business School, Ahmedabad PGDM 2015-17: Program Structure Semester-1 Semester-2 Semester-3 Semester-4 Course credit Course credit Course credit Language Skills @ Written Analysis & Communication @ Soft skills II @ Employability Skills @ IT & MIS 2 Soft skills I @ Computing skills 2 Social Media Marketing @ 2 Legal Aspects of Business 2 Business Strategy 3 Management Control Systems 3 Micro Economics 3 Macro Economics 3 Business Environment 3 Business Ethics & Corporate Governance 2 Quantitative Methods-1 3 Business Research Methods 3 Quantitative Methods-2 3 Core Elective-1 3 Core Elective1 3 Core Elective-2 3 Core Elective2 3 Elective-1 3 Elective-1 3 Elective-2 3 Elective-2 3 Grand Project-1 3 Grand Project-2 3 Principles of Management Basic Building Blocks Autumn Break Executive Skills Organisational Behavior Human Resources Management 3 Marketing Management 1 3 Marketing Management -2 3 Understanding Financial Statements 3 Financial Mgt 3 Operation Management Management Domain 3 3 Basics of Business Planning 2 Electives Credits Autumn Break credit SUMMER INTERNSHIP Course ...

Words: 7010 - Pages: 29

Premium Essay

Technology

...Chapter Three 3 Fundamentals of Cost-Volume-Profit Analysis Orientation P A R T 1 LEARNING OBJECTIVES Preparing and Organizing Yourself After reading this chapter, you should be able to: for Success in College L.O.1 Use cost-volume-profit (CVP) analysis to analyze decisions. L.O.2 Understand the effect of cost structure on decisions. L.O.3 Use Microsoft Excel to perform CVP analysis. L.O.4 Incorporate taxes, multiple products, and alternative cost structures into the CVP analysis. L.O.5 Understand the assumptions and limitations of CVP analysis. C H A P T E R S I N P A R T O N E 1 2 Making Yourself Successful in College Approaching College Reading and Developing a College-Level Vocabulary Approaching College Assignments: Reading Textbooks and Following Directions 3 ✓ Related Resources See pages 000 to 000 of the Annotated Instructor’s Edition for general suggestions related to the chapters in Part One. 1 cor50782_ch01_001-072.indd 1 10/5/09 11:09:2 P A R T I opened U-Develop because I love photography and I wanted to own my own business. I now get to spend most of my day working with employees and customers making sure that the photos they take are the best they can be. It also gives me a chance to encourage younger people who have an interest in photography, because I work with many of the school groups and after-school clubs here in town. That’s the fun part of the job. But I also have to think about the financial side of the business. I need a systematic way to understand...

Words: 16283 - Pages: 66

Free Essay

Qmb Course Guide

...ECOM90009 Quantitative Methods for Business SUBJECT GUIDE Second Semester, 2012 Prepared by: Dr. Michael Coelli Department of Economics Faculty of Business and Economics Contents Contents ...................................................................................................................................... 2 Subject Outline ........................................................................................................................... 3 Introduction ............................................................................................................................ 3 Subject Aims .......................................................................................................................... 3 Prescribed References ............................................................................................................ 3 Learning Outcomes .................................................................................................................... 3 Subject Objectives .................................................................................................................. 3 Generic Skills ......................................................................................................................... 4 Awareness Issues.................................................................................................................... 4 Prerequisites ......................................................

Words: 3953 - Pages: 16

Premium Essay

Modeling

...EXCEL MODELING AND ESTIMATION IN CORPORATE FINANCE Third Edition CRAIG W. HOLDEN Max Barney Faculty Fellow and Associate Professor Kelley School of Business Indiana University Copyright © 2008 by Prentice Hall, Inc., Upper Saddle River, New Jersey 07458 To Kathryn, Diana, and Jimmy. Contents iii CONTENTS   Preface ..................................................................................... vii  Third Edition Changes .................................................................................... vii  What Is Unique About This Book ..................................................................... x  Conventions Used In This Book .......................................................................xi  Craig’s Challenge ........................................................................................... xiii  The Excel Modeling and Estimation Series .................................................. xiii  Suggestions for Faculty Members ..................................................................xiv  Acknowledgements ........................................................................................... xv  About The Author ................................................................. xvi  PART 1 TIME VALUE OF MONEY ..... 1  Chapter 1 Single Cash Flow ....................................................1  1.1 Present Value .......................................................................................

Words: 33587 - Pages: 135

Premium Essay

Dferewrwerwe

...Business AnAlytics And intelligence Course Starting: 29 June 2014 Application Deadline: Early Decision 28 February 2014 Regular Decision 15 April 2014 (Batch 5) (Classes conducted on-campus as well as off-campus) Certificate Programme on Business Analytics and Intelligence BATCH 5 in god We trust, All Others Must Bring data - W edwards deming he theory of bounded rationality proposed by nobel laureate Herbert Simon is evermore significant today with increasing complexity of the business problems; limited ability of human mind to analyze alternative solutions and the limited time available for decision making. introduction of enterprise resource planning (eRP) systems has ensured availability of data in many organizations; however, traditional eRP systems lacked data analysis capabilities that can assist the management in decision making. Business Analytics is a set of techniques and processes that can be used to analyse data to improve business performance through fact-based decision making. Business Analytics is the subset of Business intelligence, which creates capabilities for companies to compete in the market effectively. Business Analytics is likely to become one of the main functional areas in most companies. Analytics companies develop the ability to support their decisions through analytic reasoning using a variety of statistical and mathematical techniques. thomas devonport in his book titled, “competing on analytics: the new science of winning”, claims...

Words: 4378 - Pages: 18

Premium Essay

Sibm

...Tushar Suresh Bhavsar 2/305, Rakshak Nagar-2, Date of Birth: 23rd May, 1983 Kharadi, Pune 411038. Mobile: 91-9503162041 Email:tusharbhavasar@gmail.com Professional Synopsis ← 7 years of total experience with 2 years of software project management exposure. ← On-site coordination experience from client site based in San Francisco USA. ← Requirement understanding and project initiation activities at on-site location based in New York, Cincinnati and San Francisco, USA. ← Proven abilities in leading complete SDLC entitling analysis, design, development, testing, planning, estimations and delivery. ← An effective communicator with excellent relationship management skills. Strong analytical, problem solving & analytical abilities. Possess a flexible & detail oriented attitude. ← Leading and managing team of size 20+. ← Consistently top performer. Skills Set Technical Operating System : Windows NT/2K/XP/2K3/2K8/Vista/7. Microsoft Tech. : .NET Framework, Visual C# .Net, VB .NET, ASP .Net, ADO .Net, framework 1.0, 1.1, 2.0, 3.5, web services, Windows services, Remoting, Entity framework, Linq, Share point – WSS exposure, Sales Force integration, Dial up USA. Ajax toolkit extender, Enterprise library, Crystal reports, Membership providers,In-home install api, Google api integration API integration : IBM SPSS, Google api federated login and white listing, Lumi , in-home install, Trumpia SMS. Database : RDBMS...

Words: 2307 - Pages: 10

Premium Essay

Abc - Abcdefghijjklmn

...Office Hours Tuesdays/Thursdays, 1:00-2:30, and by appointment Phone 512-288-3115 (Cell phone – feel free to call any day before 9 p.m.) E-Mail Kate.Mackie@mccombs.utexas.edu Skype katemackietx Course Web Page via Blackboard ------------------------------------------------- Teaching Assistants Dave Isquick (David.Isquick@mba12.mccombs.utexas.edu ) Course Objectives The primary objectives of this course are to: a) advance your understanding of concepts and tools useful in the analysis and development of pricing and distribution strategy, and b) help you develop skills and gain experience in formulating these strategies. Learning methods The course uses (a) individual and team assignments with field work, (b) case study briefs and discussions (c) lectures and discussions of readings, (d) guest speakers, and (e) a pricing simulation. The classroom environment will be very interactive, so prepare to get involved. Students come from a variety of backgrounds with a large and diverse base of knowledge and experience. Therefore, the primary role of the professor will be to facilitate discussions that bring out pertinent issues and to better frame the analyses of these issues. Required materials Case Packet: The case packet is available through www.study.net. Instructions to get materials from study.net are included in the last page of this syllabus, before the course schedule. Pricing Simulation – Universal...

Words: 10958 - Pages: 44