Reference no: EM13919634
3.Arizona Semiconductor is trying to determine the best place to build a manufacturing plant. Arizona wants it to be centrally located between six of its assembly facilities. These assembly facilities are mapped on a two-dimensional grid using x,y coordinates as follows:
|
Facility
|
x
|
y
|
|
1
|
12
|
101
|
|
2
|
33
|
42
|
|
3
|
22
|
75
|
|
4
|
38
|
82
|
|
5
|
24
|
69
|
|
6
|
35
|
48
|
Where should the new manufacturing plant be built in order to minimize the distance between all the assembly facilities? The answer should be an x,y coordinate. Use the formula to determine the distance between the new plant and an assembly facility, where x,y represents the location of the new plant and represents the location of any particular assembly facility.
4. Arizona Semiconductor is trying to determine which R&D projects to fund for the upcoming fiscal year. The company has a limit of $200,000 and 10 researchers available for R&D to be spread between several projects. The table below shows the resources required for each project for the upcoming year and the expected annual profit from each project.
|
|
Project
|
|
1
|
2
|
3
|
4
|
5
|
6
|
|
Expense ($)
|
75
|
100
|
25
|
43
|
55
|
12
|
|
Number of Researchers
|
7
|
4
|
4
|
6
|
2
|
1
|
|
Profit ($)
|
92
|
85
|
4
|
72
|
50
|
15
|
- Which projects should the company choose to maximize expected annual profit? How much is that profit? Set this up as a spreadsheet using Solver.
- Suppose the company determines that that it must select either project 5 or 6 but not both. Does this change the list of projects the companies should undertake? How?
- If the company wants to increase the amount of R&D it does in the upcoming year, should it allocate more funding or hire more researchers?
5. The AppleBerry Company makes a mix of three types of electronic devices: MP3 players, eReaders, and tablet computers. The company is trying to determine which products to make to optimize its profits. Each product requires a specific number of hours in fabrication, assembly, and machining. In addition, to save on expenses, all the devices have been engineered to use the same basic raw materials. The table below details the hours and costs involved, as well as the profit per device. AppleBerry has a total of 2000 hours of fabrication, 3200 hours of assembly, and 1600 hours of machining currently available per month. It also has budgeted to purchase $9200 of raw materials each month.
|
Device
|
Fabrication Hours Required
|
Assembly Hours Required
|
Machining Hours Required
|
$ of raw Materials Needed
|
Profit per Device
|
|
MP3 Player
|
6
|
6
|
9
|
$30
|
$16
|
|
eReader
|
6
|
8
|
6
|
$40
|
$20
|
|
Tablet
|
2
|
12
|
8
|
$25
|
$14
|
Answer the following questions:
- Given the current situation, what product mix should AppleBerry use to maximize its monthly profits? What is the optimized monthly profit? Set this up as a spreadsheet using Solver.
- If AppleBerry chooses to commit more resources to increase profits, should it purchase more fabrication time, assembly time, machining time, or raw materials?
6. Snoo Coffee Company creates three blends of coffee: budget, classic, and premium. The coffee blends are composed of four ingredients: A, B, C, and D. The table below shows the percentage of each component that are in each blend and the cost per pound for that ingredient. The blends have a wholesale price of $2.50, $3.00, and $4.50 for budget, classic, and premium, respectively. A limited amount of each ingredient is available on a weekly basis.
|
Ingredient
|
Budget
|
Classic
|
Premium
|
Cost/lb.
|
Max Weekly Availability
|
|
A
|
25%
|
35%
|
0%
|
$0.60
|
40,000
|
|
B
|
55%
|
25%
|
0%
|
$0.80
|
20,000
|
|
C
|
5%
|
10%
|
50%
|
$0.95
|
35,000
|
|
D
|
15%
|
30%
|
50%
|
$0.70
|
45,000
|
Snoo can make 100,000 pounds of coffee per week, and it wants to make a minimum of 25,000 pounds of each blend. (20 points)
- In order to maximize weekly profits, how many pounds of each ingredient should be purchased?
- What is the shadow price of ingredient C?
- How much should Snoo be willing to pay for an additional pound of ingredient C to raise total profit?
|
Probability and hypothesis testing
: Your final project entails systematic extraction of decision-aiding insights from a dataset (SampleDataSet.xlsx) provided to you in the Doc Sharing area. The goal of this project is to provide you with hands-on experience in conducting and interpr..
|
|
Record the events under an accounting equation
: Ignoring all other future events, what is the amount of service revenue that would be recognized in 2014?
|
|
What is the total cost at the eoq
: Explain the concepts of forecasting, system design, capacity planning, quality management and control, supply chain management, inventory management and scheduling, and project management and how they each relate to form an integrated view of prod..
|
|
Dog mosaic from the pompeii volcanic eruption
: were dogs sacred to romans? are there any specific important characteristics about it?
|
|
Which projects should the company choose to maximize?
: Arizona Semiconductor is trying to determine which R&D projects to fund for the upcoming fiscal year. The company has a limit of $200,000 and 10 researchers available for R&D to be spread between several projects. The table below shows the resourc..
|
|
How can louis use cvp to make his business more successful
: With labor being one of the major expenses in operations, do you think with the aid of the weekly manager's report that the labor percentage is in line? Assume 23.5% of net sales is the standard set by corporate guidelines.
|
|
Solve the rmc problem using the simplex method
: Solve the RMC problem using the simplex method. At each iteration, locate the basic feasible solution found by the simplex method on the graph of the feasible region.
|
|
Ed arnold started a personal financial planning business
: Ed Arnold started a personal financial planning business when he accepted $120,000 cash as advance payment for managing the financial assets of a large estate. Arnold agreed to manage the estate for a one year period beginning May 1, 2013.
|
|
Cognitive effects of stimulant medication in children
: Use the following information to answer the next three exercises: A Lake Tahoe Community College instructor is interested in the mean number of days Lake Tahoe Community College math students are absent from class during a quarter.
|