Reference no: EM1323485
Excel Quantitative Methods for Bay City Movers: construct Linear programming model
Instructions: (1) The Microsoft Excel spreadsheet using Solver to calculate the optimal solution. Include the algebraic equations for the problem if asked in the spreadsheet.
Bay City Movers is a local company that specializes in intercity moves. In the business plan submitted to its investors, Bay City has committed itself to a total trucking capacity of at least 42 tons.
The company is in the process of replacing its entire fleet of trucks with 1-ton pickup trucks and 2.5 ton moving van-type trucks. The 1-ton pickup trucks will be manned by one worker, whereas the large vans will utilize a total of four workers for larger moves.
Bay City Movers currently employs 63 workers and has facilities for at most 50 trucks. Pickup trucks cost the company $24,000 each; the moving vans cost $60,000 each. The company wishes to make the minimum investment of capital that will provide a trucking capacity of at least 42 tons while not requiring any additional workers or trucking facilities.
a) Construct, in equation form, the linear programming model that will determine the optimal number of pickup trucks and moving vans Bay City Movers should purchase.
b) Solve this problem using Solver.
|
Show integrated global system model
: Integrated Global System Model - This solution discusses the Integrated Global System Model from the Massachusetts Institute of Technology. The ways that this specific model could be adapted for a global information system in a business environmen..
|
|
Solution to linear programming model
: Frank Hurley is the farmer with 250 acres on which he wishes to plant wheat and corn to maximize his expected return for season. Based upon the output, what key points would you recommend to Frank?
|
|
Political aspects of a decision to outsource
: Global Information System Organizations and financial and political aspects of a decision to outsource?
|
|
Effectiveness of different software products
: The Efficiency and Effectiveness of Different Software Products and I need to include the specific problem that Apple is having and include questions in the problem statement.
|
|
Excel quantitative methods for bay city movers
: Develop, in equation form, linear programming model that will determine the optimal number of pickup trucks and moving vans Bay City Movers should purchase.
|
|
Show the use of tablets vs. desktops
: Show the Use of Tablets Vs. Desktops and Justify your thoughts on whether tablets will replace desktop computers and offer an opinion why Apple desktop sales have grown.
|
|
Important issues facing it project managers
: Outsourcing IT Functions - What are the three most important issues facing IT project managers in USA companies that rely heavily on outsourcing IT functions?
|
|
Purpose of research design and issues
: What is the purpose of the research design? What are basic research design issues? What are the main sorts of research design?
|
|
Show performance-based work statement
: Performance-based Work Statement - prepare performance-based work statement and what can be done to overcome that challenge?
|