Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. statistics
  3. a furniture supplier, acme chairs, inc., manufactu

A furniture supplier, Acme Chairs, Inc., manufactures a Basic office chair and a Deluxe office chair....

50.1K

Verified Solution

Question

Statistics

A furniture supplier, Acme Chairs, Inc., manufactures a Basicoffice chair and a Deluxe office chair. Each Basic chair costs$25.00 to manufacture, and each Deluxe office chair costs $40.00 tomanufacture. Acme Chairs wishes to determine the optimal productionquantities per day for each chair model in order to minimizeoverall total cost.

The production of each chair requires three types of materials:Wood, Primer, and Paint. The amount of material available per dayto manufacture the chairs is as follows:

30 units of wood.

600 oz. of primer.

750 oz. of paint.

Each chair requires the materials as shown below:

Wood (units)

1.25

2.50

Primer (oz.)

3.00

7.50

Paint (oz.)

6.00

10.00

A. State the Objective function mathematically.

B State the constraints mathematically.

C. Instead, create an Excel Model for this Example.(please givestep by step excel instructions)

Use Solver to determine the optimized solution. (Do not solvethe problem graphically)

Answer & Explanation Solved by verified expert
3.8 Ratings (365 Votes)
    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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

You’re a researcher looking at whether or not applicants are accepted to a prestigious law internship....

Basic Math
Q

How do the interventions for the swine flu compare to the coronavirus interventions? Is vaccination for Coronavirus...

Medical Sciences
Q

.What does the Cry family of proteins specifically do to a target organism? Does this affect...

Biology
Q

What are the three main mechanisms of cellular injury? Briefly describe each. Which of these is...

Biology
Q

Which of the following is seen when a multicellular organism has many specialized cell types...

Biology
Q

represents a function a set of ordered pairs or hain and range of the 8...

Basic Math
Q

The equation r t 2t i 2t 16t j is the position of a particle...

Calculus
Q

Johnson Murphy Inc. acquired an asset by issuing a note payable of $18,000 with an...

Accounting
Q

Required Information [The following information applies to the questions displayed below.] Antuan Company...

Accounting
Q

Question 26 25 26 20 30 5 points Belem Granda Awe pro oporu On 1...

Accounting
Q

Computing Present Values of Single Amounts and Annuities Refer to Tables 1 and 2 in...

Accounting
Q

You own a portfolio equally invested in a risk-free asset and two stocks. One of...

Finance