Reference no: EM131267162
Question: PM Computer Services assembles customized personal computers from generic parts. The company was formed and is operated by two part-time university students, Paul and Bryan. The company has experienced steady growth since started. The computer parts are bought using volume discounts when good deals can be found. As such it is important that they develop a good model to forecast demand for their computers so that they will know how many computer components parts to purchase and stock.
The company has accumulated computer demand data over a 12-month period. The data are shown in the Excel worksheet tab named "PM"
a. Using the Excel Insert Tab Line Graph and follow-up Chart Tools Tabs, construct an appropriate line chart displaying the time pattern of computer demand data. Please create a professional appearing chart with labeling and titles. A legend is probably not needed. Move the chart so that it starts in cell J4 and fits within the red shaded area. Is the time pattern stationary? Yes or No in cell M3.
b. Using StatTools, create the Optimal Parameters Exponential Smoothing (Simple) forecast incorporating only Forecast Overlay and Forecast Errors Charts. Anchor the output in cell A1 of the StatTools PM Worksheet.
c. Using StatTools, create the Optimal Parameters Exponential Smoothing (Holt's) forecast incorporating only Forecast Overlay and Forecast Errors Charts. Anchor the output in cell G1 of the StatTools PM Worksheet.
d. In the blue area designated Analysis, provide a managerial analysis for Paul and Bryan incorporating any patterns you have identified, recommending a forecasting method (with reasons), and providing your best forecast for the upcoming month.
|
Improve efficiency in processing data in excel
: Describe a situation in a work environment where the use of macros would improve efficiency in processing data in Excel. Identify the likely challenge(s) you would face in developing the macros, and suggest a plan for addressing the challenge.
|
|
What is the probability that one throw of two dice one red
: Two cards are drawn without replacement from a deck of 52 cards. What is the probability of drawing two queens?. What is the probability that one throw of two dice (one red and one green) will result in a sum of 10? A bag contains 3 white marbles and..
|
|
Average rate of change calculations
: The Average Rate of Change function describes the average rate at which one quantity is changing with respect to something else changing. Give an example of an everyday average rate of change calculations. Discuss how knowing this information help..
|
|
How did burger king manage the negative publicity
: What do you think of Burger King's advertising tactics? Is it OK to attract new customers while alienating others? Is Burger King's advertising ethical? Explain.
|
|
Construct an appropriate line chart displaying time pattern
: Using the Excel Insert Tab Line Graph and follow-up Chart Tools Tabs, construct an appropriate line chart displaying the time pattern of computer demand data. Please create a professional appearing chart with labeling and titles
|
|
Explain the role of each p in software engineering
: Effective software project management focuses on the four P's: people, product, process, and project. Explain the role of each P in software engineering.
|
|
Make a box size program using sublime text
: Make a box size program using Sublime text in which the box adjust itself according to monitor screen size.
|
|
Develop performance standards for the shift workers
: Develop performance standards for the shift workers, identify appropriate methods of performance appraisal, and develop appropriate training to help get them back on track.
|
|
Differences between a switch and a router
: What are the similarities and differences between a switch and a router? What are the advantages to using switches and routers?
|