Preview

Martin-Pullin Case Study

Good Essays
Open Document
Open Document
609 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Martin-Pullin Case Study
Module 4 – Chapter 6
Case Study: Martin-Pullin Bicycle Corporation

Martin-Pullin Bicycle Corp. (MPBC), located in Dallas, is a wholesale distributor of bicycles and bicycle parts. Formed in 1981 by cousins Ray Martin and Jim Pullin, the firm's primary retail outlets are located within a 400-mile radius of the distribution center. These retail outlets receive the order from Martin-Pullin within two days after notifying the distribution center, provided that the stock is available. However, if an order is not fulfilled by the company, no backorder is placed; the retailers arrange to get their shipment from other distributors, and MPBC loses that amount of business.
The company distributes a wide variety of bicycles. The most popular model, and the major source of revenue to the company, is the AirWing. MPBC receives all the models from a single manufacturer overseas, and shipment takes as long as four weeks from the time an order is placed. With the cost of communication, paperwork, and customs clearance included, MPBC estimates that each time an order is placed, it incurs a cost of $65. The purchase price paid by MPBC, per bicycle, is roughly 60% of the suggested retail price for all the styles available, and the inventory carrying cost is I % per month (12% per year) of the purchase price paid by MPBC. The retail price (paid by the customers) for the AirWing is $170 per bicycle.
MPBC is interested in making an inventory plan for 2011. The firm wants to maintain a 95% service level with its customers to minimize the losses on the lost orders. The data collected for the past two years are summarized in the following table (Table 1). A forecast for AirWing model sales in the upcoming year 2011 has been developed and will be used to make an inventory plan for MPBC.

Table 1
Demands for AirWing model
Month
2009
2010
Forecast 2011
January
6
7
8
February
12
14
15
March
24
27
31
April
46
53
59
May
75
86
97
June
7
54
60
July

