Diamond Line is a distributor of everything a florist needs to create a beautiful arrangement exceptthe flowers. It sells to 10,000 flower and gift shops and 3,000 supermarkets nationwide. Each floristis called on four times a month, and each supermarket is called on twice a month. A sales call to aflorist takes one hour, and a sales call to a supermarket takes two hours of selling time. An averagesalesperson spends 1,000 hours per year making sales calls. Calculate the number of salespeopleDiamond Line needs to cover its account base for a year.O 585O 879O 312624O 262

Marketing and sales are closely knit together.

Answered: Diamond Line is a distributor of…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section2.5: Ordering With Quantity Discounts And Demand Uncertainty

Problem 5P

See similar textbooks

Similar questions

FarmFresh Foods manufactures a snack mix called TrailTime by blending three ingredients: a dried fruit mixture, a nut mixture, and a cereal mixture. Information about the three ingredients (per ounce) is shown below. Ingredient Cost Volume Fat Grams Calories Dried fruit 0.35 0.25 cup 0 150 Nut mix 0.50 0.375 cup 10 400 Cereal mix 0.20 1 cup 1 50 Let D = number of ounces of dried fruit mix in the blend; N = number of ounces of nut mix in the blend ; C = number of ounces of cereal mix in the blend. The constraint that would ensure the mixture has no more than 25 grams of fat is:
The Sports Shoe Company is a manufacturer of basketball and football shoes. The manager of marketing must decide the best way to spend advertising resources. Each football team sponsored requires 120 pairs of shoes. Each basketball team requires 32 pairs of shoes. Football coaches receive $300,000 for shoe sponsorship, and basketball coaches receive $1,000,000. The manager’s promotional budget is $30,000,000. The company has a limited supply (4 liters, or 4,000 cubic centimeters) of flubber, a rare and costly compound used in promotional athletic shoes. Each pair of basketball shoes requires 3 cc of flubber, and each pair of football shoes requires 1 cc. The manager wants to sponsor as many basketball and football teams as resources will allow.a. Create a set of linear equations to describe the objective function and the constraints.b. Use graphic analysis to find the visual solution.c. What is the maximum number of each type of team that the company can sponsor?
A deli owner has room for 45 containers of shredded Parmesan cheese. He has 5-oz and 10-oz containers, and a total of 350 oz. cheese. If 5-oz containers sell for $8 and 10-oz containers sell for $14, how many of each should he sell to maximize his revenue? What is his maximum revenue?
The Robot Company franchises combination gas and car wash stations throughout the United States. Robot gives a free car wash for a gasoline fill-up is about the same as far a wash alone, charges $0.50. Past expericnce shows that the number of customers that have car washes following fill-ups is about the same as for a wash alone. The average profit on a gasoline fill-up is about $0.70, and the cost of the car wash to Robot is $0.10 Robot stays open 14 hours per day. Robot has three power units and drive assemblies, and a franchisee must select the unit prefered Unit I can wash cans at the rate of one every five minutes and is leased for $12 per day. Unit I, a larger unit, can wash cars at the rate of one every four minutes but costs $16 per day. Unit II, the largest, costs $22 per day and can wash a car in three minutes. The franchisee estimates that customers will not wait in line more than five minutes for a car wash. A longer time will cause Robot to lose the gasoline sales as well…
Show & Sell can advertise its products on local radio and television (TV). The advertising budget is limited to $10,000 a month. Each minute of radio advertising costs $15 and each minute ofTY commercials $300. Show & Sell likes to advertise on radio at least twice as much as on TV. In the meantime, it is not practical to use more than 400 minutes of radio advertising a month. From past experience, advertising on TV is estimated to be 25 times as effective as on radio. Determine the optimum allocation of the budget to radio and TV advertising.
Please no written by hand and no emage Kindly create a spreadsheet from the problem description. Find the optimal solution using Excel Solver (Please show working with steps on a spreadsheet) : The Heinrich Company manufactures two types of plastic hangerracks (Foldaways and Straightaways) especially suited for mountingnear clothes dryers. Because permanent press clothing must be hungon hangers immediately after removal from the dryer, these items havebeen especially popular. However, there is some concern that thePreppie movement (popularized by its own handbook) will extinguishpolyester clothing; Heinrich is terribly interested in doing the best withthe resources it has while its products are still in demand. The firsttype of hanger rack, the Foldaway, requires 10 ounces of plasticmaterial and 0.3 hours of labor. Plastic costs Heinrich 10 cents anounce; labor costs Heinrich $20 per hour. The second type of hangerrack, the Straightaway, requires 15 ounces of plastic and 0.175…
***without Explain please********without Explain please********without Explain please**** 1. M Cafe located in Adliya requires 3,000 pcs of pizza dough every quarter. They are spending BD 50 as order cost and BD 10 to maintain the quality of pizza. How much should they order so that they can maintain the lowest cost? a.346.41 pcs b.400 pcs c.420.5 pcs d.345 pcs e. 500 pcs 2.Ms. Therese is a regular customer that represents AMD Inc. Her company wants wants 180,000 pcs of Item A in 2 weeks but your maximum capacity is only 65,000 pcs per week .This requirement will be there for at least a year. From what is given below, which recommendation is not acceptable? a. All the answers given are not acceptable b.Turn down the order as it exceeds your capacity c.Get a subcontractor to help increase the capacity d.Get additional machines e.Hire more people and make 2 working shifts
. A commercial orchard grows, picks, and packs apples and pears. A peck (quarter bushel) of apples takes 4 minutes to pick and 5 minutes to pack; a peck of pears takes 5 minutes to pick and 4 minutes to pack. Only one picker and one packer are available. How many pecks each of apples and pears should be picked and packet every hour (60 minutes) if the profit is $3/peck for apples and $2/peck for pears? Solve graphically as a linear program and confirm analytically.
A firm making snowblowers produces the augers for each snowblower in batches. Annual demand is for 3,000 snowblowers, which means 3,000 augers need to be produced each year. On a given workday, 10 augers are needed for snowblower production. Annual holding costs are $3 per auger. Before the augers are produced, a setup cost of $100 is incurred to setup the equipment to produce a batch of augers. The firm can produce 50 augers per day. Given this information, find the economic production quantity for the auger units. Note: When doing interim calculations, round value to 2 decimal points.
Chicago Mercy Hospital needs to order drugs that are used to treat heart attack victims. Annually, 500 units of drug 1 and 800 units of drug 2 are used. The unit purchasing cost for drug 1 is $150 per unit, and the unit cost of purchasing drug 2 is $300. It costs $20 to store a unit of each drug for a year. When only drug 1 is ordered, an order for drug 1 costs $400. When only drug 2 is ordered, an order for drug 2 costs $600. If both drugs are ordered at the same time, the cost of placing an order is $800. Chicago Mercy’s annual cost of capital is 18%. Determine a cost-minimizing ordering policy
Happy Dog Inc. produces three types of dog food. Puppy Blend is produced for dogs that are less than a year old, Adult Blend for dogs between 1 and 8 years old, and Geriatric Blend for dogs older than 8 years. Each blend, sold in 5 pound bags, has a unique recipe that requires, among other ingredients, exact quantities of certain raw materials. Chicken Fish Meal Soy Flour Demand (in5 lb. bags) Puppy Blend Adult Blend Geriatric Blend Availability of rawmaterial 2.5 lbs. 1.5 lbs. 1.0 lbs. 10,000 lbs. 1.0 lbs. 2.0 lbs. 2.0 lbs. 20,000 lbs. 0.5 lbs. 0.5 lbs. 1.0 lbs. 5,000 lbs. 2000 8000 1000 a. Formulate a linear programming model that produces as many bags of dog food as possible without exceeding the demand or the available supply of raw material.b. Reformulate the linear programming model if the company is now interested in maximizing their profit 1price - raw material cost2 from dog food production. Assume that Puppy Blend sells for $9.50 per bag, Adult Blend…
Based on Zangwill (1992). Murray Manufacturingruns a day shift and a night shift. Regardless of thenumber of units produced, the only production costduring a shift is a setup cost. It costs $8000 to run theday shift and $4500 to run the night shift. Demand forthe next two days is as follows: day 1, 2000; night 1,3000; day 2, 2000; night 2, 3000. It costs $1 per unitto hold a unit in inventory for a shift.a. Determine a production schedule that minimizesthe sum of setup and inventory costs. All demandmust be met on time. (Note: Not all shifts have tobe run.)b. After listening to a seminar on the virtues of theJapanese theory of production, Murray has cut thesetup cost of its day shift to $1000 per shift and thesetup cost of its night shift to $3500 per shift. Nowdetermine a production schedule that minimizes thesum of setup and inventory costs. All demand mustbe met on time. Show that the decrease in setupcosts has actually raised the average inventorylevel. Is this reasonable?

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS