Question

Vollmer Manufacturing makes 3 components for industrial uses. The components are processed on two machines, a...

Vollmer Manufacturing makes 3 components for industrial uses. The components are processed on two machines, a shaper and a grinder. Component 1 requires 6 minutes on the shaper and 4 minutes on the grinder. Component 2 requires 4 minutes on the shaper and 5 minutes on the grinder. Component 3 requires 4 minutes on the shaper and 2 minutes on the grinder. The shaper is available for 120 hours and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1000 units of each of the other components can be sold. The company has orders for 600 units of component 1 that must be satisfied. Profit contributions for components 1, 2, and 3 are $6, $8, and $9 respectively.

Construct a linear optimization model for this situation on a spreadsheet and solve using Solver. Copy the Solver model from the dialog and paste it into your spreadsheet next to the model.

Homework Answers

Answer #1

The Solver model and the solution is:

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two...
Vollmer Manufacturing makes three components for sale to refrigeration companies. The components are processed on two machines: a shaper and a grinder. The times (in minutes) required on each machine are as follows: Machine Component Shaper Grinder 1 6 4 2 4 5 3 4 2 The shaper is available for 120 hours, and the grinder for 110 hours. No more than 200 units of component 3 can be sold, but up to 1,000 units of each of the other...
The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require...
The Electrotech Corporation manufactures two industrial-sized electrical devices: generators and alternators. Both of these products require wiring and testing during the assembly process. Each generator requires 2 hours of wiring and 1 hour of testing and can be sold for a $250 profit. Each alternator requires 3 hours of wiring and 2 hours of testing and can be sold for a $150 profit. There are 260 hours of wiring time and 140 hours of testing time available in the next...
1.XYZ Company produces two models of a component, Model A-3 and Model B-2. The unit contribution...
1.XYZ Company produces two models of a component, Model A-3 and Model B-2. The unit contribution margin for Model A-3 is GH¢ 6; the unit contribution margin for Model B-2 is GH¢ 14. Each model must spend time on a special machine. The firm owns two machines that together provide 4,000 hours of machine time per year. Model A-3 requires 15 minutes of machine time; Model B-2 requires 30 minutes of machine time. If XYZ Company can sell only 5,500...
Question: A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production...
Question: A manufacturing firm has discontinued production of a certain unprofitable product line. Considerable excess production capacity was created as a result. Management is considering devoting this excess capacity to one or more of three products: X1, X2, and X3. Machine hours required per unit are as follows:                                                                                           Product Machine Type X1 X2 X3 Milling machine 8 2 3 Lathe 4 3 0 Grinder 2 0 1 The available time in machine hours per week is...
Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company...
Koontz Company manufactures two models of industrial components—a Basic model and an Advanced Model. The company considers all of its manufacturing overhead costs to be fixed and it uses plantwide manufacturing overhead cost allocation based on direct labor-hours. Koontz’s controller prepared the segmented income statement that is shown below for the most recent year (he allocated selling and administrative expenses to products based on sales dollars):     Basic      Advanced      Total Number of units produced and sold      20,000  ...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a...
Kelson Sporting Equipment, Inc., makes two different types of baseball gloves: a regular model and a catcher's model. The firm has 800 hours of production time available in its cutting and sewing department, 150 hours available in its finishing department, and 400 hours available in its packaging and shipping department. The production time requirements and the profit contribution per glove are given in the following table: Production Time (Hours) Model Cutting and Sewing Finishing Packaging and Shipping Profit/Glove Regular model...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,710,000 Cost of goods sold 1,229,861 Gross margin 480,139 Selling and administrative expenses 630,000 Net operating loss $ (149,861 ) Hi-Tek produced and sold 60,100 units of B300 at a price of $20 per unit and 12,700 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,641,000 Cost of goods sold 1,245,234 Gross margin 395,766 Selling and administrative expenses 610,000 Net operating loss $ (214,234 ) Hi-Tek produced and sold 60,300 units of B300 at a price of $19 per unit and 12,700 units of T500 at a price of $39 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,708,000 Cost of goods sold 1,216,264 Gross margin 491,736 Selling and administrative expenses 640,000 Net operating loss $ (148,264 ) Hi-Tek produced and sold 60,200 units of B300 at a price of $20 per unit and 12,600 units of T500 at a price of $40 per unit....
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption...
Hi-Tek Manufacturing, Inc., makes two types of industrial component parts—the B300 and the T500. An absorption costing income statement for the most recent period is shown: Hi-Tek Manufacturing Inc. Income Statement Sales $ 1,635,200 Cost of goods sold 1,217,124 Gross margin 418,076 Selling and administrative expenses 630,000 Net operating loss $ (211,924 ) Hi-Tek produced and sold 60,200 units of B300 at a price of $19 per unit and 12,600 units of T500 at a price of $39 per unit....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT