1 Alta Electronics 2 3 4 5 Solution value 6 Selling price per unit 7 Material...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
1 Alta Electronics 2 3 4 5 Solution value 6 Selling price per unit 7 Material cost per unit 8 Labor cost per unit 15 9 Profit 10 Constraints 10 Cor 11 Department 1 Dep 12 Department 2 13 Department 3 14 Min External HD 15 Min Standard DVD 16 Min Deluxe DVD 17 Min 1 GB Flash 18 Min 30 GB HD 19 Min 60 GB HD 20 Min 2GB Mem Stick 21 22 23 24 25 26 Minutes required in each department: 27 Department 1 10 28 Department 2 6 29 Department 3 3 30 31 32 33 34 35 36 X1 Regular DVD X2 Deluxe DVD 12 6 3 X3 1 GB Flash 4 5 4 X4 30 GB External HD 10 7 4 X5 60 GB External HD 12 9 5 X6 2 GB USB Memory Stick 5 4 2 LHS <-- Revenue <-- Mati Cost <-- Labor Cost <-- Objective Sign RHS Cost $15 $12 $18 3-11 (High-tech product mix) Alta Electronics Incorporated spe- cializes in external memory expansion devices for PCs. Alta manufactures the following six peripheral devices for PCs in its Calgary plant: regular external DVD writers, deluxe exter- nal DVD writers, 1 GB flash memory cards, 30 GB external hard drives, 60 GB external hard drives, and 2 GB USB mem- ory sticks. Each of these technical products requires time, in minutes, to be processed in three departments (covering assembly, testing etc.), as shown in the table above. The first two departments are available 120 hours per week. The third department is only available for 100 hours each week. Since the demand for all six external storage devices is very large, Alta Electronics believes that it can sell as many units of each product as it can manufacture. The table that follows summarizes the revenue and material cost for each product: REVENUE PER UNIT SOLD (5) MATERIAL COST PER UNIT (51) DEVICE 200 35 Regular external DVD writer Deluxe external DVD writer 240 45 1 GB flash memory card 80 7 30 GB external HD 180 45 60 GB external HD 230 48 2 GB memory stick 90 6 In addition, variable labour costs are $15 per hour for department 1, $12 per hour for department 2, and $18 per hour for department 3. Alta also has the following produc- tion requirements based on existing standing weekly orders: At least 43 external hard drives must be produced each week At least 20 units of each of the six products must be produced each week. Alta Electronics wants to maximize its profits. (a) Formulate this problem as an LP model. (b) Solve the problem using Excel, specifying the best weekly product mix and the maximum weekly profit. 1 Alta Electronics 2 3 4 5 Solution value 6 Selling price per unit 7 Material cost per unit 8 Labor cost per unit 15 9 Profit 10 Constraints 10 Cor 11 Department 1 Dep 12 Department 2 13 Department 3 14 Min External HD 15 Min Standard DVD 16 Min Deluxe DVD 17 Min 1 GB Flash 18 Min 30 GB HD 19 Min 60 GB HD 20 Min 2GB Mem Stick 21 22 23 24 25 26 Minutes required in each department: 27 Department 1 10 28 Department 2 6 29 Department 3 3 30 31 32 33 34 35 36 X1 Regular DVD X2 Deluxe DVD 12 6 3 X3 1 GB Flash 4 5 4 X4 30 GB External HD 10 7 4 X5 60 GB External HD 12 9 5 X6 2 GB USB Memory Stick 5 4 2 LHS <-- Revenue <-- Mati Cost <-- Labor Cost <-- Objective Sign RHS Cost $15 $12 $18 3-11 (High-tech product mix) Alta Electronics Incorporated spe- cializes in external memory expansion devices for PCs. Alta manufactures the following six peripheral devices for PCs in its Calgary plant: regular external DVD writers, deluxe exter- nal DVD writers, 1 GB flash memory cards, 30 GB external hard drives, 60 GB external hard drives, and 2 GB USB mem- ory sticks. Each of these technical products requires time, in minutes, to be processed in three departments (covering assembly, testing etc.), as shown in the table above. The first two departments are available 120 hours per week. The third department is only available for 100 hours each week. Since the demand for all six external storage devices is very large, Alta Electronics believes that it can sell as many units of each product as it can manufacture. The table that follows summarizes the revenue and material cost for each product: REVENUE PER UNIT SOLD (5) MATERIAL COST PER UNIT (51) DEVICE 200 35 Regular external DVD writer Deluxe external DVD writer 240 45 1 GB flash memory card 80 7 30 GB external HD 180 45 60 GB external HD 230 48 2 GB memory stick 90 6 In addition, variable labour costs are $15 per hour for department 1, $12 per hour for department 2, and $18 per hour for department 3. Alta also has the following produc- tion requirements based on existing standing weekly orders: At least 43 external hard drives must be produced each week At least 20 units of each of the six products must be produced each week. Alta Electronics wants to maximize its profits. (a) Formulate this problem as an LP model. (b) Solve the problem using Excel, specifying the best weekly product mix and the maximum weekly profit.
Expert Answer:
Answer rating: 100% (QA)
Defination Variable Qty of each product Constraint No of labor hours available for e... View the full answer
Related Book For
Managing Controlling and Improving Quality
ISBN: 978-0471697916
1st edition
Authors: Douglas C. Montgomery, Cheryl L. Jennings, Michele E. Pfund
Posted Date:
Students also viewed these accounting questions
-
Flash Manufacturing manufactures 16 GB flash drives (jump drives). Price and cost data for a relevant range extending to 200,000 units per month are as follows: Sales price Per-unit (current monthly...
-
In the market for flash memory drives (a normal good), explain whether the following events would cause an increase or a decrease in demand or an increase or a decrease in the quantity demanded. Also...
-
For an external USB hard drive attached to a computer, which is more suitable: a write through cache or a block cache?
-
Taunton's is an all-equity firm that has 151,000 shares of stock outstanding. The CFO is considering borrowing $233,000 at 7 percent interest to repurchase 20,000 shares. Ignoring taxes, what is the...
-
The following is a set of data from a sample of n = 5: 7 4 9 8 2 a. Compute the first quartile (Q1), the third quartile (Q3), and the interquartile range. b. List the five- number summary. c....
-
You have a hollow spherical shell of radius \(R\) that carries a positive charge. The shell is very thin. You make many Gaussian surfaces concentric with the shell to determine the electric field...
-
What is the probability of drawing the letters S-E-A-L, in order? You are about to draw Scrabble tiles from a bag without replacement; the bag contains the letters A, A, C, E, E, E, L, L, N, O, R, S,...
-
Consider each of the following unrelated cases, involving the ownership of shares of Canadian-controlled private corporations. Assume all of the issued shares are common shares unless specifically...
-
Use the following information for Quick Studies below. Skip to question [The following information applies to the questions displayed below.] The following is the adjusted trial balance of Sierra...
-
Ivey Company prepared the following budgeted income statement for the first quarter of 2016: Ivey Company is considering two options. Option 1 is to increase advertising by $ 1,000 per month. Option...
-
Compute the sensitivity of NPV to a change in unit sales A proposal to build an $87 million factory is being contemplated to produce a new product. The factory is expected to last 20 years (but can...
-
An NFL defensive lineman has been offered the following contract offers: Contract A: $1,000,000 signing bonus, $1,000,000 year one salary, $1,100,000 year two salary, $1,200,000 year three salary....
-
9 8 0 0 days were exposed to 6 . 2 degrees Celsius at 2 9 1 What is the final thermal wind?
-
The required clamping force on the workpiece for a strap is 1000 lb. The clamp setup uses the first-class lever principle with A = 4 in, and B = 3 in. Find required force on stud, stud size, required...
-
CastroCo. is considering the acquisition of a unit from the French government. Its initial outlay would be $3,900,000. It will reinvest all the earnings in the unit. It expects that at the end of 8...
-
ABC's stock price is currently $80 per share. An at-the-money call option (X = $80) on ABC stock currently sells for $8, and an at-the-money put option also sells for $8. The options expire in 3...
-
2) A business purchases equipment by paying $6,276 in cash and issuing a note payable of $19,177. Which of the following occurs? A) Cash is credited for $6,276, Equipment is credited for $25,453, and...
-
Pappa's Appliances uses the periodic inventory system. Details regarding the inventory of appliances at January 1, purchases invoices during the year, and the inventory count at December 31 are...
-
Apply the Western Electric rules to the control chart in Exercise 5.14. Are any of the criteria for declaring the process out of control satisfied?
-
Discuss the relationship between a control chart and statistical hypothesis testing.
-
The data in Table 6E.18 are the number of information errors found in customer records in a marketing company database. Five records were sampled each day. Set up a c chart for the total number of...
-
Define: convertible bond, bond with equity warrants, preference share, investment certificate and bond redeemable in shares.
-
The bond market yield is 7%. A company issues a bond with equity warrants at a gross yield to maturity of 3% assuming the warrants are not exercised. What is the cost of this product? What is the...
-
Is a convertible bond more costly to the issuing company than a bond with equity warrants?
Study smarter with the SolutionInn App