In the Sam’s Bookstore problem, the quantity dis-count structure is such that all the units ordered have the same unit cost. For example, if the order quantityis 2500, then each unit costs $22.25. Sometimes thequantity discount structure is such that the unit costfor the first so many items is one value, the unit costfor the next so many units is a slightly lower value, andso on. Modify the model so that Sam’s pays $24 forunits 1 to 1500, $23 for units 1501 to 2500, and $22 forunits 2501 and above. For example, the total cost foran order quantity of 2750 is 1500(24) 1 1000(23) 1250(22). (Hint: Use IF functions, not VLOOKUP.)

In the Sam’s Bookstore problem, the quantity dis-count structure is such that all the units ordered have the same unit cost. For example, if the order quantityis 2500, then each unit costs $22.25. Sometimes thequantity discount structure is such that the unit costfor the first so many items is one value, the unit costfor the next so many units is a slightly lower value, andso on. Modify the model so that Sam’s pays $24 forunits 1 to 1500, $23 for units 1501 to 2500, and $22 forunits 2501 and above. For example, the total cost foran order quantity of 2750 is 1500(24) 1 1000(23) 1250(22). (Hint: Use IF functions, not VLOOKUP.)

Operations Research : Applications and Algorithms

4th Edition

ISBN:9780534380588

Author:Wayne L. Winston

Publisher:Wayne L. Winston

Chapter15: Deterministic Eoq Inventory Models

Section15.2: The Basic Economic Order Quantity Model

Problem 14P

See similar textbooks

Similar questions

In a list there is cost price of n goods. On the most expensive thing there is a loss of x% and on the cheapest thing there is a gain of y% and on rest of things there is a gain of p%. Find loss or gain on whole transaction in Rupees.
Write a program to generate the desired output for the model. Use it to estimate the average time that a customer spends in the system and the average amount of overtime put in by the server, in the case where the arrival process is a Poisson process with rate 10, the service time density is g(x) = 20e^−40x (40x)^2, x > 0 and T = 9. First try 100 runs and then 1000.
A. Suppose that every random variable in the joint distribution of P(A,B,C,D,E) = P(E|C,D)P(D|C)P(C|A,B)P(B|A)P(A). has a domain containing 10 elements. How many rows are needed to list the full joint distribution in an explicit table? B. Suppose that every random variable in the joint distribution of P(A,B,C,D,E) = P(E|C,D)P(D|C)P(C|A,B)P(B|A)P(A). has a domain containing 10 elements. How many rows in total are needed to list the conditional probability tables for your belief network representation?
You are given a dataset of continuous numerical features with a categorical target class. There is not any missing data or outliers. Which algorithm would you use to create a model? K-means clustering Logistic regression Decision Tree Linear regression
Method: Python Dataset: Census Income Source: https://archive.ics.uci.edu/ml/datasets/Adult Objective The objective of this task is to implement from scratch Decision Tree classification method to predict whether the incomes exceed $50K/yr based on census data. Thus, this is a binary classification problem. The training and test sets are pre-defined in the data set (i.e., in "adult.data" and "adult.test"). Requirements (1) Implement two DT models by choosing any two (2) split criteria from Information Gain, Gain Ratio, Gini Index and Variance. Note that you can use either binary-split or multiple-split. (2) Use (approximately) 2/3 records in "adult.data" for training, and 1/3 records in "adult.data" for post-pruning. (3) Report the accuracy of each model. (4) All DT models must be self-implemented. You CANNOT use any machine learning library in this task. (5) It is recommended that your implementation includes a "tree induction function", a "classification function" and a…
The size of the intersection divided by the size of the union is used to determine how similar two papers are (each having unique words). For instance, the similarity between 1, 5, 3 and 1, 7, 2, 3 is 0, 4, as the intersection has size, if the documents are made up of integers.the union has a size of 2, andWe have a large collection of documents (each with a unique value and a corresponding ID), where the similarity is deemed to be "sparse":This means that there is a high likelihood of resemblance between any two randomly chosen papers. O. Create an algorithm that provides a list of document ID pairings together with the corresponding similarity.Only the pairings with similarity larger than 0 should be printed. Documents that are empty should not
Big-O notation is defined as follows: The function f(n) is O(g(n)) if there are positive integers c and N such that f(n) ≤ c · g(n) for all n > N. Is the relation “f(n) is O(g(n))” reflexive? symmetric? transitive? Justify your answers. “Θ(g(n))” is defined as follows: f(n) is Θ(g(n)) if and only if (f(n) is O(g(n)) & g(n) is O(f(n))). Is the relation “f(n) is Θ(g(n))” reflexive? symmetric? transitive? Justify your answers
In the Barney-Jones investment model, we ran invest-ments across columns and years down rows. Many financial analysts seem to prefer the opposite. Modify thespreadsheet model so that years go across columns andinvestments go down rows. Run Solver to ensure thatyour modified model is correct. (There are two possibleways to do this, and you can experiment to see whichyou prefer. First, you could basically start over on a blankworksheet. Second, you could use Excel’s TRANSPOSEfunction on the final version of the model.)
Let c1, c2, and c3 be the confidence values of the rules {p} → {q}, {p} → {q, r}, and {p, r}→{q}, respectively. If we assume that c1, c2, and c3 have different values, what are the Customer ID Transaction ID Items Bought 1 0001 {a, d, e} 1 0024 {a, b, c, e} 2 0012 {a, b, d, e} 2 0031 {a, c, d, e} 3 0015 {b, c, e} 3 0022 {b, d, e} 4 0029 {c, d} 4 0040 {a, b, c} 5 0033 {a, d, e} 5 0038 {a, b, e} possible relationships that may exist among c1, c2, and c3? Which rule has the lowest confidence?
In this assignment, you will need to write an agent that uses logical inference to find the answers to the givenquestions based on the data given in the below table:1. Python Code Filename: ID.py ID Name GPA Program City 123 Ahmed 3.56 BS-CS Gujranwala 456 Zahid 2.85 BS-SE Lahore 789 Baber 3.70 BS-DS Gujranwala 321 Shahid 2.99 BS-CS Gujranwala 654 Jamal 3.33 BS-DS Lahore Use the given code puzzle.py and amend the code so that it finds the answer to these questions:a. Who lives in Lahore?b. Who studies in the BS-DS program?c. Who has the minimum GPA and who has the maximum GPA? You are restricted to using only the kanren logical AI library and the given code for the LogicalProgramming lectures. You may use any mathematical library (if needed) for any math related work.2. Write a report (ID.pdf) that describes the logic of your solution. Make sure to describe all main steps thatyour code uses to find the answers of the given questions. puzzle.py; from kanren import…
Write a program that will accept a sequence of `insert’ and `delete’ operations in dynamic table and compute the potential and amortized cost after each operation. The output of the program is a graph showing changes in size, num, potential and amortized cost (c i’) for the entire sequence of operations.
Suppose, you have trained a k-NN model and now you want to get the prediction on test data. Before getting the prediction suppose you want to calculate the time taken by k-NN for predicting the class for test data.Note: Calculating the distance between 2 observation will take D time. What would be the relation between the time taken by 1-NN,2-NN,3-NN?