DDD Camping and outdoor store offers quality tents, sleeping gears, and camping accessories. The store is planing
Question:
DDD Camping and outdoor store offers quality tents, sleeping gears, and camping accessories. The store is planing the next 4 quarters' production for its most popular product, pop-up tent. At the beginning of quarter 1, DDD employs 10 workers working in the pop-up tent's production line. Each worker can make up to 70 units of pop-up tent per quarter and is paid THB11,000 salary per quarter. Assume that one worker quits at the end of each quarter and that the company has established a hiring freeze for the upcoming year. The demand for the pop-up tent in quarters 1-4 are 500, 800, 300, and 600 units respectively. All quarterly demands must be met on time. There is no pop-up tent stored in an inventory prior to quarter 1. Unused pop-up tent in each quarter can be stored in an inventory to be used in the following quarters. Finally, the raw material used to manufacture one unit of the pop-tent costs THB800. The holding cost per unit of pop-tent held in inventory at the end of each quarter is THB100. Formulate and solve a linear programming model to find the optimal pop-up tent's production plan for the upcoming year. Do not restrict the production plan to be integer-value.
Can you make an excel part for me?
International Business Law And Its Environment
ISBN: 9781305972599
10th Edition
Authors: Richard Schaffer, Filiberto Agusti, Lucien J. Dhooge