ABC, Inc. is undergoing scrutiny for a possible wage discrimination suit. The following data is available: SALARY(monthly salary for each employee $), YEARS (years with the company), POSITION (position with company coded as: 1 = manual labor 2 = secretary 3 = lab technician 4 = chemist 5 = management EDUCAT (amount of education completed coded as: 1 = high school degree 2 = some college 3 = college degree 4 = graduate degree), GENDER (employee gender).

1. Using the selected model (i.e., “best” model) answer the following: a) Briefly summarize (present & calculate) the descriptive statistics of the data b)Interpret and evaluate the model coefficients for the management team and corporate lawyer of ABC, Inc. c) Test for significance of relationships (both individually and jointly for the overall model). Use a 10% level of significance. Please note if you are performing a two-tailed test or one-tailed test and justify. d) Demonstrate how ABC, Inc., could use the model for predicting employee salary. Include a sample computation. e) Verify model assumptions (e.g., residual plots) f) Identify any potential problems with the data or model & briefly discuss. g) Explicitly answer: Should ABC, Inc. be worried about possible wage discrimination charges? Deliberate about what additional variables to consider for the model.

Caterpillar, Inc., headquartered in Peoria, Illinois, is an American corporation with a worldwide dealer network which sells machinery, engines, financial products and insurance. Caterpillar is the world's leading manufacturer of construction and mining equipments, -diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. Although providing financial services through its Financial Products segment, Caterpillar primarily operates through its three product segments of Construction Industries, Resource Industries, and Energy & Transportation. Founded in 1925, the company presently has sales and revenues of $55.2 billion, total assets of $78.5 billion, and 114,000 employees. Caterpillar machinery are commonly recognized by its trademark “Caterpillar Yellow” and it's “CAT” logo. Some of its manufactured construction products include: mini excavators, small-wheel loaders, backhoe loaders, multi-terrain loaders, and compact-wheel loaders. Other products include: machinery in mining and quarrying applications, reciprocating engines and turbines in power systems, the remanufacturing of CAT engines and components, and a wide range of financial alternatives to customers and dealers for Caterpillar machinery and engines.

Caterpillar tractors have undertaken and completed many difficult tasks since the company's beginning. In the late 1920s, the Soviet Grain Trust purchased 2,050 Caterpillar machines for use on its large farm cooperatives. This sale helped to keep Caterpillar's factories busy during the Great Depression. In the 1930s, Caterpillar track-type tractors helped construct the Hoover Dam, worked on the Mississippi Levee construction project, helped construct the Golden Gate Bridge, and were used in the construction of the Chesapeake & Delaware Canal. During this time period, CATs were also used in construction projects around the world in countries such as Palestine, Iraq, India, Canada, the Netherlands, Belgium and the building of the Pan American Highway. In World War II, Caterpillar built 51,000 track-type tractors for the U.S. military.

In the 1940s, Caterpillar tractors were used in the construction of the Alaskan highway; and between 1944 and 1956, they were used to help construct 70,000 miles of highway in the United States. In the 1950s and 60s, usage of Caterpillar tractors around the world exploded and were used in such countries as Australia, Austria, Ceylon, France, Germany, Italy, Nigeria, Philippines, Rhodesia, Russia, Sweden, Switzerland, Uganda, and Venezuela, in a wide variety of projects. In addition, Caterpillar products were used to help construct the St. Lawrence Seaway between Canada and the United States. In the 1970s and 80s, Caterpillar equipment were used in numerous dam, power, and pipeline projects. Since then, Caterpillars have been used in the construction of several projects such as Japan's Kansai International Airport as a marine airport approximately three miles offshore in Osaka Bay, the Chunnel between France and England, the “Big Dig” in Boston, Panama Canal expansion, and several Olympic Games sites.

Discussion

1. The United States Department of Agriculture (USDA), in conjunction with the Forest Service, publishes information to assist companies in estimating the cost of building a temporary road for such activities as a timber sale. Such roads are generally built for one or two seasons of use for limited traffic and are designed with the goal of reestablishing vegetative cover on the roadway and adjacent disturbed area within ten years after the termination of the contract, permit, or lease. The timber sale contract requires out sloping, removal of culverts and ditches, and building water bars or cross ditches after the road is no longer needed. As part of this estimation process, the company needs to estimate haul costs. The USDA publishes variable costs in dollars per cubic-yard-mile of hauling dirt according to the speed with which the vehicle can drive. Speeds are mainly determined by the road width, the sight distance, the grade, the curves and the turnouts. Thus, on a steep, narrow, winding road, the speed is slow; and on a flat, straight, wide road, the speed is faster. Shown below are data on speed, cost per cubic yard for a 12 cubic yard end-dump vehicle, and cost per cubic yard for a 20 cubic yard bottom-dump vehicle. Use these data and simple regression analysis to develop models for predicting the haul cost by speed for each of these two vehicles. Discuss the strength of the models. Based on the models, predict the haul cost for 35 mph and for 45 mph for each of these vehicles.

