User Account

All Pages

What would the total profit for each type of wine be

Assignment Help Accounting Basics
Reference no: EM131918736

Question: Overview: It is essential for a business professional to develop spreadsheet software skills for analyzing a variety of business situations using quantitative means. This project takes a hands-on approach by placing you in a real-world context. You will utilize technical concepts to interpret a business framework and apply selected quantitative techniques to arrive at accurate information that can be used for sound decision-making.

Specifically, you will assume the role of a business analyst working for a winery in northern California. In this milestone, you are provided a set of raw data, and from that data set, you must respond to questions from management. You will calculate and present your answers in a consumable way using spreadsheet software.

Prompt: To complete this assignment, review the questions below and examine the Final Project Excel Functions spreadsheet. Then, select a function that you believe will help you to answer the following questions.

Specifically, the following critical elements must be addressed:

1. For white and organic wine, what were the measures of central tendency based on the sales figures?

2. What would the total profit for each type of wine be given the following production costs for the wine: white wine is 17% of total sales, red wine is 12%, and organic wine is 21%?

3. Deduct the sales commission discussed in question 2 from Milestone Two: Data Analysis Part II and recalculate. Draft and present the answers graphically.

4. How would you summarize the provided data? Develop pivot tables using the cleansed data to illustrate.

Information related to above question is enclosed below:

Attachment:- milestone1.rar

Reference no: EM131918736

Questions Cloud

What is the amount of the current of the second wire : Due to the total magnetic field from both wires at that point, the magnetic force on the charge is 26 x 10-7 Newtons in the +z direction.
Which change model you would follow for short-term change : Provide rationale for your decision and discuss the effects that these changes would have on the employees, managers, and executives within the organization
Average balance in accounts payable and accounts receivable : What is the company’s average balance in accounts payable and accounts receivable?
Explain the occurrence of crime : Provide theoretical support where needed, to include recommendations on crime control and crime reduction policies.
What would the total profit for each type of wine be : What would the total profit for each type of wine be given the following production costs for the wine: white wine is 17% of total sales, red wine is 12%.
Circle on the banked surface : There is no friction or air resistance, the mass is m=20kg. How fast must it go to stay in the circle? l=8.7m theta=30 degrees
Movement of h2o in the biosphere : The movement of H2O in the biosphere is governed by the chemical potential of H2O (also called the "water potential").
What are some countries that have a mixed economy : Do you agree with this classification? What you think is the Mixed Economy? What are some countries that have a Mixed Economy?
Explain the different definitions of terrorism : The Department of Defense includes the threat of violence. The Federal Bureau of Investigation notes that terrorism is illegal.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Use the results from part 2 to allocate costs from each of

health co-op is an outpatient surgical clinic that wants to better understand its costs. it decides to prepare an

  What are the strengths and weaknesses of carpenter proposal

How do you think the division managers will receive the new proposal? What are the strengths and weaknesses of Carpenter's proposal relative to the existing.

  Preparing a journal entry for carlton company

Prepare a journal entry for carlton company sells office equipment on sept.2007, for $21,000 cash. the office equipment originally cost $72,000 and as of Jan.1 2007 had accumulated deprication of $42,000. Depreciation for the first 9 months of 200..

  Don is the beneficiary of a 50000 insurance policy on the

don is the beneficiary of a 50000 insurance policy on the life of his mother anna. to date anna has paid premiums of

  Prepare variable costing comparative income statement

Prepare variable costing comparative income statement for 2014 and 2015

  Describe your experience in finance and accounting

Describe your experience in finance and accounting including professional and personal budgeting. Share what you consider to be important when making a significant financial decision, such as buying/leasing a car expanding a small business or decidin..

  Calculate operating profit for the first quarter of the year

Brighton Services repairs locomotive engines. Calculate operating profit (loss) for the first quarter of this year under actual and normal costing systems.

  Shelby manufacturing produces car parts the company has a

shelby manufacturing produces car parts. the company has a variable cost per unit of 150 and fixed costs of 200000. the

  Based on past experience it is estimated that 30 of a

cash receipts budget flagstaff co. has actual sales for july and august and fore-cast sales for september october

  What are the equivalent units for materials

What are the equivalent units for materials and for conversion costs, respectively

  Prepare a cost of production summary for the month

The Joan Company uses the process cost system and average cost method. Prepare the journal entries to record production for the month

  Prepare slatons entry to record the exchange

Slaton Corporation traded a used truck for a new truck. The used truck cost $20,000 and has accumulated depreciation of $17,000. The new truck is worth $35,000.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd