Font Paragraph QBA Fall 2020 - Misc. Assignment #1 Break Even Problems Answer the following break even problems. In addition to the answers (rounded to 0 decimal places), show the spreadsheets you created to solve them (like you do for homeworks in lab). Next to any cells with equations, put the equation in text. For example, if I was doing a spreadsheet to sum the number of fish my son and I caught, it would look like: B 1 Fish Prof Miller Caught 2 Fish Prof Miller Son Caught 3 Total Fish Caught 7 10 Formula in cell 13 is SUM(81:82) 01 (5 points Stew's Plastics produces a variety of CD cases. The best-selling product is the CD-50. Several products are produced on the same manufacturing line, so there is a setup cost each time a changeover is made for a new product. The setup cost for the CD-50 is $4350. In addition, it costs $2.17 for each unit (CD Case) produced, and for each 120 CD Cases they have to put them in a box that costs $2.58. If there is less than 120 CD Cases they will put them in a box (in other words, if they had 122 CD Cases, they would do 2 boxes, one with 120 CD Cases and one with 2 CD Cases) What is the break-even point (in terms of number of CD cases) if they sell them for $7.25 each? 0215 points) . Jerry, the manager of a small printing company, needs to replace a worn out copy machine. He is considering two machines; each has a monthly lease cost and a cost per page that is copied: Machine 1 has a $368 monthly lease with a 2.9 cents per page cost up to 300 pages, and then 1.9 cents per page after the 144 300 pages. Machine 2 has a $533 monthly lease with a 1.7 cents per page cost up to 300 pages, and then 1.0 cents per page after the 1' 300 pages. Jerry knows the break-even point is more than 300 pages for each machine. Determine the break-even point (per month) in terms of the number of copies for each machine if Jerry charges customers 5.5 cents per copy. Based on this, which machine do you recommend? Solver 03 (5 points) A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $10.28/unit, and to produce it takes 0.24 hours of labor and 0.17 hours of machine time. A keyboard has a profit of $13.15/unit, and to produce it takes 0.45 hours of labor and 0.23 hours of machine time. A flash drive has a profit of $5.32/unit, and to produce it takes 0.11 hours of labor and 0.07 hours of machine time. Each month, a total of 7,200 hours of labor and 3,100 hours of machine time are available. The maximum monthly demand is 10,500 mice, 8,000 keyboards and 12,700 flash drives. How many of each should the company make each month to maximize its profit and what is that maximum profit? Include your spreadsheet with any formulas noted. Also include a list of the you used. constraints (Question 4 on next page) Styles Editing 04 (10 points) The Minnow Bucket Bait Shop in Land O'lakes, WI raises trout, their current inventory is 18,000 fish (trout). They want to buy a mix of feed for their trout that both provides the nutrients needed and comes at the lowest cost. In order to do this, they are going to buy and mix two brands of feed. Each pound of Brand-1 feed contains 3.99 Ounces of ingredient "A", 4.05 ounces of ingredient "B" and 0.68 ounces of ingredient "C". Each pound of Brand-2 contains 8.56 ounces of ingredient "A", 3.42 ounces of ingredient "B" and no (zero) ounces of ingredient "C". Brand-1 costs $0.71 per pound and Brand-2 costs $0.90 per pound. Each trout needs 72.0 ounces of ingredient "A", 60.0 ounces of ingredient "B" and 7.5 ounces of ingredient "C" per month. How many total pounds of each brand should they buy per month to keep their cost as low as possible and still meet the dietary requirements of the 18,000 trout? What will the total cost per month be? Include your spreadsheet with any formulas noted. Also include a list of the constraints you used. Dracus Font Paragraph QBA Fall 2020 - Misc. Assignment #1 Break Even Problems Answer the following break even problems. In addition to the answers (rounded to 0 decimal places), show the spreadsheets you created to solve them (like you do for homeworks in lab). Next to any cells with equations, put the equation in text. For example, if I was doing a spreadsheet to sum the number of fish my son and I caught, it would look like: B 1 Fish Prof Miller Caught 2 Fish Prof Miller Son Caught 3 Total Fish Caught 7 10 Formula in cell 13 is SUM(81:82) 01 (5 points Stew's Plastics produces a variety of CD cases. The best-selling product is the CD-50. Several products are produced on the same manufacturing line, so there is a setup cost each time a changeover is made for a new product. The setup cost for the CD-50 is $4350. In addition, it costs $2.17 for each unit (CD Case) produced, and for each 120 CD Cases they have to put them in a box that costs $2.58. If there is less than 120 CD Cases they will put them in a box (in other words, if they had 122 CD Cases, they would do 2 boxes, one with 120 CD Cases and one with 2 CD Cases) What is the break-even point (in terms of number of CD cases) if they sell them for $7.25 each? 0215 points) . Jerry, the manager of a small printing company, needs to replace a worn out copy machine. He is considering two machines; each has a monthly lease cost and a cost per page that is copied: Machine 1 has a $368 monthly lease with a 2.9 cents per page cost up to 300 pages, and then 1.9 cents per page after the 144 300 pages. Machine 2 has a $533 monthly lease with a 1.7 cents per page cost up to 300 pages, and then 1.0 cents per page after the 1' 300 pages. Jerry knows the break-even point is more than 300 pages for each machine. Determine the break-even point (per month) in terms of the number of copies for each machine if Jerry charges customers 5.5 cents per copy. Based on this, which machine do you recommend? Solver 03 (5 points) A computer plant produces mice, keyboards and flash drives. A mouse has a profit of $10.28/unit, and to produce it takes 0.24 hours of labor and 0.17 hours of machine time. A keyboard has a profit of $13.15/unit, and to produce it takes 0.45 hours of labor and 0.23 hours of machine time. A flash drive has a profit of $5.32/unit, and to produce it takes 0.11 hours of labor and 0.07 hours of machine time. Each month, a total of 7,200 hours of labor and 3,100 hours of machine time are available. The maximum monthly demand is 10,500 mice, 8,000 keyboards and 12,700 flash drives. How many of each should the company make each month to maximize its profit and what is that maximum profit? Include your spreadsheet with any formulas noted. Also include a list of the you used. constraints (Question 4 on next page) Styles Editing 04 (10 points) The Minnow Bucket Bait Shop in Land O'lakes, WI raises trout, their current inventory is 18,000 fish (trout). They want to buy a mix of feed for their trout that both provides the nutrients needed and comes at the lowest cost. In order to do this, they are going to buy and mix two brands of feed. Each pound of Brand-1 feed contains 3.99 Ounces of ingredient "A", 4.05 ounces of ingredient "B" and 0.68 ounces of ingredient "C". Each pound of Brand-2 contains 8.56 ounces of ingredient "A", 3.42 ounces of ingredient "B" and no (zero) ounces of ingredient "C". Brand-1 costs $0.71 per pound and Brand-2 costs $0.90 per pound. Each trout needs 72.0 ounces of ingredient "A", 60.0 ounces of ingredient "B" and 7.5 ounces of ingredient "C" per month. How many total pounds of each brand should they buy per month to keep their cost as low as possible and still meet the dietary requirements of the 18,000 trout? What will the total cost per month be? Include your spreadsheet with any formulas noted. Also include a list of the constraints you used. Dracus