Determine the best times of the year to increase marketing

Assignment Help Operation Management

Reference no: EM13970465

You have been provided an Access database that contains sales data for the past five years for a florist. The data has information about the date of transaction, client name, client zip code, products purchased, and product price. You have been tasked to provide a few reports to the owner of the business. Explain the steps to import the data from Access into Excel for data analysis. Due to the high amounts of perishable inventory over the last year, the owner would like to eliminate five products. Provide the steps in your data analysis to determine the appropriate products to eliminate. The owner would like to increase marketing during slower periods of the year. Because flower sales are seasonal, the owner does not know the best times of year to increase marketing to attract more customers when business is slower. Provide the steps in your data analysis to determine the best times of the year to increase marketing. How would you report your findings to the owner to Parts 2 and 3? Assume that the owner is visual and does not want to look over a worksheet of data.

Reference no: EM13970465

Questions Cloud

Explain how you would visually present average salary : You are a Financial Analyst for a manufacturing company with more than 1000 salaried employees working in several departments. You have been provided with a list of all employee information such as Name, Title, Department, Annual Salary, etc. Determi..

Competitive in business-get acceptable bottom-line results : Do you think you can stay competitive in business, get acceptable bottom-line results, and still operate in an honest and ethical manner? Some say that as long as it is legal it is ethical. Do you agree or disagree?

Labor concerning elimination of employee rest breaks : Alice Jones was employed as a clerk-typist by a company. She requested and was refused a vacation day. The employer’s refusal was based on her failure to submit the request at least two weeks in advance as required by company policy. Jones claimed th..

Determine the best times of the year to increase marketing : You have been provided an Access database that contains sales data for the past five years for a florist. The data has information about the date of transaction, client name, client zip code, products purchased, and product price. Provide the steps i..

Enterprise risk management : Enterprise risk management (“ERM”) is a hot topic across all industries. Boards and senior management rely on ERM to help them understand and manage important risks. Briefly explain ERM and its three foundational steps.

Differentiated or commodity : In the company Apple, What are the dominant economic & marketing features of the industry? Differentiated or commodity?

Service blueprints often use to distinguish steps : A special feature that service blueprints often use to distinguish steps that are seen by the customer from those that are not seen by the customer is:

Distributed architectural structure knowledge management : Which centralized distributed architectural structure knowledge management systems best support innovation and competitive advantage? Why?

User Account

All Pages