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
-
Nitrogen gas, N2, is heated to 4000 K, 10 kPa. What fraction of the N2 is dissociated to N at this state?
-
Below are incomplete financial statements for Cyclone, Inc. Required: Calculate the missingamounts. CYCLONE, INC. CYCLONE, INC. Statement of Stockholders' Equity Common Retained Total Stock Earnings...
-
Mrs. Palsgraf was waiting for a train on a platform of a railroad. When a different train came into the station, two men ran to get on that train before it left the station. While one of the men...
-
(Entries for Bond Transactions) Presented below are two independent situations. 1. On January 1, 2010, Divac Company issued $300,000 of 9%, 10-year bonds at par. Interest is payable quarterly on...
-
2. If a person seeks to report fraud related to a World Bank Group financed operation, to what department within the World Bank should that person direct their report? Describe the process of how the...
-
FREE-CASH-FLOWS-BASED VALUATION. In Problem, we projected financial statements for Wal-Mart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 13 (see pages 985987) include the...
-
(1) An asbestos pad is rectangle in cross section, measuring 3 cm x 10 cm on a side at its small end, increasing linearly to 6 x 20 cm on a side at the large end. The pad is 20 cm high. If the small...
-
Time left 0:58:41 2 During the year ended 30 Jun 2020, Ms Jhie,, a resident of Australia, has received rents of $28970 and salary of $12481. Her allowable deductions for the year are $4883. ut of...
-
For this part, we will make a Login application where we log in based on id and password in "login" table of MySQL database in Internet. Login Application 1:29 LoginDanny ID Enter ID Password Enter...
-
What is the role of a balancing adjustment? Explain your opinion.
-
If Alan is 5 0 % taller than Kolin and Kolin is 5 0 % taller than Ford, how many times taller than Ford is Alan?
-
Discuss on what grounds an intervention order would be granted in South Australia and discuss the difference between criminal and civil legislation in relation to intervention orders. You are working...
-
Respond to the following discussion questions and try the experiment( do not report on past communication episodes )only after you read. Let's experiment. Using SPOKEN (Vocal) messages (not printed...
-
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
-
Preventing a user who approves a configuration change from being the person who implements the change is an example of which of the following? A. Rotation of duties B. Least privilege C. Segregation...
-
A onedimensional heat conduction problem can be expressed by the following differential equation: where \(k\) is the thermal conductivity, \(T(x)\) is the temperature, and \(Q\) is heat generated per...
-
Consider a simply supported beam of length \(L\) subjected to a uniformly distributed transverse load \(p(x)=p_{0}\). Use the Rayleigh-Ritz method to determine the transverse deflection \(v(x)\) of...
Study smarter with the SolutionInn App