Norther Napa Valley Winery Case Study

1944 words - 8 pages

Nova Southeastern University
H. Wayne Huizenga School
of Business & Entrepreneurship
 
Assignment for Course: | QNT5040 |
Submitted to: | Dr. P. Rokicki |
Submitted by: |
|
|
|
|
Date of Submission: 11 March 2013
Title of Assignment: Case Study of Northern Napa Valley Winery

CERTIFICATION OF AUTHORSHIP: I certify that I am the author of this paper and that any assistance I received in its preparation is fully acknowledged and disclosed in the paper. I have also cited any sources from which I used data, ideas or words, either quoted directly or paraphrased. I also certify that this paper was prepared by me specifically for this course.
Student's Signature: ...view middle of the document...

Frog’s Leap now makes its home in the heart of Rutherford in the historic Red Barn. Frog’s leap is known for its iconic Red Barn, relaxed atmosphere, and environmentally friendly operations.

In September of 2008 Quintana was considering an offer from TransContinental Stores to purchase her the excess grapes from Northern’s 2008 harvest. Prior to making a decision Quintana would have to examine the quantity her company had available to sell after using what she needed.

Problem
Quintana wishes to forecast her sales as accurately as possible so as to know what amount of excess grapes she will have available to sell to Transcontinental for 2008.

Analysis

As a first step it is necessary to understand the data in Exhibit 1 and there are a few ways of getting an idea of the data visually. The first is by examining the Monthly Wine Sales for Northern visually and then plugging in the data into a StatTools One Variable Summary.

Table 1 - Exhibit 1: Northern Napa Valley Winery – Monthly Wine Sales 2000-2008

In the data given above we see that the months of September 2008 to December 2008 is blank. This is the area of time that Quintano desires accurate forecasting. Next it is necessary to examine the One Variable Summary below.

Table 2 - One Variable Summary

StatTools Report |
Analysis: | One Variable Summary |
Performed By: | diegoandres |
Date: | Friday, March 01, 2013 |
Updating: | Live |
| |
| Total Sales |
One Variable Summary | Forecasting |
Mean | 11498.47 |
Variance | 12991521.53 |
Std. Dev. | 3604.38 |
Skewness | 1.0691 |
Kurtosis | 4.4020 |
Median | 10933.00 |
Mean Abs. Dev. | 2709.49 |
Mode | 10723.00 |
Minimum | 6385.00 |
Maximum | 23609.00 |
Range | 17224.00 |
Count | 104 |
Sum | 1195841.00 |
1st Quartile | 8820.00 |
3rd Quartile | 13349.00 |
Interquartile Range | 4529.00 |
1.00% | 6520.00 |
2.50% | 6534.00 |
5.00% | 6692.00 |
10.00% | 7133.00 |
20.00% | 8395.00 |
80.00% | 14028.00 |
90.00% | 15337.00 |
95.00% | 18821.00 |
97.50% | 21951.00 |
99.00% | 22207.00 |

The One Variable Summary provides a broad analysis with relevant information such as the mean, standard deviation, median, mode, minimum, maximum, range and the sum of revenue for the time given in Exhibit 1.

To get a visual understanding of this same data it is necessary to use a QQ Plot as the one below which demonstrates a normal looking data set.

Graph 1 - QQ Plot

Graph 2 - Box and Whisker Plot

The Box and Whisker plot above illustrates the growth in revenue and the outliers in the data in a visual manner. We can see by this plot that there is a general trend of growth with increasing outliers and range. While erratic numbers may be an indication of more than just noise, but also of randomness, there are 4 methods that can be used to test to see if the data is random. However from the visual data above it does not seem likely that the data is random.

We do that...

Other Essays Like Norther Napa Valley Winery Case Study

Nike Case Study/3 Segments Promotion

1129 words - 5 pages . Consumer behaviour, segmentation by sex,age and other parameters is more difficult issue as it is not widely published and these pieces of information are provided as a part of market report by marketing research companies. We used “Key notes” reports which are available for the students registered at UWIC website. Case study The case provided by Harvard business school is entitled as “Nike Football: World Cup 2010 South Africa”. It covered

Business Law 531 Week 6 Final Examination

2305 words - 10 pages under the corporate protection rule. d) Ted is not liable under the business judgment rule. 18. Which of the following is also called “judgemade” law? a) Statutes b) Equity c) Uniform acts d) Common law Find the final exam answers here UOP Complete Course Tutorials 19. Reggie went to the Napa Valley Harvest Festival, when he stopped at Tracy’s booth where she was selling paintings of vineyards. Reggie admired a painting of

Uop Business Law 531 Final Exam Question Answers

2271 words - 10 pages exam answers here UOP Complete Course Tutorials 19. Reggie went to the Napa Valley Harvest Festival, when he stopped at Tracy’s booth where she was selling paintings of vineyards. Reggie admired a painting of vineyards that did not appear to be for sale. Reggie said to Tracy, “I will give you $200 for that painting right now.” Tracy said nothing in response but she gave Reggie the painting, and Reggie gave her $200 in cash. This is an

Law 531 Final Exam 30 Questions with Answers

