How many of each model should you buy

Reference no: EM132854414

Quantitative Method

1. You need to buy some filing cabinets. You know that Cabinet X costs $10 per unit, requires 6square feet of floor space and holds 8 cubic feet of files. Cabinet Y costs $20 per unit, requires8 square feet of floor space and holds 12 cubic feet of files. You have been given $140 for thispurchase, though you don't have to spend that much. The office has room for no more than 72square feet of cabinets. How many of each model should you buy in order to maximize storage volume?

a) Formulate the problem, listing the decision variables, the objective function, and constraints(i.e., give the mathematical model).

b.) Log into your computer and open a NEW BLANK EXCEL WORKBOOK. Solve this problemusing Excel Solver and generate an Answer Report and a Sensitivity Report. Save the workbookas an Excel workbook.

Reference no: EM132854414

Questions Cloud

Provide the journal entries to issue of the securities : On 1 July 2022 Supertubes Ltd issues $50 million of convertible bonds to Magnatubes Ltd. Provide the journal entries to issue of the securities

What is the probability of randomly selecting 3 patients : If you have a sample of 100 patients at a hospital and 20 of them have the flu, what is the probability of randomly selecting 3 patients in a row

Assess the communication dynamics of an organization : Assess the communication dynamics of an organization to conduct a communication audit. Apply communication theories to organizational communication challenges

Determine the velocity and acceleration of the piston : Determine the velocity and acceleration of the piston P when ? = 90°. (Neglect the effect of the weight of the rod.)

How many of each model should you buy : Formulate the problem, listing the decision variables, the objective function, and constraints(i.e., give the mathematical model).

Find the? z-score that corresponds to life span : ?(a) The life spans of three randomly selected tires are 33,000 ?miles, 37,000 ?miles, and 31,000 miles. Find the? z-score that corresponds to each life span.

How much should you pay in exchange for a payment : How much should you pay in exchange for a payment of $300,000 that will be received 6 years from today? Assume an annual discount rate of 6%

Discuss the consequences of an ineffective : Discuss the consequences of an ineffective, or inadequate, onboarding program from both employee and organizational perspectives.

What is the price of the bond today : Problem - A five-year P1,000 par value bond pays 6.50% annual coupon. Given a YTM of 8.0%, what is the price of the bond today

User Account

All Pages