Romeo and Juliet Inc. make different delicious cakes for all ceremonies as required by clients. The most demanded cakes by clients this season include combination of chocolate cakes, white bread, and sugar cookies. Currently stocks at the store include 200 bags of flour, 105 bags of sugar, and 4 dozen eggs, which are the three main ingredients required for baking. The required number of flours to bake chocolate cake, white bread and sugar cookies are 35, 18 and 20 bags, respectively. Meanwhile due to scare of sugar, only 18 bags of sugar, 25 bag and 22 bag of sugar is required for chocolate cakes, white bread, and sugar cookies, respectively. Special cakes for Romeo and Juliet Inc. require that 8 eggs will be need for chocolate cakes, 5 eggs for sugar cookies and 10 eggs for white bread.
The desire baking time require 5 hours to complete cake preparation and baking with 45 minutes require for chocolates, 35 minutes for white bread and 20 minutes require for sugar cookies. Chocolate cake is expected to be sold at unit price of GHC25, a white bread for GHC15, and sugar cookies for GH¢35.
USE YOUR SENSITIVITY REPORT TO ANSWER ALL THE QUESTIONS BELOW. LEAVE ANSWERS TO 2 DECIMAL PLACE WHERE REQUIRED.
1. What is the optimal mix for packs of cakes for this season?
2. What will be the recommended value for white bread required for maximization?
3. Which type of cake will provide the maximum profit.?
4. What is the maximum profit contribution from the optimal mix?
5. Compute the minimum profit required for sugar cookies.
6. By how much profit will be contributed for bags of sugar by a 16 bags.