please attach the spreadsheet and/or the calculations

Transportation Method PT. Karya Nusantara (PT. KN) is an electronics assembly company that produces various types of computers. The Personnel Section informs that currently the company has 40 production workers who work 8 hours per day and 25 days/period. At this time, the manager of PT. KN is making production plans for the next 6 days period. The aggregate demand forecast for the computer product family for 6 periods is: Perioda Demand (unit) 12 1500 1800 3 2000 4 2100 5 2000 6 2200 At the beginning of the period there are 100 units of inventory, while at the end of the period it is desired to have a ending inventory of 120 units. It takes 10 working hours to make one unit of product. Regular labor costs are Rp. 30.000,-/unit and overtime fee is Rp. 45.000,-/unit. The cost of saving Rp. 5,000,-/unit/period and the back order fee is Rp. 25.000,-/unit/period. The company also stipulates several policies including the number of overtime hours allowed by the company is 30% of the total available regular working hours. In addition, companies are allowed not to use all available regular time capacity, if there is a shortage of production, overtime and back orders can be carried out. Help the company to make a production plan in order to meet the demand for the next 6 periods using the optimization method