Ms. Math must supplement her diet with at least 80 mg of calcium and at a minimum of 17 mg of iron. Two types of Vitamin capsules, Caltrate and Flexbon meet this requirement. The vitamin capsules Caltrate and Flexbon cost P8 and P6, respectively. Each Caltrate contains 8 mg of calcium and 2 mg of iron, whereas Flexbon contains 5 mg of calcium and 1 mg of iron. Formulate the objective function The minimum costs is The intercepts for the calcium constraints are The intercepts for the iron constraints are The vertex for the optimal solution is

Ms. Math must supplement her diet with at least 80 mg of calcium and at a minimum of 17 mg of iron. Two types of Vitamin capsules, Caltrate and Flexbon meet this requirement. The vitamin capsules Caltrate and Flexbon cost P8 and P6, respectively. Each Caltrate contains 8 mg of calcium and 2 mg of iron, whereas Flexbon contains 5 mg of calcium and 1 mg of iron. Formulate the objective function The minimum costs is The intercepts for the calcium constraints are The intercepts for the iron constraints are The vertex for the optimal solution is

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...

See similar textbooks

Similar questions

A boat manufacturer requires 14 outboard engines per day in its assembly operations. No shortages are to be allowed. The engine manufacturer can produce 100 outboard engines per day. The cost associated with initiating engine manufacturing action is $2,500 and the holding cost is $3.00 per engine per day. The manufacturing cost is $1,000 per engine. This question consists of three parts. (1) Find the minimum-cost production quantity. (2) Find the minimum-cost procurement level of production lead time is 45 days. (3) Calculate the total system cost per day.
The number of taxicabs in Motorville and the taxicab fares are regulated. The fare currently charged is Rs.500 a ride. Motorville taxicab drivers want to obtain government's permission to raise the fare to increase their revenues and ask you to be their economic adviser. After studying the market, you come up with the following demand schedule for taxicab rides: Price (Rupees per ride) Quantity demanded (rides per month) 300 160 400 120 500 80 600 40 700 0 (i) Calculate the price elasticity of demand for taxicab rides as the fare rises from Rs.500 to Rs.600. Is the demand…
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…
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?
Inayah is a rational consumer who consumes milk and cookies only from her monthly income of Rs. 1,500. If the price of milk is Rs. 500 per liter and the price of one pack of cookie is Rs. 300, answer the following questions: Assume that Inayah’s consumption of milk and cookies give her following level of utility: Quantity MU milk MU cookies 1 400 450 2 350 200 3 200 150 4 100 100 5 70 60 6 30 30 7 0 0 Find the optimal level of consumption. Find the consumer equilibrium using the two-dimensional labeled diagram.
Three years ago, Barbara Jones started a business that creates and delivers holiday and birthday gift baskets to students at the local university. Barbara sells the baskets for $ 29 each, and her variable costs are $ 19 per basket. She incurs $ 12,500 in fixed costs each year. Last year, Barbara sold 4,000 baskets, and she believes that demand this year will be stable at 4,000 baskets. The following are the actions Barbara could take if she wants to earn $ 30,900 in operating income by selling only 4,000 baskets. Consider each action independently. (Round per unit answers to 2 decimal places, e.g. 52.75 and fixed cost to 0 decimal places, e.g. 5,275.) Raise selling price per unit to? Reduce variable costs per unit to? Reduce fixed costs to?
A restaurant uses 100 per week or 5,000 quart bottles of ketchup each year. The ketchup costs $3.00 per bottle and is served only in whole bottles because its taste quickly deteriorates. The restaurant figures that it costs $10.00 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes 3 weeks for an order to arrive. The restaurant operates 50 weeks per year. The restaurant would like to use an inventory system that minimizes inventory cost. The restaurant has figured that the most economical order size or EOQ is approx. 409 (rounding up the decimals). Approximately, what is the time between two orders (in terms of weeks) 08 06 04 02 None of the above
The Rainwater Brewery produces Rainwater Light Beer, which it stores in barrels in its warehouse and supplies to its distributors on demand. The demand for Rainwater is 1,500 barrels of beer per day (365 days per year). The brewery can produce 2,000 barrels of Rainwater per day. It costs $6,500 to set up a production run for Rainwater. Once it is brewed, the beer is stored in a refrigerated warehouse at an annual cost of $50 per barrel. Determine the economic order quantity and the minimum total annual inventory cost.
Greener Pastures Incorporated (GPI) produces a highquality organic lawn food and weed eliminator called SuperGreen (SG). Super Green is sold in 50-pound bags. Monthlydemand for Super Green is 75,000 pounds. Greener Pastures hascapacity to produce 24,000 50-pound bags per year. Th e setup costto produce Super Green is $300. Annual holding cost is estimatedto be $3 per 50-pound bag. Currently, GP is producing in batchesof 2500 bags.(a) Calculate the total annual costs of the current operatingpolicy at GPI.(b) Calculate the economic production quantity (EPQ).(c) Calculate the total annual costs of using the EPQ.(d) Calculate the penalty cost incurred with the presentpolicy.
A grocery store company specializing in rare and expensive foods is considering operating under a backorder policy for a particular kind of Bel- gian cheese. The company currently operates with no backorders. It costs the company $75 to place an order with the Belgian manufacturer, and pays $1500 per wheel of cheese, with a 20% annual holding cost per wheel. De- mand for the cheese is on average 1 wheel of cheese per week. The company operates the store 50 weeks per year. (a) What is the economic order quantity that minimizes yearly inventory cost (with no backorders)? (b) What is the total cost to operate this inventory policy? Page 3 of 8 (c) The company proposes allowing backorders. It will compensate cus- tomers by providing them a discount and promising home delivery. The company estimates the backorders will cost $680 per wheel of cheese. What is the new economic order quantity and planned backorder quan- tity under the new policy? (d) What is the total cost of the backorder…
Consider a hardware supply warehouse that is contractually obligated to deliver 1000units a specialized fastener to a local manufaturing company each week. Each time thewarehouse places an order for these items from its supplier, an ordering and transporationfee off $20 is charged to the warehouse. The warehouse pays $1.00 for each fastener andcharges the local firm $5.00 for each fastener. Annual holding cosst iss 25% off inventoryvalue, or $0.25 per year. The warehouse manager would like to know how much to orderwhen inventory gets to zero.Assume that the warehouse works 50 weeks/year.
An electronics retailer sells laptops at a steady rate of 7,500 per quarter. It costs the manufacturer $350 tomake each laptop, and they charge $400/laptop to the retailer. The manufacturer produces the laptop at asteady rate that matches demand, and incurs a fixed cost of $2,800 to fulfill each retail order. Both theretailer and the manufacturer have an annual holding cost percentage of 20%. The retailer places 10orders with the laptop manufacturer each quarter (which it determined from an EOQ calculation). Whatare the retailer’s and manufacturer’s costs under this current setup, as well as the total supply chain cost?What quantity discount should the manufacturer offer the retailer in order to minimize the total supplychain costs? Under this quantity discount, what are the new retailer and manufacturer costs? Does theretailer choose to use the quantity discount? PLEASE SHOW ALL CALUCALTIONS/EXCEL MODEL