Reference no: EM131055253
Assignment Overview
You are working as a data analyst for the Excellent Consulting Group. Your client, Buddy's Floor Barn, wants to analyze how they are doing in their 18 locations in four regions across their five product lines over the last 3 quarters. Each Regional Manager has compiled the data for his/her region showing the sales revenue for each of the five product lines (premium flooring) for each of the first three quarters.
Case Assignment
Assemble the data from each Store Manager into a data table in list format. And then generate Pivot Table Report. Use this report to analyze the data to answer Buddy's questions. Write a business report to Buddy's Floor Barn that provides the answers and discusses the issues.
Data: Download Case 1-Data.xlsx with the data from the four regional managers for the first three quarters showing sales of their five premium flooring products.
Assignment Expectations
Analysis:
Accurate and complete analysis in Excel.
Written report:
Length requirements = 4-5 pages minimum (not including Cover and Reference pages)
Provide a brief introduction/ background of the problem.
Complete and accurate Excel analysis.
Written analysis that supports Excel analysis, and provides thorough discussion and analysis of assumptions, rationale, and logic used.
Complete, meaningful, and accurate recommendation(s).
Attachment:- case_1_data.xlsx
|
Discuss the relationships between operating
: In the introduction to the chapter, we learned that Apple Computer (AAPL) recently reinstated the payment of cash dividends, which had been suspended since the 1990s. What are some reasons that might have influenced the firm's decision to begin pa..
|
|
Assume that hospital has steady cash inflows
: Assume that a hospital has steady cash inflows of $10,000 for 3 years and cash ourflows of $9,500 for the same periods. At 10% cost of capital, what is the NPV of this project? Should the project be accepted, assuming there are no limits on capital? ..
|
|
Question regarding the collaboration and social media
: While planning for a new project, a young developer mentions that she used Facebook as a collaborative group space for developing her senior project. She tells you that it was the ideal solution since it was free and all of her group members were ..
|
|
Considering project that has cash flow and WACC data
: Company A is considering a project that has the following cash flow and WACC data. What is the project's NPV? Note that if a project's expected NPV is negative, it should be rejected. WACC: 10.00% Year 0 1 2 3 Cash flows -$1,000 $500 $500 $500
|
|
Provide brief introduction/ background of the given problem
: Provide a brief introduction/ background of the problem. Written analysis that supports Excel analysis, and provides thorough discussion and analysis of assumptions, rationale, and logic used.
|
|
Determining the interaction devices
: Touch screens are becoming extremely popular input devices for phones and tablets. Assess the value of touch screen devices related to human-computer interaction systems. Identify at least two advantages and two disadvantages of having touch scree..
|
|
Strike price and expiration date as for the call option
: The current price of a stock is $45, the annual risk-free rate is 6%, and a 1-year call option with a strike price of $60 sells for $7.20. What is the value of a put option, assuming the same strike price and expiration date as for the call option, a..
|
|
Based on the binominal model-what is the option value
: The current price of a stock is $20, and at the end of one year its price will be either $25 or $15. The annual risk-free rate is 8.0%, based on daily compounding. A 1-year call option on the stock, with an exercise price of $22, is available. Based ..
|
|
Describe the major components of the monetary system
: Analyze the evolution of the country's monetary system, including the impact of any fiscal monetary and trade policies.
|