Describe a data consolidation strategy

Assignment Help Business Economics

Reference no: EM13739790

A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales manager at the corporate office. The data is sent in an Excel spreadsheet. Describe a data consolidation strategy and at least two different types of visualization techniques the sales manager can use to analyze the data received from all stores. Be sure to include formulas that are to be used in the Excel spreadsheet.

Reference no: EM13739790

Questions Cloud

What was purpose of the north atlantic treaty organization : What was the purpose of the North Atlantic Treaty Organization (N.A.T.O.)? in 250 words or more, also needs to be cited!

Determine which bread gives you most revenue : You have been provided with an Access database that contains sales data from a small bakery. The data has information about the client, bread type, cost to produce the bread and sales. You have been tasked to provide a few reports. Provide and descri..

Consumption good will she be able to consume : Total time available is 168 hours per week. Suppose Toni's wage rate is $10 per hour, the price of the consumption good is $1 per unit, and non labor income is $320 per week. If Toni chooses to take 118 hours of leisure per week, how much of the cons..

Advantages or disadvantages of market-based indicators : A survey by Fitch Ratings found that capital market participants felt that Credit Default Swaps, what advantages or disadvantages of market-based indicators for making investment (bonds, loans, stock) decisions

Describe a data consolidation strategy : A retail chain keeps daily data with summaries of the dollar amounts of sales for each of 151 different products sold at 23 retail stores. The daily data is tracked by product and by store. At the end of the day each store sends its data to the sales..

Use accounts receivable as collateral to borrow money : Many small companies use accounts receivable as collateral to borrow money for continuing operations and meeting payrolls. If a company borrows $230,000 now at an interest rate of 16.00% per month, but the rate changes to 18.00% per month after 6 mon..

Present worth of the costs at an interest rate : Periodic outlays for inventory control software at Baron Chemicals are expected to be $280,000 immediately, $280,000 in 1 year, and $200,000 in 2 years. What is the present worth of the costs at an interest rate of 3.92% per year, compounded continuo..

Producing dental crowns qualify for different property class : Two investments involving a virtual mold apparatus for producing dental crowns qualify for different property classes. Investment A has a cost of $59,500.00, lasts 9 years with no salvage value, and costs $150,000 per year in operating expenses.

Employee portfolio-motivation action plan : Determine the motivational strategy or strategies that would likely be most appropriate for each of your three employees on basis of their individual characteristics.

User Account

All Pages