Problem 3. (Chapter 12: Storage and Handling Decisions, hint: similar to the sizing problem example in class, watch Module 3 Ch12 Part 1 video on Canvas) 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 dollars 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

Consider the following two options: (1) Construct a 10,000 sq. ft. of private warehouse and rent public warehouse as needed. (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?

Month Sales ($) Jan. Feb. Mar. Apr. May June July Aug. Sept. Oct. Nov. Dec. Total 5,000,000 4,000,000 3,000,000 2,000,000 1,000,000 250,000 1,250,000 2,250,000 3,000,000 3,500,000 4,000,000 4,500,000 33,750,000