Question: Please do it on excel. If done so, I'll upvote. Thanks :) A food company wants to launch a new product in Mexico for halloween

 Please do it on excel. If done so, I'll upvote. Thanks

Please do it on excel. If done so, I'll upvote. Thanks :)

A food company wants to launch a new product in Mexico for halloween in the category of cakes. The department of new products has developed four prototypes which have been accepted by marketing and sales; however according to the budget we can only launch 1 product in the Q4 2020. The evaluation of the prototypes must be done based on the following criteria: In the consumer test's, it was obtained that option B was the one that the children liked the most, followed by option A also had a good acceptance and option C and D moderately acceptance. Option A and C : the supplier has limited yellow color and the stock of almonds at Supplier's facility of 1 month. This will delay 1 week the launch of the both options. Option D: the supplier needs at least 6 weeks to get the special packaging to avoid breaking the legs of the product, which will delay the launch by 2 weeks and for option B there are no problems with any ingredients or packaging. For option A an attractive price of 8 pesos per piece was obtained, for option B a price of 10 pesos per piece was obtained and for option C and D for the cost of the ingredients the cost can be 13 pesos per piece. For option A and B the life of the product is 35 days, for option D it is 45 days and for option C it is 30 days, consider an average life of a cake is 40 days. The option D has a very low profit margin, the option C has a medium profit margin and Option A and B have a very good profit margin. The production lines that make option A and option B nationwide are 80% saturated and the lines that make option B and C have sufficient capacity, they are at 60% of their capacity. According to the Weighted Factor Scoring Model, determining which cake is the best option to launch. A food company wants to launch a new product in Mexico for halloween in the category of cakes. The department of new products has developed four prototypes which have been accepted by marketing and sales; however according to the budget we can only launch 1 product in the Q4 2020. The evaluation of the prototypes must be done based on the following criteria: In the consumer test's, it was obtained that option B was the one that the children liked the most, followed by option A also had a good acceptance and option C and D moderately acceptance. Option A and C : the supplier has limited yellow color and the stock of almonds at Supplier's facility of 1 month. This will delay 1 week the launch of the both options. Option D: the supplier needs at least 6 weeks to get the special packaging to avoid breaking the legs of the product, which will delay the launch by 2 weeks and for option B there are no problems with any ingredients or packaging. For option A an attractive price of 8 pesos per piece was obtained, for option B a price of 10 pesos per piece was obtained and for option C and D for the cost of the ingredients the cost can be 13 pesos per piece. For option A and B the life of the product is 35 days, for option D it is 45 days and for option C it is 30 days, consider an average life of a cake is 40 days. The option D has a very low profit margin, the option C has a medium profit margin and Option A and B have a very good profit margin. The production lines that make option A and option B nationwide are 80% saturated and the lines that make option B and C have sufficient capacity, they are at 60% of their capacity. According to the Weighted Factor Scoring Model, determining which cake is the best option to launch

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!