help please A linear programming computer package is needed.Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around the world. Two of the store's leadingproducts use the Romans Food Market name: Romans Regular Coffee and Romans DeCaf Coffee. These coffees are blends of BrazilianNatural and Colombian Mild coffee beans, which are purchased from a distributor located in New York City. Because Romans purchases largequantities, the coffee beans may be purchased on an as-needed basis for a price 10% higher than the market price the distributor pays forthe beans. The current market price is $0.47 per pound for Brazilian Natural and $0.62 per pound for Colombian Mild. The compositions ofeach coffee blend are as follows.BlendBeanRegularDeCafBrazilian Natural75%40%Colombian Mild25%60%Romans sells the Regular blend for $3.60 per pound and the DeCaf blend for $4.40 per pound. Romans would like to place an order for theBrazilian and Colombian coffee beans that will enable the production of 800 pounds of Romans Regular coffee and 300 pounds of RomansDeCaf coffee. The production cost is $0.80 per pound for the Regular blend. Because of the extra steps required to produce DeCaf, theproduction cost for the DeCaf blend is $1.05 per pound. Packaging costs for both products are $0.25 per pound. Formulate a linearprogramming model that can be used to determine the pounds of Brazilian Natural and Colombian Mild that will maximize the totalcontribution to profit. (Let BR = pounds of Brazilian beans purchased to produce Regular, BD = pounds of Brazilian beans purchased toproduce DeCaf, CR= pounds of Colombian beans purchased to produce Regular, and CD = pounds of Colombian beans purchased toproduce DeCaf.)MaxXs.t.Regular % constraint 0XDeCaf % constraint 0XPounds of Regular 800XPounds of DeCaf 300XWhat is the optimal solution and what is the contribution to profit (in $)? (Round your contribution to profit to two decimal places.)(BR, BD, CR, CD) =XProfit $2338.60Need Help?Read It

Max X s.t. Regular % constraint 0 X DeCaf % constraint 0 X Pounds of Regular 800 X Pounds of DeCaf 300 X What is the optimal solution and what is the contribution to profit (in $)? (Round your contribution to profit to two decimal places.) (BR, BD, CR, CD) = X Profit $2338.60

