Every year millions of Canadians enjoy the flavour of ice cream. T J Conner (T J),...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Every year millions of Canadians enjoy the flavour of ice cream. T J Conner (T J), the owner and president of Bakerview Dairies is counting on having more Canadians enjoy the flavour of 'Cowlix Natural Ice Cream', Bakerview's featured brand name product. Cowlix, was introduced in 1995 and it continued to enjoy steady growth in local markets. Many consumers liked both the taste of Cowlix and the fact that the Cowlix brand's ingredients came from dairy cows that are given natural vitamin supplements instead of those with synthetic additives. Bakerview also ensured that their ice cream contained a lower percentage of fat than the competitor's product. This, together with their wacky and exotic flavours, 'Moose Madness' and 'Chai High' have given the company a competitive advantage in the premium ice cream niche market. Ice cream is produced in batches. The batches which consist of 4000 litres of ice cream, are processed in a similar manner and receive the same amount of direct labour costs, basic ingredients, and manufacturing overhead costs. Therefore these costs are averaged over all batches. The following table summarizes the standards for mix and cost of ingredients per 1000 litres of ice cream: STANDARDS FOR MIX AND COST OF MATERIALS (per 1000 litres) VANILLA % in Cost per MOOSE MADNESS % in Cost per CHAI HIGH % in Cost per Ingredients Cream Price Per mix 1000 mix 1000 mix 1000 $4.00 litre 32.0% $640.00 25.0% $500.00 27.0% $540.00 Sucrose $0.65 litre 14.1% $45.83 11.5% $37.38 12.5% $40.63 Stabilizer & emulsifier $3.50 litre 0.6% $10.50 0.5% $8.75 0.5% $8.75 100 Fluid milk $58.20 litres 46.0% $133.86 36.0% $104.76 40.0% $116.40 Milk powder $5.30 kg 5.0% $132.50 4.0% $106.00 4.0% $106.00 Vanilla $70.00 litre 2.3% $805.00 1.0% $350.00 1.0% $350.00 Variegate sauce $6.00 litre 15.0% $450.00 15.0% $450.00 Particulate $7.00 litre 7.0% $245.00 Cost per 1000 litres 100.0% $1,767.69 100.0% $1801.89 100.0% $1,611.78 It is May and the operations team is gearing up for the summer months when sales are at the highest level of the year. The production department prepares for these months by increasing the number of batches produced in June, July and August. The production plan per month and data relating to the various resources required are as below: Ice cream is produced in batches, and the maximum number of batches of Vanilla that can be produced in a month is 30. Each batch produces 4,000 litres of ice cream, which was normally shipped within two days to local retailers and wholesalers. Since Vanilla is one of their best-sellers, they want to ensure that at least 15 batches of Vanilla ice cream are produced per month. The consumption data for labour hours and machine hours, and the maximum hours available in a month are as given below: MACHINE AND LABOUR REQUIREMENTS PER BATCH Vanilla Moose Madness Chai High Maximum Available per Month Machine Hours 17 24 19 720 hours Labour Hours 27.5 27.5 27.5 900 hours Cream is one of the major ingredients of Cowlix ice cream. The main reason for developing the ice cream division was to make efficient use of the cream that was taken from the raw milk in the milk processing division. In the milk processing division, each hectolitre (100 litres) of milk had five percent of the cream skimmed at the separation stage of the production line. The skimmed milk is then pasteurized, homogenized and eventually bottled in the milk processing division. The cream is transferred to the ice cream division. The cream skimmed from milk in the milk processing division is the most inexpensive source of cream for the ice cream division. Purchasing it from outside suppliers would cost more per litre, not to mention the additional overhead for purchasing. As a result, ice cream production was limited to the cream that was skimmed from the milk processed in the milk processing division. Larry, in operations, told them that the milk processing division would purchase 4,220 hectolitres of milk per month in the spring and summer months. After separating the cream and allowing for shrinkage, there would be 20,000 litres of cream available for ice cream per month. A batch of vanilla ice cream requires 800 litres of cream, while a batch of Moose Madness requires 500 and Chai High requires 540 litres. This year there were additional constraints on ice cream production. Severe storms had pummeled Madagascar, the key vanilla-producing region in the world. Vanilla from this island off the east coast of Africa is said to be the best in the world and it was agreed that the Cowlix vanilla flavour recipe was successful because of this prime flavouring. As a result, supplies of quality vanilla flavouring were restricted. Bakerview's supplier had warned them that shipments may be limited to 1,000 litres per month during their peak production months. Cowlix Vanilla ice cream requires 46 litres of vanilla flavouring per batch, while the Moose Madness and Chai High flavours each require 20 litres. The only other restriction on processing was the special sauce for the production of the Chai High flavour. An importer in Vancouver was able to ship a maximum of 2,000 litres of the sauce per month. One 4,000 litre batch of Chai High requires 300 litres of mix. Jared, the Production Manager and Carly, the Management Accountant had disagreed about how to optimize their profits in the production lines. Jared is sure that the restriction on the supply of cream from the milk processing division is limiting their production and their profits while Carly argues that the lack of quality vanilla is reducing their profits. Jared suggests that at extra expense, additional cream should be purchased from an outside source in order to maximize production and profits. Carly insists that they need to focus on their sources and supplies of vanilla. The amount of contribution per batch of each flavour of ice cream is in the following table: Vanilla ICE CREAM CONTRIBUTION PER BATCH Moose Madness Chai High $ 5,000 $ 4,000 $4,750 Required Create a linear programming model in good form by defining the decision variables and stating the linear programming model. (You can assume that Ice Cream can be made in part batches.) Using Excel Solver generate the Answer Report and the Sensitivity Report to answer the questions below. Remember to use the SIMPLEX (or LINEAR) method. Do not use the GRG Non Linear method. 1 What is the optimal solution? 2 (How many batches of each type of Ice Cream should they produce? What will be the Total Contribution Margin.) At the optimal solution, which constraints are binding? 3 Whose assumptions about restrictions were correct, Jared or Carly's? How do you know this? 4 In order to improve profitability which, if any, additional resources should they consider purchasing? Use the Solver reports to justify your answer. 5 If no additional resources are available what might they do to improve profitability? Use the Solver reports to justify your answer. Every year millions of Canadians enjoy the flavour of ice cream. T J Conner (T J), the owner and president of Bakerview Dairies is counting on having more Canadians enjoy the flavour of 'Cowlix Natural Ice Cream', Bakerview's featured brand name product. Cowlix, was introduced in 1995 and it continued to enjoy steady growth in local markets. Many consumers liked both the taste of Cowlix and the fact that the Cowlix brand's ingredients came from dairy cows that are given natural vitamin supplements instead of those with synthetic additives. Bakerview also ensured that their ice cream contained a lower percentage of fat than the competitor's product. This, together with their wacky and exotic flavours, 'Moose Madness' and 'Chai High' have given the company a competitive advantage in the premium ice cream niche market. Ice cream is produced in batches. The batches which consist of 4000 litres of ice cream, are processed in a similar manner and receive the same amount of direct labour costs, basic ingredients, and manufacturing overhead costs. Therefore these costs are averaged over all batches. The following table summarizes the standards for mix and cost of ingredients per 1000 litres of ice cream: STANDARDS FOR MIX AND COST OF MATERIALS (per 1000 litres) VANILLA % in Cost per MOOSE MADNESS % in Cost per CHAI HIGH % in Cost per Ingredients Cream Price Per mix 1000 mix 1000 mix 1000 $4.00 litre 32.0% $640.00 25.0% $500.00 27.0% $540.00 Sucrose $0.65 litre 14.1% $45.83 11.5% $37.38 12.5% $40.63 Stabilizer & emulsifier $3.50 litre 0.6% $10.50 0.5% $8.75 0.5% $8.75 100 Fluid milk $58.20 litres 46.0% $133.86 36.0% $104.76 40.0% $116.40 Milk powder $5.30 kg 5.0% $132.50 4.0% $106.00 4.0% $106.00 Vanilla $70.00 litre 2.3% $805.00 1.0% $350.00 1.0% $350.00 Variegate sauce $6.00 litre 15.0% $450.00 15.0% $450.00 Particulate $7.00 litre 7.0% $245.00 Cost per 1000 litres 100.0% $1,767.69 100.0% $1801.89 100.0% $1,611.78 It is May and the operations team is gearing up for the summer months when sales are at the highest level of the year. The production department prepares for these months by increasing the number of batches produced in June, July and August. The production plan per month and data relating to the various resources required are as below: Ice cream is produced in batches, and the maximum number of batches of Vanilla that can be produced in a month is 30. Each batch produces 4,000 litres of ice cream, which was normally shipped within two days to local retailers and wholesalers. Since Vanilla is one of their best-sellers, they want to ensure that at least 15 batches of Vanilla ice cream are produced per month. The consumption data for labour hours and machine hours, and the maximum hours available in a month are as given below: MACHINE AND LABOUR REQUIREMENTS PER BATCH Vanilla Moose Madness Chai High Maximum Available per Month Machine Hours 17 24 19 720 hours Labour Hours 27.5 27.5 27.5 900 hours Cream is one of the major ingredients of Cowlix ice cream. The main reason for developing the ice cream division was to make efficient use of the cream that was taken from the raw milk in the milk processing division. In the milk processing division, each hectolitre (100 litres) of milk had five percent of the cream skimmed at the separation stage of the production line. The skimmed milk is then pasteurized, homogenized and eventually bottled in the milk processing division. The cream is transferred to the ice cream division. The cream skimmed from milk in the milk processing division is the most inexpensive source of cream for the ice cream division. Purchasing it from outside suppliers would cost more per litre, not to mention the additional overhead for purchasing. As a result, ice cream production was limited to the cream that was skimmed from the milk processed in the milk processing division. Larry, in operations, told them that the milk processing division would purchase 4,220 hectolitres of milk per month in the spring and summer months. After separating the cream and allowing for shrinkage, there would be 20,000 litres of cream available for ice cream per month. A batch of vanilla ice cream requires 800 litres of cream, while a batch of Moose Madness requires 500 and Chai High requires 540 litres. This year there were additional constraints on ice cream production. Severe storms had pummeled Madagascar, the key vanilla-producing region in the world. Vanilla from this island off the east coast of Africa is said to be the best in the world and it was agreed that the Cowlix vanilla flavour recipe was successful because of this prime flavouring. As a result, supplies of quality vanilla flavouring were restricted. Bakerview's supplier had warned them that shipments may be limited to 1,000 litres per month during their peak production months. Cowlix Vanilla ice cream requires 46 litres of vanilla flavouring per batch, while the Moose Madness and Chai High flavours each require 20 litres. The only other restriction on processing was the special sauce for the production of the Chai High flavour. An importer in Vancouver was able to ship a maximum of 2,000 litres of the sauce per month. One 4,000 litre batch of Chai High requires 300 litres of mix. Jared, the Production Manager and Carly, the Management Accountant had disagreed about how to optimize their profits in the production lines. Jared is sure that the restriction on the supply of cream from the milk processing division is limiting their production and their profits while Carly argues that the lack of quality vanilla is reducing their profits. Jared suggests that at extra expense, additional cream should be purchased from an outside source in order to maximize production and profits. Carly insists that they need to focus on their sources and supplies of vanilla. The amount of contribution per batch of each flavour of ice cream is in the following table: Vanilla ICE CREAM CONTRIBUTION PER BATCH Moose Madness Chai High $ 5,000 $ 4,000 $4,750 Required Create a linear programming model in good form by defining the decision variables and stating the linear programming model. (You can assume that Ice Cream can be made in part batches.) Using Excel Solver generate the Answer Report and the Sensitivity Report to answer the questions below. Remember to use the SIMPLEX (or LINEAR) method. Do not use the GRG Non Linear method. 1 What is the optimal solution? 2 (How many batches of each type of Ice Cream should they produce? What will be the Total Contribution Margin.) At the optimal solution, which constraints are binding? 3 Whose assumptions about restrictions were correct, Jared or Carly's? How do you know this? 4 In order to improve profitability which, if any, additional resources should they consider purchasing? Use the Solver reports to justify your answer. 5 If no additional resources are available what might they do to improve profitability? Use the Solver reports to justify your answer.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
(12 of 21) Suppose you are considering buying a stock. You expect the stock to pay a dividend of $3 one year from today and that the dividend will grow 3% each year after that. Using the CAPM, you...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
A square garden has an area of 900 square feet. If a sprinkler (with a circular pattern) is placed in the center of the garden, what is the minimum radius of spray the sprinkler would need in order...
-
What are the main benefits of international harmonization of auditing standards?
-
Prove that for all n Z+, n > 4 = n2 < 2n.
-
At the close of share trading on 24 April 2015, investment ratios for Next plc, the UK fashion and home furnishings retailer, and the averages for the general retailers section, were as follows:...
-
The income statement of Heifer Technology Inc. for the year ended December 31, 2011, is given below. Using the yearly income statement and the supplemental information, reconstruct the third-quarter...
-
Of the last 12 contestants on a game show, 3 qualified for the bonus round. What is the experimental probability that the next contestant will qualify for the bonus round? Simplify your answer and...
-
You are evaluating various investment opportunities currently available for you and identified two mutual funds that you are interested in: equity (stock) fund and long- term bond fund. You have...
-
Given the file structure shown in the following figure. PROJ_NUM PROJ_NAME EMP_NUM Hurricane 1 Hurricane 1 Hurricane 2 Coast 2 Coast EMP_NAME 101 John D. Newson 105 David F. Schwann 110 Anne R....
-
The customers and the potential facilities of a country have been aggregated in seven regions as shown in Figure 1. Figure 1: A B D E F G A 0 7 4 5 12 7 14 B 7 0 11 12 12 14 11 A A company would...
-
Discuss one (1) type of internal communication document and the uses for this type of document (minimum 50 words). -Discuss one (1) type of external communication document and how it is used (minimum...
-
Crane Company of Emporia, Kansas, spreads herbicides and applies liquid fertilizer for local farmers. On May 31, 2022, the company's Cash account per its general ledger showed a balance of $6,000.00....
-
This task relates to problem of temporal and situational factors in consumer behavior. Your task is to devise and compose a two-day record of how you spent time. Note all discrete activities that you...
-
Bridgett Sandals is a Jamaican company that was formed over two decade ago. The company is very profitable and has a wide consumer base locally. Bridgett Scandals conducted a feasibility study and...
-
CRUZ, INC. Comparative Balance Sheets December 31, 2015 CRUZ, INC. Income Statement For Year Ended December 31, 2015 Required Use the indirect method to prepare the cash provided or used from...
-
Ernest Petroleum began operations January 1, 2015. Transactions for the first three years include the data below. Using that data: a. Prepare journal entries assuming full cost (ignore revenue...
-
Data as of 12/31/15 for Dry Hole Oil Companys U.S. properties are as follows: (This problem is similar to problem 14 in chapter 6.) Dry Holes activities during 2016 were as follows: a. Use T-accounts...
-
Cowboy Oil Corporation began operations in 2016. Give the entries, assuming the following transactions in the first three years of operations. Calculate DD&A twice, once assuming no exclusions and...
Study smarter with the SolutionInn App