Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Operation Management Expert

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.

Operation Management, Management Studies

  • Category:- Operation Management
  • Reference No.:- M91645408

Have any Question?


Related Questions in Operation Management

Required text book c langley c john langley robert a

REQUIRED TEXT BOOK : C. Langley; C. John Langley; Robert A. Novack; Brian Gibson; John J. Coyle (2016) Supply Chain Management (12th Edition). Publisher: Cengage South-Western Chapter 9: Managing Inventory in the Supply ...

What are the foundations of a comprehensive job analysishow

What are the foundations of a comprehensive Job Analysis? How do organizations utilize a Job Analysis Questionnaire? Does research support that a job analysis leads to an effective job description? Opineon how you think ...

1 discuss the following 4 types of business insurance and

1. Discuss the following 4 types of business insurance and why they are important. general liability insurance, product liability insurance, professional liability insurance, commercial liability insurance. 2. Which of t ...

The case study discusses the dynamics of the global ev

The case study discusses the dynamics of the global EV industry and Volkswagen's efforts to challenge Tesla's supremacy. To understand the developments and advancements in electric vehicle market - "Buying a Trend or the ...

1 a hires b to work for his logging operation which is

1. A hires B to work for his logging operation, which is dangerous work. A has B sign a contract that says that B will not sue A in the event of injuries that happen on the job. This contract, which is probably illegal i ...

Case studyinstructionsimplementation plan part 1during unit

Case Study Instructions Implementation Plan: Part 1 During Unit IV, VI, and VIII, you will be working on an implementation plan for a business. The components within these three units combined will create this plan. Plea ...

Consider a retail store importing unlocked smart phones

Consider a retail store importing unlocked smart phones from overseas. The monthly demand for phones is 100. The store carries half the lead time demand as safety inventory. Each phone costs $450 and the annual holding c ...

What are other businesses or areas that have been impacted

What are other businesses or areas that have been impacted by changing communication technology? MIS uses three primary resources. Which of those resources are the most important and why? Can this vary depending on the n ...

1 give an example of the following types of decisions that

1) Give an example of the following types of decisions that you have had to make (personal or work-related): Low consequence work-oriented High consequence work-oriented 2) Give an example (personal or work-related) for ...

1 discuss why obtaining true free market competition would

1. Discuss why obtaining true free market competition would require considerable government intervention. Provide a reference. 2. Discuss the number of roles the federal government needs to play in support of an effectiv ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As