AirPower Products, Inc. (API) is a new entrepreneurial venture located in the San Francisco Bay Areas Livermore Valley, just west of the famous Altamont Pass wind power farms. APIs products are personal wind power units capable of producing sufficient power in windy locales to dramatically reduce homeowners and small business dependence on the main power grid.

All components of the wind power units, with the exception of the generator module, are produced at the companys facility in Livermore. The generators are outsourced locally to Tesla Generators, Ltd. (TesGen), a manufacturing company specializing in small and efficient power generators.

The purchase price per unit of a TesGen generator is $150. TesGen does not offer quantity discounts on purchases. TesGen delivery performance is extremely reliable and there are no expected shortages. With each purchase order of TesGen generators, API incurs an ordering cost of $500 for the order. In addition to the ordering cost, API incurs an inventory carrying cost that is equal to $200 per each TesGen generator per year.

The management team of API is embarking on a strategic 5-year planning exercise with a focus on long-term cost reduction. Management is using an annual demand forecast of 15,000 API power units for their planning purposes.

One of the high profile processes identified as a candidate for possible cost savings is inventory planning, specifically related to the total inventory costs associated with outsourcing (procuring) the generators from TesGen. However, over the past year, through various Six Sigma process improvement efforts, API has freed sufficient capacity in APIs design and production departments to consider replacing the TesGen generator with one of APIs proprietary internal design and production. API management is confident an internally-manufactured generator can meet or exceed all quality and design requirements already required met by the TesGen generator.

If API were to decide to undertake internal production of generators, the expected production capacity (production rate) is 900 generators weekly. API management is confident that within a two-week lead time, internal schedules can be arranged to support production whenever inventory replenishment is required. All parameters of this production will be constant, shortages are not expected, production costs are expected to be $155 per unit per year, and setup costs will be $200 per production order. Due to various internal cash flow considerations, the per-unit inventory carrying cost of internally produced generators is expected to be 50% of the carrying cost of the outsourced TesGen generators.

Assignment

1. Prepare your submission using Excel. Submit the Excel file so that your formulas can be reviewed.

2. Based on facts given in the case, identify APIs optimal inventory policy for outsourcing generators to TesGen. Calculate the optimal order quantity and annual total cost of inventory for the generators. Clearly explain your results. NOTE: DO NOT ROUND YOUR EXCEL FORMULAS ROUND(). However, DO decrease your Excel displayed decimals to two places for currency and zero places for units.

3. Based on facts given in the case, identify what APIs optimal inventory planning policy would be if the company were to produce generators internally. Calculate what the optimal production order quantity and annual total cost of generator inventory would be. (TIP: Assume API operates production all 52 weeks of the year). NOTE: DO NOT ROUND YOUR EXCEL FORMULAS ROUND(). However, DO decrease your Excel displayed decimals to two places for currency and zero places for units.

4. Make a recommendation as to whether API should continue to outsource (purchase) generators from TesGen or initiate internal production. Clearly state the total annual savings expected from your recommendation.

Economic order quantity (EOQ)
Annual demand, units	D	2920
Holding (Carrying) Cost, $	H	50.00	per unit per year
Ordering Cost, $	S	80.00	per order
Purchase Price, $	P	28.00	per unit
Economic order quantity (EOQ)
Optimal order quantity (EOQ) = sqrt[(2*D*S)/H]	Q*	97	units per order
Number of orders per year = D/Q*	NO	30.2	per year
Inventory Costs
Holding Costs = (QH)/2	HC	2,416.61
Ordering Costs = (D/Q)S	OC	2,416.61
Purchase Price = PD	PP	81,760.00
Annual Total Costs, $	TC	86,593.22		$86,593.21
Production Order Quantity (POQ)
Annual demand	D	2920
Production rate per Production Time Period (PTP)	r	10	units per day (given as 3630/yr)
Usage (demand) rate = D/PTP	d	8	units per day
Holding Cost, $	H	50.00	per unit per year
Setup Cost, $	S	80.00	per order
Production Cost, $	P	28.00	per unit per year
Production Order Quantity (POQ)
Optimal production order quantity (POQ)	Q*	216	[sqrt(2DS)/H] * [sqrt r/(r-d)]
Number of orders per year = D/Q* =	NO	13.5	orders per year
Inventory Costs
Holding Costs = (Q*H)/2 * (1- d/r) =	HC	1,080.74
Setup Costs = (D/Q*)*S =	SC	1,080.74
Production Cost = P * D =	PC	81,760.00
Annual Total Costs, $	TC	83,921.48
Quantity Discount Model
Annual demand, units	D	2920
Holding (Carrying) Cost, $	H	50.00	per unit per year
Ordering Cost, $	S	80.00	per order
Price Breaks			EOQ	EOQ fit into Price Break	Optimal Value for Price Break
1-99	P1	28.00	97	Yes/Feasible	97
100-199	P2	24.00	97	No/Infeasible	100
200 and up	P3	22.00	97	No/Infeasible	200
Total costs for each price break		Optimal Value	Holding cost, $	Ordering Cost, $	Purchase Price, $	Total Cost, $
1-99		97	2,416.61	2,416.61	81,760.00	86,593.22
100-199		100	2,500.00	2,336.00	70,080.00	74,916.00
200 and up		200	5,000.00	1,168.00	64,240.00	70,408.00
Optimal quantity	Q*	200
Optimal annual total cost, $	TC	70,408.00