solution

An Architect wishes to design the safety deposit room for a bank safe. He plans to place safety deposit boxes approximately 6 feet high by the approximate length of the room’s walls, 40 feet (i.e., 240 square feet total space available). The bank has asked him to plan for two sizes of box: large and small. Large boxes consume 1 square foot and will rent for $90 per year. Small boxes consume 0.6 square feet and will rent for $60 per year. The bank has asked for at least 80 large boxes and at least 120 small boxes. The bank hopes to maximize its revenue from safety deposit boxes.

A correct formulation for this problem is provided below:

Let L and S denote the number of units of large and small boxes that the architect’s design will provide

MAX Z = 90L+ 60S ($)

subject to,

1) Available Space L + 0.6S240 square feet

2) Minimum number of large boxes L80

3) Minimum number of small boxes S 120

4) Non-negativity L, S 0

(a) Graph the constraint lines and mark them clearly with the numbers (1), (2) and (3) to indicate which line corresponds to which constraint. Darken the feasible region. (12 points)

(b) Using the graphical method, how many of each size should the architect’s design provide? What is the annual revenue? Report the solution in a managerial statement (i.e. describe verbally the optimal solution and its profit). Provide all necessary calculations to justify your answers. (8 points).

(c) The bank would like to add a mini size box, which will rent for $35 per year and will consume 0.3 square feet of wall space. The bank will now require at least 30 mini boxes, at least 100 small boxes, and at least 40 large boxes. Further, the bank wants the total area of the large boxes to be at least 50% of the available space. How many boxes of each type should the architect include and what is the total annual revenue?

Formulate the linear programming problem on a spreadsheet and SOLVE using Excel Solver (Provide the corresponding “Excel Spreadsheet” and the “Answer Report” on this document). Include “managerial statements” that communicate the results of the analysis. (i.e. describe verbally the results).

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

1. What are your thoughts about Canada’s ethnic diversity and the diversity of languages spoken in Canada, the origin of Canadian visible minorities and where in Canada they live now, and the changing pattern of immigrant settlement in Canada?

2. Describe your feelings about the number of older immigrant adults in Canada; their reasons for immigration as an older adult; their living arrangements; their financial, physical, and mental health; and the problems with and limitations of the current Canadian literature on Canadian immigrant populations.

3. Describe your thoughts about the number of Aboriginal peoples who live in Canada; the language diversity of First Nations people; the lasting impact of the residential school system on First Nations people; problems with and limitations of the research on Canada’s Aboriginal peoples; and difficulties that First Nations people face, particularly, the unique challenges of older Aboriginal peoples.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Lori Franz, maintenance supervisor for the Baltimore Transit Authority, would like to determine whether there is a positive relationship between the annual maintenance cost of a bus and its age. If a relationship exists, Lori feels that she can do a better job of forecasting the annual bus maintenance budget. She collects the data shown in Table P-5.

a. Plot a scatter diagram.

 b. What kind of relationship exists between these two variables?

c. Compute the correlation coefficient.

d. Determine the least squares line.

e. Test for the significance of the slope coefficient at the .05 significance level. Is the correlation significant? Explain.

 f. Forecast the annual maintenance cost for a five-year-old bus.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Information supplied by a mail-order business for 12 cities is shown in Table P-7.

a. Determine the fitted regression line.

 b. Calculate the standard error of the estimate.

c. Determine the ANOVA table.

d. What percentage of the variation in mail orders is explained by the number of catalogues distributed?

 e. Test to determine whether the regression slope coefficient is significantly different from zero. (Use the .01 significance level.)

f. Test for the significance of the regression using the F statistic from the ANOVA table. (Use the .01 significance level.) Is the result consistent with the result in part e? Should it be?

 g. Forecast the number of mail orders received when 10,000 catalogues are distributed with a 90% prediction interval.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"