Numerical Methods
must use Excel plz
Problem 2 Extra Credit You have started working for a manufacturer of pet toys that just received a new contract to make durable thermoplastic rubber toys to market for dogs that are heavy chewers (H), moderate chewers (M) and puppies (P). Based on market trends, the contract asks for 15% more moderate chewer M toys to be produced than heavy chewer H toys, with no constraint specified on number of toys for puppies (P toys). There are two steps to making the toys: compression molding the components (Step 1) and assembly including deflashing (removing of excess rubber) (Step 2). After receiving the toy designs you decide to do a test run, to see how many toys you can produce if you run the compression molding machine for an hour for each toy type. From your test you learn the following: In 60 minutes of compression molding, components for 30 H toys are produced, which require 30 minutes of assembly. For M toys, you can produce components for 60 toys in 60 minutes, and 240 minutes is required to assemble the 60 toys. For P toys, in 60 minutes of compression molding the components for 15 toys are made, and it takes 30 minutes to assemble them into 15 toys. Due to competing scheduling and need for planned maintenance, you are told you can run the compression molding machine for 12 hours over a 24 hour period. The assembly line works in multiple rotating shifts with a maximum of 600 minutes available for this contract over a 24 hour period. With those time constraints, and from what you have learned from the pilot test run, how many toys of each type do you anticipate you can produce a day? Hint: put what you know and what you need to know into a table. Note: to receive any extra credit you must show your work including clear explanation and steps. Problem 2 Extra Credit You have started working for a manufacturer of pet toys that just received a new contract to make durable thermoplastic rubber toys to market for dogs that are heavy chewers (H), moderate chewers (M) and puppies (P). Based on market trends, the contract asks for 15% more moderate chewer M toys to be produced than heavy chewer H toys, with no constraint specified on number of toys for puppies (P toys). There are two steps to making the toys: compression molding the components (Step 1) and assembly including deflashing (removing of excess rubber) (Step 2). After receiving the toy designs you decide to do a test run, to see how many toys you can produce if you run the compression molding machine for an hour for each toy type. From your test you learn the following: In 60 minutes of compression molding, components for 30 H toys are produced, which require 30 minutes of assembly. For M toys, you can produce components for 60 toys in 60 minutes, and 240 minutes is required to assemble the 60 toys. For P toys, in 60 minutes of compression molding the components for 15 toys are made, and it takes 30 minutes to assemble them into 15 toys. Due to competing scheduling and need for planned maintenance, you are told you can run the compression molding machine for 12 hours over a 24 hour period. The assembly line works in multiple rotating shifts with a maximum of 600 minutes available for this contract over a 24 hour period. With those time constraints, and from what you have learned from the pilot test run, how many toys of each type do you anticipate you can produce a day? Hint: put what you know and what you need to know into a table. Note: to receive any extra credit you must show your work including clear explanation and steps
