Reference no: EM1370619
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.
|
Question related to external environment
: Give examples of firms that did not understand their external environment and what were the implications of the firm's failure to understand that environment?
|
|
Two part pricing strategy
: You're the manager of monopoly. A typical consumer's inverse demand function for your firm's product is P=100-2Q and your cost function is C(Q)=20Q. Find out the optimal two part pricing strategy.
|
|
Explain what is the proper format in writing a letter
: Explain What is the proper format in writing a Donation letter from the organization and At the very end was an appeal for a donation
|
|
Assign passed value to function to return value
: Assign passed value to this member and another function to return value. Your main should read the integer from an input data file, and write the output to the output data file.
|
|
Decision models - excel spreadsheet
: 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.
|
|
Regulation of monopolies and potential monopolies
: Why is the government so quick to regulate monopolies and potential monopolies? What are the major concerns and evils that arise from this market structure?
|
|
Critisim of the federal income tax exemption of interest
: Give some arguments for and against the critisim of the federal income tax exemption of interest on state-local debt as being an inefficient subsidy.
|
|
Bundling of free internet browser software
: Explain how microsofts bundling of free internet browser software with its windows operating system could violate US antitrust laws, and be sure to mention which laws in particular might be violated.
|
|
Example on decision models
: Decision Models- Steel Fabricators manufactures truck panels by blending ore from four different mines. Each ton of blended ore requires at least
|