A wastewater plant needs to reduce the methane content in water in a stripping tower to 0.3 mol %. The liquid stream is entering the tower with a flow rate of 200 mole/h and contains 0.8 mol % methane. The tower uses pure air for stripping and its temperature and pressure are held constant at 300 K and 1 atm, respectively. The equilibrium relation for methane in the air-water system is ? = 1.2?. a) Find the minimum vapor flow rate required to achieve this separation. B) Find the number of stages required if the vapor flow rate is taken as 1.2 ???? ′ .

Quantitative Methods in BUSN

Solve this problem using Excel Solver

1. Devos Inc. is building a hotel. It will have 4 kinds of rooms: suites where customers can smoke, suites that are non-smoking, budget rooms where the customers can smoke, and budget rooms that are non-smoking. When we build the hotel, we need to plan for how many rooms of each type we should have. The following are requirements for the hotel:

1. We want to figure out how many rooms of each type to build based on maximizing revenue if we fill up the hotel. We expect to charge $190 for a suite that is non-smoking and $140 for a budget room that is non-smoking. Smoking room customers for both suites and budget rooms will have to pay an additional $20 per night.
2. We can spend up to $7,500,000 on construction of our hotel. The cost to build a non-smoking budget room is $12,000. The cost to build a non-smoking suite is $15,000. It is $3,000 additional for a smoking room of either type for smoke detectors and sprinklers.
3. We require that the number of budget rooms be at least 1.5 times the number of suites, but no more than 3 the number of suites.
4. There needs to be at least 80 suites, but no more than 200.
5. Industry trends recommend that smoking rooms should be less than 50% of the non-smoking room and in addition, we require our builder gives us at least 4 smoking rooms.

Answer the following using your Solver answers:

1. How many of each room type should be built, and what would the revenue be for a night when our hotel was fully booked?
2. Without re-running Solver, what happens to our revenue if we get an additional $1,500,000 for building? Explain in words how you got this answer without re-running solver. Over what amount of construction costs can you use this procedure?
3. Over what range of room price can our budget non-smoking rooms vary over for us to get the same answer for the quantity of each type of room?

Consider the solution of the differential equation y′=−3yy′=−3y passing through y(0)=0.5y(0)=0.5.

A. Sketch the slope field for this differential equation, and sketch the solution passing through the point (0,0.5).

B. Use Euler's method with step size Δx=0.2Δx=0.2 to estimate the solution at x=0.2,0.4,…,1x=0.2,0.4,…,1, using these to fill in the following table. (Be sure not to round your answers at each step!)

C. Plot your estimated solution on your slope field. Compare the solution and the slope field. Is the estimated solution an over or under estimate for the actual solution?
A. over
B. under

D. Check that y=0.5e−3xy=0.5e−3x is a solution to y′=−3yy′=−3y with y(0)=0.5y(0)=0.5.

Consider two countries, Germany and Italy, which produce two goods, beer and cheese. The labour requirements (in hours) for producing one unit of these goods in each country are:

Which country has the absolute advantage in the production of beer and which in the production of cheese? (Mark: 0.2)

Which country has the comparative advantage in the production of beer and which in the production of cheese? Describe the pattern of trade. (Mark: 0.6)

Determine the range of the international relative price defined as the price of beer over the price of cheese. (Mark: 0.2)

country with the lower productivity, can be competitive in the good they specialize. (Mark: 1.0)

Calculate the percent yield of the aldol condensation-dehydration reaction.

I did the following

Put 0.8 mL aldehyde, 0.2 mL ketone, 4 mL ethanol, 3 mL of 2M sodium hydroxide in a flask. Then swirled it for 15 min. Then I added 6 mL ethanol and 4 mL of 4% acetic acid. I put the solution on ice and crystals formed. I ended up with 0.305 g of product. Please show me how to calcualte my percent yield for my product.

The following data is the unemployment rate in a metropolitan community over the last 10 years. Use exponential smoothing with a smoothing constant of a = 0.2, 0.4, 0.6, and 0.8 to find the best forecast for unemployment for next year. Using mean absolute deviation which forecast constant provides the best prediction of unemployment? Why?

Please show work

The unemployment rates in the United States during

1. A ten year period is given in the following table. Use exponential smoothing to find the best forecast for next year. Use smoothing constants of 0.2, 0.4, 0.6, and 0.8. Which one had the lowest MAD?

1.a We have 12 dice: 8 are regular and 4 are irregular. The probability of getting a 3 with an irregular dice is twice the probability of anyone of the rest of the numbers. 1) Find the probability of getting a 3 2) If we have got a 3, find the probability of being tossed with a regular dice 3) Find the probability of getting a 3 with an irregular dice (0.8 points)

1.b Which one is true and why? P(A|B) + P(B|A) = 1 or P(A|B) + P(Ac|B) = 1 (0.2 points)