How would you forecast the amount of product

Assignment Help Case Study
Reference no: EM132213116

Case Study: Pricing Perishable Products

Instructions - Read the case below and use the data provided to answer the questions in the case. You may use a calculator. Once you have answered the questions, you will prepare a short, 5 to 8 slide presentation that will be presented during the interview. You can consider including the following items, but you are free to present any aspects of the case you wish:

  • Key facts and important aspects
  • Risks and issues
  • Recommendations
  • Next steps
  • Other considerations or information needed

Case Overview - John Kline, the pricing manager of Prime Foods, a food distribution company in Texas is trying to come up with a better process of coordinating pricing for his customers along with the perishability aspect of the products he is managing. Prime Foods has been in business for a long time and they specialize in processed foods including frozen pizzas, frozen veggies as well as some deli meats. They cater to small and mid-size grocery stores across the state.

The first thing he realized was that he needed some data to investigate the current situation and come up with a plan. He reached out to the IT department, and he found out he could get the following information:

  • Visibility into the inventory levels for all the distribution centers as well as the current shelf life for all products in-stock. This is possible by tracking the product's lot number with the manufactured date, tracking the product life cycle and then calculating the remaining shelf life.
  • Transactional data that included sales for the month of October. With this information he is able to answer the following: Which products have been sold, how much quantity, at what price and to whom? He has the ability to extract all the invoices for a given time period.
  • Volume targets for each product and distribution center. The sales leadership has come up with certain volume targets they would like to hit broken down to the monthly level. These targets were derived from historical information along with corporate strategy (e.g. brand positioning, competitor pressure, etc.).

John is trying to leverage all this data in order to come up with a better pricing strategy that is in-line with the corporate goals but also takes in consideration the inventory in order to avoid spoilage.

Questions -

1. Which product(s) are at risk to perish before being sold?

2. Which product(s) are under-sold / over-sold? What other insights can you derive from the targets that have been set by the sales leadership?

3. From a pricing standpoint what can be done to minimize the spoilage?

4. What conclusions can you draw from their historical transactions?

5. Assuming the data was extracted on October 23rd 2015, how would you forecast the amount of product that will be sold at the end of the month? How is this information relevant? (Hint)

6. Any other supply chain considerations?

Note - Words: As appropriate to the answer. Present it in a project format short, 5 to 8 slide presentation.

Attachment:- Case Study.rar

Reference no: EM132213116

Questions Cloud

Differences between a connection-oriented protocol : What is the differences between a connection-oriented protocol and a connectionless protocol?
Explain the ceo conduct leading to the whistleblowing : Describe an accounting theory that may help to explain the CEO's conduct leading to the whistleblowing. Critically link that theory with CEO'sbehaviour.
Explain the functional view of an organization : Explain the functional view of an organization and describe each function.
Which fundraising goals and organizational goals : Discuss way in which fundraising goals and organizational goals affect one another. what ways does patient data exchange present problem for healthcare provider
How would you forecast the amount of product : Case Study: Pricing Perishable Products. How would you forecast the amount of product that will be sold at the end of the month
Walter shewhart developed : External failure costs include all of the following except. Walter Shewhart developed the.
Sun systems makes two types of retractable awnings : Sun Systems makes two types of retractable awnings - Premium and Deluxe.
Emphasis on customer service is based on speed-quality : Creative Design Group designs brochures for companies, trade groups and associations. Their emphasis on customer service is based on speed, quality and value.
How many 5s appears in a given number passed : Write a recursive function called countFive. It counts how many 5's appears in a given number passed in as a parameter.

Reviews

Write a Review

Case Study Questions & Answers

  From the scenario, prioritize the attributes of golds reling

From the scenario, prioritize the attributes of Golds Reling's brand from the brand map presented in the scenario according to the attributes that you believe would be most important to the new tablet's target market. Provide support for your respons..

  Discuss critically infosys current and future strategy

Discuss critically Infosys current and future strategy. What advice would you give Kris Gopalakrishnan and KShop has resulted in information overload among staff. What operational measures would you suggest to overcome such challenges?

  Review tarmac business case for diversity

Review Tarmac's Business Case for Diversity and the Learning Resources. Think about Tarmac's approach to managing diversity and how it relates to organisational behaviour concepts and human resource processes.

  Enron case shared activity

Enron was the first nationwide natural gas pipeline network in the United States. As the company grew, executives shifted the company's primary focus from energy delivery and infrastructure to investing in the stock market.

  Ebay inc internet success or fairy tale

Read the case study "eBay Inc.: Internet Success or Fairy Tale? "and answer the question below,   Use the 2002 financial statement data to replicate the Meyer's report calculations that illustrate the conclusion based on the 2001 data reached in the ..

  Mintendo game girl case study

Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? How does the answer change if a discount of $10 must be given to reach the same level of impact that the $5 discount received?

  Splash soft drinks case study

Splash Soft Drinks Inc. (SSD) has recently achieved sales that exceeded its expectations after it introduced a new beverage that was greatly welcomed by their customers. The company is currently considering opening a new plant to which some of the pr..

  Details of the task using tesco plc

Details of the task Using Tesco plc (www.tesco.com) as a case study, prepare a report of no more than 2,500 words that:

  What are the common manifestations of alcoholic cirrhosis

What are the common manifestations of alcoholic cirrhosis? Which of these are secondary to hepatocellular failure? Which are secondary to portal hypertension?

  Judge the extent to which the marketing plan at just us

From the case study, judge the extent to which the marketing plan at Just Us! is outdated. Propose two (2) ways that Just Us! could improve the customer experience and thus sustain future growth.

  Read natasha kingery case and answer the questions

Read the DATA CASE on pages 126-127 about Natasha Kingery who is considering furthering her education and is seeking financial advice. Determine the interest rate she is currently earning on her inheritance by going to Yahoo!

  Identify the relevant facts of the case study

Imagine you are the financial controller of XYZ Ltd a corporation that is a very large donor to HOHO. You have recently become aware that its TV advertising has resulted in the charity violating the 25% expenditure ratio for its charity drive.    Id..

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