Purchase Solution

Solving 7 questions on various topics

Not what you're looking for?

Ask Custom Question

Problem 1
Suppose a manufacturing company makes a certain item. The time to produce each item is normally distributed around a mean of 157 minutes with a standard deviation of 46 minutes.

(a) What proportion of the items will take more than 2 hours to make?
(b) What proportion of the items will take between 160 and 200 minutes to make?

Problem 2
The average prices for a product in 12 stores in a city are shown below.

$2.99, $2.15, $3.25, $3.55, $3.00, $2.99, $2.66, $3.50, $3.20, $2.15, $3.75, $3.85

Test the hypothesis that the average price is higher than $2.57. Use level of significance  = 0.05.

Problem 3
A store wishes to predict net profit as a function of sales for the next year. The following table gives the years 1998 to 2005.

Year Sales
(thousands of dollars) Net Profit
1998 51 7
1999 55 9.2
2000 65 9.6
2001 82 -3
2002 75 2.5
2003 71 3.2
2004 82 -2.3
2005 81 -2.6

(a) Graph the points from 1998 through 2005 on a scatter diagram using Sales as the independent variable and Net Profit as the dependent variable.
(b) Draw the regression line on the graph you constructed in Part (a).
(c) What is the value of the coefficient of determination for this regression model? Comment on the strength of the regression line for this model.
(d) What is the predicted net profit for 2006 if sales are expected to be 105?
 
Problem 4
Last week's sales of iMac computers at an Apple Store in Oklahoma City, OK, are shown in the following table:

Day Sales (Dollars)
1 160
2 150
3 200
4 215
5 195
6 205
7 220

(a) Use the exponential smoothing with α = 0.25 to predict the most immediate future sales.
(b) Use the 3-day weighted moving average method for forecasting days 4-7. Use Weight 1 day ago = 3, Weight 2 days ago = 5, and Weight 3 days ago = 2.
(c) Compare the techniques using the mean absolute deviation (MAD).

Problem 5
The following table shows six years of average annual cost-of-living index data:

Year Annual Cost of Living Index
2008 102.8
2009 101.4
2010 111.9
2011 124.3
2012 138.6
2013 135.2

(a) Forecast the average annual food price index for all years from 2008 to 2013. Use a 3-year weighted moving average with weights of 0.6, 0.3, and 0.1. Use the largest weight with the most recent data.
(b) Forecast the average annual food price index using exponential smoothing with α = 0.4 for all years from 2008 to 2014. Use the rate for 2008 as the starting forecast for 2008.
(c) Which of the methods in parts (a) and (b) produces better forecasts for the 3 years from 2011 to 2013? Answer on the basis of mean square error (MAD).
 
Problem 6
A company manufactures two products, Product A and Product B. The wholesale price and manufacturing cost of each product are shown below.

Item Price Cost Assembly Times (hr)
A $70 $10 10
B $70 $20 5

The company will produce a minimum of 2,000 units of type A and 5000 units of type B. Suppose the company has a budget of $200,000 and 80,000 hours of assembly time available.

(a) How many of each item should it produce in order to maximize profits while meeting all necessary constraints? Give the LP model and use the graphical method to find the optimal solution.

Final Solution:
Number of units of item A: ________________

Number of units of item B: ________________

The Maximum Profit: ________________

(b) Solve the problem by using the Excel Solver. Then without solving the problem again, use the Excel reports to answer the following question. You must state exactly what portion of the Excel reports you have used.

If an additional 4000 hours are added to the assembly line, how much will the optimal profit increase as a consequence?

Problem 7
A commercial real estate company is evaluating a proposed warehouse. The proposed site is near a rail terminal, but the state government may extend the highway to the area. In addition, the federal government is considering rebuilding the local port facilities. Below is the payoff table in monthly profit depending upon what government actions are taken. Based on the following criteria, what are the correct choices for terminal rental?

(a) Equally likely or principle of insufficient reason criterion
(b) Minimax Regret criterion
(c) Find the EVPI (The expected value of perfect information). Use equal probabilities for the states.

Warehouse size (ft2) Development projects
Rail terminal only Highway expansion Port rehabilitation All
15000 10 25 35 40
30000 15 25 40 50
60000 20 30 45 75
100000 15 20 40 90

Attachments
Purchase this Solution
Solution Summary

The solution gives detailed steps on solving 7 questions. The topics are regression, forecasting, linear programming and optimal value.

Solution Preview

