What is the expected production in tons of grapes for each of the three variety of grapes (Pinot Noir, Zinfandel, and Chardonnay)?

You will need to prepare a 3-5 slide Power Point (or Google Sheets) presentation to the PBW Owners answering the questions below. In addition, you must include an appendix (Excel) consisting of the calculations you used to make the recommendations and explain the methods you used.

The documents you submit must answer the following questions:

What is the expected production in tons of grapes for each of the three variety of grapes (Pinot Noir, Zinfandel, and Chardonnay)?

How many bottles of wine would you expect to produce given your forecasted harvest quantities (Note: One ton of grapes produces, on average, 2,700 liters of wine)

Based on the pricing provided by PBW, how much should they budget to purchase wine bottles, wine labels, corks, and cardboard storage boxes? (costs for each are provided in the documents)

Requirements: 3-5 slides

Project Phase 1.

Client Overview

PB Winery is a small, family-owned boutique winery located in Paso Robles. The winery has a 5-acre vineyard where it grows a variety of grapes including Zinfandel, Pinot Noir and Chardonnay. Since beginning winemaking operations in 2010, PBW has experienced lower profits and losses due to cost overruns and production issues.

Project Description

You have been engaged by PB Winery to help them improve their operations and turn a profit. In the first phase of this project, you will help them properly forecast their harvest based on historical data and predictions for the factors that affect their harvest. PBW has provided you with a Historical Production

Table and the weather data for the Paso Robles area in 2022.

Deliverables

You will need to prepare a 3-5 slide Power Point (or Google Slides) presentation to the PBW Owners answering the questions below. In addition, you must include an appendix consisting of the calculations you used to make the recommendations and explain the methods you used.

The documents you submit must answer the following questions:

1. What is the expected production in tons of grapes for each of the three variety of grapes (Pinot Noir, Zinfandel, and Chardonnay)?

2. How many bottles of wine would you expect to produce given your forecasted harvest quantities

(Note: One ton of grapes produces, on average, 2,700 liters of wine)

3. Based on the pricing provided by PBW, how much should they budget to purchase wine bottles, wine labels, corks, and cardboard storage boxes?

(costs for each are provided in the documents)