Preview

Retail Op

Good Essays
Open Document
Open Document
1465 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Retail Op
OPIM340 Retail Operations
Assignment 1: Retail Valuation (45 points)
Due: start of class Lecture 2

1. How does the strategic profit model assist retailers in planning and evaluating their marketing and financial strategies? (Limit your answer to 3-4 sentences max) (3 points)

2. Explain inventory turnover? Why does a low inventory turnover indicate more risk than a high turnover? Why do different products have different benchmarks for inventory turnover? (3 points) Average Inventory at Cost is $1,000. Say you have gross profit margins of 20%. If you sell $5,000 per year of this product, you make 20% of that or $1,000 in gross profit. What is your GMROI? (1 point) What is your Inventory Turnover? (1 point) What are your Days Sales of Inventory (given your turnover, how many days of inventory do you hold on average) (1 point)

3. A retailer has yearly sales of $800,000. Inventory on January 1 is $300,000 (at cost). During the year, $600,000 of merchandise (at cost) is purchased. The ending inventory is $305,000 (at cost). Operating costs are $90,000. Calculate the cost of goods sold and net profit and set up a P&L statement. (3 points)
4. A computer retailer has net annual sales of $150,000 and average inventory at cost is $20,000. What is the annual sales-to-stock measure? (1 point) If the computer retailer has a gross margin percentage of 15, what is the gross margin return on investment (GMROI)? (1 point)

5. A large catalog retailer of fashion apparel reported $100,000,000 in revenues over the last year. On average, over the same year, the company had $5,000,000 worth of inventory in their warehouses. Assume that units in inventory are valued based on cost of goods sold (COGS) and that the retailer has a 100 percent markup on all products. The company uses a 40 percent per year cost of inventory. That is, for the hypothetical case that one item of $100 COGS would sit exactly one year in inventory, the company

You May Also Find These Documents Helpful

  • Powerful Essays

    Hrm 531 Week 3 Quiz

    • 4852 Words
    • 20 Pages

    B uses LIFO. In an extended period of rising inventory costs, Company A's gross profit and inventory…

    • 4852 Words
    • 20 Pages
    Powerful Essays
  • Satisfactory Essays

    Xacc/280 Week 3 Quiz

    • 826 Words
    • 4 Pages

    A physical count of merchandise inventory on November 30 reveals that there are 90 units on hand. Assume a periodic inventory system is used. Ending inventory under LIFO is…

    • 826 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Acc/531 Week 4

    • 623 Words
    • 3 Pages

    1. Beginning ($1,200) and ending ($1,400) finished goods inventory and cost of goods sold ($12,000) are used to squeeze costs of…

    • 623 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    What is the markup you must apply to your initial inventory to meet your gross target in year 1? Use your result from #5. Round your answer to the nearest percent.…

    • 1331 Words
    • 6 Pages
    Satisfactory Essays
  • Good Essays

    Hamptonshire Express Case

    • 632 Words
    • 3 Pages

    b. The optimal stocking quantity differs from problem #2 because Ralph is incurring the cost of overstocking, which changes the critical ratio from .8 in problem #2 to .2. Because of the critical ratio change, Anna’s profit decreases as Ralph’s increases. This is consistent with the Newsvendor Model, which gives Cu=.2, Co=.8, for a critical ratio of .2. Using the formula in the spreadsheet, Q*=NORM.INV(.2,600,100)=515.837, gives the optimal stocking quantity of 516.…

    • 632 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    6) Refer to the information above. What is the average inventory held in a given cycle?…

    • 1687 Words
    • 12 Pages
    Satisfactory Essays
  • Good Essays

    L.L. Bean Case Study

    • 721 Words
    • 3 Pages

    The two main basic components that are relevant in determining how many units of an item that L.L Bean should stock are the cost of the item for L.L. Bean and also the price at which they can sell the item. Calculating these two figures, selling price minus the item’s cost, will give L.L. Bean their profit margin, which in turn relates to the cost of understocking. The annual cost for understocking in the case is $11 million. They also need to figure their overstocking costs. Taking the original cost of the item minus the liquidation value will give them the loss for failing to sell that item, in essence overstocking an item. L.L. Bean has an annual cost of $10 million for having too much of the wrong inventory, according to the case. Another cost that is involved with overstocking is the annual holding time of their facility when they keep inventory for the next year.…

    • 721 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Milligan’s Backyard Storage Kits, a mail order company, sells a variety of backyard storage unit kits and landscaping decorations to its customers. Although the company makes a profit, David Milligan, the company’s owner, realizes that he can improve his company’s operations if he better manages his inventory. Mr. Milligan requests your help in preparing an Inventory Analysis worksheet. The Inventory Analysis worksheet provides Mr. Milligan with information about his annual sales, cost of goods sold, gross profit, and markup on this products. Preparing the worksheet for Mr. Milligan requires you to insert columns, use several functions, and apply proper formatting to the worksheet and cells.…

    • 877 Words
    • 4 Pages
    Powerful Essays
  • Powerful Essays

    Jack Jones, the materials manager at Precision Enterprises, is beginning to look for ways to reduce inventories. A recent accounting statement shows the following inventory investment by category: raw materials, $3,129,500; work-in-process, $6,237,000; and finished goods, $2,686,500. This year’s cost of goods sold will be about $32.5 million. Assuming 52 business weeks per year, express total inventory as…

    • 1629 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    5. During August, the cost of goods manufactured was $73,000. The beginning finished goods inventory was $15,000 and the ending finished goods inventory was $21,000. What was the cost of goods sold for the month?…

    • 1416 Words
    • 8 Pages
    Satisfactory Essays
  • Good Essays

    Inventory Turnover

    • 1081 Words
    • 5 Pages

    The investment of a company’s success depends on their inventory. Inventory turnover is a ratio showing how many times a company’s inventory is sold and replaced over the period of time. The risk of Kudler Fine Foods was to make sure that their perished goods had a fast inventory turnover rate. The importance of high inventory turnover was expected to protect the brand’s integrity and vision of keeping all goods fresh.…

    • 1081 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Practice Problem

    • 762 Words
    • 4 Pages

    1. Keith Shoe Stores carries a basic black dress shoe for men that sells at an approximate constant rate of 500 pairs of shoes every 3 months. Keith’s current buying policy is to order 500 pairs each time an order is placed. It costs Keith $30 to place an order. The annual holding cost rate is 20%. With an order quantity of 500, Keith obtains the shoes at the lowest possible unit cost of $28 per pair. Other quantity discounts offered by the manufacturer are as follows. What is the minimum-cost order quantity for the shoes? What are the annual savings of your inventory policy over the policy currently being used by Keith?…

    • 762 Words
    • 4 Pages
    Good Essays
  • Good Essays

    2. Determine the existences of inventories and the occurrence of transactions affecting cost of goods sold.…

    • 583 Words
    • 3 Pages
    Good Essays
  • Satisfactory Essays

    Solution Manual

    • 473 Words
    • 2 Pages

    Unit cost = = P4.35 2. Cost of goods sold = 360,000 units x P4.35 = P1,566,000 3. Inventory – Aug. 31 = 40,000 units x P4.35 = P174,000 [Problem 4] | | | | |Dep| | | | | | | |art| | | | | | | |men| | | | | | | |t A| | | | | (P250,000 x 120 / 400) | | |75,| | | | | | | |000| | | | |…

    • 473 Words
    • 2 Pages
    Satisfactory Essays