Figure 2.23 Profit as a Function of Order Quantity and Demand 21 Data table of profit as a function of order quantity (along side) and demand (along top) 50 1500 $3,000 $7,000 $10,500 2500 $3,000 $7,000 $9,375 500 1000 $3,000 $7,000 $500 -$4,500 -$20,625 -$10,625 -$25,250 -$15,250 -$31,125 -$21,125 -$11,125 -$35,200 -$25,200 -$15,200 -$40,850 -$30,850 -$20,850 -$10,850 2000 3000 $3,000 $7,000 $10,500 $10,500 $15,500 $19,375 $24,750 $18,875 $4,800 $14,800 $9,150 22 3500 4000 4500 $3,000 $7,000 $10,500 $5,500 $15,500 $15,500 $9,375 $19,375 $4,750 $1,125 -$5,200 $3,000 $7,000 $10,500 $15,500 $19,375 $3,000 $7,000 $10,500 $15,500 $19,375 $24,750 $28,875 $34,800 $39,150 $3,000 -$3,000 -$9,500 -$14,500 $3,000 $7,000 $10,500 $15,500 $19,375 23 24 1000 25 1500 26 2000 27 2500 -$625 3000 -$5,250 $14,750 $24,750 $28,875 $24,800 $19,150 $24,750 $28,875 $34,800 $29,150 28 3500 4000 4500 29 $8,875 30 31 -$850

Figure 2.23 Profit as a Function of Order Quantity and Demand 21 Data table of profit as a function of order quantity (along side) and demand (along top) 50 1500 $3,000 $7,000 $10,500 2500 $3,000 $7,000 $9,375 500 1000 $3,000 $7,000 $500 -$4,500 -$20,625 -$10,625 -$25,250 -$15,250 -$31,125 -$21,125 -$11,125 -$35,200 -$25,200 -$15,200 -$40,850 -$30,850 -$20,850 -$10,850 2000 3000 $3,000 $7,000 $10,500 $10,500 $15,500 $19,375 $24,750 $18,875 $4,800 $14,800 $9,150 22 3500 4000 4500 $3,000 $7,000 $10,500 $5,500 $15,500 $15,500 $9,375 $19,375 $4,750 $1,125 -$5,200 $3,000 $7,000 $10,500 $15,500 $19,375 $3,000 $7,000 $10,500 $15,500 $19,375 $24,750 $28,875 $34,800 $39,150 $3,000 -$3,000 -$9,500 -$14,500 $3,000 $7,000 $10,500 $15,500 $19,375 23 24 1000 25 1500 26 2000 27 2500 -$625 3000 -$5,250 $14,750 $24,750 $28,875 $24,800 $19,150 $24,750 $28,875 $34,800 $29,150 28 3500 4000 4500 29 $8,875 30 31 -$850

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter24: Forecasting Models

Section24.8: Multiple Regression

Problem 4P

See similar textbooks

Similar questions

