Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the Solver model in Excel how many sets ofen's and women's clubs should you produce to maximize profits given the below constants and constraints.
Using the Solver model in Excel how many sets ofen's and women's clubs should you produce to maximize profits given the below constants and constraints. (Solver cannot recommend building a fractional part or a golf club set abd at least 700 womens set and 700 men sets must be produced)
the goal is to maximize profits. given the time contstraints and constants shown on the excel attachment, how many sers of womens gold clubs and how many sets of mens golf clubs should be produced? (a minimum of 700 have to be produced)
B 1 GOLF CLUB PRODUCT MIX PROBLEM BASE CASE 3 CHANGING CELLS NUMBER OF SETS OF MEN'S CLUBS 5 NUMBER OF SETS OF WOMEN'S CLUBS 6 0.28 9. CONSTANTS 20 TAX RATE 11 SELLING PRICES. 12 MEN'S SET 13 WOMEN'S SET $1,200 $1,140 $900 $885 - 42 38 54 46 54 54 18 PRODUCTION COST 17 MEN'S SET 13 WOMEN'S SET TO 21 TIME REQUIREMENTS MINUTES. 22 INVESTMENT CASTING, MENS SET 23 INVESTMENT CASTING, WOMEN'S SET 24 TUBE DRAWING, MEN'S SET 25 TUBE DRAWING, WOMEN'S SET 26 ASSEMBLY, MENS SET 27 ASSEMBLY, WOMENS SET 28 29 30 DEPT TIME AVAILABLE IN YEAR MINUTES 31 INVESTMENT CASTING 32 TUBE DRAWING 33 ASSEMBLY 35 SELLING, GENERAL & ADMINISTRATIVE 36 37 CALCULATIONS 38 REVENUE 39 MEN'S SETS 40 WOMEN'S SETS 100,000 105,000 110,000 $100,000 - 12 PRODUCTION COSTS: 43 MEN'S SETS 44 WOMEN'S SETS 45 46 TIME USED MINUTES! 47 INVESTMENT CASTING, MENS-WOMENS SETS 48 TUBE DRAWING, MEN'S WOMENS SETS 49 ASSEMBLY, MENS-WOMEN'S SETS 50 51 52 INCOME STATEMENT 53 TOTAL REVENUE 54 EXPENSES: 55 PRODUCTION COSTS 56 SELLING, GENERAL & ADMINISTRATIVE 57 TOTAL EXPENSES 58 INCOME BEFORE TAXES 59 INCOME TAX EXPENSE 60 NET INCOME AFTER TAXES B 1 GOLF CLUB PRODUCT MIX PROBLEM BASE CASE 3 CHANGING CELLS NUMBER OF SETS OF MEN'S CLUBS 5 NUMBER OF SETS OF WOMEN'S CLUBS 6 0.28 9. CONSTANTS 20 TAX RATE 11 SELLING PRICES. 12 MEN'S SET 13 WOMEN'S SET $1,200 $1,140 $900 $885 - 42 38 54 46 54 54 18 PRODUCTION COST 17 MEN'S SET 13 WOMEN'S SET TO 21 TIME REQUIREMENTS MINUTES. 22 INVESTMENT CASTING, MENS SET 23 INVESTMENT CASTING, WOMEN'S SET 24 TUBE DRAWING, MEN'S SET 25 TUBE DRAWING, WOMEN'S SET 26 ASSEMBLY, MENS SET 27 ASSEMBLY, WOMENS SET 28 29 30 DEPT TIME AVAILABLE IN YEAR MINUTES 31 INVESTMENT CASTING 32 TUBE DRAWING 33 ASSEMBLY 35 SELLING, GENERAL & ADMINISTRATIVE 36 37 CALCULATIONS 38 REVENUE 39 MEN'S SETS 40 WOMEN'S SETS 100,000 105,000 110,000 $100,000 - 12 PRODUCTION COSTS: 43 MEN'S SETS 44 WOMEN'S SETS 45 46 TIME USED MINUTES! 47 INVESTMENT CASTING, MENS-WOMENS SETS 48 TUBE DRAWING, MEN'S WOMENS SETS 49 ASSEMBLY, MENS-WOMEN'S SETS 50 51 52 INCOME STATEMENT 53 TOTAL REVENUE 54 EXPENSES: 55 PRODUCTION COSTS 56 SELLING, GENERAL & ADMINISTRATIVE 57 TOTAL EXPENSES 58 INCOME BEFORE TAXES 59 INCOME TAX EXPENSE 60 NET INCOME AFTER TAXES Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started