please use this excel format

0. The Silver Star Bicycle Company will be manufacturing men's and women's models of its Easy-Pedal 10 -speed bicycle during the next two months, and the company would like a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown in Exhibit 14.29. Each month, 3,000 hours of manufacturing labor and 1,000 hours of assembly labor are available. The company charges monthly inventory at the rate of two percent of the production cost based on the inventory levels at the end of the month. Silver Star would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this as a linear optimization model but do not solve (see Supplement D). Chapter 14#30 Bicycle Production Plan Solve this problem using Level Strategy and Chase Strategy with the goal of minimizing production costs, labor hours and inventory costs. A. Level Strategy B. Chase Strategy C. Which strategy works best to minimize total cost? \begin{tabular}{ll} \hline Problem A Level Strategy \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Mens & \\ \hline Beg Inventory & 20 \\ \hline Prodn Cost & 40 \\ \hline Mfg Labor (hrs) & 10 \\ \hline Assembly Labor (hrs) & 3 \\ \hline Desired End Inv & 25 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Mens & & & & & & \\ \hline & Beg Inventory & 20 & & & & & \\ \hline & Prodn Cost & $ & & & & & \\ \hline & Mfg Labor (hrs) & 10 & & & & & \\ \hline & Assembly Labor (hrs) & 3 & + & ? & & z & \\ \hline 5 & Desired End Inv & 25 & x 2 = & & & & \\ \hline ? & & & 4 & & & & 1. \\ \hline & Demand & Beg. Inv & Prodn & End Imv & Prodn Cost & Labor & Inv. Cost \\ \hline Month 1 & 150 & 20 & 8 & & ? & & \\ \hline Month 2 & 200 & 0 & tilt: & 3 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Women's & \\ \hline Beg Inventory & 30 \\ \hline Prodn Cost & 30 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Demand & Beg. Inv & Prodn & End Inv & Prodn Cost & Labor & Inv. Cost \\ \hline Month 1 & 150 & 20 & I & & & & \\ \hline \multirow[t]{10}{*}{ Month 2} & 200 & 0 & & & & & \\ \hline & & & & & + & & \\ \hline & Women's & & & & 1. & & \\ \hline & Beg inventory & 30 & e 2 & & & & \\ \hline & Prodn Cost & 30 & & & & + & \\ \hline & M'g Labor (hrs) & 8 & & & & & \\ \hline & Assembly Labor (hrs) & 2 & & \pm & & & \\ \hline & Desired End Inv & 30. & & A & & 4 & \\ \hline & & & & & & = & \\ \hline & Demand & Beg. Inv & Prodn & End Inv & Prodn Cost & Labor & Inv, Cost \\ \hline Month 1 & 125 & 30 & & & & & \\ \hline \multirow[t]{2}{*}{ Month 2 } & 150 & 0 & & & & \pm & \\ \hline & & = & & & & & \\ \hline Month 1 & Total labor Hrs & & & & \multicolumn{3}{|c|}{ add mens and womens labor hrs } \\ \hline \multirow[t]{2}{*}{ Month 2} & Total labor Hrs & & & = 8 & \multicolumn{3}{|c|}{ add mens and womens labor hrs } \\ \hline & & & & & - & & \\ \hline \multirow[t]{3}{*}{ ? } & Total Production Cost & & & & \multicolumn{3}{|c|}{ add mens and womens prodn costs } \\ \hline & Total Inventory Cost & 4. & H & & \multicolumn{3}{|c|}{ add mens and womens inventory costs } \\ \hline & Total Cost & & & & +4 & & \\ \hline & & & & & 8 & & \\ \hline \multirow[t]{4}{*}{ Problem B } & Chase Strate 8 y & \multicolumn{2}{|c|}{ Use same data as in Problem A } & & & & \\ \hline & & & & & & & \\ \hline & Mens & & & & & & \\ \hline & Demand & Bee lou & & & & & \\ \hline \end{tabular} 0. The Silver Star Bicycle Company will be manufacturing men's and women's models of its Easy-Pedal 10 -speed bicycle during the next two months, and the company would like a production schedule indicating how many bicycles of each model should be produced in each month. Current demand forecasts call for 150 men's and 125 women's models to be shipped during the first month and 200 men's and 150 women's models to be shipped during the second month. Additional data are shown in Exhibit 14.29. Each month, 3,000 hours of manufacturing labor and 1,000 hours of assembly labor are available. The company charges monthly inventory at the rate of two percent of the production cost based on the inventory levels at the end of the month. Silver Star would like to have at least 25 units of each model in inventory at the end of the two months. Formulate this as a linear optimization model but do not solve (see Supplement D). Chapter 14#30 Bicycle Production Plan Solve this problem using Level Strategy and Chase Strategy with the goal of minimizing production costs, labor hours and inventory costs. A. Level Strategy B. Chase Strategy C. Which strategy works best to minimize total cost? \begin{tabular}{ll} \hline Problem A Level Strategy \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Mens & \\ \hline Beg Inventory & 20 \\ \hline Prodn Cost & 40 \\ \hline Mfg Labor (hrs) & 10 \\ \hline Assembly Labor (hrs) & 3 \\ \hline Desired End Inv & 25 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Mens & & & & & & \\ \hline & Beg Inventory & 20 & & & & & \\ \hline & Prodn Cost & $ & & & & & \\ \hline & Mfg Labor (hrs) & 10 & & & & & \\ \hline & Assembly Labor (hrs) & 3 & + & ? & & z & \\ \hline 5 & Desired End Inv & 25 & x 2 = & & & & \\ \hline ? & & & 4 & & & & 1. \\ \hline & Demand & Beg. Inv & Prodn & End Imv & Prodn Cost & Labor & Inv. Cost \\ \hline Month 1 & 150 & 20 & 8 & & ? & & \\ \hline Month 2 & 200 & 0 & tilt: & 3 & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|} \hline Women's & \\ \hline Beg Inventory & 30 \\ \hline Prodn Cost & 30 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline & Demand & Beg. Inv & Prodn & End Inv & Prodn Cost & Labor & Inv. Cost \\ \hline Month 1 & 150 & 20 & I & & & & \\ \hline \multirow[t]{10}{*}{ Month 2} & 200 & 0 & & & & & \\ \hline & & & & & + & & \\ \hline & Women's & & & & 1. & & \\ \hline & Beg inventory & 30 & e 2 & & & & \\ \hline & Prodn Cost & 30 & & & & + & \\ \hline & M'g Labor (hrs) & 8 & & & & & \\ \hline & Assembly Labor (hrs) & 2 & & \pm & & & \\ \hline & Desired End Inv & 30. & & A & & 4 & \\ \hline & & & & & & = & \\ \hline & Demand & Beg. Inv & Prodn & End Inv & Prodn Cost & Labor & Inv, Cost \\ \hline Month 1 & 125 & 30 & & & & & \\ \hline \multirow[t]{2}{*}{ Month 2 } & 150 & 0 & & & & \pm & \\ \hline & & = & & & & & \\ \hline Month 1 & Total labor Hrs & & & & \multicolumn{3}{|c|}{ add mens and womens labor hrs } \\ \hline \multirow[t]{2}{*}{ Month 2} & Total labor Hrs & & & = 8 & \multicolumn{3}{|c|}{ add mens and womens labor hrs } \\ \hline & & & & & - & & \\ \hline \multirow[t]{3}{*}{ ? } & Total Production Cost & & & & \multicolumn{3}{|c|}{ add mens and womens prodn costs } \\ \hline & Total Inventory Cost & 4. & H & & \multicolumn{3}{|c|}{ add mens and womens inventory costs } \\ \hline & Total Cost & & & & +4 & & \\ \hline & & & & & 8 & & \\ \hline \multirow[t]{4}{*}{ Problem B } & Chase Strate 8 y & \multicolumn{2}{|c|}{ Use same data as in Problem A } & & & & \\ \hline & & & & & & & \\ \hline & Mens & & & & & & \\ \hline & Demand & Bee lou & & & & & \\ \hline \end{tabular}