The production facility has two production lines operated by 3 employees each at the same time. The company pays a rent for the production hall of 5.000 per month, and the utilities expenses are expected to be of 500 per month, fixed and a variable cost of 0,005 per sqm. The sales organization has one customer service with an annual cost of 33.500, and the support of an external agent that takes a 5% commission over sales The administration of the company has two persons in the accounting department, with an annual cost of 25.000 each. The machines run at 50 linear meters per minute, and the product has a width of 2 meters. Our quarterly sales budget for 2019 is: 2019 Total Q4 Q3 Q2 Q1 741.600 30.823.200 11.016.000 10.795.680 11.289.600 1.140.250 7.776.000 7.698.240 Unit sales melamine Unit sales phenol 20.398.018 763.848 The sales price for melamine products is 45 cents, and the price for the phenolic is 40 cents This is the production calendar that the company has agreed with its union. 2019 Q distribution Total 04 Q3 Q2 Q1 % of sales 218,75 18,75 65 70 65 Production days according to calendar 3-For the year 2020, the market situation has changed, Phenol sales units drop 1.000.000 every quarter compared to 1919 and melamine products increase in 1.500.000 every quarter Raw materials cost has also changed both melamine and phenol resins have a prices per Kg of 2 Prepare a new production schedule maximizing the result, assigning the overtime if needed to the last quarter and prepare a quarterly budget 2020. The production facility has two production lines operated by 3 employees each at the same time. The company pays a rent for the production hall of 5.000 per month, and the utilities expenses are expected to be of 500 per month, fixed and a variable cost of 0,005 per sqm. The sales organization has one customer service with an annual cost of 33.500, and the support of an external agent that takes a 5% commission over sales The administration of the company has two persons in the accounting department, with an annual cost of 25.000 each. The machines run at 50 linear meters per minute, and the product has a width of 2 meters. Our quarterly sales budget for 2019 is: 2019 Total Q4 Q3 Q2 Q1 741.600 30.823.200 11.016.000 10.795.680 11.289.600 1.140.250 7.776.000 7.698.240 Unit sales melamine Unit sales phenol 20.398.018 763.848 The sales price for melamine products is 45 cents, and the price for the phenolic is 40 cents This is the production calendar that the company has agreed with its union. 2019 Q distribution Total 04 Q3 Q2 Q1 % of sales 218,75 18,75 65 70 65 Production days according to calendar 3-For the year 2020, the market situation has changed, Phenol sales units drop 1.000.000 every quarter compared to 1919 and melamine products increase in 1.500.000 every quarter Raw materials cost has also changed both melamine and phenol resins have a prices per Kg of 2 Prepare a new production schedule maximizing the result, assigning the overtime if needed to the last quarter and prepare a quarterly budget 2020
