Based on the anticipated demand and revenue for years 6, 7, and 8, do you expect the Indy-Motors product family to exceed an annual revenue of $500M within the next three years? If yes, in which year? If not, why not?

Assignment

SPM, Inc.
Background

Swiss Precision Motors, Inc. (SPM) is a globally recognized producer of miniaturized ultraprecision electric motors used in medical equipment, industrial machines, and other applications.
A familyowned business, SPM was established in 1947 by Heinrich Rohrer in Basel, Switzerland. In 2018, Steffi Rohrer Heinrich’s granddaughter became the CEO of SPM.

SPM’s product portfolio is composed of two major product families. While they offer multiple product models in each product family, these various models are all minor variations of a core model in each product family.

One product family is IndyMotors, developed primarily for industrial applications that require highprecision movement and positioning, precise cutting, etc. The core model for the IndyMotors product family is the Indy1 platform.

Last year, SPM’s R&D group developed a new ultraprecision miniature motor for medical applications, primarily to serve the precision tools/robots used in roboticsurgery and other applications in medical equipment. This effort led to introduction of a new product family, named MedMotors. The core model for MedMotors product family is the Med1 platform. SPM’s sales and marketing department has prepared a forecast of monthly demand for MedMotors models for this year based on projected demand provided by their medical equipment manufacturing customers that had extremely favorable evaluation of the MedMotors prototypes. All MedMotors orders and deliveries will be handled by a SPM distribution center located in Germany.

Every year, SPM holds a strategic business review and planning at the very end of December. The focus of this review/planning process is to examine the business performance and trends for the current year (that has practically ended) and the prior four years. They also make plans for the year ahead based on the discussions on this review. The data that was reviewed in SPM’s most recently (end of last Dec.) is noted in the tables provided in the attached exhibits.

Questions
Prepare a forecast for the IndyMotors demand and revenue, as outlined in questions A through C below. You forecast needs to address all three questions (A through C). Refer to the attached Exhibits 1 and 2 for more data and information.

A. Select very suitable forecasting models for forecasting demand and revenue for the IndyMotors product family. Specifically and thoroughly articulate the forecasting models you have selected AND articulate in detail the justification for selection/suitability of the model, i.e. what makes the models you have selected very suitable for use in this case.

B. Using the model you have selected in PartA, provide clearly shown demand and revenue forecasts for IndyMotors product family each of the four calendar quarters of year6, as well as for the whole year.

C. Based on the anticipated demand and revenue for years 6, 7, and 8, do you expect the IndyMotors product family to exceed an annual revenue of $500M within the next three years? If yes, in which year? If not, why not?

SPM needs to choose a specific inventory model for the MedMotors product family. Below are some specific data and information for MedMotors. Address all three questions (D through F) as a recommended inventory management plan for MedMotors inventories for year 6.

Monthly demand forecast for MedMotors is provided in the attached Ehibit3
MedMotors average selling price is $1700 per unit

Assume backordering is not an option for MedMotors

SPM’s cost of build for MedMotors is $700 per unit

Delivery lead time for MedMotors orders is 1 month (just assume 1 month, do not worry about whether a month is 28, 30, or 31 days)

SPM incurs ordering costs of $150 each time an order is placed for MedMotors

Monthly inventory carrying costs for medMotors are $15 per unit

SPM wants to maintain a 96% service level with its MedMotors customers

D. Choose an appropriate inventory model to recommend for managing MedMotor inventories for year 6. Specifically, articulate what inventory model you have chosen AND why it is an appropriate model to use in this case. Show details of your work, i.e. describe the model/approach and show the equations, if any, that you use.

E. Determine the reorder point (ROP).

F. Determine the Total Annual Inventory costs for MedMotors. Show details of your work, i.e. describe the approach and show the equations, if any, that you use.

Exhibits

Exhibit1: Consolidated actual IndyMotors demand data for the last five years (these are the year that has just ended and the prior four years) by calendar quarter.
Calendar Quarter
Demand, (units)
Year1
Year2 Year3 Year4 Year5
1st Quarter
55,640 58,100 59,180 65,246 68,135
2nd Quarter
63,223 67,070 72,120 75,900 79,850
3rd Quarter
61,168 63,318 66,686 68,294 70,370
4th Quarter
46,250 43,436 47,980 50,154 57,625
Total (for the year)
226,281 231,924 245,966 259,594 275,980
Exhibit2: IndyMotors average selling price (ASP) for the last 5 years.

Average Selling Price per Unit

Year1
Year2 Year3 Year4 Year 5
$1,800
$1,740 $1,680 $1,600 $1,540
Exhibit3: MedMotors forecasted monthly demand for year 6.

Month
Demand (units) for Next Year
Jan
6,500
Feb
4,200
Mar
2,000
Apr
1,700
May
9,500
Jun
7,500
Jul
11,500
Aug
14,500
Sep
2,000
Oct
8,100
Nov
3,100
Dec
3,700
Total
74300

Based on the anticipated demand and revenue for years 6, 7, and 8, do you expect the Indy-Motors product family to exceed an annual revenue of $500M within the next three years? If yes, in which year? If not, why not?
Scroll to top