Final Project A new company that makes flavored beverages is reviewing its policies and annual action...

  
 
 
 

Transcribed Image Text:

Final Project A new company that makes flavored beverages is reviewing its policies and annual action plan in order to achieve corporate goals and increase its competitiveness. The following information has been collected to be analyzed: • Each soft drink uses a specialized bottler for its personalized bottle, which has a fixed operating cost of $ 2000 per month. • There is a monthly production capacity of 100,000 soft drink bottles, given by the ingredient mixing machine, which produces all types of beverages. • All beverages vary in volume between 500 and 600 ml, which is given by their liquid components, remember that solution volumes are not necessarily additive. • There are silos to store finished beverage before bottling, 6,500 gallons each. • There are statistics on the behavior of customers in their last 2 purchases, the sample is representative of the population. • A minimum of 10% of the total production needs to be produced for each beverage flavor • You want to make a production mix whose proportion resembles the behavior of the client population in the long term. • You want to ensure a minimum profit of $ 200,000 Additionally, there are 2 issues to consider: Since all beverages use the same ingredient mixer, it wears out quickly, the machine works without problems when it is new, when it is new it causes 5% production losses, when it is damaged it causes 15% and when it is inoperable the total loss of the production. Unfortunately there is no way to repair these machines, the only options are to buy a new machine, which costs $ 3000, or buy a used one (semi-new) with supplier A, which costs $ 1500 but 1 out of 10 times turns out to be damaged, or go to supplier B than to offer half the price of A, but the risk of receiving a damaged machine is 3 times higher. (The purchase and delivery of the machine is done quite quickly, and at the beginning of the month so there is no loss of production) 5% of the time a new machine is damaged and is inoperable, while that happens 20% of the time with pre-owned machines and 70% when operating it with damaged ones. New machines tend to break down 10% of the time, while pre-owned ones do 30%. New machines tend to have natural wear and tear that will leave them semi-new 70% of the time. List of ingredients for each flavor Ingredient fructose(gr) sucrose (gr) colorants (ml) carbonated water (ml) maltodextroza (gr) Citric acid (gr) Ascorbic acid (gr) Artificial flavor A (gr) Artificial flavor B (gr) Artificial flavor C (gr) Sale price strawberry 21.94 strawberry pineapple 114 123 143 143 15 25 500 500 30 25 23 12 38 16 21 14 pineapple 22.95 34 6 12 1 cola 25.55 cola grape 123 120 136 139 27 18 500 500 44 19 32 35 35 32 45 19 13 10 1 22 grape watermelon 20.63 22.05 watermelon 136 140 25 500 3 0 8 48 20 14 Purchase price per unit 0.03 0.02 0.1 0.01 0.07 0.05 0.08 0.01 0.01 0.01 Surveys of buyers Previous purchase Strawberry pineapple grape cola pineapple grape cola cola watermelon Strawberry grape grape watermelon grape grape grape cola watermelon watermelon pineapple grape Strawberry watermelon cola cola watermelon grape pineapple cola Strawberry Strawberry cola Current purchase Strawberry pineapple pineapple pineapple grape pineapple pineapple pineapple watermelon watermelon grape watermelon cola grape grape grape Strawberry grape cola grape watermelon watermelon grape watermelon cola cola watermelon Strawberry grape cola pineapple watermelon Previous purchase Strawberry watermelon Strawberry Strawberry Strawberry pineapple Strawberry cola cola cola Strawberry cola watermelon cola Strawberry pineapple cola grape cola watermelon grape cola cola pineapple cola grape cola cola pineapple watermelon Strawberry watermelon Current purchase watermelon grape cola Strawberry pineapple grape grape cola Strawberry pineapple cola watermelon watermelon Strawberry grape grape watermelon Strawberry watermelon pineapple cola Strawberry pineapple grape grape cola cola cola grape grape Strawberry Strawberry Previous purchase pineapple cola cola cola cola grape grape watermelon Strawberry Strawberry pineapple watermelon pineapple pineapple cola watermelon pineapple watermelon Strawberry grape Strawberry pineapple cola grape Strawberry cola pineapple pineapple watermelon watermelon cola watermelon Current purchase Strawberry grape pineapple grape watermelon cola watermelon pineapple cola grape Strawberry grape Strawberry Strawberry pineapple watermelon grape pineapple grape Strawberry Strawberry cola watermelon Strawberry Strawberry pineapple cola watermelon watermelon pineapple grape cola Instructions Determine the course of action to be taken by the company, including contingency cases, as well as the annual estimate of income and expenses for your recommendations. Final Project A new company that makes flavored beverages is reviewing its policies and annual action plan in order to achieve corporate goals and increase its competitiveness. The following information has been collected to be analyzed: • Each soft drink uses a specialized bottler for its personalized bottle, which has a fixed operating cost of $ 2000 per month. • There is a monthly production capacity of 100,000 soft drink bottles, given by the ingredient mixing machine, which produces all types of beverages. • All beverages vary in volume between 500 and 600 ml, which is given by their liquid components, remember that solution volumes are not necessarily additive. • There are silos to store finished beverage before bottling, 6,500 gallons each. • There are statistics on the behavior of customers in their last 2 purchases, the sample is representative of the population. • A minimum of 10% of the total production needs to be produced for each beverage flavor • You want to make a production mix whose proportion resembles the behavior of the client population in the long term. • You want to ensure a minimum profit of $ 200,000 Additionally, there are 2 issues to consider: Since all beverages use the same ingredient mixer, it wears out quickly, the machine works without problems when it is new, when it is new it causes 5% production losses, when it is damaged it causes 15% and when it is inoperable the total loss of the production. Unfortunately there is no way to repair these machines, the only options are to buy a new machine, which costs $ 3000, or buy a used one (semi-new) with supplier A, which costs $ 1500 but 1 out of 10 times turns out to be damaged, or go to supplier B than to offer half the price of A, but the risk of receiving a damaged machine is 3 times higher. (The purchase and delivery of the machine is done quite quickly, and at the beginning of the month so there is no loss of production) 5% of the time a new machine is damaged and is inoperable, while that happens 20% of the time with pre-owned machines and 70% when operating it with damaged ones. New machines tend to break down 10% of the time, while pre-owned ones do 30%. New machines tend to have natural wear and tear that will leave them semi-new 70% of the time. List of ingredients for each flavor Ingredient fructose(gr) sucrose (gr) colorants (ml) carbonated water (ml) maltodextroza (gr) Citric acid (gr) Ascorbic acid (gr) Artificial flavor A (gr) Artificial flavor B (gr) Artificial flavor C (gr) Sale price strawberry 21.94 strawberry pineapple 114 123 143 143 15 25 500 500 30 25 23 12 38 16 21 14 pineapple 22.95 34 6 12 1 cola 25.55 cola grape 123 120 136 139 27 18 500 500 44 19 32 35 35 32 45 19 13 10 1 22 grape watermelon 20.63 22.05 watermelon 136 140 25 500 3 0 8 48 20 14 Purchase price per unit 0.03 0.02 0.1 0.01 0.07 0.05 0.08 0.01 0.01 0.01 Surveys of buyers Previous purchase Strawberry pineapple grape cola pineapple grape cola cola watermelon Strawberry grape grape watermelon grape grape grape cola watermelon watermelon pineapple grape Strawberry watermelon cola cola watermelon grape pineapple cola Strawberry Strawberry cola Current purchase Strawberry pineapple pineapple pineapple grape pineapple pineapple pineapple watermelon watermelon grape watermelon cola grape grape grape Strawberry grape cola grape watermelon watermelon grape watermelon cola cola watermelon Strawberry grape cola pineapple watermelon Previous purchase Strawberry watermelon Strawberry Strawberry Strawberry pineapple Strawberry cola cola cola Strawberry cola watermelon cola Strawberry pineapple cola grape cola watermelon grape cola cola pineapple cola grape cola cola pineapple watermelon Strawberry watermelon Current purchase watermelon grape cola Strawberry pineapple grape grape cola Strawberry pineapple cola watermelon watermelon Strawberry grape grape watermelon Strawberry watermelon pineapple cola Strawberry pineapple grape grape cola cola cola grape grape Strawberry Strawberry Previous purchase pineapple cola cola cola cola grape grape watermelon Strawberry Strawberry pineapple watermelon pineapple pineapple cola watermelon pineapple watermelon Strawberry grape Strawberry pineapple cola grape Strawberry cola pineapple pineapple watermelon watermelon cola watermelon Current purchase Strawberry grape pineapple grape watermelon cola watermelon pineapple cola grape Strawberry grape Strawberry Strawberry pineapple watermelon grape pineapple grape Strawberry Strawberry cola watermelon Strawberry Strawberry pineapple cola watermelon watermelon pineapple grape cola Instructions Determine the course of action to be taken by the company, including contingency cases, as well as the annual estimate of income and expenses for your recommendations.

Answer rating: 100% (QA)

Course of action to be t... View the full answer