1. Business
  2. Economics
  3. aggregate planning case san juaniso beverage lps is producing many...

Question: aggregate planning case san juaniso beverage lps is producing many...

Question details

Aggregate Planning Case San Juaniso Beverage lps is producing many types of beverage and has been in the industry for 20 years. None carbonic juices are the major contributors of its income for the last 10 years and is growing since. Also, due to some of its products they can only provide up to 3 production days a week for the none carbonic juices. Schedule is only from Friday to Sunday According to its Plant Manager, production run for its flavor should only be once a month to minimize change over time since changeover time from one flavor to the over is about six hours. No changeover is needed if there is only one flavor run. Shown below is the Sales Forecast for 2019 from January to December for its None Carbonic Juices TOTAL 90,773 82,427 FORECAST RASPBERRY BLUEBERRY JANUARY FEBRUARY 12,119 11,653 14,007 14,277 25,593 22,908 18,603 17,764 22,867 20,065 5,964 20,017 15,43917,731 15,163 19,244 11,591 10,037 9,786 8,607 20,366 20,360 76,420 77,127 106,281 109,247 APRIL MAY JUNE JULY AUGUST SEPTEMBER 15,778 OCTOBER NOVEMBER 15,659 DECEMBER! 18,843 TOTAL 31,059 20,620 22,603 2,403 21,899 32,434 23,729 31,250 23,696 21,777 18,443 16,657 18,315 18,757 29,364 28,017 13,803 28,453 13,931 3,451 112,673 105,166 15,891 26,925 29,093 25,314 185,000 322,100 235,700 291,900 143,200 1,177,900 The beginning inventory of the plant for January 01, 2019 was Flavor Beg.Inventory Raspberry 3,000 Blueberry 10,000 Ube Mango Apple 11,000 18,000 12,000 The production has an hourly production output of 1,440 cases (20 Pallets @72 cases per pallet) and currently has 2 working shifts (8 hours) for the line producing these bottled juices. Moxing of the concentrates also has a limitation since every concentrate has an equivalent 2,000 cases worth of bottles juice (No Partial Mixing) is allowed since once the seal of the concentrates are opened, its shelf- life is up to 8 hours only.
Production Constraints are the following 1. You need to run each flavor once every month. 2. One Case has 24 bottles and 1 Pallet has 72 cases 3. Maintaining Fes Days Level is 12-18 days, Assuming 26 production & selling days in a month 4, Line efficiency is at 95% 5. Selling Price for the None Carbonic Juice is at Php 150/case These are the costs: a. Holding Cost: Php 1.54/case b. Regular Production Cost: Php 32/case c.Overtime Cost is 57,600 per hour. d. Subcontracting Cost: Php 62/case (Sourcing from other Plants, should be in multiples of 1,152 cases) e. Hiring Cost:Php 20,000 per case f. Layoff Cost: Php 40,000 per case Provide an Aggregate Plan in order for the company to be able to supply demand for the year and determine the cost associated with the plan.
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution