Question

In: Economics

Jan Northcutt, owner of Northcutt Bikes, started business in 1995. She notices the quality of bikes...

Jan Northcutt, owner of Northcutt Bikes, started business in 1995. She notices the quality of bikes she purchased for sale in her bike shop declining while the prices went up. She also found it more difficult to obtain the features she wanted on ordered bikes without waiting for months. Her frustration turned to a determination to build her own bikes to her particular customer specifications.

She began by buying all the necessary parts (frames, seats, tires, etc.) and assembling them in a rented garage using two helpers. As the word spread about her shop’s responsiveness to options, delivery, and quality, however, the individual customer base grew to include other bike shops in the area. As her business grew and demanded more of her attention, she soon found it necessary to sell the bike shop itself and concentrate on the production of bikes from a fairly large leased factory space.

As the business continued to grow, she backward integrated more and more processes into her operation, so that now she purchases less than 50% of the component value of the manufactured bikes. This not only improves her control of production quality but also helps her control the costs of production and makes the final product more cost attractive to her customers.

The Current Situation

Jan considers herself a hands-on manager and has typically used her intuition and her knowledge of the market to anticipate production needs. Since one of her founding principles was rapid and reliable delivery to customer specification, she felt she needed to begin production of the basic parts for each particular style of bike well in advance of demand. In that way she could have the basic frame, wheels, and standard accessories started in production prior to the recognition of actual demand, leaving only the optional add-ons to assemble once the order came in. Her turnaround time for an order of less than half the industry average is considered a major strategic advantage, and she feels it is vital for her to maintain or even improve on response time if she is to maintain her successful operation.

As the customer base have grown, however, the number of customers Jan knows personally has shrunk significantly as a percentage of the total customer base for Northcutt Bikes, and many of these new customers are expecting or even demanding very short response times, as that is what attracted them to Northcutt Bikes in the first place. This condition, in addition to the volatility of overall demand, has put a strain on capacity planning. She finds that at times there is a lot of idle time (adding significantly to costs), whereas at other times the demand exceeds capacity and hurts customer response time. The production facility has therefore turned to trying to project demand for certain models, and actually building a finished goods inventory of those models. This has not proven to be too satisfactory, as it has actually hurt costs and some response times. Reasons include the following:

  • The finished goods inventory is often not the “right” inventory, meaning shortages for some goods and excessive inventory of others. This condition both hurts responsiveness and increases inventory costs.
  • Often, to help maintain responsiveness, inventory is withdrawn from finished goods and reworked, adding to product cost.
  • Reworking inventory uses valuable capacity for other customer orders, again resulting in poorer response times and/or increased costs due to expediting. Existing production orders and rework orders are both competing for vital equipment and resources during times of high demand, and scheduling has become a nightmare.

The inventory problem has grown to the point that additional storage space is needed, and that is a cost that Jan would like to avoid if possible.

Another problem that Jan faces is the volatility of demand for bikes. Since she is worried about unproductive idle time and yet does not wish to lay off her workers during times of low demand, she has allowed them to continue to work steadily and build finished goods. This makes the problem of building the “right” finished goods even more important, especially given the tight availability of storage space.

Past Demand

The following shows the monthly demand for one major product line: the standard 26-inch 10-speed street bike. Although it is only one of Jan’s products, it is representative of most of the major product lines currently being produced by Northcutt Bikes. If Jan can find a way to sue this data to more constructively understand her demand, she feels she can probably use the same methodologies to project demand for other major product families. Such knowledge can allow her, she feels, to plan more effectively and continue to be responsive while still controlling costs.

Actual Demand

Month

2011

2012

2013

2014

January

437

712

613

701

February

605

732

984

1291

March

722

829

812

1162

April

893

992

1218

1088

May

901

1148

1187

1497

June

1311

1552

1430

1781

July

1055

927

1392

1843

August

975

1284

1481

839

September

822

1118

940

1273

October

893

737

994

912

November

599

983

807

996

December

608

872

527

792

Questions and assignment:

  1. Plot the data and describe what you see. What does it mean and how would you use the information from the plot to help you develop a forecast?
  2. Use at least two different methodologies to develop as accurate a forecast as possible for the demand. Use each of those methods to project the next four months demand.
  3. Which method from question 2 is “better”? How do you know that?
  4. How, if at all, could we use Jan’s knowledge of the market to improve the forecast? Would it be better to forecast in quarterly increments instead of monthly? Why or why not?
  5. Are there other possible approaches that might improve Jan’s operation and situation? What would they be and how could they help?

Solutions

Expert Solution

The data gives an idea about the sales of bikes in different months of the year. Thus we'll get to know the patern of demand in various, which month has got higher demand and which month has got lower demand. Accordingly the inventory can be kept ready so that there wont be any excessive or shortfall of inventory.

The two methods used are 3 period Moving Average and 4 period Moving Average methods.

3 Period Moving Average for the Month of January : 712 + 613 + 701 / 3 = 675

February : 732 + 984 + 1291 / 3 = 1002

March : 829 + 812 + 1162 / 3 = 934

April : 992 + 1218 + 1088 / 3 =1099

4 Period Moving Average Method for the month of January : 437 + 712 + 613 + 701 /4 = 616

February : 605 + 732 + 984 + 1291 / 4 = 903

March : 722 + 829 + 812 + 1162 / 4 = 881

April : 893 + 992 + 1218 + 1088 / 4 = 1048

4 Period Moving Average Method is better as it has considered more number of past sat sales record and thus the sales smoothens out for more number of months and gives more accurate sales forecast.

Jan's knowledge can be used as she is serving the market for the past so many months and thus knows the market very well. As the sales and demand of bikes varies on monthly basis and thus it is better to forecast on monthly basis.

