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

  A business plan: gift shop

A business plan for a gift shop contains so many constraints and aspects to be taken into consideration before start up with something.

  Managerial decision making

This assignment is based on Managerial Decision Making. Compare and contrast the theoretical and practical differences between "formal research" and "business proposals".

  London congestion charge

Generate revenue for city are under consideration. The two proposals are London Congestion Charge and Charging for Firefighting.

  Market research

The director of market research at a large department store chain wanted to prepare a survey throughout a metropolitan area to calculate the amount of time working women spend shopping for clothing in a typical month.

  Producing quality steel by stressing sound management

Nucor Corporation- Producing Quality Steel by Stressing Sound Management Practices

  Monitor and review the performance of members of a team

Monitor and review the performance of members of a team.

  Scientific research and informal research

Differences between scientific research and some informal research

  Dilmah ceylon tea: market development in australia

Dilmah Ceylon Tea: Market Development in Australia.

  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..

  Market research report

Market Research Report

  Designing a lunchbox menu for children

Marketing Plan- Designing a lunchbox menu for Children

  Case study:moet hennessy louis vuitton

Case study:Moet Hennessy Louis Vuitton

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