Implement the linear optimization model developed for the Silver Star Bicycle Company in Problem 30 in a spreadsheet and use Excel Solver (see Supplement D) to determine a production plan that minimizes production and inventory costs and satisfies the labor-smoothing, demand, and inventory requirements. What inventories will be maintained, and how much labor is used each month in manufacturing and assembly?