Reference no: EM131130285

A. 1. Read and analyze the Super Grain Case in section 3.1 (page 65) and its extension in section 3.4 (page SS) of the textbook, then independently test your abilities in coming up with the algebraic and spreadsheet models along with the solutions for the extended case.

2. Repeat the same above activities in A.1 for the following cases in sections 3.2 and 3.5 respectively.
Think Big" Capital Budgeting (page 75) and Big M Company Transportation Problem (page 95).

B. 1. Based on your reading of the extension of the Super Grain Case study in section 3.4, prepare and submit a report analyzing the case inputs and output result using your own words.

2. Based on your reading of the "Think Big" Capital Budgeting Case in section 3.2, prepare and submit a report analyzing the case inputs and output result using your own words. $ comparison with the Operational Budgeting concept, you we required to Li:cheers why Carder Budgeting u more appropriate to consider in this case.

C. Submit the solutions to problems 3.10, 3.13 (only-a, d, e) and 3 17 on pages 108-109 of the textbook.

D. Submit the solution to the following case:

An Ice cream company supplies its ice cream shops with three flavors of ice cream: chocolate, vanilla, and banana_ In addition to the different specific flavors; Milk, sugar, and cream constitutes the main ingredients required in making ice cream. Due to extremely hot weather and a high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all the orders received from their retail outlets (the ice cream stores). Due to these circumstances, the company has decided to choose the amount of each flavor to produce that will maximize total profit, given the limitations on the supply of the basic ingredients.

The chocolate, vanilla, and banana flavors generate, respectively, $1.00, $0.90, and $0.95 of profit  for each gallon sold. The table below illustrates the required ingredients for making one gallon of ice

 

Ice Cream Flavors Chocolate I Vanilla Ban'
Ingredients (Gallons)             Requirements per gallon
Milk                                       0.45 0.5 0.4
Sugar                                    0.5 0.4 0.4
Cream                                   0.1 0.15 0.2

The company has only 200 gallons of milk, 150 pounds of sugar, and 60 gallons of awn left in its inventory. Provide below the algebraic and Spreadsheet models that represent the above case in order to determine how min, gallons of Ice cream should the compartv produce from each flavor using the available ingredients, in order to maximize the total profit. Your algebraic model must include clear definitions of the Decision Variables to be used in :erring up the Objective Futction and constraints.