Decision models - excel spreadsheet using solverneed help

Assignment Help Business Management

Reference no: EM13369875

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.

Reference no: EM13369875

Questions Cloud

Face to face interactionsin an increasingly internet world : face to face interactionsin an increasingly internet world what could possibly replace the face to face? is this good

Commercial logging and tree farmswhat do you think would : commercial logging and tree farmswhat do you think would happen if commercial loggers have their own tree farms? find

Question about forecasting - regression analysisjohn howard : question about forecasting - regression analysisjohn howard a mobile alabama real estate developer has devised a

Question related to external environmentplease help with : question related to external environmentplease help with the followinggiven the importance of understanding the

Decision models - excel spreadsheet using solverneed help : decision models - excel spreadsheet using solverneed help with this question asapsuzzalo library is planning to buy new

Decision models- excep spreadsheet with solversteel : decision models- excep spreadsheet with solversteel fabricators manufactures truck panels by blending ore from four

Describing the nature and extent of knowledge management in : describing the nature and extent of knowledge management in walmartplease assist me in describing the nature and extent

Management and changing definition of familyhow has the : management and changing definition of familyhow has the changing definition of family affected the functions of

Importance of good management to an organizationhow does : importance of good management to an organizationhow does good management affect the successful performance of an

User Account

All Pages