Max X s.t. Regular % constraint 0 X DeCaf % constraint 0 X Pounds of Regular 800 X Pounds of DeCaf 300 X What is the optimal solution and what is the contribution to profit (in $)? (Round your contribution to profit to two decimal places.) (BR, BD, CR, CD) = X Profit $2338.60

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% How much is the EOQ for each quantity discount? How much should be the EOQ?
ESTRELLA is a bike retailer located in the outskirts of Bacolod City. ESTRELLA purchases bikes from STORAGEHUB in orders of 250 bikes which is the current economic order quantity. STORAGEHUB is now offering the following bulk discounts to its customers: Price 0% discount on orders less than 499 P3,500 10% discount on orders above 500 units - 999 3,150 15% discount on orders above 1,000 units 2,975 ESTRELLA is wondering if the EOQ model is still the most economical and whether increasing the order size would actually be more beneficial. Following information is relevant to forming the decision: Annual demand is 5000 units Ordering cost is $100 per order Annual holding cost is 25% QTY SETUP HOLDING PROODUCT COST TOTAL COST Q1 25423.73 25812.5 what is the product cost what is the total cost Q2 3000 198437.5 what is…
Tasty Treats is a distributor of candy and snack products serving customers in a six-state region of the midwestern United States. Bill Jones, chief operations officer, has been concerned about inventory levels and inventory performance at Tasty Treats for quite some time. In speaking with Jim Busfield, chief executive officer of Tasty Treats, Bill voiced some of his concerns: “Jim, we carry over 5,000 different items in inventory. I have a feeling that we just don’t have a good handle on the proper approach to managing this part of our operations. We don’t have any real analysis that tells us how much we should carry of each item. We just use simple rules of thumb to determine how much we should order from our suppliers. For example, we sell an average of 100 cases of Chocolate Chewies every day. When we order Chocolate Chewies from our supplier, it usually takes about 10 days for us to get the order. So, we order 1,000 cases of Chocolate Chewies every 10 days. I also try to keep an…
Using excel. The Metropolitan Bus Company (MBC) purchases diesel fuel from AmericanPetroleum Supply. In addition to the fuel cost, American PetroleumSupply charges MBC $250 per order to cover the expenses of deliveringand transferring the fuel to MBC’s storage tanks. The lead time for anew shipment from American Petroleum is 10 days; the cost of holding agallon of fuel in the storage tanks is $0.04 per month, or $0.48 peryear; and annual fuel usage is 150,000 gallons. MBC buses operate 300days a year.a.What is the optimal order quantity for MBC?b.Howfrequently should MBC order to replenish the gasoline supply?c.TheMBC storage tanks have a capacity of 15,000 gallons. ShouldMBC consider expanding the capacity of its storage tanks?d.What isthe reorder point?
Carico Ltd, a manufacturer of construction blocks, operates with a fiscal year-end of June 30th, 2021. With a trading history spanning over 25 years, Carico caters to a diverse range of customers, including both large and small hardware stores nationwide. The company's operations encompass a manufacturing plant, five warehouses, and a central head office. Following the manufacturing process, the blocks are stored in one of the warehouses until they are dispatched to customers. It is important to note that Carico currently does not possess an internal audit department. The following is a reflection of the sales system:  Each customer is assigned a distinct customer account number, which is utilized to input sales orders upon receiving written requests from customers. The responsibility of entering orders lies with an order clerk, and the system performs an automated verification to ensure product availability and prevent the customer from exceeding their credit limit.  New customers…
Carico Ltd, a manufacturer of construction blocks, operates with a fiscal year-end of June 30th, 2021. With a trading history spanning over 25 years, Carico caters to a diverse range of customers, including both large and small hardware stores nationwide. The company's operations encompass a manufacturing plant, five warehouses, and a central head office. Following the manufacturing process, the blocks are stored in one of the warehouses until they are dispatched to customers. It is important to note that Carico currently does not possess an internal audit department. The following is a reflection of the sales system: Each customer is assigned a distinct customer account number, which is utilized to input sales orders upon receiving written requests from customers. The responsibility of entering orders lies with an order clerk, and the system performs an automated verification to ensure product availability and prevent the customer from exceeding their credit limit. New customers are…
Square City Appliance orders four types of washing machines. Table 7 gives the annual demand, purchasing cost, and annual holding cost (as a percentage of purchase cost), and the fixed cost of ordering a product. Determine an ordering policy that minimizes the sum of fixed and holding costs. Each time an order is delivered, a $10,000 cost is incurred. Determine an ordering policy to minimize annual cost of meeting demand. TABLE 7 Product 1 Product 2 Product 3 Product 4 Annual demand 10,000 3,000 4,000 500 Unit purchasing cost $400 $300 $200 $900 Holding cost percentage .2 .2 .2 .2 Product order cost $1,000 $1,000 $1,000 $1,000 Step-by-step solution Step 1 of 3 Square city appliance orders four types of washing machines. The annual demand, purchasing cost and annual holding cost (as a percentage of purchase cost) and the fixed cost of ordering a product are given in the table below. Also each time an order is…
Little Caesars 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. Little Caesars Pizza uses an average of 150 pounds of pepperoni each week, with a standard deviation of 30 pounds. Little Caesars prides itself on offering only the best quality ingredients and a high level of service, so it wants to ensure a 98 percent probability of not stocking out on pepperoni. Assume that the sales representative just walked in the door and there are currently 500 pounds of pepperoni in the walk-in cooler. How many pounds of pepperoni would you order? What is the standard deviation of demand during the review period and lead-time? How many pounds of pepperoni would you order?
The Frist Corporation has the followinginternal controls related to inventory:1. Only authorized inventory warehousing personnel are allowed in inventory storageareas.2. All inventory products are stored in warehousing areas that are segregated fromother storage areas used to house equipment and supplies.3. All inventory held on consignment at Frist Corporation is stored in a separatearea of the warehouse.4. The inventory purchasing system only allows purchases from pre-approved vendors.5. The perpetual inventory system tracks the average number of days each inventoryproduct number has been in the warehouse.6. Microchips are embedded in each product and when inventory items are removedfrom the warehouse to shipping, radio-frequencies signal a deduction of inventoryto the perpetual inventory system.7. On a weekly basis, inventory accounting personnel take samples of inventoryproducts selected from the perpetual inventory system and verify that the inventoryis on-hand in the warehouse…
The ePaint stocks paint in its warehouse and sells it online on its Internet Web site The store stocks several brands of paint; however, its biggest seller is SW-IT paint. The company wants to determine the optimal order size and total inventory cost for SW-IT paint given an estimated annual demand of 10,000 gallons of paint, an annual carrying cost of $0.75 per gallon, and an ordering cost of $150 per order. They would also like to know the number of orders that will be made annually and the time between orders (i.e., the order cycle).
Surge Electric uses 4,000 toggle switches a year. Switches are priced as follows: 1 to 499, 90 cents each; 500 to 999, 85 cents each; and 1,000 or more, 80 cents each. It costs approximately $30 to prepare an order and receive it, and carrying costs are 40 percent of purchase price per unit on an annual basis. Determine the optimal order quantity and the total annual cost.
ABC Company has correctly computed its economic order quantity at 1,000 units; however, management feels it would rather order in quantities of 1,500 units. How should ABC’s total annual purchase order cost and total annual carrying cost for an order quantity of 1,500 units compare to the respective amounts for an order quantity of 1,000 units? A. Lower purchase order cost and lower carrying cost B. Lower purchase order cost and higher carrying cost C. Higher purchase order cost and higher carrying cost D. Higher purchase order cost and lower carrying costs