You May Also Find These Documents Helpful

  • Satisfactory Essays

    In order to predict the future flows of the demand and match the info with the kit orders we create a model in attempting to avoid stock breaks or…

    • 855 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    JET 2 Task 1

    • 6185 Words
    • 20 Pages

    Due to variable expenses, expenses that increase as production and sales increase, selling expenses for Competition Bikes, Inc. increased. From year 6 to year 7, total selling expenses increased by 33%. General and Admin expenses also increased, by a lesser amount, at 31.1%. Due to a sufficient increase in net sales, the added selling expenses did not come at a deficit to the bike company. Advertising expenses also increased to 37.5% but due to website creation and various maintenance costs staying relatively the same, it did helped balance the expenses and net sales and negative impacts on the company were not made. (WGU, 2014)…

    • 6185 Words
    • 20 Pages
    Good Essays
  • Powerful Essays

    JCT2 Task 1

    • 1659 Words
    • 8 Pages

    15,000 15,000 15,000 + Shipping 0 27,665 46,811 52,995 + Inventory Holding Costs 0 4,544 20,489 0 + Excess Capacity Cost 0 0 0 0 + Depreciation 0 45,833 91,667 137,500 =…

    • 1659 Words
    • 8 Pages
    Powerful Essays
  • Powerful Essays

    Final Accounting

    • 1555 Words
    • 5 Pages

    As reflected in the Production Budget captured in Exhibit B below and included in the overall Peyton Approved budget worksheet included in Appendix A. First budgeted sales units for each month in the quarter was used to multiply with ratio to inventory future sales to compute budgeted ending inventory. The company stated that it was company's policy to have a given month's ending finished goods inventory to equal 70% of the next month's expected unit sales. Then, budgeted sales units of 18,000, 22,000 and 20,000 units are added to the budgeted ending inventory units of 15,400, 14,000 and 16,800 units for the month of July, August and September, respectively to arrive to required units to be produced of 33,400, 36,000 and 36,800 units for each respective months. Subsequently, beginning inventory is deducted from required…

    • 1555 Words
    • 5 Pages
    Powerful Essays
  • Powerful Essays

    Fredrick, J. (2002, 21 October 2002). AIMing to match supply and demand - Distribution - CVS is using a new data-driven inventory management system. Retrieved 8 October 2005, http://www.findarticles.com/p/articles/mi_m3374/is_14_24/ai_93371107…

    • 2171 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    During the year, 235 bicycles were sold at a price of $1,500 each. Other operating costs equaled $80,000 and their tax rate is 30%. Round final…

    • 951 Words
    • 7 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Alexander and Thurston, Inc. is a mail sorting equipment company providing high quality service to their customers. The increasing pressure to live up to the service contracts let company start to rethink about their current inventory control strategy from both their distribution center (DC) and facility. The challenge of this company is to reduce their inventory level while maintaining the high fill rate and further improving their service level.…

    • 295 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The University of Phoenix Summer Historical Inventory Data is the source for developing Team B’s inventory management proposal. Annual trend lines were plotted in Microsoft Excel © to display the inventory amounts for each year. The trend line in this case is positive, which indicates that the likelihood of inventory levels in the subsequent years will continue to rise without considering any additional factors that may influence the business. Factors to support the observation include economic instability from stock market volatility, a decline in consumer confidence, severe weather, and acts of terrorism. Table 1 shows the existing data and includes the fifth year projections. Figure 1 displays the trend…

    • 285 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    The volume of the seasonal inventories (both seasonal and highly seasonal goods) peak in the March – April period and then later in October suggesting the build-up of inventories in the High Cube Capacity and Yard areas for spring planting and gardening and fall harvesting and holiday decoration sales. With 50% of the inventory cost in the High Cube Capacity and Yard areas and these inventory items arriving at the London DC within a relatively narrow time slot, these SKUs seem to be perfect candidates for direct shipment to store locations or cross docking (receive goods at a DC receiving dock and move the product to a DC shipping dock to go out in smaller quantities with the rest of a truckload order. In addition, final sales to the end customers of many of these seasonal items can be forecast with great accuracy. The replenishment schedule for an individual store can be very accurately forecast using prior year sales information by time period and…

    • 565 Words
    • 3 Pages
    Good Essays
  • Good Essays

    This equation gave us our final order quantity of 327, although based on slight demand fluctuations we had been at 321 prior to that.…

    • 795 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Bus 630 Week 2

    • 391 Words
    • 2 Pages

    Auerbach Enterprises is an air conditioning company who manufactures air conditioners for automobiles and trucks. Their business provides these products across North America. In evaluating the type of costing method Auerbach Enterprises would benefit from the most, they fall into job order costing system due to the variety of auto and truck air conditioning units they manufacture. Their manufacturing of the units varies as they specialize in unique and individual orders in order to meet the demands of their customers. Their products which have portions of their order which can be assembled in mass still require individualization to fit the distinct trucks or automobiles. In evaluating the cost of the product and analyzing profitability it is important to apply the job order costing system. Each item must be categorized as the direct and indirect labor and manufacturing costs will vary with each output. “Determining the accurate cost of a product is necessary for finding optimal pricing for that product and, more importantly, whether that product can be profitable.” (Tatikonda, 1988). Tatikonda goes on to discuss that accurate inventory is vital to the survival of any organization. Accurate inventory is required in order for management to make the best business decision recommendations to the owners and CEO’s of the organization.…

    • 391 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    Forecasting Best Practices

    • 2091 Words
    • 9 Pages

    Marien, Edward J. Demand Planning and Sales Forecasting: A Supply Chain Essential. Supply Chain Management Review, 1999…

    • 2091 Words
    • 9 Pages
    Better Essays
  • Good Essays

    The number of units to stock was generally not equal to the forecast demand, but it was determined using historical forecast errors. To determine the stock of each item, first, they calculated the historical forecast errors for each item in the previous year and the frequency distribution of those errors. Then, this frequency was used as probability distribution for the future forecast errors. The next step was to balance the individual items' contribution margin if this item was demanded against the…

    • 422 Words
    • 2 Pages
    Good Essays
  • Better Essays

    Realco Breadmaster Company

    • 1027 Words
    • 5 Pages

    Inventory is the stock of items used to support production, supporting activities and customer service. It is the “bread and butter” that keeps manufacturing firms in business, and is a critical resource in the supply chain. Inventory can be manually managed so that different business conditions can have less of a negative impact on the operations, and give support to the efficient running of supply chains. There are also many tools that companies use to manage production, such as the master scheduling, the material requirements planning (MRP), job sequencing, and distribution requirements planning (DRP). Now with all that said, let us now begin the review and analyze the first case study about the Realco Breadmaster Company.…

    • 1027 Words
    • 5 Pages
    Better Essays