Mathematics Homework Solutions

A problem on Regression is solved in this posting using Excel data Analysis. A complete Interpretation of the Excel output for Regression is given with explanation enabling students to interprete the Regression output of Excel.

*Please show all work, use excel and identify the value and units measured. (Notes for my own Use: Ch8: 6) The National Transportation Safety Board collects data by state (including the District of Columbia) on traffic fatalities. Part of this data is shown in the following table. along with potentially related factors incl ...continues

Modeling and Optimization : Staffing Levels

Scheduling staff. You are the director of the Computer Center for Gaillard College and rewponsible for scheduling the staffing of the center, which is open from *a.m. until midnight. You have monitored the usage of the center at various times of the day and determined that the following number of computer consultants are req ...continues

Mixed Integer Problem

The Weithoff company has a contract to produce 10000 garden hoses for a customer. Weithoff has 4 different machines that can produce this kind of hose. because these machines are from different manufacturers and use differing technologies, their specifications are not the same. machine fixed cost ...continues

Case: The Racquetball Racket - It is early in 1999, and a friend of yours has invented a new manufacturing process for producing racquetballs.

Use excel and identify the value and units measured. MBA: Management Science: Ch5 #13 *Please show all work, use excel and identify the value and units measured. Review the Racquetball Racket case below. Develope a problem statement and influence diagram as preliminary steps. Design a spreadsheet to evaluate the Net P ...continues

Quantitative Analysis - The number of cars arriving per hour at Lundberg's Car Wash

I have some Quantitative Analysis questions I need help understanding. 1-15 The number of cars arriving per hour at Lundberg's Car Wash during the past 200 hours of operation is observed to be the following: # of Cars arriving Frequency 3 or less 0 ...continues

Waiting Lines and Queuing Theory Models

The problem is this: In planning for a major redesign, Beth collected data at her store on several consecutive Saturday mornings. She noticed that customers arrived at the checkout at a rate of approximately 100 per hour. Fully 20 percent of the customers had 10 items or less. Those people took about 2 minutes to serve on av ...continues

Differential Equations : Predator / Prey Models

Part a) Given the following predator prey model where x(t) is the predator population and y(t) is the prey population: dx/dt = - ax + bxy + (z1)*x dy/dt = cy – gxy +(z2)*y Here both z1 and z2 can be positive or negative; parameters a, b, c, g are all defined to be positive. Parameters z1 and z2 can r ...continues

Martin Pullin Inventory Plan Calculations

I need your help in checking my caculation the attached inventory plan table for Martin-Pullin Bicycles Corp. My other calcualtions on the case are also included on the spreadsheet, I now need to calculate the inventory table, (there are two tabs on the spreadsheet). The key thing is to set up the inventory plan correctly, a mon ...continues

Quantitative Methods - The production manager for the Whoppy soft drink company is considering the production of 2 kinds of soft drinks: regular and diet.

I need help finding a solution to the below problems for Quantatitive Methods. 15. The production manager for the Whoppy soft drink company is considering the production of 2 kinds of soft drinks: regular and diet. The company operates one “8 hour” shift per day. Therefore, the production time is 480 minutes per day. During ...continues

Waiting Line Models

The Sea View Resort uses a multiple-channel queue registration system. If the average service time is 9 minutes, there are three registration clerks, and guests arrive at the rate of one every 6 minutes, find a. Arrival and service rate. b. the probability all three clerks are idle. c. the probability a g ...continues

Browse