What is the average inventory at cost for each buyer

Assignment Help Marketing Research
Reference no: EM131326063

Assignment-Retailing& E-Commerce

Let's assume that a retailer has two different buyers working on a specific merchandise category (i.e., Buyer 1 and Buyer 2).

The table below contains information on the effectiveness of each buyer by providing you with the inventory left at the end of each month (for a six-month period). The dollar amount associated with this inventory reflects what the retailer had to pay for the inventory (i.e., the retailer's cost). In addition to EOM (end-of-month) inventory at cost, you also have the sales and COGS associated with each buyer's purchasing decisions.

 

Buyer 1

Buyer 2

Month

EOM Inventory at Cost

EOM Inventory at Cost

Jan

$22,000

$15,000

Feb

$25,000

$22,000

March

$15,000

$18,500

April

$30,000

$23,750

May

$45,000

$38,850

June

$42,500

$38,225

COGS

$400,667

$500,648

Sales (or Revenue)

$5,100,337

$6,800,398


1. What is the average inventory at cost for each buyer?

2. Utilize the information in the table to compute the sales-to-stock ratio for each buyer.

Another retailing metric that is important during the merchandise planning process is gross margin return on inventory (or GMROI).

3. Utilize thedata provided in the table to calculate GMROI for each buyer.

4. Which buyer is doing the best job? Why?

5. What is the key difference between GMROI and sales-to-stock ratio? What does each number tell you about a buyer's merchandise decisions?

Reference no: EM131326063

Questions Cloud

Write vba code to extract the data and display it in listbox : Create a form (frmUpdateMedia), write a VBA code to extract the data and display it in a listbox, dropdownbox or any from of grid. Delete the current records then insert the records from the spread sheet extra credit (advanced way).
Perfect competition render advertising utterly ineffective : How would the assumption of perfect information in the theory of perfect competition render advertising utterly ineffective?
Discuss the arguments for and against using devaluation : Suppose the economy is operating below the natural level of output. Discuss the arguments for and against using devaluation in such a situation.
Domestic and foreign interest rates : Suppose the domestic and foreign interest rates are both initially equal to 4%. Now suppose the foreign interest rate rises to 6%. Explain what effect this will have on the exchange rate. Also explain what must occur for the interest parity condit..
What is the average inventory at cost for each buyer : MKT 482/5482: The table below contains information on the effectiveness of each buyer by providing you with the inventory left at the end of each month (for a six-month period). The dollar amount associated with this inventory reflects what the re..
Develop a table mainmenu with at least three fields : Create a table MainMenu with at least 3 fields: ID, caption, and form or report to run. Your code (for the button) will dynamically read the caption from the table and assign it to the button.
Inflation affect the number of vehicles : How will higher inflation affect the number of vehicles the dealership can sell? Based on the GM's inflation expectation what type of loan should the dealership arrange with its bank in order finance its inventory of automobiles?
Explain the regulatory compliance law : From the e-Activity, explain the regulatory compliance law that you researched, and ascertain the effect that information security could have on such a law
Reasons for alternative of buying a call at higher price : Explain the advantages and disadvantages to a call buyer of closing out a position prior to expiration rather than holding it all the way until expiration?

Reviews

Write a Review

Marketing Research Questions & Answers

  Determine new crops on which avg might be effective

Evaluate the attractiveness of the stone fruits markets (both in the US and internationally), the pineapple market, and the almond market as potential markets for ReTain.

  Define the first step of research in your own words

Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page is not included in the required assignment page length.

  How and why firms try to influence consumers expectations

Describe the trade-off between backward compatibility and performance. Explain how and why firms try to influence consumers' expectations in a standards war?

  Research and determine the importance of role regional

objective research and identify the importance of the role regional blocs play in global-international commerce.what is

  Explain the process of contingency planning

What factors (risks) can potentially disrupt a supply chain, and how?What factors are the largest contributors to flexibility? Explain each of them.How is a multiple linear regression model useful in measuring flexibility?

  Quantitative analysis based on a excessive research

Zara is part of a multi-national conglomerate and it is operating in many countries worldwide. There are a total number of 1770 Zara stores world wide in regions of Africa, Asia, Central America and The Caribbean, Europe, North America, and South Ame..

  Explain limitations in marketing research report

Why are conclusions and recommendations included in a marketing research report?- What are the common problems associated with the marketing research report?

  Discuss the research methodology used for the study

Identify possible areas in which the research can be extended. Does the article call for further research on any specific issue? Identify limitations of the article and formulate them as potential research questions.

  Do the authors arguments support his or her main point

Briefly introduce and summarize the article.Do the author's arguments support his or her main point?What evidence supports the main point?How could the topic of this article apply to your personal or professional life?How could the topic apply to an ..

  Establish the marketing mix components

BSB51215 Diploma of Marketing - Research the products and services of Apple .Identify the key characteristics of the products and/or services and their significance to the market.(approximately 100 words)

  Make a recommendations for the marketing mix strategies

You are required to make recommendations for the following key components of a marketing plan for Godiva Gems. Segmentation-Targeting-Positioning strategies and Marketing Mix Strategies.

  Type of marketing research

Describe what type of marketing research your company will need to use in order to support its marketing strategy. Create a list of questions or issues that your company will need to settle using marketing research.

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