Spectra Electronics manufactures five different models of telecommunications interface cards for desktop and laptop PCs. As...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Spectra Electronics manufactures five different models of telecommunications interface cards for desktop and laptop PCs. As summarized in Table 1, each of these devices requires differing amounts of printed circuit (PC) board, resistors, memory chips and assembly. Table 1. Per Unit Requirements HyperLink FastLink Speed Lin MicroLink EtherLink k PC Board (sq. in.) 20 15 10 8 Resistors 22 24 18 12 Memory Chips 6 8 4 4 Assembly Labor (hours) 0.75 0.6 0.5 0.65 The unit wholesale price and manufacturing costs for each model are as follows. Note: the profit per unit is the wholesale price minus the manufacturing cost. Per Unit Revenues and Costs HyperLink EtherLink $189.00 FastLink SpeedLink MicroLink $149.00 $149.00 $169.00 $101.00 $96.00 $137.00 Wholesale price Manufacturing cost $139.00 $136.00 $101.00 In their next production period, Spectra has 80,000 square inches of PC board, 100,000 resistors, 30,000 memory chips and 5000 hours of assembly time available. The marketing environment requires that they produce at least 500 units of each model and that the number of HyperLinks produced be at least twice the number of Speed Links produced. Note that the profit margin per unit manufactured and sold, is equal to the wholesale price minus the manufacturing cost. Create a Solver-based spreadsheet model to determine the number of each of the five interface cards products to produce in the next production period in order to maximize profit and solve the model. 5661 Comments and Hints: 1. Be sure to use sumproduct, formulas that can be copied and range constraints. 2. Don't let the terms wholesale price and manufacturing cost mislead you into thinking this is a make or buy problem. It is a profit maximization problem where the only option is to make. 3. The restriction "the number of HyperLinks produced be at least twice the number of SpeedLinks produced must be handed with a "linearized " ratio constraint. It cannot be correctly handed by simply doubling the minimum number of HyperLink cards from 500 to 1000. Spectra Electronics manufactures five different models of telecommunications interface cards for desktop and laptop PCs. As summarized in Table 1, each of these devices requires differing amounts of printed circuit (PC) board, resistors, memory chips and assembly. Table 1. Per Unit Requirements HyperLink FastLink Speed Lin MicroLink EtherLink k PC Board (sq. in.) 20 15 10 8 Resistors 22 24 18 12 Memory Chips 6 8 4 4 Assembly Labor (hours) 0.75 0.6 0.5 0.65 The unit wholesale price and manufacturing costs for each model are as follows. Note: the profit per unit is the wholesale price minus the manufacturing cost. Per Unit Revenues and Costs HyperLink EtherLink $189.00 FastLink SpeedLink MicroLink $149.00 $149.00 $169.00 $101.00 $96.00 $137.00 Wholesale price Manufacturing cost $139.00 $136.00 $101.00 In their next production period, Spectra has 80,000 square inches of PC board, 100,000 resistors, 30,000 memory chips and 5000 hours of assembly time available. The marketing environment requires that they produce at least 500 units of each model and that the number of HyperLinks produced be at least twice the number of Speed Links produced. Note that the profit margin per unit manufactured and sold, is equal to the wholesale price minus the manufacturing cost. Create a Solver-based spreadsheet model to determine the number of each of the five interface cards products to produce in the next production period in order to maximize profit and solve the model. 5661 Comments and Hints: 1. Be sure to use sumproduct, formulas that can be copied and range constraints. 2. Don't let the terms wholesale price and manufacturing cost mislead you into thinking this is a make or buy problem. It is a profit maximization problem where the only option is to make. 3. The restriction "the number of HyperLinks produced be at least twice the number of SpeedLinks produced must be handed with a "linearized " ratio constraint. It cannot be correctly handed by simply doubling the minimum number of HyperLink cards from 500 to 1000.
Expert Answer:
Answer rating: 100% (QA)
B G H optimal solution A D E F HyperLink FastLink Spe... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
A set of 1000 cards numbered 1 through 1000 is randomly distributed among 1000 people with each receiving one card. Compute the expected number of cards that are given to people whose age matches the...
-
Pennsylvania has a lottery entitled "Big 4". To win, a player must correctly match 4 digits, in order, from a daily lottery in which four digits are selected. Digits are chosen from four separate...
-
Cards are chosen randomly from a pack of cards with replacement. Calculate the probability that: (a) The first heart is obtained on the third drawing. (b) The fourth heart is obtained on the tenth...
-
Evaluate the integrals in Problem. Check your answers by differentiating. (3x 2 - 4x - 4) dx
-
The efficiency X of a certain electrical component may be assumed to be a random variable that is distributed uniformly between 0 and 100 units. What is the probability that X is: (a) Between 60 and...
-
Modify your roll.html page so that it incorporates one of the two techniques, either priming the loop or a flag, from Figure 13.3. Then, load the page and verify that the code behaves as before?
-
In your audit of the Learned Corporation you request a management "rep" letter. You are particularly interested in management's representations on 1. Irregularities involving management or employees....
-
On July 31, 2014, the end of the first month of operations, Rhys Company prepared the following income statement, based on the absorption costing concept: a. Prepare a variable costing income...
-
Suppose that the weekly average expenditure of a student in your college is $150 with a variance of $81. (a) Suppose you draw a sample of 100 students. Compute the probability that the sample mean is...
-
1. A friend has offered to play a gambling game with you that involves flipping a coin that be has provided. Since a flip of heads will be to his advantage, you want to test the coin for fairness...
-
After graduating four years later, Maria wants to buy an apartment in the city centre. An apartment costs $20,000 and the price is expected to increase by 4% each year. Maria wants to sell her old...
-
Explain the value of social media marketing.
-
Explain the reasons why the Internet could be expected to decrease prices online.
-
Describe the unique characteristics of digital media in contrast to traditional media.
-
Select three websites of your choice and compare their design effectiveness. You should describe design features such as navigation, structure and graphics.
-
What characteristics of the Internet make it so conducive to the direct marketing approach?
-
What types of messages would you personally need extra elaboration on to sway you more one way or another? Out of the 5 influences on motivation, which one would be more effective when trying to...
-
A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?
-
The beams AB and BC are supported by the cable that has a parabolic shape. Determine the tension in the cable at points D, F, and E, and the force in each of the equally spaced hangers. 3'm 9 m A B 5...
-
Draw the influence line for the force in (a) Member EH and (b) Member JE. L. 3 m IC |D -4 m--4 m--4 m- |F E4 m--4 m--4 m-
-
Determine the slope and displacement at point B. EI is constant. Using Castiglianos theorem. 400 N 300 N/m 'A 3 m
-
Fill in the Blank. __________ equation involves time-dependent coefficients.
-
Fill in the Blank. When finite amplitudes of motion are involved, __________ analysis becomes necessary.
-
Fill in the Blank. __________ principle is not applicable in nonlinear analysis.
Study smarter with the SolutionInn App