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
Materials: Oats Wheat Barley Malt Honey Water Time: Miller Loader Standard Qty. 525 pounds 450 pounds 85 pounds 65 pounds 25 quarts 25 gallons 4.5 hours Nov. 14 1.5 hours Q Search Overhead is applied at $5.75 per pound completed. The recipe produced 1,025 pounds of cereal mix. If an amount box does not require an entry, leave it blank. If required, round your answers to the nearest cent. a. Journalize the entry for the issuance of raw materials to Job 111407A. Nov. 14 Materials Wages Payable Standard Cost $1.25 per pound $1.15 per pound $1.45 per pound $2.15 per pound $1.20 per quart $0.45 per gallon 1,478 b. Journalize the entry for direct labor incurred for Job 111407A. L $22.75 per hour $11.50 per hour 119.63 1,478 119.63 D 6/
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
Please do not give solution in image format thanku
Please do not give solution in image format thanku
Ameyuri Ringo Dinners Inc. packages a frozen fish dinner that consists of 9 ounces of halibut, 6 ounces of asparagus, 7.5 ounces of, rice, and 4.5 ounces of yogurt. On October 1, the following price standards were set for each batch of 1,000 dinners: Materials Price Standard P.60 per Item Halibut ounce Asparagus.. Rice .25 10 Yogurt .20 The actual cost for 1,000 dinners was: halibut, P.70 per ounce; asparagus P.20 per ounce; rice, P.12 per ounce; and yogurt, P.22 per ounce. Quantity variances arise from the cooking process. The materials used for the 1,000 dinners in Batch 1099 were: Halibut. 8,250 ounces Asparagus.. Rice 5,700 Yogurt. 7,350 4,725 Required: Determine the materials price usage variance and the materials quantity (or usage) variance for Batch 1099. (Indicate whether each variance is favorable or unfavorable.)
CARNING SYSTEM (ACADEMI entory Management - Spring21 Time left 1:39:43 XYZ Company is specialized in mangoes distribution in the city of Muscat. Sales are 400 boxes (unit) per month. It costs. OR 10 to make and receive an order and holding cost is OR 3.5 per box per year. The prices depend on quantities ion purchased such that the order quantities from 1 to 199 at a unit price RO 5; quantity 200 to 499 at a unit price 4.5 RO; and quantity 500 and more at a per unit price of 4 RO. If the discount option is considered, then the best decision that minimizes the total annual inventory cost is ut of O a 200 units. Total cost=27,240 O b. 500 units. Total cost = 20.171 O c. 450 units. Total cost = 23,500 O d. Noneis correct O e. 185 units, Total cost= 30,649 NEXT PAGE EVIOUS PAGE
Cheese 0.80 1.30 In addition, Tobin's has determined the following information about each material: Dough Tomato Cheese Estimated inventory, November 1 560 lbs. 180 lbs. 360 lbs. Desired inventory, November 30 Price per pound 590 lbs. $1.30 170 lbs. 390 lbs. $2.40 $3.40 Prepare November's direct materials purchases budget for Tobin's Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Tobin's Frozen Pizza Inc. Direct Materials Purchases Budget For the Month Ending November 30 Line Item Description Dough Tomato Cheese Total Units required for production: 12" pizza 16" pizza Total units available Total units to be purchased Unit Price Total direct materials to be purchased x $ x $ x $
A1
Question 6 The Achyboi Candies manufacturer of chewing gum, uses a standard cost system. Standard product and cost specifications for 1,000 lbs of chewing gum are as follows: Gumbase Corn Syrup Sugar Quantity 800 lbs 200 lbs 200 lbs Materials record the following: Gumbase Corn Syrup Sugar Price 0.25/lb 0.40/lb 0.10/lb Opening Inventory 10,000 lbs 12,000 lbs 15,000 lbs Purchases in January 162,000 lbs 30,000 lbs 32,000 lbs Determine PV. This one requires numerical answer. Do not put Peso sign. Ending Inventory 15,000 lbs 4,000 lbs 11,000 lbs As standard, it requires 23 hours worth of conversion time. Actual direct labor hours is 3,800 hours at P11,552. Factory OH is applied on a direct labor hours basis at P9 for fixed and P2 for variable. Historically, 4000 direct labor hours are needed for conversion. Actual measured OH is 22,000 at 200,000 lbs output.
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