Assignment 1- Due at 11.59PM on 09/16/24 via the D2L Dropbox only 1. The Danone dairy company produces three cheese spreads- Asiago, American and Pecorino. The cheese spreads are packaged in 1.75 pound containers, which are then sold to distributors throughout the Northeast. The Asiago blend must have at least 58% extra sharp cheddar, the Pecorino blend must contain at least 11% extra sharp cheddar and the American blend must contain at least 26% extra sharp cheddar. The company has orders for 3850 containers of Asiago, 2200 containers of Pecorino and 950 containers of American. This year, a local dairy cooperative offered to provide the three ingredients that will be used in the production process. They can offer up to 1700 pounds of ingredient 1 for $2.72 per pound, up to 3800 pounds of ingredient 2 for $3.60 per pound and up to 1900 pounds of ingredient 3 for 2.95 per pound. Ingredient 1 consists of 55% mild cheddar and 45% extra sharp while ingredient 2 consists of 45% mild and 55% extra sharp. Ingredient 3 consists of 22% mild and 78% extra sharp Per pound extra sharp percentage in Asiago at least 58% Formulate a Linear Programming model to determine the optimal production plan.

Assignment 1- Due at 11.59PM on 09/16/24 via the D2L Dropbox only 1. The Danone dairy company produces three cheese spreads- Asiago, American and Pecorino. The cheese spreads are packaged in 1.75 pound containers, which are then sold to distributors throughout the Northeast. The Asiago blend must have at least 58% extra sharp cheddar, the Pecorino blend must contain at least 11% extra sharp cheddar and the American blend must contain at least 26% extra sharp cheddar. The company has orders for 3850 containers of Asiago, 2200 containers of Pecorino and 950 containers of American. This year, a local dairy cooperative offered to provide the three ingredients that will be used in the production process. They can offer up to 1700 pounds of ingredient 1 for $2.72 per pound, up to 3800 pounds of ingredient 2 for $3.60 per pound and up to 1900 pounds of ingredient 3 for 2.95 per pound. Ingredient 1 consists of 55% mild cheddar and 45% extra sharp while ingredient 2 consists of 45% mild and 55% extra sharp. Ingredient 3 consists of 22% mild and 78% extra sharp Per pound extra sharp percentage in Asiago at least 58% Formulate a Linear Programming model to determine the optimal production plan.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter11: Linear Optimization Models

Section: Chapter Questions

Problem 12P: The Atlantic Seafood Company (ASC) is a buyer and distributor of seafood products that are sold to...

See similar textbooks

Similar questions

Problem 11-14 (Algo) Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every four weeks to take orders. Because the orders are shipped directly from Italy, they take three weeks to arrive. Charlie's Pizza uses an average of 250 pounds of pepperoni each week, with a standard deviation of 12 pounds. Charlie's prides itself on offering only the best-quality ingredients and a high level of service, so it wants to ensure a 90 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 450 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? Note: Use Excel's NORM.S.INV() function to find the z value. Do not round intermediate calculations. Round z value to 2 decimal places and final answer to the nearest whole number. Amount of pepperoni ordered
Please do not give solution in image format thanku
A1
21.7A
Gg.7.
solve all parts within 30 mins
PROBLEM 3 Present your answer as 1000 FAVORABLE OR 1000 UNFAVORABLE if applicable. MARINA Bottlers Inc, a leading softdrinks company is producing their bottle requirements. For each case of 24 eight-ounce bottles, the company prescribed the following standard product mix: Material A @ 2.4 lb,P50/lbs;Material B @ 6 lb,P22/lbs and Material C @ 1.6 lbs, P15/lb. During the month of August, 25,000 cases were produced from an input of: Material Pounds Cost/lb A 63,700 49.00 B 125,200 20.50 C 48,100 16.00 1. COMPUTE FOR THE MATERIALS MIX VARIANCE. 2. COMPUTE FOR THE MATERIALS YIELD VARIANCE.
Required information You are the owner of a very small business that sells gourmet coffee. You sell only one product, a 12-ounce bag of whole-bean French roast coffee. You sell each bag of coffee for $14 each, but due to the fluctuation in commodity prices, the price you pay your supplier to stock the product is constantly changing. In your first month of operations, you bought bags of coffee from your supplier in the following order: (a) 2 units at $2 each on January 1, (b) 6 units at $4 each on January 8, and (c) 4 units at $8 each on January 29. Requirement 1 (of 2): Assuming you sold 7 units during the month, calculate the cost of goods available for sale, cost of goods sold, and cost of ending inventory under the (a) FIFO, (b) LIFO, and (c) weighted average cost flow assumptions. Assume a periodic inventory system is used. (Round "Cost per Unit" to 2 decimal places.) Cost of Goods Available for Sale Cost of Goods Sold Ending Inventory FIFO $ 60.00 $ LIFO 60.00 Weighted Average…
Multiplication table: 1. Quantity ordered Percentage of Discount Less than 100 units 5 % 101-150 units 10% 151-200 units 15% 201-250 units 20% 251units and above 25% With reference to the above table, if a cumulative discount was given by JJ Cake Pastries to Ace Catering for twenty dozens of cupcakes, priced at P25.00 per unit for orders within one month. Total amount payable is P________ if orders are as follow: November 6, 2020 - 5 dozens November 8, 2020 - 10 dozens November 15, 2020 - 10 dozens November 20, 2020 - 8 dozensa. 7,425 b.7,920 c.8,910 d.8,415 2. William is the owner of a company that specializes in the manufacturing of office computers and printers. He recently received a large order from a company…
14/ Do not solve it in excel, please.
c.16q1 Can you help me
2. [EXCEL] Operating cycle: Lilly’s Bakery distributes its products to more than 75 restaurants and delis. The company's average collection period is 27 days, and it keeps its inventory for an average of four days. What is Lilly's operating cycle? Please use excel