Marc Hernandez’s construction firm currently has three projects in progress. Each requires a specific supply of gravel. There are three gravel pits available to provide for Hernandez’s needs, but shipping costs differ from location to location.
To From Job 1 Job 2 Job 3 Tonnage Allowance
Central pit $9 $ 8 $ 7 3,000
Rock pit $7 $11 $ 6 4,000
Acme pit $4 $ 3 $12 6,000
Job requirements (tons) (Job1) 2,500 (Job 2) 3,750 (Job 3) 4,850
A. Determine Hernandez’s optimal shipping quantities so as to minimize total transportation costs.
B. It is the case that Rock Pit and Central Pit can send gravel by rail to Acme for $1 per ton. Once the gravel is relocated, it can be trucked to the jobs. Reformulate this problem to determine how shipping by rail could reduce the transportation costs for the gravel.
| Problem 5-13 | ||||||||||||
| Shipments: | To | Flow balance equations | ||||||||||
| From | Job 1 | Job 2 | Job 3 | Flow out | Location | Flow in | Flow out | Net flow | Sign | RHS | ||
| Central | 0.0 | Central | 0 | 0 | 0 | >= | -3000 | |||||
| Rock | 0.0 | Rock | 0 | 0 | 0 | >= | -4000 | |||||
| Acme | 0.0 | Acme | 0 | 0 | 0 | >= | -6000 | |||||
| Flow in | 0.0 | 0.0 | 0.0 | Job 1 | 0 | 0.0 | 0 | = | 2500 | |||
| Job 2 | 0 | 0.0 | 0 | = | 3750 | |||||||
| Unit costs: | To | Job 3 | 0 | 0.0 | 0 | = | 4850 | |||||
| From | Job 1 | Job 2 | Job 3 | |||||||||
| Central | $9 | $8 | $7 | |||||||||
| Rock | $7 | $11 | $6 | |||||||||
| Acme | $4 | $3 | $12 | |||||||||
| Total cost = | $0 | <--- Minimize total transportation costs. Formula = SUMPRODUCT(B5:D7,B12:D14) | ||||||||||
| Note: | ||||||||||||
|
Once all values are entered in the appropriate shaded areas, go to
the DATA tab on the Excel sheet ribbon, click on the Data Analysis
Group, and then choose Solver. Click SOLVE to run Excel's Solver
add-in to obtain the optimized solution. Note that if Solver is not
on the DATA tab, refer to the Help file (Solver) for instructions
or pages 569–571 of Balakrishnan (2013) Managerial Decision
Modeling With Spreadsheets. For more information on entering
information in Solver, refer to pages 44–49 of Balakrishnan (2013).
To learn more about how to set up and solve linear programming (LP)
problems, refer to pages 40–51 of Balakrishnan (2013). For the changing variable cells (yellow shaded), the initial entries in the cells can be blank or any value of your choice based on the given constraints. |
||||||||||||
| Problem 5-13 (Transshipment) | ||||||||||||
| Shipments: | To | Flow balance equations | ||||||||||
| From | Job 1 | Job 2 | Job 3 | Acme | Flow out | Location | Flow in | Flow out | Net flow | Sign | RHS | |
| Central | 0.0 | Central | 0 | 0 | 0 | >= | -3000 | |||||
| Rock | 0.0 | Rock | 0 | 0 | 0 | >= | -4000 | |||||
| Acme | 0.0 | Acme | 0.0 | 0 | 0.0 | >= | -6000 | |||||
| Flow in | 0.0 | 0.0 | 0.0 | 0.0 | Job 1 | 0 | 0 | 0 | = | 2500 | ||
| Job 2 | 0 | 0 | 0 | = | 3750 | |||||||
| Unit costs: | To | Job 3 | 0 | 0 | 0 | = | 4850 | |||||
| From | Job 1 | Job 2 | Job 3 | Acme | ||||||||
| Central | $9 | $8 | $7 | $1 | ||||||||
| Rock | $7 | $11 | $6 | $1 | ||||||||
| Acme | $4 | $3 | $12 | $0 | ||||||||
| Total cost = | $0 | |||||||||||
| Note: | ||||||||||||
|
Once all values are entered in the appropriate shaded areas, go to
the DATA tab on the Excel sheet ribbon, click on the Data Analysis
Group, and then choose Solver. Click SOLVE to run Excel's Solver
add-in to obtain the optimized solution. Note that if Solver is not
on the DATA tab, refer to the Help file (Solver) for instructions
or pages 569–571 of Balakrishnan (2013) Managerial Decision
Modeling With Spreadsheets. For more information on entering
information in Solver, refer to pages 44–49 of Balakrishnan (2013).
To learn more about how to set up and solve linear programming (LP)
problems, refer to pages 40–51 of Balakrishnan (2013). For the changing variable cells (yellow shaded), the initial entries in the cells can be blank or any value of your choice based on the given constraints. |
||||||||||||
In: Operations Management
Given all the service guarantees we see or hear on a daily bases, do these really make you feel better about the services you are paying for at the bank, restaurant, cable company or retail store?
a. Give specific examples of a good guarantees
b. Give specific examples of a bad guarantees
c. Give specific examples of a evoke guarantees
In: Operations Management
What is the relationship between business intelligence and analytics?
How can managers use business analytics and business intelligence to create successful organizational outcomes?
Please provide a scenario, based on your experience, in which analytics and business intelligence was used successfully to achieve a business goal.
In: Operations Management
Should the family of Mary authorize the replacement of the double hip ? What factors should be considered? Who else , if anyone, should be considered ? What are the implications of this decision to the parties involved : Mary, their children
In: Operations Management
Campaign for Real Beauty for re-launch of the Dove brand has been successful in many countries. Discuss why this campaign has been so successful, in term of a) message, b) media mix, and c) promotion mix.
In: Operations Management
Four questions as below: Investigate and categorize the marketing arena for Dove and its competitors.
In: Operations Management
What are the major ways to enter a foreign market? What should a firm consider when choosing the optimal entry mode? What entry mode would you suggest fpr opening a business in Canada and why?
In: Operations Management
As an international management consultant, what advice would you give a foreign company looking to move operations to Brazil? Do you think Brazil holds the potential for future growth? As an investor, do you think the buy low mindset applies to Brazil? If not, what changes would you like to see before making any investments in the country?
In: Operations Management
Describe the concept of convergence and how it relates to technology and e-commerce.
In: Operations Management
View this article/video about a 2015 Supreme Court decision against a major clothing brand and retailer.
SCOTUS Rules in Favor of Muslim Woman in Suit Against Abercrombie and Fitch
As a manager, how would you maintain consistent standards, while also accommodating religious differences?
In: Operations Management
Historical demand for a product is
| DEMAND | |
| January | 15 |
| February | 12 |
| March | 16 |
| April | 15 |
| May | 17 |
| June | 16 |
|
a. Using a weighted moving average with weights of 0.60 (June), 0.20 (May), and 0.20 (April), find the July forecast. (Round your answer to 1 decimal place.) b. Using a simple three-month moving average, find the July forecast. (Round your answer to 1 decimal place.) c. Using single exponential smoothing with ? = 0.30 and a June forecast = 11, find the July forecast. (Round your answer to 1 decimal place.) d. Using simple linear regression analysis, calculate the regression equation for the preceding demand data. (Do not round intermediate calculations. Round your intercept value to 1 decimal place and slope value to 2 decimal places.) e. Using the regression equation in d, calculate the forecast for July. (Do not round intermediate calculations. Round your answer to 1 decimal place.) |
|
In: Operations Management
Imagine that you are the HR manager for a new company just opening its doors in your community. The owners have asked you to prepare a vision for compensating the staff. They do not want specific policies but rather guiding principles that will help them collect data and write specific HR policies later.
Complete the following:
Describe the type of business, the number and types of employees (such as exempt and non-exempt), and the customer base you will use as your example company for this assessment, as well as the state and city or area of the state where your company is located.
Identify a business strategy that is most appropriate for the company, and include an analysis of why you believe this is the case.
Discuss the appropriate business response, HR program alignment, and compensation system for this new business.
Create a list of essential guideposts for developing a total compensation policy. In your vision, include statements that can be made public to your customers and employees.
Consider whether your vision will be strategic in a strong economy, as well as in an economic downturn. Will you be able to adapt your vision during various economic conditions?
Describe an HR program aligned with the business strategy chosen for the new company.
Describe how other existing businesses in your community affect the compensation vision and strategy of this new company. You can reference the Overview of BLS Wage Data by Area and Occupation Web page from the Bureau of Labor Statistics Web site (cited in the Resources) to help you research information for your response.
In: Operations Management
Post your article about Social Responsibility:
1. What is the article about?
2. What did you learn?
In: Operations Management
Capacity Planning
The high-end yachts could be personalized products. The current factory of Breeze Company in France could produce 600 yachts every year as maximum capacity. However, they produce only 30 yachts every month.
Explain the possible reasons why Breeze company is using large cushion in their production.
In: Operations Management
1) How doseany author explain the shareholder theory requires no ethical reasoning? and why?
2) why does use of the shareholder theory prevent effective resolution of the 13 common business practices?
In: Operations Management