Exercise 1 Product Name Sales Rep Country Product 1 Paul China Product 1 Paul Singapore Product 1 John India Product 2 Joe Canada Product 2 Joe China Product 2 Joe India Product 2 Harry US Product 3 Tom India Product 3 Paul Japan Product 3 Mike Japan Product 4 Racheal US Product 4 Paul Indonesia Product 4 Mike Canada Product 5 Stephen India Product 5 Stephen Philippines 1. Sort table above first by Product (asc), Sales Rep (desc) and Country (asc).
2. Filter the table to show all the Joe from any country. Product Name Sales Rep Country Product 1 John India Product 2 Joe China Product 3 Mike Japan Product 4 Racheal US Product 5 Arvind India Product 6 Xin China Product 7 Harry US Product 8 Tom India Product 9 Paul Indonesia Product 10 Stephen Philippines Product 11 Paul Singapore Product 12 Joe Canada Product 13 Paul Japan Product 14 Mike Canada Product 15 Joe India
1. To get the TOTAL SALES, add beginning stock and purchased. 2. To get the TOTAL PRICE, multiply total sales, and price per piece. 3. Get the highest total price using the MAX function. 4. Get the lowest total price using the MIN function. 5. Count the total price to get the number of items using the COUNT function. 6. Sort the description from A-Z.7. Insert a line chart using only DESCRIPTION and TOTAL SALES.
.Consider the Bank Management System.account(account_number, branch_name, balance)branch (branch_name, branch_city, assets)customer (customer_name customer_street, customer_city)loan (loan_number, branch_name, amount)depositor((customer_name, account_number)borrower(customer_name, loan_number)Answer the following queries using relational algebra operators1.List all branch names and their assets2. List all accounts of Brooklyn branch3. List all loans with amount > 10004. List all accounts of Perryridge branch with balance < 10005. List Numbers of accounts with balances between 700 and 900
Give employee Id, name, and date hired of the managers who have the highest experience (years employed) order by employee name. If there is more than one employee with the highest experience, show all. Q1.2 : Give all manager names and date hired for managers whose work experience is higher than the work experience of their employees. List results in managers' name order. Q1.3: List Material ID and Product Id in which the Material has the highest quantity required for this material. List results in order of Material ID. Q1.4: For products that have used materials, show the product ID, product description, material ID, and quantity required of materials whose quantity required is higher than the average quantity required for that material. Sort the results by product ID and then by material ID
Problem 21 Provide a summary of customer balance characteristics for customers who made purchases. Include the minimum balance, maximum balance, and average balance, as shown in Figure P7.21. SELECTMIN(CUSTOMER.CUS_BALANCE) AS 'Minimum Balance',MAX(CUSTOMER.CUS_BALANCE) AS 'Maximum Balance',ROUND(AVG(CUSTOMER.CUS_BALANCE),2) AS 'Average Balance' FROM CUSTOMER WHERE CUS_CODE IN(SELECT CUS_CODE FROM INVOICE); This does not work, what am i missing it is suppose to be Minimum Balance 0.00 Maximum Balance 345.86 Average Balance 70.30
consider the following tables: Table name: sales salesman_id 5001 city name commission John Paris 0.15 James New York 0.13 Neel 5002 5005 Rome 0.11 5006 lla Paris 0.13 5003 Jordan Mexico 0.12 Table name: customers customer id Cust_name city Nick grade salesman_id 100 3002 Paris 5001 3007 David New York 200 5001 3005 London 5002 Jozy Julian 200 3008 Paris 300 5003 3004 Brad New York 100 5003 Perform the following queries on the above tables: 1. Create the above tables using the validations of your choice. (4 Marks) 2. find the salesperson(s) and the customer(s) he handle. Return Customer Name, city, Salesman, commission. (3 marks) 3. Display the customer information who have salesman associated with them.
Consider the table below with the given values, what is the result of the formula: 1.) =AVERAGE(A1:B1) 2.) =PRODUCT(MAX(A1:C2), ROUND(E8,2)
Write the table below and answer the questions according to the tables: customers - id - name - family_name - address - phone products code name stock unit_cost unit_price orders - id - customer_id - product_code - quantity - price - date For that tables write the queries as a table valued functions: 1. Find the customers (name, family_name, address) which are get a product with code. 2. Find name, code, unit_price, quantity who the customer gets by customer_id
Calculate the Theil index and the Atkinson index (use = 1) of house-hold income for all households and by race (in other words, calculate the inequality measures within racial categories). what would be the code for the above question in stata?
Problem 20.c Using MySQL, populate the CUST_LNAME, CUST_FNAME, and CUST_BALANCE fields with the following customers: CUST_LNAME CUST_FNAME CUST_BALANCE Smith Jeanne 1050.11 Ortega Juan 840.92
n _______ method of amortized analysis, the upper bound T(n) on the total cost of a sequence of n operations is determined and then amortized cost is calculated as T(n)/n. (accounting, aggregate)