New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
practical management science
Practical Management Science 5th Edition Wayne L. Winston, Christian Albright - Solutions
Suppose the current exchange rate is 100 yen per dollar. We currently sell 100 units of a product for 700 yen. The cost of producing and shipping the product to Japan is $5, and the current elasticity of demand is –3. Find the optimal price to charge for the product (in yen) for each of the
Another way to derive a demand function is to break the market into segments and identify a low price, a medium price, and a high price. For each of these prices and market segments, we ask company experts to estimate product demand. Then we use Excel’s trend curve fitting capabilities to fit a
A company produces widgets at plants 1 and 2. It costs 125x1/2 dollars to produce x units at plant 1 and 235x1/3 dollars to produce x units at plant 2. Each plant can produce up to 500 units. Each unit produced can be sold for $10. At most 800 widgets can be sold. Determine how the company can
If a monopolist produces qunits, she can charge 400 – 4q dollars per unit. The variable cost is $60 per unit.a. How can the monopolist maximize her profit?b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the
It costs a company $12 to purchase an hour of labor and $15 to purchase an hour of capital. If L hours of labor and K units of capital are available, then 0.05L2/3 K1/3 machines can be produced. Suppose the company has $100,000 to purchase labor and capital.a. What is the maximum
In the previous problem, what is the minimum-cost method of producing 100 machines? (Ignore the $10,000 budget constraint.)Data from Previous Problem:It costs a company $12 to purchase an hour of labor and $15 to purchase an hour of capital. If L hours of labor and K units of capital are
The cost per day of running a hospital is 200,000 + 0.5x2 dollars, where x is the number of patients served per day. What number of patients served per day minimizes the cost per patient per day of running the hospital if the hospital’s daily capacity is 300 patients? How does the solution change
Two companies are producing widgets. It costs the first company q12 dollars to produce q1 widgets and the second company 0.5q22 dollars to produce q2 widgets. If a total of q widgets are produced, consumers will pay 200 – q dollars for each widget. If the two companies want to collude in an
A company manufactures two products. If it charges price pi for product i, it can sell qi units of product i, where q1 = 60 – 3p1 + p2 and q2 = 80 – 2p2 + p1. It costs $5 to produce a unit of product 1 and $12 to produce a unit of product 2. How many units of each product should the
A brewing company has $100,000 to spend on advertising in four markets. The sales revenue (in thousands of dollars) that can be created in each market by spending xi thousand dollars in market i is given in the file P07_55.xlsx.a. To maximize its sales revenue, how much money should the
Q&H Company advertises during soap operas and football games. Each soap opera ad costs $50,000, and each football game ad costs $100,000. If S soap opera ads are purchased, they will be seen by 5S1/2 million men and 20S1/2 million women. If F football ads are purchased, they will be
A beer company has divided Bloomington into two territories. If the company spends x1 dollars on promotion in territory 1, it can sell 60x11/2 cases of beer there; and if it spends x2 dollars on promotion in territory 2, it can sell 40x21/2 cases of beer there. Each case of
A company uses raw material to produce two products. For $150, a unit of raw material can be purchased and processed into four units of product 1 and two units of product 2. If x1 units of product 1 are produced, they can be sold at 250 – x1 dollars per unit. If x2 units of product 2 are
J&J has given you $12 million to spend on advertising Huggys diapers during the next 12 months. At the beginning of January, Huggys has a 30% market share. During any month, 10% of the people who purchase Huggys defect to brand X, and a fraction 0.2a1/2 of customers who usually
Based on Kolesar and Blum (1973). Suppose that a company must service customers lying in an area of A square miles with n warehouses. Kolesar and Blum showed that when the warehouse(s) are located properly, the average distance between a warehouse and a customer is (A/n)1/2. Assume that it
A company has five factories. The x- and y-coordinates of the location of each factory are given in the file P07_61.xlsx. The company wants to locate a warehouse at a point that minimizes the sum of the squared distances of the plants from the warehouse. Where should the warehouse be located?
Monroe County is trying to determine where to place the county fire station. The locations of the county’s four major towns are as follows: (10, 20), (60, 20), (40, 30), and (80, 60) (Figure 7.50). Town 1 averages 20 fires per year; town 2, 30 fires; town 3, 40 fires; and town 4, 25 fires. The
Consider three investments. You are given the following means, standard deviations, and correlations for the annual return on these three investments. The means are 0.12, 0.15, and 0.20. The standard deviations are 0.20, 0.30, and 0.40. The correlation between stocks 1 and 2 is 0.65, between stocks
You have $1000 to invest in three stocks. Let R1 be the random variable representing the annual return on $1 invested in stock i. For example, if Ri = 0.12, then $1 invested in stock i at the beginning of a year is worth $1.12 at the end of the year. The means are E(R1) = 0.14, E(R2) = 0.11, and
An oil company must determine how many barrels of oil to extract during each of the next two years. If the company extracts x1 million barrels during year 1, each barrel can be sold for 80 – x1 dollars. If the company extracts x2 million barrels during year 2, each barrel can be sold for 85 –
Suppose that you are hiring a weather forecaster to predict the probability that next summer will be rainy or sunny. The following suggests a method that can be used to ensure that the forecaster is accurate. Suppose that the actual probability of next summer being rainy is 0.6. If the forecaster
The cost of producing x units of a product during a month is x1/2 dollars. Show that the minimum-cost method of producing 40 units during the next two months is to produce all 40 units during a single month.
Four items are for sale in the Dollar Value store. The product and sum of their prices is $7.11. What is the price of each item?
Most economies have a goal of maximizing the average consumption per period. Assume that during each year, an economy saves the same (to be determined) percentage S of its production. During a year in which the beginning capital level is K, a quantity K1/2 of capital is
Each morning during rush hour, 10,000 people want to travel from New Jersey to New York City. If a person takes the commuter train, the trip lasts 40 minutes. If x thousand people per morning drive to New York, it takes 20 + 5x minutes to make the trip. This problem illustrates a
Kellpost Cereal Company sells four products: (1) Special L (a low-calorie, high-nutrition cereal); (2) Corn Bran (another low-calorie, high-nutrition cereal); (3) Admiral Smacks (a sugary cereal pitched at the children’s market); and (4) Honey Pops (another sweet cereal pitched at the
Find the minimum perimeter rectangle having area 64 square feet. Can you generalize this result?
A cylindrical soda can has a volume of 20 cubic inches. What height and diameter minimize the surface area of the can? Can you generalize this result?
City B is 10 miles downstream from city A. City A is 5 miles south of the river, and city B is 20 miles north of the river. The river is two miles wide. Where should a bridge be built across the river to make the travel distance between cities A and B as small as possible? Can you generalize this
You can swim two miles per hour and run six miles per hour. You are walking north along South Beach and see someone drowning half a mile out in the ocean and one mile north of you. What combination of running and swimming is the quickest way to reach the swimmer?
A triangle has a 5-inch side and a 12-inch side. To maximize the area of the triangle what should the third side be? Can you generalize this result?
Your company is about to market a new golf club. You have convened a focus group of 100 golfers and asked them to compare your club to the clubs produced by your competitors. You have found, for example, that 30 customers in the focus group would purchase your club if you charged $120, 28 customers
For the product mix examples, discuss where you think the assumptions of a linear model are most likely to break down. How might an NLP model look in this situation?
For the oil blending example, discuss where you think the assumptions of a linear model are most likely to break down. How might an NLP model look in this situation?
For the aggregate planning example, is it likely that the cost per worker of changing the size of the workforce during a month would be constant? How could an NLP model account for a situation in which the cost per worker of changing the size of the workforce is not constant?
Consider the sports ratings model in section 7.6. If you were going to use the approach used there to forecast future sports contests, what problems might you encounter early in the season? How might you resolve these problems?
UE is going to invest $400 million to acquire companies in the auto and/or electronics industry. How would you apply portfolio optimization to determine which companies should be purchased?
Your family owns a large farm that can grow wheat, corn, cotton, alfalfa, barley, pears, and apples. Each product requires a certain amount of labor each month and a certain number of hours of machine time. You have just studied portfolio optimization and want to help your family run its farm. What
Modify the function in Example 8.1 so that it becomes f(x) = (x – 1)(x – 2)(x – 3)(x – 4)(x – 5)(x – 6)(x – 7) for 1 ≤ x ≤ 7. Plot a lot of points from 1 to 7 to see what the graph of this function looks like. Then use GRG Nonlinear Solver to find its maximum. Try the
Visit http://biz.yahoo.com/r/. Under Research Tools, click on Historical Quotes, and then download the monthly returns on at least four stocks for the preceding 60 months. Use this data to determine the portfolio that maximizes the chance of beating the S&P 500 for these years.
The file P08_18.xlsx contains information on the following items about 24 companies: EBITASS (earnings before income and taxes, divided by total assets), ROTC (return on total capital), and Group (1 for most admired companies and 2 for least admired companies). Use these data to develop a rule that
An important problem in operations management is the job sequencing problem. Actually, there are many versions of this problem, but they all basically attempt to find the proper sequencing of jobs on a machine. Here is one version of the problem. There are 10 jobs to perform on a single machine.
Repeat Problem 20, but now assume there is a setup time for changing from any job to another job, and this setup time can depend on the jobs. For example, the setup time when changing from job 2 to job 4 can be different from the setup time when changing from job 3 to job 4. The data from Problem
You are operating a Web site to match up sellers and buyers of a product. 35 sellers and 35 buyers have input their reservation prices, as listed in the file P08_23.xlsx. For example, buyer 1 is willing to pay up to $8 for an item, and seller 1 is willing to accept $9 or more for an item. This
Fourteen jobs must be assigned to one of three identical machines. The goal is to minimize the total time needed to complete all 14 jobs. The machine capacities and times needed for the jobs are given in file P08_25.xlsx. For example, job 8 requires three units of capacity on a machine for two
Nine jobs need to be completed within eight weeks. The number of weeks required to complete each job is given in the file P08_26.xlsx. For example, job 2 requires three weeks. Each job requires 40 hours of labor per week. Each week, 160 hours of regular time labor are available. Up to 40
Eight students need to be assigned to four dorm rooms (two students to a room) at State University. Based on incompatibility measures, the “cost” incurred if two students room together is shown in the file P08_27.xlsx. How should these students be assigned to rooms to minimize the total
The costs of producing product A, product B, or products A and B bundled together are $50, $90, and $140, respectively. The file P08_28.xlsx lists the sizes of the three market segments for these products and how much each of the segments is willing to pay for A alone, B alone, or the bundle. Under
Bus 99 serves towns 1 through 10. We assume that town k is |k– j| miles from town j. The numbers of people in the towns who want to take the bus each hour are listed in the file P08_34.xlsx. Bus 99 will make two stops and anyone who wants to take the bus will walk to the closest bus stop.a. If
Xerox is trying to determine how many maintenance centers are needed in the mid-Atlantic states. Xerox earns $500 profit (excluding the cost of running maintenance centers) on each copier sale. The sales of copiers in each major market (Boston, New York, Philadelphia, Washington, Providence, and
A common approach to clustering is called multidimensional scaling (MDS). To apply MDS, we rank each pair of objects we want to cluster from least similar (higher number) to most similar (lower number). For example, in the file P08_42.xlsx, we compared the similarity of 10 banks and found banks 5
Starting with the finished version of the file for Example 9.3, change the fixed cost in cell B5 to $4000. Change the probabilities in cells B9 (make it smaller), B14 (make it larger), and B15 (make it smaller) in some systematic way (you can choose the details) and, for each combination, calculate
When you use @RISK’s correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following. Use the RISKCORRMAT function to generate two normally distributed random numbers, each with mean 100 and standard deviation 10, and with correlation 0.7.
Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.a. Calculate the mean and standard deviation of these random numbers. Are they approximately what you would expect?b. What
Ford is going to produce a new vehicle, the Pioneer, and wants to determine the amount of annual capacity it should build. Ford’s goal is to maximize the profit from this vehicle over the next five years. Each vehicle will sell for $19,000 and incur a variable production cost of $16,000. Building
Repeat the previous problem, but make the correlation between the two inputs equal to –0.7. Explain how the results change.Data from Previous Problem:When you use @RISK’s correlation feature to generate correlated random numbers, how can you verify that they are correlated? Try the following.
1. Assume that Pacific National Bank remains with human tellers only.a. For each time period in Table 13.4, deter-mine the minimum number of tellers needed on station to service the customer stream.b. Assume that the number of tellers found in part a is used. For each time period, deter-mine the
You can easily generate random numbers in a spread-sheet that have an exponential distribution with a given mean. For example, to generate 200 such numbers from an exponential distribution with λ = 1/3, enter the formula = –3*LN(RAND()) in cell A4 and copy it to the range A5:A203. Then select
A fast-food restaurant has one drive-through window. On average, 40 customers arrive per hour at the window. It takes an average of one minute to serve a customer. Assume that inter-arrival and service times are exponentially distributed.a. On average, how many customers are waiting in line?b. On
The MM1 Template.xlsx file is now set up so that you can enter any integer in cell E11 and the corresponding probability of that many in the system appears in cell F11. Change this setup so that columns E and F specify the distribution of the number in the queue rather than the system. That is, set
For an M/M/1 queueing system, L = λ/(µ – λ). Suppose that land µare both doubled. How does L change? How does W change? How does WQ change? How does LQ change? (Remember the basic queueing relationships, including Little’s formula.)
Each airline passenger and his luggage must be checked to determine whether he is carrying weapons onto the airplane. Suppose that at Gotham City Airport, 2.6 passengers per minute arrive, on average. Also, assume that inter-arrival times are exponentially distributed. To check passengers for
A service facility consists of one server who can serve an average of two customers per hour (service times are exponential). An average of three customers per hour arrive at the facility (inter-arrival times are assumed to be exponential). The system capacity is three customers: two waiting and
On average, 40 cars per hour are tempted to use the drive-through window at the Hot Dog King Restaurant. (We assume that inter-arrival times are exponentially distributed.) If a total of more than four cars are in line (including the car at the window), a car will not enter the line. It takes an
A laundromat has five washing machines. A typical machine breaks down once every five days. A repairman can repair a machine in an average of 2.5 days. Currently, three repairmen are on duty. The owner of the laundromat has the option of replacing them with a superworker, who can repair a machine
Referring to Problem 18, suppose the airline wants to determine how many checkpoints to operate to minimize operating costs and delay costs over a 10-year period. Assume that the cost of delaying a passenger for one hour is $10 and that the airport is open every day for 16 hours per day. It costs
Consider the following two queueing systems.■ System 1: An M/M/1 system with arrival rate λ and service rate 3µ.■ System 2: An M/M/3 system with arrival rate λ and each server working at rate µ.Which system will have the smaller Wand L?
The Smalltown Credit Union experiences its greatest congestion on paydays from 11:30 A.M. until 1:00 P.M. During these rush periods, customers arrive according to a Poisson process at rate 2.1 per minute. The credit union employs 10 tellers for these rush periods, and each takes 4.7 minutes to
Given the model in the Multi-server Simulation.xlsm file, what unit cost parameters should be used if we are interested in “optimizing” the system? Choose representative inputs and unit costs, and then illustrate how to use the simulation outputs to estimate total system costs.
A telephone-order sales company must determine how many telephone operators are needed to staff the phones during the 9-to-5 shift. It is estimated that an average of 480 calls are received during this time period and that the average call lasts for six minutes. There is no queueing. If a customer
A company’s warehouse can store up to four units of a good. Each month, an average of 10 orders for the good are received. The times between the receipts of successive orders are exponentially distributed. When an item is used to fill an order, a replacement item is immediately ordered, and it
A printing shop receives an average of one order per day. The average length of time required to complete an order is half a day. At any given time, the print shop can work on at most one job. Inter-arrival times and service times are exponentially distributed.a. On average, how many jobs are
The file P14_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future.a. Explain briefly
1. Determine whether you can develop a more accurate estimate of overhead costs.2. Wagner is now preparing a bid for an important order that may involve a considerable amount of repeat business. The estimated requirements for this project are 15 labor hours, 8 machine hours, $150 direct labor cost,
The file P14_03.xlsx contains monthly data on production levels and production costs during a four-year period for a company that produces a single product. Use simple regression on all of the data to see how Total Cost is related to Units Produced. Use the resulting equation to predict total cost
Management of a home appliance store wants to understand the growth pattern of the monthly sales of a new technology device over the past two years. The managers have recorded the relevant data in the file P14_05.xlsx. Have the sales of this device been growing linearly over the past 24 months? By
Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable.
The file P14_07.xlsx contains monthly values of the U.S. national debt (in dollars) from 1993 to early 2010. Fit an exponential growth curve to these data. Write a short report to summarize your findings. If the U.S. national debt continues to rise at the exponential rate you find, approximately
The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P14_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest
We have discussed linear and exponential trend lines. Another popular choice is a power trend line, also called a constant elasticity trend line. This trend line has the form y = axb, and it has the property that when x increases by 1%, y changes by a constant percentage. In fact, this constant
Sometimes curvature in a scatter plot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2
Suppose you are an analyst for a company that produces four products, and you are trying to decide how much of each product to produce next month. To model this decision problem, you need the unit variable production cost for each product. After some digging, you find the historical data on
A trucking company wants to predict the yearly maintenance expense (Y) for a truck using the number of miles driven during the year (X1) and the age of the truck (X2, in years) at the beginning of the year. The company has gathered the data given in the file P14_13.xlsx. Note that each observation
An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P14_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data.
Stock market analysts are continually looking for reliable predictors of stock prices. Consider the problem of modeling the price per share of electric utility stocks (Y). Two variables thought to influence this stock price are return on average equity (X1) and annual dividend rate (X2). The stock
Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semi-fragile, and durable. Costs for 15 randomly chosen packages of approximately the same
The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P14_17.xlsx.a. Estimate a simple regression equation involving annual sales (the dependent variable) and the
The file P14_19.xlsxcontains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period.a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known
You have been assigned to forecast the number of aircraft engines ordered each month by Commins Engine Company. At the end of February, the forecast is that 100 engines will be ordered during April. During March, 120 engines are ordered. Using a 50.3 and the basic equation for simple exponential
Simple exponential smoothing with α = 0.3 is being used to forecast sales of digital cameras at Lowland Appliance. Forecasts are made on a monthly basis. After August camera sales are observed, the forecast for September is 100 cameras. Suppose 120 cameras are sold in September. Use the basic
A version of simple exponential smoothing can be used to predict the outcome of sporting events. To illustrate, consider pro football. We first assume that all games are played on a neutral field. Before each day of play, we assume that each team has a rating. For example, if the rating for the
Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P14_33.xlsx.a. Create a scatterplot for these data. Comment on the observed behavior of monthly
A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P14_34.xlsx.a. Determine an equation that can be used to predict monthly production costs from
The file P14_35.xlsx contains the amount of money spent advertising a product (in thousands of dollars) and the number of units sold (in millions) for eight months.a. Assume that the only factor influencing monthly sales is advertising. Fit the following two curves to these data: linear (Y = a +
When potential workers apply for a job that requires extensive manual assembly of small intricate parts, they are initially given three different tests to measure their manual dexterity. The ones who are hired are then periodically given a performance rating on a 0 to 100 scale that combines their
Callaway Golf is trying to determine how the price of a set of clubs affects the demand for clubs. The file P14_37.xlsx contains the price of a set of clubs (in dollars) and the monthly sales (number of sets sold).a. Assume the only factor influencing monthly sales is price. Fit the
The file P14_38.xlsx lists the average salary for each Major League Baseball team from 2004 to 2009, along with the number of team wins in each of these years.a. Rearrange the data so that there are four long columns: Team, Year, Salary, and Wins. There should be 6*30 values for each.b. Create a
GMC wants to decide whether to retool the Lyra and Libra plants. In addition, GMC wants to determine its production plan at each plant in the coming year. Based on the previous data, formulate a MILP model for solving GMC's production planning–capacity expansion problem for the coming
During 2001, many European markets for mobile phones reached saturation. Because of this, mobile phone operators started to shift their focus from growth and market share to cut-ting costs. One way to do this is to reduce spending on international calls. These calls are routed through network
1. Using the spreadsheet model from Case 2.1 as a starting point, use Solver to find the optimal set of projects to approve. The solution should maximize the total NPV from the approved projects, and it should satisfy the constraints imposed by CEO J. R. Bayer and the functional areas: (1) capital
Showing 2000 - 2100
of 2541
First
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Step by Step Answers
Get 50% OFF
Claim Now
