Question

In: Statistics and Probability

Martin-Pullin Bicycle Corp. (MPBC), located in Dallas, is a wholesale distributor of bicycles and bicycle parts....

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 overseas manufacturer, 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 bike models available. The inventory carrying cost is 1% per month (12% per year) of the purchase price paid by MPBC. The retail price (paid by the customer) 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 impact of lost orders. The data collected for the past two years is summarized in the following table. A forecast for AirWing model sales in upcoming year 2011 has been developed and will be used to make an inventory plan for MPBC.

Demands for AirWing Model

MONTH

2009

2010

FORECAST FOR 2011

January

6

7

8

February

12

14

15

March

24

27

31

April

46

53

59

May

75

86

97

June

47

54

60

July

30

34

39

August

18

21

24

September

13

15

16

October

12

13

15

November

22

25

28

December

38

42

47

Total

343

391

439

Questions

  1. Develop an inventory plan to help MPBC.
  2. Discuss ROPs and total costs.
  3. How can you address demand that is not at the level of the planning horizon?

Solutions

Expert Solution


Related Solutions

Zhou Bicycle Case Study Zhou Bicycle Company, located in Seattle, is a wholesale distributor of bicycles...
Zhou Bicycle Case Study Zhou Bicycle Company, located in Seattle, is a wholesale distributor of bicycles and bicycle parts. Formed in 1991 by University of Washington Professor Yong-Pia Zhou, the firm’s primary retail outlets are located within a 400-mile radius of the distribution center. These retail outlets receive the order from ZBC with 2 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;...
CASE: Parts Emporium Parts Emporium, Inc., is a wholesale distributor of automobile parts formed by two...
CASE: Parts Emporium Parts Emporium, Inc., is a wholesale distributor of automobile parts formed by two disenchanted auto mechanics, Dan Block and Ed Spriggs. Originally located in Block’s garage, the firm showed slow but steady growth for 7 years before it relocated to an old, abandoned meat-packing warehouse on Chicago’s South Side. With increased space for inventory storage, the company was able to begin offering an expanded line of auto parts. This increased selection, combined with the trend toward longer...
The Hazim Company is a wholesale distributor of automotive replacement parts. For purposes of this question,...
The Hazim Company is a wholesale distributor of automotive replacement parts. For purposes of this question, assume on January 1, year 3, Hazim Co. adopted the dollar-value LIFO method of determining inventory costs for financial and income-tax reporting. The following information relates to this change: Hazim has continued  to use the FIFO method for internal reporting purposes. Hazim's FIFO inventories at December 31, Year 3, Year 4, and Year 5, were $100,000, $137,500, and $195,000, respectively. The FIFO inventory amounts are...
Parts Emporium, Inc., is a wholesale distributor of automobile parts formed by two disenchanted auto mechanics,...
Parts Emporium, Inc., is a wholesale distributor of automobile parts formed by two disenchanted auto mechanics, Dan Block and Ed Spriggs. Originally located in Block’s garage, the firm showed slow but steady growth for 7 years before it relocated to an old, abandoned meat-packing warehouse on Chicago’s South Side. With increased space for inventory storage, the company was able to begin offering an expanded line of auto parts. This increased selection, combined with the trend toward longer car ownership, led...
The Alpha Company, located in numerous locations, is a wholesale distributor of computer equipment. The information...
The Alpha Company, located in numerous locations, is a wholesale distributor of computer equipment. The information shown below was taken from the company’s annual reports for the last three years. Balance Sheet                                                           year 2              year 1              year 0 Total Assets                                      $270,000                $155,000               $90,000 Accounts Payable                               $23,500                        $19,500                   $17,000 Loans Payable                                     $28,000                       $22,500               $20,000 Long-Term Debt                                $35,000                        $25,000                     $20,000 Preferred Stock                                  $5,000                          $5,000                     ...
Chapter 12 Case– Inventory Management Background Zhou Bicycle Company (ZBC), located in Seattle, is a wholesale...
Chapter 12 Case– Inventory Management Background Zhou Bicycle Company (ZBC), located in Seattle, is a wholesale distributor of bicycles and bicycle parts. Formed in 1981 by University of Washington Professor Yong-Pin Zhou, the firm’s primary retail outlets are located within a 400-mile radius of the distribution center. These retail outlets receive the order from ZBC within 2 days after notifying the distribution center, provided that the stock is available. However, if an order is not fulfilled by the company, no...
Ace Bicycle produces bicycles and manufactures all parts internally. Ace has received an offer from an...
Ace Bicycle produces bicycles and manufactures all parts internally. Ace has received an offer from an outside vendor to supply all of the chains Ace requires at $8.20 per chain. Ace’s expected production for the year is 10,000 units. The following information relates to chain production: Variable Costs: $7.50/unit, $75,000 total Machine Rent: $5000 Other Fixed Costs: $30,000 Total Costs: $110,000 Suppose that if Ace buys the chains from the outside vendor, the factory where Ace used to make the...
Parks Auto is a wholesale distributor of auto parts. Parks Auto received the promissory note shown...
Parks Auto is a wholesale distributor of auto parts. Parks Auto received the promissory note shown below from Jones Auto, Inc., as security for payment of a $44,000 auto parts shipment. When Parks accepted the note as collateral for the debt owed by Jones, Parks was aware that the maker of the note, Chad, was claiming that the note was unenforceable because Victoria had breached the license agreement under which Chad had given the note. Jones had acquired the note...
Kevin Rocks is a wholesale distributor of automotive replacement parts. Initial amounts taken from Kevin Rocks’...
Kevin Rocks is a wholesale distributor of automotive replacement parts. Initial amounts taken from Kevin Rocks’ accounting records are as follows: Inventory on December 31, 2016 (based on physical count of goods in Kevin Rocks warehouse on December 31, 2016) $        1,150,000 Sales in 2016 $        9,000,000 Accounts Payable at December 31, 2016 Vendor Terms Amount Baker Company 2% 10 days, net 10 $ 265,000 Dolly Company Net 30 $210,000 Eager Company Net 30 $300,000 Full Company Net 30 $225,000...
Bharat Bicycle, located in India, produces an inexpensive yet rugged bicycle for use on crowded city...
Bharat Bicycle, located in India, produces an inexpensive yet rugged bicycle for use on crowded city streets. The company sells the bicycle for 600 rupees. (Indian currency is denominated in rupees, denoted by R.) Selected data for the company’s operations last year follow:      Units in beginning inventory 0   Units produced 18,050   Units sold 15,600   Units in ending inventory 2,450   Variable costs per unit:      Direct materials R187      Direct labour R199      Variable manufacturing overhead R39      Variable selling and administrative R24   Fixed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT