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

  Products or services and marketing plan

Explain how you intend to promote your products or services and Marketing plan - Discuss the pricing for your major products (items) or services.

  Interview two different types of local retail merchants

Interview two different types of local retail merchants (for example. a boutique owner and a manager of a franchise) to determine how the merchandise in their stores is distributed to them.

  Can any weaknesses be converted to strengths

What are the internal strengths and weakness of your company?What are the external opportunities and threats in your industry and its environment?Can any weaknesses be converted to strengths? Any threats into opportunities?

  Process of developing international marketing strategy

Develop skills and capability in the process of developing International Marketing Strategy. You are required to form a group of two to three people for this task. It requires you to draw on the key principles of the courseand international market..

  Draw up a research proposal for the city council

Draw up a research proposal for the city council that will specifically address the question of identifying the quality of the communication processes with employees.

  Determine distribution strategy relative to target market

Determine the distribution strategy relative to your target market, location, and selection of distribution channels. Indicate whether or not you will leverage.

  Explain the difference between heavy and long lift surcharge

Difference between heavy lift surcharge and long lift surcharge

  Matching structure with strategy i am working on matching

i am working on matching structure with strategy and the question is ltbrgt ltbrgteven in an industry that is not so

  Executive summary with key findings and recommendations

Executive Summary with key findings and recommendations and clear and concise description of the market in which the organization operates

  What are possible efficiency-defences of use of resale-price

What are possible efficiency-defences of the use of resale-price maintenance? For which reasons can it be profitable for manufacturers to grant exclusive territories to their retailers?

  Develop pricing strategies-distribution channels for product

Develop strategies to assess performance and achieve marketing goals.Develop pricing strategies and distribution channels for products.Analyze integrated marketing communications and its relationship to advertising strategy.Evaluate marketing researc..

  Can the physician order hiv testing of the patients blood

Can the physician order HIV testing of the patient's blood immediately, without the patient's consent, so he knows whether he has been exposed to the HIV virus?

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