What observational unit is identified in the file

Assignment Help Accounting Basics

Reference no: EM132641644

Question - Background Information Bibitor, LLC is a retail liquor company with over 75 locations throughout the state of Lincoln. They sell spirits and wine products. Bibitor, LLC has been serving the area for over 50 years. Their wine and spirits selection is hand-picked and focused on value. Their employees are trained as personal beverage concierges and provide unmatched service to all customers. There are over 12,000 brands throughout the organization. 2 Task The CFO has performed a review of Bibitor's overall gross margin percentage, and it appears reasonable based on the typical retail mark-ups for wine (50%) and spirits (30% - 35%). However, the CFO would like to identify whether any brands have gross margins that are negative or zero. She has asked for your help in finding the right data for this analysis. 3 Steps 1. Review the files in the folder "BibitorCaseData". For each file:

(a) What observational unit is identified in the file?

(b) What attributes do columns represent? What type of data is contained in these attributes? (e.g., is the data quantitative or qualitative?)

1. What properties should a key have?

2. Select the data that are most relevant for the CFO's request.

3. Identify any data issues that might interfere with your analysis.

4. Is it possible that a product could have different sale prices at different locations? How would you determine if this is the case?

5. What will the final dataset you give to the CFO look like?

Reference no: EM132641644

Questions Cloud

How much will be in the Deferred Rent Revenue account : How much will be in the Deferred Rent Revenue account by the end of the year, after the adjusting entries have been prepared and posted

What should be the tax consequences to Nell and Kirby : What should be the tax consequences to Nell and Kirby if the following, considered individually, became part of the agreement

Focus on empowering leadership : This journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams,

What does advertisement reveal to about internet presence : What does this advertisement reveal to you about your own internet presence? Why do you think this advertisement is being shown to you?

What observational unit is identified in the file : What observational unit is identified in the file? What attributes can serve as "keys" for identifying observations of interest and combining data across tables

Evaluate the deficiencies in internal controls : Evaluate the deficiencies in internal controls and corporate governance at Navistar. Do you believe external auditors should be expected to discover fraud

Advise louise as to whether monique has validly resigned : Case - HYDRO FRACKING LTD - CORPORATE GOVERNANCE ISSUES Advise Louise as to whether Monique has validly resigned as a director of the company.

Calculate Lisa Net Capital Gain for the year ending : You are required to calculate Lisa's Net Capital Gain (loss) for the year ending 30 June 2020 based on the above information provided

How would reduce medical costs in community : What recommendations do you have for solving this issue and improving the health of your community? How would you reduce medical costs in your community?

User Account

All Pages