Emery Pharmaceutical uses an unstable chemical compound that must be kept in an environment where both temperature and humidity can be controlled. Emery uses 200 pounds per month of the chemical, estimates the holding cost to be £3.33 (because of spoilage), and estimates order costs to be £10 per order. The cost schedules of four suppliers are as follows: SEE PHOTO ATTACHED: What quantity should be ordered, and which supplier should be used?

Emery Pharmaceutical uses an unstable chemical compound that must be kept in an environment where both temperature and humidity can be controlled. Emery uses 200 pounds per month of the chemical, estimates the holding cost to be £3.33 (because of spoilage), and estimates order costs to be £10 per order. The cost schedules of four suppliers are as follows: SEE PHOTO ATTACHED: What quantity should be ordered, and which supplier should be used?

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

One option for coverage for flood, earthquake, and possible other loss exposures not covered under regular commercial property policies is a difference in conditions (DIC) policy. Which one of the following statements is true regarding DIC policies? DIC policies often require coinsurance as a condition of the property coverage. DIC insurance is not a cost-effective method of obtaining flood and earthquake coverage. DIC forms may offer broader coverage for some perils, and some exclusions may be less restrictive. A DIC policy takes little time to negotiate and prepare when compared to a policy made up of standard forms.
SLO 9.2. Expediting: May be caused by the buyer or the supplierIs caused by buyer behavior onlyIs caused by supplier behavior onlyMay be the result of legal noncomplianceIs a routine order tracking process SLO 10.1. Radio frequency identification (RFID) will: Eliminate bar coding and manual countingEliminate further investment in information technologySupplement bar coding to reduce theftBe more cost effective to implement than bar codingImprove data capture but slow down inventory picking
Sarah is a buyer for a department store. A supplier offers her a 5 percent discount if shetriples her usual order quantity. Which of the following best explains why Sarah shouldtake the deal?a. Even though the increase in the operating costs is likely to exceed the benefit of the5 percent discount, Sarah feels that her customers expect the lowest possible price.b. Sarah hopes that customers are likely to purchase more if they see an increase in theinventory in the store.c. Sarah knows that even though she may triple her order quantity, this would increaseher operating costs by far less than a factor of three.d. Sarah knows that the sum of operating costs is probably less than 5 percent of thepurchase cost, so an increase in the operating costs is unlikely to be a concern.
The sales value at splitof method: a. allocates joint costs to joint products on the basis of the relative total sales value at the splitof point b. allocates joint costs to joint products in a way that each product has an identical gross-margin percentage c. allocates joint costs to joint products on the basis of a comparable physical measure at the splitof point d. allocates joint costs to joint products on the basis of relative NRV
Adriana Alvarado has decided to purchase a personal computer. She has narrowed the choices to two: Drantex and Confiar. Both brands have the same processing speed, 6.4 gigabytes of hard-disk capacity, two USB ports, and a DVDRW drive, and each comes with the same basic software support package. Both come from mail-order companies with good reputations. The selling price for each is identical. After some review, Adriana discovers that the cost of operating and maintaining Drantex over a 3-year period is estimated to be $300. For Confiar, the operating and maintenance cost is $600. The sales agent for Drantex emphasized the lower operating and maintenance costs. The agent for Confiar, however, emphasized the service reputation of the product and the faster delivery time (Confiar can be purchased and delivered 1 week sooner than Drantex). Based on all the information, Adriana has decided to buy Confiar. What is the total product purchased by Adriana?
Suppose that a firm can produce a part it uses for $520 per unit, with a fixed cost of $25,000. The company has been offered a contract from a supplier that allows it to purchase the part at a cost of $544 per unit, which includes transportation. The key outputs in the model are the difference in these costs and the decision that results in the lower cost. Assume that the production volume is uncertain. Suppose the manufacturer has enough data and information to estimate that the production volume will be normally distributed with a mean of 1,000 and a standard deviation of 85. Use a 100-trial Monte Carlo simulation to find the average cost difference and percent of trials that result in manufacturing or outsourcing as the best decision. Please include table showing both the cost difference and decision for each trial. Please include the Excel worksheet with all the details with your answer.
A small firm uses 3,400 lbs of chemical dye a year. Currently the firm purchases 300 lbs per order and pays $3 per order. The supplier has just announced that orders of 1,000 lbs or more will be filled at a price of $2per lb. The firm incurs a cost of $100 each time it submits an order and assigns an annual holding cost of 17% of the purchase price. If the supplier offered the discount at 1,500 lbs instead of 1,000 lbs, what order size would minimize total cost. What is the total cost at 1500
Suppose that a firm has the option to make or buy a part. Its annual requirement is 11,000 units. A supplier is able to supply the part at $6 per unit. The firm estimates that it costs $800 to prepare the contract with the supplier. To make the part, the firm must invest $29,000 in equipment, and the firm estimates that it costs $3 per unit to make the part. COSTS MAKE OPTION BUY OPTION Fixed Cost $29,000 $800 Variable Cost $3 $6 Annual Requirement = 11,000 units 1. What is the break-even point? Round your answer to the nearest whole number. 2. What is the total cost at the break-even point? Round your answer to the nearest dollar. 3. What is the total cost for the make option? Round your answer to the nearest dollar.
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.
SLO 7.1. The purpose of a requisition is: To request or requisition supplies from external suppliersTo give users a way to authorize buyers to acquire goods and servicesTo clarify the description of need before communicating with potential suppliersTo solicit price quotes for goods or services from suppliersTo give finance a way to have the final say in any decision to spend money SLO 8.1. Online reverse auctions are typically used when: Specifications are clearly definedThere is a competitive supply market with qualified suppliers willing to participateThe buyer is prepared to switch suppliers if necessarySpecifications are clearly defined and there is a competitive supply market with qualified suppliers willing to participateSpecifications are clearly defined, there is a competitive supply market with qualified suppliers willing to participate, and the buyer is prepared to switch suppliers if necessary
Kai is perplexed by the manufacturer’s invoice, which specifies the product’s negotiated price of $100,000 plus a discount of 3/10 net 30. You explain that if your company pays the invoice within 10 days, it will only have to pay a. $103,000 b. $92,000 c. $70,000 d. $100,000 e. $97,000 Component parts are an example of a firm's costs. a. breakeven b. fixed c. operating d. variable e. selling Greta has an idea for a new product. She wants to market outdoor holiday LED lights that can change their colors so that consumers can hang them outside year-round and alter the colors of the lights to match the season: multicolor for Christmas or blue and white for Hanukkah, orange and black for Halloween, and pastel colors for Easter. Because she wants such a product herself, she believes that others will want such a product as well. She thinks she has the financial resources to develop and market the product. In order to develop the product, what should her next step be? a. Technical…
The number of persons likely to die within a year, at each age, is calculated by actuaries on the basis of past experiences and made available as: a. Mortality tables b. Calculation tables c. Monetary tables d. Tariff tables For offering a group insurance scheme, we need a: a. Large group b. Heterogeneous large group c. Homogeneous large group d. Small group