Data analyst for the excellent consulting group

Assignment Help Operation Management
Reference no: EM13904768

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 10 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.

Reference no: EM13904768

Questions Cloud

What is the capability ratio of the current process : A chocolate factory has weighed 4 chocolate truffles coming out of production over 5 working days to obtain the following data, weights are in grams. Suppose the process has a standard deviation of 0.2. The factory quality assurance requires rework f..
Describe the process in the money market : Describe the process in the money market (demand and supply of/for money) by which the interest rate reaches its equilibrium value if it starts above equilibrium.
Accompanying verbal explanation : Does trade under increasing returns to scale still make both countries better off, as the constant-returns-to-scale H-O model shows? Answer this question using both your diagram and an accompanying verbal explanation.
Levels for divisions and management structures : Discuss the importance of the levels for divisions and management structures. Also discuss how multidivisional structure of hierarchy in an organization helps in decentralized decision making.
Data analyst for the excellent consulting group : 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 10 product lines over the last 3 quarters
Cost of one procurement : A particular item has demand of 3000 units per year. The cost of one procurement is Rs. 100 and the holding cost per unit is Rs. 2.40 per year. The replenishment is instantaneous and no shortages are allowed.
What is the average throughput time for table of customers : A small restaurant has 30 tables. When guests arrive, the manager seats them, servers serve them, and then the customers pay their bills. It takes the manager 1 minute to find a table for customers. What is the capacity of the system and the bottlene..
What safety margin of stock is being carried : The daily demand of an item is 1600 units. The average processing time is 25 seconds per unit. Containers (carrying 250 items) on the average wait for 6 hours before being processed. Currently 10 containers (Kanbans) are being used for this parts. Wh..
Percent of the investment in the inventories : The production department for a company requires 7200kg of raw material for manufacturing particular item per year. It has been estimated that the cost of placing an order is A 72 and the cost of carrying inventory is 25 percent of the investment ..

Reviews

Write a Review

Operation Management Questions & Answers

  Book review - the goal

Operations Management is about a book review. Title of the book is "Goal". This book has been written by Dr. Eliyahu Goldartt. The book has been appreciated by many as one of those books which offers an insight into the operations and strategic capac..

  Operational plan in hospitality enterprise

Operational plan pertaining to a hospitality enterprise is given in detail in the solution. The operational plan is an important plan or preparation which gives guidelines regarding the role and responsibilities of each and every operation at all lev..

  Managing operations and information

Recognise the importance of a strategic approach to the development and deployment of organisational information systems. Demonstrate an understanding of the importance of databases and their integration to the organisation's overall information mana..

  A make-or-buy analysis

An analysis of the holding costs, including the appropriate annual holding cost rate.

  Evolution and contributor of operations management

Briefly explain Evolution and contributor of Operations management.

  Functions and responsibilities of an operations manager

A number of drivers of change have transformed the roles, functions and responsibilities of an operations manager over recent years. These drivers have not only been based on technological innovations but also on the need for organisations to develop..

  Compute the optimal order quantity

Compute the Optimal Order quantity of DVD players. Determine the appropriate reorder point.

  Relationship to operations practice in the organisation

Evaluate problems in operations and identify approaches to overcoming them. Critically evaluate operating plans and identify areas for improvement. Justify, implement and evaluate changes to operations in line with modern approaches.

  A make or buy analysis

Develop a report for Figi Fabricating that will address the question of whether the company should continue to purchase the part from the supplier or begin to produce the part itself.

  Prepare a staffing plan

Prepare a staffing plan showing the change of your unit from medical/surgical staffing to oncology staffing.

  Leadership styles in different organizations

Ccompare the effectiveness of different leadership styles in different organizations

  Risk management tools and models

Be able to understand the concept of risk, roles and responsibilities for risk management and risk management tools and models.

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!

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