I attach 3 files. One is word to answer all questions, one is excel for problem 6(b), one is excel for reference.

1. Copy and paste all necessary data from Excel into this document and create tables as needed.
2. For problem 6 part b, the corresponding Excel workbook should be submitted as a second attachment along with the completed Word document.

Problem 1
Suppose a manufacturing company makes a certain item. The time to produce each item is normally distributed around a mean of 157 minutes with a standard deviation of 46 minutes.

(a) What proportion of the items will take more than 2 hours to make?

First 2 hours=120 minutes.
We know that Z=(X-mu)/sd where in this case X=120, mu=157 and sd=46.
So P(X>120)=P(Z>(120-157)/46)=P(Z>-0.80)=0.7881 from standard normal table.

(b) What proportion of the items will take between 160 and 200 minutes to make?

P(160<X<200)=P((160-157)/46<Z<(200-157)/46)=P(0.0652<Z<0.9348)=0.2991 from standard normal table.

Problem 2
The average prices for a product in 12 stores in a city are shown below.

$2.99, $2.15, $3.25, $3.55, $3.00, $2.99, $2.66, $3.50, $3.20, $2.15, $3.75, $3.85

Test the hypothesis that the average price is higher than $2.57. Use level of significance  = 0.05.

The calculations of mean and sd are done by excel with following output:

Data 2.99 2.15 3.25 3.55 3 2.99
2.66 3.5 3.2 2.15 3.75 3.85
Mean 3.09
Sd 0.56

So we know that T=(Xbar-mean)/(sd/sqrt(n)) where in this case n=12, Xbar=2.57, mean=3.09 and sd=0.56.
So test statistic=(2.57-3.09)/(0.56/sqrt(12))=-3.22
Now with df=n-1=12-1=11 and alpha=0.05, the critical vaue=-1.80 from t table.
Since -3.22<-1.80, we reject Ho.
Hence, we have evidence to say that the average price is higher than $2.57.

Problem 3
A store wishes to predict net profit as a function of sales for the next year. The following table gives the years 1998 to 2005.

Year Sales
(thousands of dollars) Net Profit
1998 51 7
1999 55 9.2
2000 65 9.6
2001 82 -3
2002 75 2.5
2003 71 3.2
2004 82 -2.3
2005 81 -2.6

(a) Graph the points from 1998 through 2005 on a scatter diagram using Sales as the independent variable and Net Profit as the dependent ...

Purchase this Solution
Free BrainMass Quizzes
Probability Quiz

Some questions on probability

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

View More Free Quizzes
Related BrainMass Solutions

  • Problem Solving, Memory & Vision

    This solution assists with one multiple choice exercise on various topics e.g. problem solving, memory, vision, etc.

  • Steps on Solving Discrete Questions

    The solution gives detailed steps on solving a couple of discrete questions. The topics include Binomial Theorem, coefficient of terms, reflexive property, anti-symmetric property, transitive property and partial order.

  • Solving for Various Algebraic Equations

    So f-1(x)=5x/(3x-4) The solution gives detailed steps on solving various algebra questions: finding the midpoint of segment, finding the equation of line if it is parallel or perpendicular to given line, finding the intercept of given equation, computing

  • Explanation of how to conduct meetings

    Many leaders have found that a meeting where team members openly communicate on various topics and participate in problem solving yields better results and outcomes.

  • Gathering Interview Questions

    545406 Gathering Interview Questions Requirement Gathering Interview Questions: Put together between 1-20 Questions on the following topics. Please Put the Requirement Gathering Interview Questions into a template Format.

  • Control Concepts, Methodes & Reliability

    The Questions are attached. Please see the attached file. X-charts, R-charts were prepared for various problems.

  • Facilitating Problem Solving, and Devil's Advocacy Technique

    Analysis Overall, ratings of the questions, using the Likert Scale, are on the high end, with many questions rated at 4 or 5.

  • Algebra equations

    Make square on both sides and we get Topics in this set include solving by graphing, word problems for mixtures and dilutions, rationalizing denominator, and volume of a sphere.

  • 40 Multiple choice Questions- Auditing

    271620 Auditing Attach sheet details the questions. The answer are in bold in the sheet. 40 Multiple choice Questions- Auditing on various topics

  • Managerial Econ: Marginal Revenue Cost of Labor/Price Elasticity

    Problem-solving question: Use the following data on a firm's total cost schedules to calculate its average variable cost, average fixed cost, average total cost, and marginal cost schedules.

View More Related Solutions