Reference no: EM132267965
Decision Support Systems Assignment -
Instructions: Solve 2 problems on 1 excel document. Please use a separate tab for each problem!
Problem 1 - Western Lithium produces a special type of material that is currently in short supply. Four of Western Lithium's customers have already placed orders that together exceed the combined capacity of Western Lithium's two plants. Western Lithium's management faces the problem of deciding how many units it should supply to each customer. Since the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants and customers make a "sell to the highest bidder" strategy unacceptable. After considering price, production costs, and transportation costs, Western Lithium has established the following profit per unit for each plant-customer alternative.
|
Plant
|
Customer
|
|
Panasonic
|
Samsung
|
Tesla
|
Sony
|
|
Reno
|
$32
|
$34
|
$32
|
$40
|
|
Vancouver
|
$34
|
$30
|
$28
|
$38
|
The plant capacities and customer orders are as follows:
|
Plant Capacity (units)
|
|
Reno
|
5000
|
|
Vancouver
|
3000
|
|
Distribution Orders (units)
|
|
Panasonic
|
2000
|
|
Samsung
|
5000
|
|
Tesla
|
3000
|
|
Sony
|
2000
|
A. Develop an Excel layout and solver model to find a solution for this problem.
B. How many units should each plant produce for each customer to maximize profits?
Problem 2 - Anderson and Associates, Inc. is a software development firm that has three new clients. Project teams will be assigned to the three clients. Based on the different backgrounds and experiences of the teams, the various team-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in weeks are:
|
Project Team
|
Client
|
|
C1
|
C2
|
C3
|
|
Agile team
|
10
|
16
|
32
|
|
Spiral team
|
14
|
22
|
40
|
|
Waterfall team
|
22
|
24
|
34
|
A. Develop an Excel layout and solver model to find a solution to this problem.
B. What team assignments will result in the minimum overall completion time?
|
Implementing and maintaining the change
: Give an example of the 5-phase model of change: Identify the need for change, build the lead team, design the change process, announcing the change
|
|
Potential causes in jack disturbance of selfconcept
: Jack is a 36yearold leader within a major hospital. Identify the potential causes in Jack disturbance of selfconcept.
|
|
Why is it important for researchers to understand the errors
: Describe the research question you are pursuing for your final project. When drawing a statistical conclusion, what would a potential Type I error be?
|
|
Correct definition of repeatability
: Which of the following is the correct definition of repeatability? Which of the following is defined as continuous, incremental improvement?
|
|
Develop an excel layout and solver model to find a solution
: CIS 3315 Decision Support Systems Assignment, Florida Institute of Technology, USA. Develop an Excel layout and solver model to find a solution
|
|
What factors may be affecting your hearing
: Other than age, what factors may be both positively and negatively affecting your hearing? For example, using headphones regularly or a history of ear.
|
|
Managerial accounting staff
: When compiling data for its sustainability reports, The company does not request direct input from its managerial accounting staff.
|
|
Six sigma project methodologies normally begins
: Six Sigma project methodologies normally begins with what initial step? Which of the following is not the right reason to do sampling?
|
|
Record keeping and reporting processes
: Explain the data collection, record keeping and reporting processes that would apply to the project.
|