schedule how many telephone operators for each shift. W. L. Brown predicts that a discrete probability distribution in the excel template file can describe the number of phone calls received per hour of a typical eight-hour shift. Each operator spends $20 per hour and handles 15 calls. The corporation loses $6 per unanswered call. Simulate the number of operators that minimizes the projected hourly cost (labor costs plus lost revenues) for 6, 8, 10, 12, 14, or 16 operators.

schedule how many telephone operators for each shift. W. L. Brown predicts that a discrete probability distribution in the excel template file can describe the number of phone calls received per hour of a typical eight-hour shift. Each operator spends $20 per hour and handles 15 calls. The corporation loses $6 per unanswered call. Simulate the number of operators that minimizes the projected hourly cost (labor costs plus lost revenues) for 6, 8, 10, 12, 14, or 16 operators.

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 8P

See similar textbooks

Similar questions

Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment. If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profit of 4.5 dollar. For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% where for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. Investment will always be greater or equal to 25,000 and multiple of 100. Complete the RECURSIVE methods below that take an array of integers (investments) and an iterator (always sets to…
Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment. If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profit of 4.5 dollar. For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% whereas for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. The investment will always be greater or equal to 25,000 and multiple of 100. Complete the RECURSIVE methods below that take an array of integers (investments) and an iterator (always sets to…
During the internship season m tech companies are looking to hire CS undergrads, each company has k number of available positions. There are also n CS undergrads, each interested in joining one of the companies. After all the interviews each company has rankings of students in order of preference, and each student has a ranking of companies in order of preference. We can assume that there are more internship slots available than the number of students. (This means that at the end not all slots will be filled.) Describe an algorithm that finds a stable assignment of students to companies. That is, each student will get assigned to one company and the resulting matching is stable. In your answer make sure to follow the guidelines of solving an algorithmic problem, as described above.
Assignment 2. ELECTRICITY BILL CALCULATOR FOR DOMESTIC DWELLING Electrical Unit Tariff blocks Unit RM Fixed Charge First Unit Slab Next Unit 200 0.218 200 RM Slab 100 0.334 Surcharge 0.00 RM/Unit Next Unit Slab 300 0.516 Tax.Charge 6 % Next Unit Slab 300 0.546 Meter Charge 200 RM Last Unit Slab 100 0.571 ITEM RATINGS NUMBER no. hours/day unit consumed in kwh LED 8 16 CFL 20W 5 16 REF 200W 1 24 FAN 80W 6 24 total meter reading for a month 190 Monthly Bill 540 final bill 1 Calculate the electricity bill as per the table given 2 nested if formula has to be used to apply various conditions for all tariff blocks 3 for two tariff blocks formula is already applied so you have to do for the remaining tariff block IF(F18<=100,F18*2.7,(100*2.7)+(F18-100)*3)
Suppose, you are working in a company ‘X’ where your job is to calculate the profit based on their investment.If the company invests 100,000 USD or less, their profit will be based on 75,000 USD as first 25,000 USD goes to set up the business in the first place. For the first 100,000 USD, the profit margin is low: 4.5%. Therefore, for every 100 dollar they spend, they get a profitof 4.5 dollar.For an investment greater than 100,000 USD, for the first 100,000 USD (actually on 75,000 USD as 25,000 is the setup cost), the profit margin is 4.5% where for the rest, it goes up to 8%. For example, if they invest 250,000 USD, they will get an 8% profit for the 150,000 USD. In addition, from the rest 100,000 USD, 25,000 is the setup cost and there will be a 4.5% profit on the rest 75,000. Investment will always be greater or equal to 25,000 and multiple of 100.Complete the RECURSIVE methods below that take an array of integers (investments)and an iterator (always sets to ZERO(‘0’) when the…
An assignment was given to four students attending a sample survey course. The problem was to estimate the average time per week devoted to study in Punjab Agricultural University (PAU) library by the students of this university. The university is running undergraduate, master's degree and doctoral programs. Number of students registered for the three programs is 1300, 450, and 250 respectively. Since the value of the study variable is likely to differ considerably with the program, the investigator divided the population of students into 3 strata: undergraduate program (stratum I), master's program (stratum II), ånd doctoral program (stratum III). First of the four students selected WOR simple random samples of sizes 20, 10, and 12 students from strata I, II, and III respectively, so that, the total sample is of size 42. The information about weekly time devoted in library is given in table 5.1. Table 5.1 Time (in hours) devoted to study in the university library during a week Stratum…
Teddy Bower is an outdoor clothing and accessories chain that purchases a line of parkas at $10 each from its Asian supplier, TeddySports. Unfortunately, at the time of the order placement, demand is still uncertain: Teddy Bower forecasts that its demand is normally distributed with a mean of 2100 and a standard deviation of 1200. Teddy Bower sells these parkas at $22 each. Unsold parkas have little salvage value; Teddy Bower simply gives them away to a charity (and also doesn’t collect a tax benefit for the donation). Round your answer to 2 digits after the decimal point if it is not an integer. Do NOT use comma in your numeric answers. Use excel for accuarate numbers. Dont round until the end. The probability that this parka turns out to be a “dog” is [xa]%, which is defined as a product that sells less than half of the forecast (use the standard normal table below). The underage cost is $[xb]. The overage cost is $[xc]. The critical ratio is [xd]. Teddy Bower should buy [xe] parkas…
The gasoline price often varies a great deal across different regions across country X. The followingdata show the price per gallon for regular gasoline for a random sample of gasoline service station forthree major brands of gasoline (A, B and C) located in 10 metropolitan areas across the country X.A B C3.77 3.83 3.783.72 3.83 3.873.87 3.85 3.893.76 3.77 3.793.83 3.84 3.873.85 3.84 3.873.93 4.04 3.993.79 3.78 3.793.78 3.84 3.793.81 3.84 3.86 State the null and alternative hypothesis for single factor ANOVA to test for any significant difference in the mean price of gasoline for the three brands
You are considering developing a new product. Forecastyear 1 sales are for 80,000 units, and the year 1 price is$4.00 per unit. In file Simidata.xls you are given data onseven similar products from the past. (See Figure 63.)For example,For product 1, actual sales were 92.26% of forecast sales.Year 2 price (in real dollars) was 76.7% of year 1 price.Year 2 demand was 30.7% more than year 1 demand.Product 1 only sold for 6 years.The risk-adjusted discount rate is 11% per year. We assumethat the price index will climb 5% per year.We are unsure about the fixed cost of developing theproduct. It is equally likely to be $50,000 or $150,000. Weare also unsure about the year 1 variable cost of producingit. It is equally likely to be $1, $1.50, or $2. After year 1,variable cost will climb by 5% per year. It costs $3 to buildone unit of annual capacity.a Assuming 80,000 units of annual capacity, estimatethe 10-year risk-adjusted NPV of this product.b What capacity level do you recommend?
Suppose you are working as a data scientist for an online retailer, and you are tasked with optimizing the pricing strategy for a new product. The product is currently priced at $50, but you want to determine whether a higher or lower price would result in greater profit. You estimate that the demand for the product can be modeled using a normal distribution with a mean of 100 units per day and a standard deviation of 20 units per day. The cost of producing each unit is $30, and the retailer's profit is the difference between the revenue and the cost. The retailer incurs a fixed cost of $1000 per day for operating expenses, regardless of the number of units sold. Use simulation to answer to the question.
You run a logistic regression model in R using the glm() function. The dependent variable is the factor variable Y and independent variables are X1 and X2 (in other words, the formula is Y~X1+X2). In the model output, the coefficient of the constant term is a0, the coefficient of X1 is a1, and the coefficient of X2 is a2. Assuming a cutoff = 0.5, which of the following defines the equation of a decision boundary? a0 + a1X1 + a2X2 = 0.5 exp(-(a0 + a1X1 + a2X2)) = 0 a0 + a1X1 + a2X2 = 0 O exp(-(a0 + a1X1 + a2X2)) = 0.5
The scores visualized by this histogram are the histogram average commute times in minutes for employces at a certain company to get to work. f Describe the Shape of this distribution. Ho 30 o Normal o Bimodal o Skewed 20 J0 Uniform 10 40 Minutes of Commute Time 30 50 60 +