Managerial Decision Modeling with Spreadsheet please use microsoft excel software to answer the question 2-21 A decorating store specializing in do-it-your-self home decorators must decide how many information packets to prepare for the summer decorating season. The store managers know they will require at least 400 copies of their popular painting packet. They b elieve their new information packet on specialty glazing techniques could be a big seller, so they want to prepare at least 300 copies. Their printer has given the following information: The painting packet will require 2.5 minutes of printing time and 1.8 minutes of collating time. The glazing packet will require 2 minutes for each operation. The store has decided to sell the painting packet for $5.50 a copy and to price the glazing packet at $4.50. At this time, the printer can devote 36 hours to printing and 30 hours to collation. He will charge the store $1 for each packet prepared. How many of each packet should the store order to maximize the revenue associated with information packets, and what is the store's expected revenue? 2-24 A small motor manufacturer makes two types of motor, models A and B. The assembly process for each is similar in that both require a certain amount of wiring, drilling, and assembly. Each model A takes 3 hours of wiring, 2 hours of drilling, and 1.5 hours of assembly. Each model B must go through 2 hours of wiring, 1 hour of drilling, and 0.5 hours of assembly. During the next production period, 240 hours of wiring time, 210 hours of drilling time, and 120 hours of assembly time are available. Each model A sold yields a profit of $22. Each model B can be sold for a $15 profit. Assuming that all motors that are assembled can be sold, find the best combination of motors to yield the highest profit. 2-28 Treetops Hammocks produces lightweight nylon hammocks designed for campers, scouts, and hikers. The hammocks come in two styles: double and single. The double hammocks sell for $225 each. They incur a direct labor cost of $101.25 and a production cost of $38.75, and they are packed with hanging apparatus and storage bags, which cost $20. The single hammocks sell for $175 each. Their direct labor costs are $70 and production costs are $30, and they too are packed with the same hanging apparatus and storage bags, which cost $20. Each double hammock uses 3.2 hours of production time; each single hammock uses 2.4 hours of production time. Treetops plans for no more than 960 labor hours per production cycle. Treetops wants to maximize its profit while making no more than 200 single hammocks and no more than 400 total hammocks per production cycle. (a) How many of each hammock should Treetops make? (b) If the restriction on single hammocks were removed, what would be the optimal production plan 3-3 A manufacturer of travel pillows must determine the production plan for the next production cycle. He wishes to make at least 300 of each of the three models that his firm offers and no more than 1,200 of any one model. The specifics for each model are shown in the following table. How many pillows of each type should be manufactured in order to maximize total profit? 3-12 A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His political consultants have provided him with the following estimates of additional votes as a result of the advertising effort: For every small sign placed by the roadside, he will garner 10 additional votes. For every large sign placed by the roadside, he will garner 30 additional votes. For every thousand bumper stickers placed on cars, he will garner 10 additional votes. For every hundred personal mailings to registered voters, he will garner 40 additional votes, and For every radio ad heard daily in the last month before the election, he will garner 485 additional votes. The costs for each of these advertising devices, along with the practical minimum and maximum that should be planned for each, are shown on the following table. How should the candidate plan to spend his campaign money? 3-21 A small trucking company is determining the composition of its next trucking job. The load master has his choice of seven different types of cargo, which may be loaded in full or in part. The specifications of the cargo types are shown in the following table. The goal is to maximize the amount of freight, in terms of dollars, for the trip. The truck can hold up to 900 pounds of cargo in a 2,500-cubic-foot space. What cargo should be loaded, and what will be the total freight charged