USING THE SOLVER ON A NEW PROBLEM Here is a short problem that will let you test what you have learned about the Excel Solver Assume you run a shirt-manufacturing company. You have two products: (I) polo-style T-shirts, and (2) dress shirts with button-down collars. You must decide how many T-shirts and how many button-down shirts to make. Assume you'll sell every shirt you make. AT THE KEYBOARD Set up a Solver spreadsheet to handle this problem. Changing Cells The Changing cells should look like this SHIRT MANUFACTURING PROBLEMM Number of T-Shirts Number of Button Down Shirts Fig. D-23 ConstantsThe Constants should look like this Tax Rate Selting price: T-Shirt Selling price: Button Down Variable cost to make: T-Shirt Variable cost to make: Button Down Cotton usage bs: T-Shirt Cotton usa Total cotton available (Ibs Buttons per T-Shirt Buttons per Button Down Total buttons available 36 2.5 2.5 13000000 Button Down 10000000 Fig. D-24 The constants cells (and some of your company's operations) are discussed next .The tax rate is .28 on pre-tax income, but no taxes are paid on losses. .You sell a polo-style T-shirt for $8, and a button-down shirt for $36. .It costs $2.50 to make a T-shirt, and it costs $14 to make a button-down shirt. These variable costs are for machine-operator labor, cloth, buttons, and so forth. . Each polo T-shirt uses 1.5 pounds of cotton fabric. Each button-down shirt uses 2.5 pounds of cotton fabric. You have only 13 million pounds of cotton on hand to be used to make all the T-shirts and button-down shirts. .Each polo T-shirt has 3 buttons. Each button-down shirt has a button on each collar tip, 8 buttons down the front, and 1 on each cuff, for a total of 12 buttons. You have 110 million buttons on hand to be used to make all your shirts. USING THE SOLVER ON A NEW PROBLEM Here is a short problem that will let you test what you have learned about the Excel Solver Assume you run a shirt-manufacturing company. You have two products: (I) polo-style T-shirts, and (2) dress shirts with button-down collars. You must decide how many T-shirts and how many button-down shirts to make. Assume you'll sell every shirt you make. AT THE KEYBOARD Set up a Solver spreadsheet to handle this problem. Changing Cells The Changing cells should look like this SHIRT MANUFACTURING PROBLEMM Number of T-Shirts Number of Button Down Shirts Fig. D-23 ConstantsThe Constants should look like this Tax Rate Selting price: T-Shirt Selling price: Button Down Variable cost to make: T-Shirt Variable cost to make: Button Down Cotton usage bs: T-Shirt Cotton usa Total cotton available (Ibs Buttons per T-Shirt Buttons per Button Down Total buttons available 36 2.5 2.5 13000000 Button Down 10000000 Fig. D-24 The constants cells (and some of your company's operations) are discussed next .The tax rate is .28 on pre-tax income, but no taxes are paid on losses. .You sell a polo-style T-shirt for $8, and a button-down shirt for $36. .It costs $2.50 to make a T-shirt, and it costs $14 to make a button-down shirt. These variable costs are for machine-operator labor, cloth, buttons, and so forth. . Each polo T-shirt uses 1.5 pounds of cotton fabric. Each button-down shirt uses 2.5 pounds of cotton fabric. You have only 13 million pounds of cotton on hand to be used to make all the T-shirts and button-down shirts. .Each polo T-shirt has 3 buttons. Each button-down shirt has a button on each collar tip, 8 buttons down the front, and 1 on each cuff, for a total of 12 buttons. You have 110 million buttons on hand to be used to make all your shirts
