Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribed

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: (1) 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 PROBL EMM Number of T-Shirts Number of Button Fig. D-23 Constants The Constants should look like this: 0.28 8 36 ax Rate e: T-Shirt ce: Button Down Variable cost to make: T-Shirt Variable cost to make Cotton usage Tbs): T-Shirt 2.5 otton u Total cotton available (bs Buttons per T-Shirt Buttons per Button 12 s available 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: (1) 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 PROBL EMM Number of T-Shirts Number of Button Fig. D-23 Constants The Constants should look like this: 0.28 8 36 ax Rate e: T-Shirt ce: Button Down Variable cost to make: T-Shirt Variable cost to make Cotton usage Tbs): T-Shirt 2.5 otton u Total cotton available (bs Buttons per T-Shirt Buttons per Button 12 s available 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Application Development And Design

Authors: Michael V. Mannino

1st Edition

0072463678, 978-0072463675

More Books

Students also viewed these Databases questions