2315 words - 10 pages . b) Ted is liable under the various liability rule. c) Ted is not liable under the corporate protection rule. d) Ted is not liable under the business judgment rule. 18. Which of the following is also called “judgemade” law? a) Statutes b) Equity c) Uniform acts d) Common law Final Exam Answers just a click away LAW 531 Final Exam Test 19. Reggie went to the Napa Valley Harvest Festival, when he stopped at Tracy’s booth where she

Yvw Change Model Analysis

1171 words - 5 pages Change Models Lewin’s three stage application Evidence from case study Unfreeze: The cultural change program began with the management team completing an organisational culture questionnaire, developed by an international consulting company, to determine the preferred culture for the organisation. Management and employees then completed a second organisational culture questionnaire to determine the actual operating culture. Change

Knowledge and Time in García Márquez’s Chronicle of a Death Foretold

4471 words - 18 pages . Because the historical method of investigation alters the object of study, which in this case is Santiago’s death, the practice of history reveals itself to be more structurally rigid than the memories it attempts to chronicle. Within the “kinds of projects one can legitimately conceive,” the historical approach also presupposes a level of authorial objectivity, shown through the impersonal and journalistic persona assumed by the narrator

Case Study

819 words - 4 pages 284 399 239 259 310 322 417 275 274 232 347 419 474 241 205 317 393 516 194 190 361 369 421 478 207 243 411 361 595 303 215 277 419 497 223 304 241 258 341 315 331 384 130 291 258 407 246 195 MBA 643 / February 2012 Case Study 2 3/3 The board has developed the following criteria for making a decision on whether to issue new shares: 1. The expected number of days on which attendance would

Studies Pertaining To The Clinical Aspects Of Malaria

1032 words - 5 pages STUDIES PERTAINING TO THE CLINICAL ASPECTS OF MALARIA Malaria is a complex condition exhibiting different manifestations in different parts of the world depending on a few variables (Bin Mohanna et al. 2007). It was found that anemia and splenomegaly are significantly associated with malaria among asymptomatic schoolchildren in Hajr valley, Hadramout (Bin Mohanna et al. 2007). Agina and Abd-Allah (1999) conducted a case control study for the

Arthur Conan Doyle

611 words - 3 pages Holmes (1894) The Hound of the Baskervilles (1902) The Return of Sherlock Holmes (1904) The Valley of Fear (1915) His Last Bow (1917) The Case-Book of Sherlock Holmes (1927) {text:bookmark-start} {text:bookmark-end} Challenger stories The Disintegration Machine (1927) When the World Screamed (1928) Micah Clarke (1888) The White Company (1891

Area Study: 2 Case Studies Of Areas Around China's Three Gorges Dam, Using A Political Ecology Approach

6444 words - 26 pages outcomes of the TGDP relating to the case study areas and their residents.II. Description of Political Ecology's Conceptual FramePolitical ecology "focuses on the political, economic and social structures and processes which underlie the human practices leading to degradation" (Neumann, 1992, 86). This approach examines (historical) power struggles between people and the land, and between people and people. For example, what are the environmental

Disaster Management

927 words - 4 pages DISASTER MANAGEMENT: A CASE STUDY OF UTTRAKHAND Dr. M. N. Zubairi Faculty of Commerce & Business Management Ranchi University , Ranchi. Nazia Abbas Abidi Faculty of Business Management ,Dr. Zakir Hussain Institute, Ranchi Abstract Every one would be agree that disaster can ruined the life of anyone or demolish the city or the whole geographical area only in a few seconds. We

Related Papers

Case Study: Clover Valley Dairy Company

856 words - 4 pages Case Study: Clover Valley Dairy Company Rebeca Aquino DeVry University Case Study: Clover Valley Dairy Company Statement of the Problem(s) The main issue in this case study is weather a newly developed multipack carrier for yogurt was ready for market testing and, if so, how should Vince Roth, General Manager of the Clover Valley Dairy Company, should perform this testing. Summary of the Facts The Clover Valley Dairy

Mkt 421 Personal Branding Plan Essay

787 words - 4 pages throughout the last couple of years and I live very close to Napa Valley where a wealth of wineries provide opportunities for possible employment. The third choice for a company I would interested in is Jelly Belly. Again this company is out of my current field of insurance but my customer service background would come in handy. Jelly Belly is one of the largest factories in the town I currently live in. After I obtain my Bachelor’s degree I

Business Law 531 Final Exam New Assignments

2442 words - 10 pages under the various liability rule. c) Ted is not liable under the corporate protection rule. d) Ted is not liable under the business judgment rule. 18. Which of the following is also called “judgemade” law? a) Statutes b) Equity c) Uniform acts d) Common law Want to download the Complete Answer..?? Click LAW 531 Week Complete Final Exam Answer 19. Reggie went to the Napa Valley Harvest Festival, when he stopped at Tracy’s booth

A Study On "Impact Of Leather Technology"

2770 words - 12 pages [pic] Department of Accounting Term Paper On A study on the “Impact of Leather Technology of Bangladesh” Supervised by Ganesh Chandra Dey Lecturer Department of Accounting Govt. Asheq Mahmud College, Jamalpur Submitted By A.M. Ahsanur Rahman Tonmoy College Roll: 94 Reg No: 2119731 Roll No: 8101622 Session: 2011-12 Student Type: Regular Department of Accounting Govt. Asheq Mahmud College, Jamalpur