(Solved): The Silver Star Bicycle Company must determine how many new sport model bicycles to produce each of ...

The Silver Star Bicycle Company must determine how many new sport model bicycles to produce each of the next four quarters. The demand for each of the next four quarters is as follows: first quarter, 60 bicycles; second quarter, 55 bicycles; third quarter, 75 bicycles, fourth quarter, 65 bicycles. Silver star must meet demand on time. At the beginning of the first quarter, Silver star has an inventory of 35 bicycles. At the beginning of each quarter, Silver Star must decide how many bicycles should be produced during that quarter. For simplicity, we assume that bicycles manufactured during a quarter can be used to meet demand for that quarter. During each quarter, Silver Star produces up to 35 bicycles with regular-time labor at a total cost of \( \$ 400 \) per bicycle. By having employees work overtime during a quarter, Silver Star can produce additional bicycle with overtime labor at a cost of \( \$ 450 \) per bicycle. At the end of each quarter (after production has occurred and the current quarter's demand has been satisfied), a carrying or holding cost of \( \$ 20 \) per bicycle is incurred. a. Formulate the linear programming to determine a production schedule to minimize the sum of production and inventory costs during the next four quarters. [10 marks] b. Provide a correct excel output (do not forget to attach your excel output). [10 marks]