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

UA Hamburger Hamlet (UAHH) places a daily order for its high-volume items (hamburger patties, buns, milk, and so on). UAHH counts its current inventory on-hand once per day and phones in its order for delivery 24 hours later. Average daily demand Standard deviation of demand Desired service probability Hamburger inventory 600 100 99% 800 Determine the number of hamburgers UAHH should order for the above conditions. Note: Use Excel's NORM.S.INV() function to find the z value. Round z value to 3 decimal places and final answer to the nearest whole number. Number of hamburgers
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
Required: Prepare the Hiatt Hotel's bank reconciliation for January 20X2. lato qioon de Annd Problem 10 The Terica Café uses a standard cost approach to aid in controlling its food costs. Listed below are the sales price, standard food cost, and quantity sold for its five sandwiches for the week ended August 28. Required Item Selling Price Standard Food Quantity LanSold benhg holltila Cost Evalu e et Pork Barrel kal $4.95 Idovs $1.60 50 Chicken Breast 4.4509 100 1.40 ylim Burger Delightod orlt es ov sv-3.95 how 0.95 2sri orlw emc 150 tosa1.70la ed ei 80v Ocean Catch in 4.95uf edd2.95 won e 0.45 lesiti 40 r IAGO the o Egg Salad aplgre
include lingo codes
An order is shipped to a retail customer who has ordered 8 individual items. This order will be shipped in 4 separate boxes. What is the packing and shipping cost that will be allocated to the order? $18.60 $4.20 $12.60 $8.40 $16.80
Solve all please
The following is data obtained from cheese cake production activities by PT Cheese Higen for January 2018 During January 2018, the number of cheese cakes produced was 20.000 units Requested: 1. What is the total production cost and production cost of cheese cake per unit? 2. What is the total prime cost and prime cost of cheese cake per unit? 3. What is the total conversion cost and the cheese cake conversion cost per unit?
Economic Order Quantity Melchar Company uses 117,600.00 pounds of oats each year. The cost of placing an order is $15, and the carrying cost for one pound of oats is $0.45. Required: 1. Compute the economic order quantity for oats. If required, round your answer to the nearest whole number. pounds 2. Compute the carrying and ordering costs for the EOQ. If required, round your answers to the nearest cent. Carrying cost Ordering cost 24
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
Making sales mix decisions Each morning, Max Smith stocks the drink case at Max’s Beach Hut in Myrtle Beach South Carolina. The drink case has 120 linear feet of refrigerated drink space. Each linear foot can hold either six 12-ounce cans or three 20-ounce bottles. Max’s Beach Hut sells three types of cold drinks: Licious-Ade in 12-oz. cans for $1.40 per can Licious-Ade in 20-oz. bottles for $1.90 per bottle Pep-Cola in 20—oz. bottles for $2.20 per bottle Max’s Beach Hut pays its suppliers: $0.20 per 12-oz. can of Licious-Ade $0.35 per 20—oz. bottle of Licious—Ade $0.55 per 20-oz. bottle of Pep-Cola Max’s Beach Hut’s monthly fixed costs include; Max’s Beach Hut can sell all the drinks stocked in the display case each morning. Requirements What is. Max’s Beach Hur’s constraining factor? What should Max stock to maximize profits? Suppose Max’s Beach Hut refuses to devote more than 80 linear feet to any individual product. Under this condition, how many linear feet of each drink…
Please do not give solution in image format thanku
1. Malinao Bakery forecast sales 2100 loaves of bread for the month ofJanuary. The owner would like to maintain 150 loaves of bread in itsending inventory at the end of each month. The beginning inventory at thestart of January is 50 loaves of bread. How many loaves of bread shouldMalinao Bakery produce for January?A. 2,300 loaves C. 2,200 loavesB. 2,050 loaves D. 2,250 loaves 2. If the projected or forecasted sales of Malinao Bakery for the month of Januaryis 2100 loaves of bread, beginning inventory 50 loaves and the selling price isP50 per loaves. How much are the projected sales in peso of Malinao Bakeryfor January?A. P100,000. C. P107,500.B. P100,500. D. P105,000. 3. What is the possible suggestion of the Accountant or Financial Officer to theowner of the company, if there is excess cash above its required maintainingcash balance?A. Pay all creditsB. Buy brand new carC. Purchase additional machineD. Invest in short term investments to earn additional profits. 4.…