Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. advance math
  3. winkler furniture manufactures two different types

Winkler Furniture manufactures two different types of china cabinets A French Provincial model and a Danish...

70.2K

Verified Solution

Question

Advance Math

Winkler Furniture manufactures two different types of chinacabinets A French Provincial model and a Danish Modern model. Eachcabinet produced must go through three departments: Carpentry,Painting and Finishing. The table provided gives all of theproduction times per cabinet produced and production capacities foreach operation per day along with net revenue per unit prodced.

The firm has a contract to produce a minimum of 60 cabinets perday. How many of each cabinet should the manufacturer make tomaximize daily revenue.

Please show how to set up in excel and how to get the answerusing solver in excel

Answer & Explanation Solved by verified expert
3.9 Ratings (435 Votes)
Decision variablesX1 No ofFrench Provincial cabinetsproduced each dayX2 No of Danish    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Accounting
1.2K views

Vadar owned Tatooine Farm. He sold the farm to Luke. Luke neverrecorded the deed....

Finance
1.2K views

Discuss the major components of the Sarbanes-Oxley Act of 2002 and Corporate Governance?

Biology
1.2K views

How might the information gained from this lab pertaining to mitosis and meiosis be useful to...

Accounting
1.2K views

Using the below information open an excel file and create a Sales Budget, a Cash Receipt...

Biology
1.2K views

The adoption of agriculture resulted in an increase in health generally Owidespread weight gain a...

Statistics
1.2K views

The manager of a computer retail store is concerned that his suppliers have been giving...

Statistics
1.2K views

Suppose small aircraft arrive at a certain airport according to a Poisson process with rate...

Calculus
1.2K views

Solve An investment is worth 2877 in 1992 By 1997 it has grown to 5547...

Algebra
1.2K views

A pair of standard dice are rolled Find the probability of rolling a sum of...

Algebra
1.2K views

3 If there are 20 students who are late to school on Monday 15 students...

Finance
1.2K views

APPLE MARKET VALUE = $115.05 CALLS EXP DATE: DEC 4, 2020 PUTS LAST PRICE STRIKE...

Finance
1.2K views

SDJ, Inc., has net working capital of $1,090, current liabilities of $6,750, and inventory of...