Practical Management Science, Loose-leaf Version
5th Edition
ISBN: 9781305631540
Author: WINSTON, Wayne L.; Albright, S. Christian
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 4, Problem 45P
a)
Summary Introduction
To determine: The way to minimize the bus company’s costs over the period of next five years.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
a)
Expert Solution
Explanation of Solution
Model:
Solver input:
The solver input is selected from under the “Data” tab in Excel and the input is given as shown below:
Formula:
The total cost is $3,420,000.
b)
Summary Introduction
To use: The solver table to determine the .change in the total number of hired, fired, total cost change due to the change in unit hiring, firing where each of them increases by the same percentage.
Linear programming:
It is a mathematical modeling procedure where a linear function is maximized or minimized subject to certain constraints. This method is widely useful in making a quantitative analysis which is essential for making important business decisions.
b)
Expert Solution
Explanation of Solution
One-way solver table:
The one-way solver table is selected and the input is given as shown below:
Output:
In the given range of percent increases, the total of hired and fired does not change. But, the cost increases.
Want to see more full solutions like this?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
The Clothing Shack is an online retailer of men's, women's, and children's clothing. The company has
been in business for four years and makes a modest profit from its online sales. However, in an effort
to compete successfully against online retailing heavyweights, the Clothing Shack's marketing
director, Makaya O'Neil, has determined that the Clothing Shack's marketing information systems
need improvement.
Ms. O'Neil feels that the Clothing Shack should begin sending out catalogs to its customers, keep
better track of its customer's buying habits, perform target marketing, and provide a more
personalized shopping experience for its customers. Several months ago, Ms. O'Neil submitted a
systems service request (SSR) to the Clothing Shack's steering committee. The committee
unanimously approved this project. You were assigned to the project at that time and have since
helped your project team successfully complete the project initiation and planning phase. Your team
is now ready to move…
b-1.
Activity
ES
EF
LS
LF
Slack
1
2
3
4
5
6
7
8
9
b-2. Identify the critical activities, and determine the duration of the project.
The critical activities are .
The forecast for each week of a four-week schedule is 50 units. The MPS rule is to schedule production if the projected on-hand
Inventory would be negative without it. Customer orders (committed) are follows:
Week
Customer Order
1
52
35
20
12
Use a production lot size of 75 units and no beginning Inventory. Determine the available-to-promise (ATP) quantities for each period.
Note: Leave no cells blank - be certain to enter "0" wherever required.
Period
ATP
1
2
3
Chapter 4 Solutions
Practical Management Science, Loose-leaf Version
Ch. 4.2 - Prob. 1PCh. 4.2 - Prob. 2PCh. 4.2 - Prob. 3PCh. 4.2 - Prob. 4PCh. 4.2 - Prob. 5PCh. 4.2 - Prob. 6PCh. 4.3 - Prob. 7PCh. 4.3 - Prob. 8PCh. 4.3 - Prob. 9PCh. 4.3 - Prob. 10P
Ch. 4.3 - Prob. 11PCh. 4.3 - Prob. 12PCh. 4.4 - Prob. 13PCh. 4.4 - Prob. 14PCh. 4.4 - Prob. 15PCh. 4.4 - Prob. 16PCh. 4.4 - Prob. 17PCh. 4.4 - Prob. 18PCh. 4.4 - Prob. 19PCh. 4.5 - Prob. 20PCh. 4.5 - Prob. 21PCh. 4.5 - Prob. 22PCh. 4.5 - Prob. 23PCh. 4.5 - Prob. 24PCh. 4.5 - Prob. 25PCh. 4.6 - Prob. 26PCh. 4.6 - Prob. 27PCh. 4.6 - Prob. 28PCh. 4.6 - Prob. 29PCh. 4.7 - Prob. 30PCh. 4.7 - Prob. 31PCh. 4.7 - Prob. 32PCh. 4.7 - Prob. 33PCh. 4.7 - Prob. 34PCh. 4.7 - Prob. 35PCh. 4.7 - Prob. 36PCh. 4.7 - Prob. 37PCh. 4.7 - Prob. 38PCh. 4.7 - Prob. 39PCh. 4.7 - Prob. 40PCh. 4.8 - Prob. 41PCh. 4.8 - Prob. 42PCh. 4.8 - Prob. 43PCh. 4.8 - Prob. 44PCh. 4 - Prob. 45PCh. 4 - Prob. 46PCh. 4 - Prob. 47PCh. 4 - Prob. 48PCh. 4 - Prob. 49PCh. 4 - Prob. 50PCh. 4 - Prob. 51PCh. 4 - Prob. 52PCh. 4 - Prob. 53PCh. 4 - Prob. 54PCh. 4 - Prob. 55PCh. 4 - Prob. 56PCh. 4 - Prob. 57PCh. 4 - Prob. 58PCh. 4 - Prob. 59PCh. 4 - Prob. 60PCh. 4 - Prob. 61PCh. 4 - Prob. 62PCh. 4 - Prob. 63PCh. 4 - Prob. 64PCh. 4 - Prob. 65PCh. 4 - Prob. 66PCh. 4 - Prob. 67PCh. 4 - Prob. 68PCh. 4 - Prob. 69PCh. 4 - Prob. 70PCh. 4 - Prob. 71PCh. 4 - Prob. 72PCh. 4 - Prob. 73PCh. 4 - Prob. 74PCh. 4 - Prob. 75PCh. 4 - Prob. 76PCh. 4 - Prob. 77PCh. 4 - Prob. 78PCh. 4 - Prob. 79PCh. 4 - Prob. 80PCh. 4 - Prob. 81PCh. 4 - Prob. 82PCh. 4 - Prob. 83PCh. 4 - Prob. 84PCh. 4 - Prob. 85PCh. 4 - Prob. 86PCh. 4 - Prob. 87PCh. 4 - Prob. 88PCh. 4 - Prob. 89PCh. 4 - Prob. 90PCh. 4 - Prob. 91PCh. 4 - Prob. 92PCh. 4 - Prob. 93PCh. 4 - Prob. 94PCh. 4 - Prob. 95PCh. 4 - Prob. 96PCh. 4 - Prob. 97PCh. 4 - Prob. 98PCh. 4 - Prob. 99PCh. 4 - Prob. 100PCh. 4 - Prob. 101PCh. 4 - Prob. 102PCh. 4 - Prob. 103PCh. 4 - Prob. 104PCh. 4 - Prob. 105PCh. 4 - Prob. 106PCh. 4 - Prob. 107PCh. 4 - Prob. 108PCh. 4 - Prob. 109PCh. 4 - Prob. 110PCh. 4 - Prob. 111PCh. 4 - Prob. 112PCh. 4 - Prob. 113PCh. 4 - Prob. 114PCh. 4 - Prob. 115PCh. 4 - Prob. 116PCh. 4 - Prob. 117PCh. 4 - Prob. 118PCh. 4 - Prob. 119PCh. 4 - Prob. 120PCh. 4 - Prob. 121PCh. 4 - Prob. 122PCh. 4 - Prob. 123PCh. 4 - Prob. 124PCh. 4 - Prob. 125PCh. 4 - Prob. 126PCh. 4 - Prob. 127PCh. 4 - Prob. 128PCh. 4 - Prob. 129PCh. 4 - Prob. 130PCh. 4 - Prob. 131PCh. 4 - Prob. 132PCh. 4 - Prob. 133PCh. 4 - Prob. 134PCh. 4 - Prob. 135P
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week Customer Orders 1 2 36 28 4 1 Use a production lot size of 85 units and no beginning inventory. Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required. June July 1 2 3 4 5 8 7 8 Forecast 60 60 60 60 60 60 60 60 Customer Orders 38 28 4 1 0 0 0 0 Projected On-Hand Inventory MPS ATParrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 Forecast 21.0 21 21 24 31 28 29 32 28 26.50 b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 21.0), the MAD = |||||sales (round your response to two decimal places).arrow_forwardSales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 2 3 4 5 6 7 8 9 10 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 Demand 21 21 27 38 Forecast 21.0 ☐ G ☐ ☐ 6 7 25 30 35 ∞ ☐ 8 9 10 24 25 30arrow_forward
- Each machine costs $3 Million. Building the room with all its attendant safety protection and other ancillary costs increases the spending by an additional $2.0 million dollars per MRI suite. Each machine can perform 2000 scans per year. Each reading of an MRI scan by a radiologist, along with other per-scan-related costs, is $500 per scan. The machine will last five years. Don’t worry about discount rates for this problem Graph the total costs over 5 years as a function of sales for 0-3000 patients annually. Hint: you may need to add a second MRI at some point. Suppose that you want to make a profit of $500 per scan at a target volume of 1000 patients per year, and you purchase only one machine. Superimpose the total revenue curve on top of the total cost curve in (1).arrow_forwardI need the answer to requirement C.arrow_forwardImagine you are Susan Kim and are faced with a difficult choice to either follow the orders she was given, or refusing to do so. Using each lens determine what the ethical response would be. Suppot your answer with materials from readings and lectures. For example, using Universalism what would the ethical response be? Do the same for all four lenses.arrow_forward
- Answer all these questions, selecting any company of your choice. Choose a specific type of food company. Select a specific product. Develop all the inputs that are part of the process. Develop the transformation process in a graphic (diagram, etc.). Develop all the outputs or finished products that are part of the process. Describe all the processes involved in one line of production in any manufacturing facility. Also describing how good management is the center of any part of a production company.arrow_forwardUsing exponential smoothing with α =0.2, forecast the demand for The initial forecast for January is 2000 tons. Calculate the capacity utilization for June, July and Discuss the implications of underutilized or over utilized capacity for Green Harvestarrow_forwardIn organizational development when results are improving but relationships are declining, what leadership style is appropriate? directing delegating supporting coachingarrow_forward
- What is the first thing a leader should do when moving through a cultural change? conduct an assessment comparing the practices to other high-performing organizations learn about the current organizational culture continue to monitor key metrics define expectationsarrow_forwardThe third change leadership strategy, Collaborate on Implementation, is designed to address what type of concerns? impact concerns personal concerns refinement concerns collaboration concernsarrow_forwardIf team members are concerned with specifics such as their tasks, contingency plans, resources, and timeline, what concerns do they have? implementation concerns impact concerns refinement concerns personal concernsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,