Answered step by step
Verified Expert Solution
Link Copied!

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)
image text in transcribed
image text in transcribed
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

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

Oracle Database Administration The Essential Reference

Authors: Brian Laskey, David Kreines

1st Edition

1565925165, 978-1565925168

More Books

Students also viewed these Databases questions