Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Read the question CAREFULLY. Use excel solver to solve this problem and state the solution in words. . A lumber store stocks dowels in

Please Read the question CAREFULLY. Use excel solver to solve this problem and state the solution in words. image text in transcribed

. A lumber store stocks dowels in one standard length of 150 cm. Each dowel costs $20. A customer wants the store to cut him at minimal cost twenty dowels of length 67 cm, eighty dowels of length 51 cm, sixty dowels of length 28 cm, and forty dowels of length 15 cm. You might wish to use Excel to help create a list of patterns when beginning part (a). A metalworking company buys sheet metal from which they make swings and slides for children's playgrounds. They then outsource the rustproofing of the swings and slides, and sell the finished products. They buy the metal at a cost of $5 per kilogram (kg). Each swing requires 3 kg of metal, while each slide requires 6 kg. Each product spends time in three operations: cutting; polishing; and assembly. The times in minutes per unit are: Swing Slide Cutting Polishing Assembly 25 12 16 18 10 11 Each day, the shop is available for 6.5 hours of productive time. There are four cutting machines, one polisher, and one person to do the assembly. However, up to an extra 80 minutes of assembly time can be purchased for $2 per minute. The rust-proofing firm charges $30 per hour. When rust-proofing swings, they can rust- proof 5 swings per hour; when rust-proofing slides, they can rust-proof 16 slides per hour. The metalworking company sells its products to a wholesaler at $190 per swing and $75 per slide. The market requires that at least two slides be made for every swing made. We define all variables are on a daily basis): S = the number of swings made (integer) L = the number of slides made (integer) R = the number of hours of rust-proofing purchased M = the number of kilograms of metal purchased A = the number of extra assembly minutes purchased . A lumber store stocks dowels in one standard length of 150 cm. Each dowel costs $20. A customer wants the store to cut him at minimal cost twenty dowels of length 67 cm, eighty dowels of length 51 cm, sixty dowels of length 28 cm, and forty dowels of length 15 cm. You might wish to use Excel to help create a list of patterns when beginning part (a). A metalworking company buys sheet metal from which they make swings and slides for children's playgrounds. They then outsource the rustproofing of the swings and slides, and sell the finished products. They buy the metal at a cost of $5 per kilogram (kg). Each swing requires 3 kg of metal, while each slide requires 6 kg. Each product spends time in three operations: cutting; polishing; and assembly. The times in minutes per unit are: Swing Slide Cutting Polishing Assembly 25 12 16 18 10 11 Each day, the shop is available for 6.5 hours of productive time. There are four cutting machines, one polisher, and one person to do the assembly. However, up to an extra 80 minutes of assembly time can be purchased for $2 per minute. The rust-proofing firm charges $30 per hour. When rust-proofing swings, they can rust- proof 5 swings per hour; when rust-proofing slides, they can rust-proof 16 slides per hour. The metalworking company sells its products to a wholesaler at $190 per swing and $75 per slide. The market requires that at least two slides be made for every swing made. We define all variables are on a daily basis): S = the number of swings made (integer) L = the number of slides made (integer) R = the number of hours of rust-proofing purchased M = the number of kilograms of metal purchased A = the number of extra assembly minutes purchased

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Corporate Financial Management

Authors: Douglas R. Emery, John D. Finnerty, John D. Stowe

4th Edition

1935938002, 9781935938002

More Books

Students also viewed these Finance questions