Jan's could have taken experts and sales force opinion and thus can predict the sales more accurately and finally serves the customers in a much better way.


Related Solutions

Jan Northcutt, owner of Northcutt Bikes, started business in 1995. She notices the quality of bikes...
Jan Northcutt, owner of Northcutt Bikes, started business in 1995. She notices the quality of bikes she purchased for sale in her bike shop declining while the prices went up. She also found it more difficult to obtain the features she wanted on ordered bikes without waiting for months. Her frustration turned to a determination to build her own bikes to her particular customer specifications. She began by buying all the necessary parts (frames, seats, tires, etc.) and assembling them...
Northcutt Bikes: the Service Department Introduction Several years ago, Jan Northcutt, owner of Northcutt Bikes, recognized...
Northcutt Bikes: the Service Department Introduction Several years ago, Jan Northcutt, owner of Northcutt Bikes, recognized the need to organize a separate department to deal with service parts for the bikes her company makes. Because the competitive strength of her company was developed around customer responsiveness and flexibility, she felt that creating a separate department focused exclusively on aftermarket service was critical in meeting that mission. When she established the department, she named Ann Hill, one of her best clerical...
Northcutt Bikes: the Service Department Introduction Several years ago, Jan Northcutt, owner of Northcutt Bikes, recognized...
Northcutt Bikes: the Service Department Introduction Several years ago, Jan Northcutt, owner of Northcutt Bikes, recognized the need to organize a separate department to deal with service parts for the bikes her company makes. Because the competitive strength of her company was developed around customer responsiveness and flexibility, she felt that creating a separate department focused exclusively on aftermarket service was critical in meeting that mission. When she established the department, she named Ann Hill, one of her best clerical...
Your client has started a photography business on Jan 1 of 2016 (sole proprietorship). She has...
Your client has started a photography business on Jan 1 of 2016 (sole proprietorship). She has never started a business before. The business had sales of $15,000 and incurred the following expenses in 2016. Explain to your client how these will be handled in 2016 and in 2017 and beyond. Licenses   5,000 Advertising 2,000 Studio rent 3,500 Market studies 2,300 Studio equipment, cameras & lenses      $25,000
Molly Swift is the owner of Swift Bikes, a company that produces high-quality cross-country bicycles. Swift...
Molly Swift is the owner of Swift Bikes, a company that produces high-quality cross-country bicycles. Swift Bikes participates in a supply chain that consists of suppliers, manufacturers, distributors, and elite bicycle shops. For several years, Swift has purchased titanium from an established set of suppliers in the supply chain. Swift uses titanium for the bicycle frames because it is stronger and lighter than other metals and therefore increases the quality of the bicycle. Earlier this year, Molly hired Alan Morrison,...
INSTRUCTIONS: THE OWNER IS IVETTE MARTINEZ AND IS DEDICATED TO GIVING BUSINESS CONSULTATIONS. THE BUSINESS STARTED...
INSTRUCTIONS: THE OWNER IS IVETTE MARTINEZ AND IS DEDICATED TO GIVING BUSINESS CONSULTATIONS. THE BUSINESS STARTED IN THE MONTH OF OCTOBER OF THE CURRENT YEAR. 1. ANALYZE THE FOLLOWING TRANSACTIONS IN THE TABLE OF THE SIMPLE EQUATION. 2. PREPARE THE TRANSACTIONS IN A JOURNAL. 3. TRANSFER THE TRANSACTIONS TO THE RELEVANT T ACCOUNTS. 4. PREPARE THE TRIAL BALANCE OF THE COMPANY CALLED FREE CONSULTATIONS. TRANSACTIONS: 1. MARTINEZ INVESTED $60,000 IN HER COMPANY. 2. MADE A LOAN TO BANCO SANTANDER FOR...
1) The nurse has just started her morning shift, when entering the client's room, she notices...
1) The nurse has just started her morning shift, when entering the client's room, she notices the wrong IV drip is administering to the client. The nurse quickly stop the IV drip, assess the client's condition, and collect vital signs. What should the nurse do next? A. Document the medication error B. Do nothing as the client condition is normal C. Report this to the nurse supervisor D. Report this to the prescribing physician 2) The nurse is assessing a...
The owner of a chain of supermarkets notices that there was a positive correlation between the...
The owner of a chain of supermarkets notices that there was a positive correlation between the sales of beer and the sales of ice cream over the course of the previous year. During seasons when sales of beer were above average, sales of ice cream also tended to be above average. Likewise, during seasons when sales of beer were below average, sales of ice cream also tended to be below average. The owner is curious whether the observed association is...
SHU Bicycle Shop sells Mountain bikes, Dirt bikes and Leisure bikes. D. Shim, owner, aggregated the...
SHU Bicycle Shop sells Mountain bikes, Dirt bikes and Leisure bikes. D. Shim, owner, aggregated the following information with help of SHU Accounting Consulting Group: Product sales price purchase cost Mountain bike $1,500 $900 Dirt Bike $1,800 $800 Leisure Bike $800 $600 The shop anticipates selling 600 Mountain bikes, 250 Dirt bikes and 150 Leisure bikes. Monthly common fixed costs which can’t be separated to any product are $1,000,000 and income tax rate is 40%. Required) 1. What is unit...
On the first day of the new year to get her business started, the owner/photographer of...
On the first day of the new year to get her business started, the owner/photographer of Exquisite Portraits Inc. paid $200 for business cards, $1,000 for a listing in Yellow Pages, and $250 for an annual business license. She also leased a professional portrait camera and studio lighting equipment by signing an agreement to pay a monthly lease of $1,000 each month for the next 12 months. This lease is ironclad: She must pay for all 12 months, and she...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT