Sta. Elena Winery sells 100,000 gallons of wine a year. It sells 10% of its wine...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
Lets start by calculating the total volume sold in each type of packaging barrels jugs and bottles t... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A reducing elbow in a horizontal pipe is used to deflect water flow by an angle u = 45? from the flow direction while accelerating it. The elbow discharges water into the atmosphere. The cross-...
-
Dom's Pizza Company uses taste testing and statistical analysis of the data prior to marketing any new product. Consider a study involving three types of crusts (thin, thin with garlic and oregano,...
-
The following table presents the percentage of people who lived in poverty in the various regions of the United States in the years 2010 and 2014. a. Construct a side-by-side bar graph for these...
-
Describe the environmental impact-added life-cycle chain. Select one particular industry and list the environmental interventions for each function in the chain. Rank the functions in terms of their...
-
In this task, you will research and present your findings on ammonium lauryl sulfate, also called ammonium dodecyl sulfate.Ammonium lauryl sulfate is a type of surfactant, a cleaning chemical...
-
https://docs.google.com/document/d/1rpVKbsZGeLrUYXR_BjrUyoLGPS3bBD6oXz0gcKt9Rc/edit?usp=sharing need help with this question please b. On a per-unit basis, what would be the recommended increase in...
-
1. What is your assessment of the financial performance of Nelson Nurseries? 2. Do you agree with Christine Barton?s accounts-payable policy? 3. What explains the erosion of the cash balance? 4. What...
-
A company is considering a new project for which the investment data are as follows: Cash Outlay Depreciation Corporate Tax Rate Year Profit before depreciation and after tax (PBDAT) Rs 2,00,000 20%...
-
Use Eclipse IDE for writing a program in JavaFX programming to display the following and explain the layout. Use ClockPance Class. Test 12 3 - 9 12 m 9 6 12 39 16 12 6 6
-
what is an accounting example using the = MATCH function? Like when would that function be needed in the accounting world?
-
Identification and analysis of a Brand's current marketing campaign- Any multinational brand You will evaluate the importance or role of marketing in generating customer value. 1: The marketing mix...
-
A company has estimated the expected cash flows for two mutually exclusive projects as follows: Year Project 0 1 2 3 (RM'000) (RM'000) (RM'000) (RM'000) (RM'000) 1 (600) 400 300 300 100 2 (400) 200...
-
write the function i_join, which takes in only two lists and returns a list that contains lists with i-th elements of two sequences join together. The lengths of two sequences are the same. def...
-
The company is Dunkin Donuts. What was the full impact of the use of Digital or Social Media? Item 1: Was the change created by the use of digital or social media positive or negative (or both) in...
-
On January 1, 2017, McIlroy, Inc., acquired a 60 percent interest in the common stock of Stinson, Inc., for $340,200. Stinson's book value on that date consisted of common stock of $100,000 and...
-
To facilitate a move toward JIT production, AB Company is considering a change in its plant layout. The plant controller, Anita Bentley, has been asked to evaluate the costs and benefits of the...
-
Pricing and impact on demand Andrea Kimball has recently acquired a franchise of a well-known fast-food restaurant chain. She is considering a special promotion for a week during which hamburger...
-
Breakeven analysis and target profit for a hospital Morton Medical Institute operates a 300-bed hospital and offers a number of specialized medical services. Mortons hospital facility and equipment...
-
A reversible process is a process (a) Which proceeds with no driving force (b) Which takes place spontaneously (c) Which is quasi-static (d) Which is frictional process.
-
At constant temperature and pressure, the free energy for a chemically reacting system at equilibrium is (a) Minimum (b) Maximum (c) Can not be predicted (d) None of these.
-
The operation of a throttling device follows the (a) Zeroth law of thermodynamics (b) First law of thermodynamics (c) Second law of thermodynamics (d) Third law of thermodynamics.
Study smarter with the SolutionInn App