90.2K

Verified Solution

Link Copied!

For the table below how will I set my solver what numbers to fill in figure D-24

SHIRT MANUFACTURING EXAMPLE
CHANGING CELLS
Number of T-shirts	1
Number of Button-down Shirts	1
CONSTANTS
Tax Rate	0.28
Selling Price: T-shirt	$8.00
Selling Price: Button-down Shirt	$36.00
Variable Cost to Make T-shirt	$2.50
Variable Cost to Make Button-down Shirt	$14.00
Cotton Usage (lbs): T-shirt	1.50
Cotton Usage (lbs): Button-down Shirt	2.50
Total Cotton Available (lbs)	13,000,000
Buttons per T-shirt	3.00
Buttons per Button-down Shirt	12.00
Total Buttons Available	110,000,000
CALCULATIONS
Ratio of Net Income to Total Revenue	0.45
Cotton Used: T-shirts	1.50
Cotton Used: Button-down Shirts	2.50
Cotton Used: Total	4.00
Buttons Used: T-shirts	3.00
Buttons Used: Button-down Shirts	12.00
Buttons Used: Total	15.00
Ratio of Button-down to T-shirts	1
INCOME STATEMENT
T-shirt Revenue	$8.00
Button-down Shirt Revenue	$36.00
Total Revenue	$44.00
Variable Costs: T-shirts	$2.50
Variable Costs: Button-down Shirts	$14.00
Total Costs	$16.50
Income Before Taxes	$27.50
Income Tax Expense	$7.70
Net Income After Taxes	$19.80

Expression Fill in the Excel Expression Net income to revenue Ratio of button-downs to T-shirts =_ Minimum button-downs Usage of buttons =_ Minimum button-downs Usage of buttons

Answer & Explanation Solved by verified expert

See Answer