1.
2.
Download E 7 (download) to answer the following questions. Create a table showing Returns per Year (varying from 5.0 to 8.0 by 0.25) and 401(k) per Month (varying from 100 to 300 by 20). If you contribute $220 per month, what return must you make to have at least $200,000 at the end of 26 years? (Enter your answer as a percentage with two decimal places and without the percent symbol) AJ If you now decide to work for 30 years and contribute only $200 per month, what minimum return must you make to have at least $250,000 in your account? (Enter your answer as a percentage with two decimal places and without the percent symbol) AJ A B 25 1 Retirement 2 3 Years 4 5 401(k) per month $ 6 Returns per year 7 8 Value 9 100 7.0% $81,007 10 Download E 10 (download). It contains the detailed instructions in one tab and a second tab for your Linear Program. How many Rocky Mountain Parkas are sold in the optimal solution? A How many minutes of sewing time are used? (Enter whole minutes) AJ What is the total revenue produced by this solution? (Enter whole dollars) A Expedition manufacturers a variety of specialty clothing for skiing and mountain climbing. The company has decided to begin production on two new parkas designed for use in extremely cold weather: the Mount Everest Parka and the Rocky Mountain Parka. Expedition's manufacturing plant only has 140 hours of cutting time and 130 hours of sewing time available. There is plenty of material to make the coats, except the fact that the zipper union is on strike and there are only 350 zippers. Because management believes that the Mount Everest Parka is a unique coat that will enhance the image of the firm, management has specified that at least 100 of this model must be produced. Each Mount Everest Parka requires 30 minutes of cutting time and 40 minutes of sewing time; the Labor and Material cost is $140 and the retail price is $250. Each Rocky Mountain Parka requires 20 minutes of cutting time and 15 minutes of sewing time; the Labor and Material cost is $50 and the retail price is $200. Download E 7 (download) to answer the following questions. Create a table showing Returns per Year (varying from 5.0 to 8.0 by 0.25) and 401(k) per Month (varying from 100 to 300 by 20). If you contribute $220 per month, what return must you make to have at least $200,000 at the end of 26 years? (Enter your answer as a percentage with two decimal places and without the percent symbol) AJ If you now decide to work for 30 years and contribute only $200 per month, what minimum return must you make to have at least $250,000 in your account? (Enter your answer as a percentage with two decimal places and without the percent symbol) AJ A B 25 1 Retirement 2 3 Years 4 5 401(k) per month $ 6 Returns per year 7 8 Value 9 100 7.0% $81,007 10 Download E 10 (download). It contains the detailed instructions in one tab and a second tab for your Linear Program. How many Rocky Mountain Parkas are sold in the optimal solution? A How many minutes of sewing time are used? (Enter whole minutes) AJ What is the total revenue produced by this solution? (Enter whole dollars) A Expedition manufacturers a variety of specialty clothing for skiing and mountain climbing. The company has decided to begin production on two new parkas designed for use in extremely cold weather: the Mount Everest Parka and the Rocky Mountain Parka. Expedition's manufacturing plant only has 140 hours of cutting time and 130 hours of sewing time available. There is plenty of material to make the coats, except the fact that the zipper union is on strike and there are only 350 zippers. Because management believes that the Mount Everest Parka is a unique coat that will enhance the image of the firm, management has specified that at least 100 of this model must be produced. Each Mount Everest Parka requires 30 minutes of cutting time and 40 minutes of sewing time; the Labor and Material cost is $140 and the retail price is $250. Each Rocky Mountain Parka requires 20 minutes of cutting time and 15 minutes of sewing time; the Labor and Material cost is $50 and the retail price is $200
