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

  Determine the amount of the adjusting entry

Determine the amount of the adjusting entry to provide for doubtful accounts under each of the assumptions (a through d) listed above

  Discuss mountain goat cycles was operating at capacity

Would it make a difference if Mountain Goat Cycles was operating at capacity

  Compute the materials price variance and the materials

banner company manufactures flags of various countries. each flag has a standard of 8 square feet of fabric and 3 hours

  Grover inc wishes to use the revaluation model

The fair value for the property is $100,000. What amount would be booked to the 'accumulated depreciation' account if Grover chooses to use the proportional method to record the revaluation?

  Calculate the century division contribution margin

Fixed selling and administrative expenses 56,000. Calculate the Century Division's contribution margin

  Determining year-end balance

Damons uses the allowance method to account for uncollectible receivables. At the beginning of the year, allowance for doubtful accounts had a debit balance of $100. During the year you recorded bad debt expense of $1,800 and wrote off bad receiva..

  Discuss the use of adjusting entries in the preparation of

discuss the use of adjusting entries in the preparation of accurate financial

  Metropolitan office of regional public accounting firm

You are the partner-in-charge of a large metropolitan office of a regional public accounting firm. Two members of your professional staff have come to you to discuss problems that may affect the firm's independence. Neither of these situations has..

  Write report to chairpersons of financial reporting council

ACC307 Individual Assignment Question. Attempts to bring about radical change through the introduction of a conceptual framework have failed

  Journalizing and posting adjustments to the t-accounts

Journalizing and posting adjustments to the T-accounts and preparing an adjusted trial balance - Journalize the adjusting entries on December 31.

  Computing budgeted purchases for fourth quarter

A Company forecasts sales of $91,500 for the quarter ended December 31. Its gross profit rate is 18% of sales, and its September 30 inventory is $25,000. If the December 31 inventory is targeted at $7,500, budgeted purchases for the fourth quarter..

  Calculate its book value at the end of year 6

The company uses straight-line depreciation. Calculate its book value at the end of year 6

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