Answered step by step

Verified Expert Solution

## Question

1 Approved Answer

# Sta. Elena Winery sells 100,000 gallons of wine a year. It sells 10% of its wine in barrels, 60% in jugs, and 30% in

## Sta. Elena Winery sells 100,000 gallons of wine a year. It sells 10% of its wine in barrels, 60% in jugs, and 30% in 1-liter bottles. Its base selling price is $2 per gallon in barrels. The selling price of wine in jugs is 25% higher than in barrels; for wine bottles, it is 40% higher. a. b. Set up a spreadsheet model to determine total revenues for Sta. Elena. Start with total volume of wine in gallons and then set up cells (i.e. show the formula or equation) to determine volume for barrels, jugs and 1-liter bottles. c. Then set up cells to calculate revenue per type of packaging. d. Next, set up the cell for the total revenue e. Finally set up the cell that computes average selling price per gallon. f. Use your model and a calculator to answer the following questions: 1. How much revenue is provided for by the sale of wine in barrels? In jugs? In bottles? Total? 2. What is the average selling price in dollars per gallon?

## Step by Step Solution

★★★★★

3.51 Rating (161 Votes )

There are 3 Steps involved in it

### Step: 1

RealLife Example Imagine you own a small boutique winery that produces 50000 gallon...### Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

### Step: 2

### Step: 3

## Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started