Reference no: EM131116789
Fundamentals of Analytics and Business Intelligence
Linear Programming (LP) and Sensitivity Analysis
Stop Fast Brakes makes brake disc pads for motor vehicles at three locations: Plant 1-Florida, Plant 2- California, and Plant 3-Texas. The profit contribution for each disc pad at each plant is $300, $280, and $225 respectively. Each plant has sufficient capacity to produce 750 disc pads per week. Stop Fast has 525 workers and each can work up to 40 hours per week. Currently the firm has 9,400 units of raw materials in stock. Every week, at least 1400 disc pads must be produced across all three plants. Labour and raw material requirements at each plant are shown below.
|
PLANT
|
LABOUR (hrs)
|
RAW MATERIAL (units)
|
|
1 (Florida)
|
20
|
5
|
|
2 (California)
|
16
|
8
|
|
3 (Texas)
|
10
|
7
|
Please note: You are required to submit the Microsoft Excel file and Microsoft Word file for this assignment. All workings should be shown and explained and all questions must be numbered appropriately.
1. Formulate a LP model for this problem. Specifically, do the following: Identify the decision variables (make sure that you specify the units for these variables). Specify the objective function and the relevant constraints
2. The production manager uses a DSS to make decisions about what to do. The maximum attainable profit is required. Develop a simple DSS prototype to solve this problem.
a. How many disc pads should be produced at each plant?
b. What is the total profit realized?
c. What is the profit contribution for each plant?
For the question 3, make sure to undo each change (put back to original value) after each question is completed.
3. Perform sensitivity analysis to determine:
a. What would happen if 5 more workers are hired? Please explain the total impact of this decision on the production process, and at most how much each of these workers should be paid each week.
a. Due to economic factors, the profit for producing disc pads in California has gone up by $25. Evaluate and discuss the impact of this.
b. The profit for producing disc pads in Texas has gone DOWN to $200 each and the plant capacity increased by 200. Evaluate and discuss the impact of this, and if you would recommend this change
4. Write a short memo to the management of Stop Fast Brakes, explaining:
a. Over what range of raw material units is the dual price applicable, and what does the raw material constraint shadow price value mean?
b. Which plant capacity should the company work to increase and which one/s should not be increased? Explain the reason for your decision
|
Transferred from the packaging department
: Hobart Beverage Company uses the weighted-average method in its process costing system.Materials are included at the start of the production process but conversion costs are uniformlyapplied throughout the production process. The following data ab..
|
|
Demonstrate the trade-offs between these three factors
: In many project management texts you will see a triangle, with the sides representing time, cost and scope. These are factors that are interlinked, so why for example if I change the scope, making the project larger, what impact might that have on ti..
|
|
Is your choice long-term or short-term strategy
: Why can Prada sell a handbag for $2,000 that costs the firm a little more to manufacture than the $200 bag sold at a department store? At the other end of the pricing spectrum, why would a consumer goods company provide a coupon that makes their new ..
|
|
Give three examples of organizations that have acquired
: Give three examples of organizations that have acquired or developed new technologies to support the following objectives:
|
|
How many disc pads should be produced at each plant
: How many disc pads should be produced at each plant and What is the profit contribution for each plant - Write a short memo to the management of Stop Fast Brakes.
|
|
Context of a public good
: Using the Internet, research the influenza vaccine, or "flu shot." Use the following to guide your research: a. Think about the flu shot in the context of a public good. b. What are the economic benefits of the flu shot?
|
|
Reverse discrimination and reverse glass ceiling cases
: Reverse discrimination and reverse glass ceiling cases have grown in recent years. A reverse glass ceiling occurs when higher seniority persons are dead-ended in the area of promotions. Because younger employees tend to have greater science and techn..
|
|
Weighted-average method in its process costing system
: Hobart Beverage Company uses the weighted-average method in its process costing system. Materials are included at the start of the production process but conversion costs are uniformly applied throughout the production process.
|
|
Systems of suppliers-vendors and customers
: Describe the information systems that a typical restaurant might use and the tasks these systems perform. How might such systems differ between a low-cost restaurant such as a McDonald’s and a high-quality, five-star restaurant such as Le Cinq in Par..
|