Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. use excel and formulas linear program problem whos

Use EXCEL and formulas Linear program problem whose output follows determines how many necklaces, bracelets, rings, and...

50.1K

Verified Solution

Question

Basic Math

Use EXCEL and formulas

Linear program problem whose output follows determines how manynecklaces, bracelets, rings, and earrings a jewelry store shouldstock. The objective function measures profit; it is assumed thatevery piece stocked will be sold. Constraint 1 measures displayspace in units, constraint 2 measures time to set up the display inminutes. Constraints 3 and 4 are marketing restrictions.

MAX 100X1+120X2+150X3+125X4

S.T.

1) X1+2X2+2X3+2X4<108

2) 3X1+5X2+X4<120

3) X1+X3<25

4) X2+X3+X4>50


Use the microsoft excel solver method to find the solution and thesensitivity report.

Which resource should the company increase and why?

Answer & Explanation Solved by verified expert
4.5 Ratings (857 Votes)
1 Put the value in excel    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

Physics
1.2K views

3. A positive point charge q = +3 µC is placed on the y axis...

General Management
1.2K views

You are to post an example of a business plan you developed for the development or...

Physics
1.2K views

6 There is a medium has refractive index and 3 3 another medium 2 has...

Physics
1.2K views

two particles of mass M1 and M2 and velocities U1 and U2 aU1 makes an...

Physics
1.2K views

A spool of mass M inner radius R and outer radius 2R MR having moment...

Basic Math
1.2K views

Assume the economy is operating beyond the full employment output level as shown in the...

Basic Math
1.2K views

Sine Graphs Consider the following Sine graph A local maximum occurs at point A 2...

Calculus
1.2K views

Calculate the difference quotient for f x 2x2 at a 1 Express numbers in exact...

Accounting
1.2K views

Homework Problem #3- Boards Inc. fabricates skateboards that the company sells...

Accounting
1.2K views

Alice is single and self-employed in 2023 . Her net business profit on her Schedule...

Finance
1.2K views

Masawi Foods inc. sells 50-pound bags of apple to the customers for $20a bag. The...

Accounting
1.2K views

Tara Company owns 80 percent of the common stock of Stodd Inc. In the current...