Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Business Management Expert

Decision Models - excel spreadsheet, using SOLVER

need help with this question ASAP:

Suzzalo Library is planning to buy new copier machines. It has narrowed its selection to two different models: Model A, a high-speed copier, and Model B, a lower-speed but less expensive copier. Model A can handle 20,000 copies a day and costs $6,000. Model B can do 10,000 copies a day, but costs only $4,000. The Suzzalo staff wants to have at least six copiers to be able to space them throughout the library, and at least one high-speed copier in the library. Finally, the copiers purchased must have a collective capacity of at least 75,000 copies a day. The objective is to determine the mix models A and B that will handle these requirements at minimum cost.

a) Formulate this problem in algebraic form. That is, define the decision variables, and express the objective function and all constraints in terms of these decision variables.

b) Solve this problem using Solver.

c) In simple English, state your proposed solution and its cost.

Business Management, Management Studies

  • Category:- Business Management
  • Reference No.:- M9305923

Have any Question?


Related Questions in Business Management

Question i need a solution this this question followed by

Question: I need a solution this this question followed by the Industry case: Question:  "Using the 5-Forces broken down on a separate sheet, summarize how your company competes and creates profit within your industry. R ...

Suppose that the demand curve for tickets to see a football

Suppose that the demand curve for tickets to see a football team play a game is given by Q = 80,000 - 40P and marginal cost is zero. The team's stadium can host 75,000 fans. i) How many tickets would the team sell if it ...

For this discussion activity you will get insight into the

For this discussion activity, you will get insight into the federal budgeting process and how key allocation decisions are made. As part of that effort you will work through the National Budget Simulation in an effort to ...

What do you think about the response from the ceo of united

What do you think about the response from the CEO of United? The United Airlines statement reads: "Flight 3411 from Chicago to Louisville was overbooked. After our team looked for volunteers, one customer refused to leav ...

Describe three things you can do to develop a community of

Describe three things you can do to develop a "community of learners" in your classroom. Give a specific example for each.

Discuss the importance of interdisciplinary team

Discuss the importance of Interdisciplinary team collaboration and communication in HC related managerial situations. Offer minimum 1 advantage of the established communication and one disadvantage of the failed communic ...

1 how could a manager educate stakeholders on effective

1) How could a manager educate stakeholders on effective risk management? 2) How risk management should relate to the scope, schedule and budget?

Discuss the following question studies indicate that good

Discuss the following question: Studies indicate that good leaders are typically positive and enthusiastic. In what ways do the tips cited in the vignette suggest the possession of these qualities by the various leaders ...

Mr barney the ceo has received your memo request to be

Mr. Barney, the CEO, has received your memo request to be considered for further leadership positions. He has decided to put you to the test! He assigns you to help his Director of Payroll, Loretta Cash with a problem.  ...

For this response consider the space shuttle challenger

For this response, consider the Space Shuttle Challenger case and address the following questions: Did Morton-Thiokol use a Stockholder or a Stakeholder model when they made the decision? What decision would you have mad ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As