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...
-
Why is CRM so important to any organization?
-
Paul Ward is interested in the stock of Pecunious Products, Inc. Before purchasing the stock, Ward would like your help in analyzing the data that are available to him as follows: Mr. Ward would like...
-
Pileri Industries shipped goods to Consolidated Industries, Inc., via a common carrier. The goods were lost in transit. Pileri claimed that the sale was a shipment contract, thus putting the risk of...
-
Entries for Held-to-Maturity Securities on January 1, 2010, Jennings Company purchased at par 10% bonds having a maturity value of $300,000. They are dated January 1, 2010, and mature January 1,...
-
__________ are expenses that can be subtracted from total income in order to calculate tax liability. They may include child care expenses and union dues. deductions debentures tax credits dividends...
-
A new edition of a very popular textbook will be published a year from now. The publisher currently has 1,000 copies on hand and is deciding whether to do another printing before the new edition...
-
d) o = 15.1, 15% above 16.6; u= ? Choose the correct graph below. OB. OC. OD. O A. 16.6 18.6 16.6 16.6 G= 15.1, 15% above 16.6; u= ? Find the mean. p= (Round to one decimal place as needed.)
-
The following information is provided to you: a) current market price of the share= $24 b) Recent Dividend per share = $1 c) Risk-free rate = 4 percent; d) Estimated beta = 1.2 e) Equity risk premium...
-
Re-write each of the following as an equivalent expression that uses addition and then simplify. a. 10-14.5 b. -10-14.5 c. -10-(-14.5) d. 10-(-14.5)
-
a profit maximizing firm has a technology with the production function f(x1,x2) =x1^0.5 x2^0.5 can only use 4 units of x2 in the short run. what is the optimal amount of x1 to use in the short run if...
-
Heidi C. sells golf putters specifically designed for petite women. The company's accountant prepared the following income statement for the company's most recent quarter. Sales Revenue $525,000 Cost...
-
Bon Vivant has just issued bonds whose face value on the market is $200,000. The bonds mature in 10 years and carry an interest rate of 5%. Interest is payable semi annually. The market rate is 4%....
-
The Lagrange function is in which stands for the Lagrange multiplier. Observation: A crucial observation is that there are two arguments (separated by the one comma) in the utility function. The...
-
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...
-
The Milham Theatre Club has been in existence for a number of years. Members pay an annual subscription of 15 which entitles them to join trips to professional productions at a reduced rate. On 1...
-
The accounting records of the Happy Tickers Sports and Social Club are in a mess. You manage to find the following information to help you prepare the accounts for the year to 31 December 2015. (1)...
-
A business both buys loose tools and also makes some itself. The following data is available concerning the years ended 31 December 2014, 2015 and 2016. You are to draw up the Loose Tools Account for...
Study smarter with the SolutionInn App