Problem:
The Acme Manufacturing Company is concerned about its warehouse needs and how they can be best met. The company produces a line of spare parts for appliances. Due to the combination of production policies and demand patterns, warehousing space requirements vary considerably throughout the year. Space requirements are known with a great deal of certainty because the product line satisfies a replacement market. Growth, or decline, in production and sales is not anticipated in the near future. Warehouse inventory turns at the rate of two times per month. A dollar's worth of merchandise occupies 0.1 cubic feet of warehouse space and can be stacked 10 ft. high. The product density is $5 per lb. Given aisles, administrative space, and normal operating efficiency, only 40 percent of the total warehouse space is actually used for storage. A private warehouse can be constructed and equipped for $35 per sq. ft. and can be amortized over 20 years. The cost of operation is $0.04 per lb of throughput. Annual fixed costs amount to $10 per sq. ft. of total space. Space may also be rented for a storage charge on inventory of $0.06 per lb per month and a handling charge of $0.05 per lb of throughput.
Monthly sales rates for a typical year are as follows:
Month Sales ($)
Jan. 5,000,000
Feb. 4,000,000
Mar. 3,000,000
Apr. 2,000,000
May 1,000,000
June 250,000
July 1,250,000
Aug. 2,250,000
Sept. 3,000,000
Oct. 3,500,000
Nov. 4,000,000
Dec. 4,500,000
Total 33,750,000
Required:
Consider the following two options:
Question 1) Construct a 10,000 sq. ft. of private warehouse and rent public warehouse as needed.
Question 2) Do not construct a private warehouse, and use only public warehouse. What are the annual costs for each option, and which one has a lower annual cost? Solve the problem and show all work.