- Case StudyHelp.com
- Sample Questions
Case Study Solutions on Management Science and Operations Analytics
Are you stuck with your Management Science and Operations Analytics Assignment? Casestudyhelp.com provides you with assignment answers at an affordable price. We have professional writing experts who deliver quality material such as case study assignment help, Management Assignment Help. We are available for you by our 24/7 online service.
Assignment Details:-
- Words: 2500
- Assignment Type: Case Study
- Subject: Business Management
Cuillin Ride
Cuillin Ride (CR) is a Scottish manufacturer and wholesale distributer of kids’ bicycles. Bicycles are sold through major retail outlets. The firm’s primary retail outlets are located in Edinburgh, Belfast, Cardiff, London and Southampton all within a reasonable distance from the distribution center in Manchester. If the stock is available, these retail outlets receive the order from Cuillin Ride within 48 hours after notifying the distribution center. However, if the company does not fulfil an order, no back order is placed and the retailers arrange to receive their shipment from other distributors.
Cuillin Ride distributes a wide range of finished bicycles, but all are based on three different frame designs: Flexa, Quest and Discovery. Table 1 gives a breakdown of different types of bicycles that are available to the retail outlets. Flexa sells for £170; the other two types of bicycles (i.e., Quest and Discovery) are more expensive and sell for £220 and £350 respectively. All three models are produced in a manufacturing hub in Mexico, El Bajio, for Cuillin Ride. A shipment takes as long as one month from the time an order is placed. With the cost of communication and paperwork included, Cuillin Ride estimates that each time an order is placed, it incurs a cost of £65. The purchase price paid by Cuillin Ride, per bicycle, is roughly 70% of the suggested retail price for all the three styles available.
The inventory carrying cost is 1% per month of the purchase price paid by Cuillin Ride. Demand for these bicycles is somewhat seasonal in nature being high in spring and early summer and relatively low through autumn and winter (with the exception of the six weeks before Christmas during which often a high level of demand is observed). Sales forecast for all three models in the upcoming year have been developed and are summarized in Table 1. It is assumed that the monthly demand data is normally distributed.
Cuillin Ride is interested in developing an inventory plan to use as the basis for its upcoming annual plan. The firm wants to maintain a 98% service level with its customers to minimize the losses on the lost orders. The company would like to consider both “aggregated” and “dis-aggregated” ordering policies. With a dis-aggregated policy, each type of bicycles is considered as a single product and therefore multiple orders need to be placed. While in an aggregated case, different bicycle types are combined and a single order will be placed to manage the inventory.
Assignment:
(a) Develop and compare two inventory control plans for each type of bicycles distributed by Cuillin Ride under continuous and periodic review
(b)Develop and compare two aggregated inventory control plans for the bicycles distributed by Cuillin Ride under continuous and periodic review Compare the two plans developed in (a) and (b) (i.e., the aggregated and dis-aggregated cases), discuss their pros and cons and provide recommendation.
Attempt either part (c) or part (d)
(c) Cuillin Ride has provided a new sales forecast for Flexa-see Table 2. Evaluate the impact of this new forecast on your developed plans for this type of bicycle in part (a) and elaborate on your observations.
(d) The Mexican supplier intend to reduce a large stock of its Flexa model. It has offered a 20% discount on Flexa unit price if Cuillin Ride order 100 bicycles (of this type) or more. Assuming that the forecast figures are accurate and ignoring the forecast errors, advise Cuillin Ride whether it should take advantage of this discount or purchase the basic EOQ order size to manage Flexa’s inventory.
Hint: (1) Calculate and report the order size only for Flexa style in your proposed plan under the periodic review system; no need to report the order size for the aggregated case under the periodic review system (i.e., part b). (2) Use EOQ to estimate the order size in the periodic review system wherever needed.
You are free to organize your report using any standard structure. However, it is recommended to include a short executive summary, a short introduction, detailed calculations and analysis, concluding remarks and assumptions (if any).
Table 1. Sales forecast
Month | Flexa | Quest | Discovery | Total |
Jan. | 10 | 5 | 3 | 18 |
Feb. | 13 | 10 | 2 | 25 |
Mar. | 30 | 21 | 13 | 64 |
April | 60 | 40 | 20 | 120 |
May | 98 | 65 | 37 | 200 |
June | 59 | 41 | 18 | 118 |
July | 38 | 26 | 11 | 75 |
Aug. | 25 | 16 | 9 | 50 |
Sept. | 17 | 11 | 7 | 35 |
Oct. | 14 | 10 | 7 | 31 |
Nov. | 29 | 19 | 13 | 61 |
Dec. | 46 | 33 | 18 | 97 |
Total | 439 | 297 | 158 | 894 |
Table 2. New sales forecast for Flexa
Month | Flexa |
Jan. | 30 |
Feb. | 25 |
Mar. | 35 |
April | 50 |
May | 55 |
June | 45 |
July | 30 |
Aug. | 30 |
Sept. | 20 |
Oct. | 15 |
Nov. | 15 |
Dec. | 35 |
Total | 385 |
For REF… Use: #getanswers2001786