Consider the following problem: A company supplies goods to three customers, who each require30 units. The company has two warehouses. Warehouse 1 has 40 units available, and warehouse 2has 30 units available. The costs of shipping 1 unit from warehouse to customer are shown below.Customer 1.From ToWarehouse 1Customer 235Customer 325$15Warehouse 2105040There is a penalty for each unmet customer unit of demand: With customer 1, a penalty cost of$90 is incurred; with customer 2, $80; and with customer 3, $110.a. Formulate the corresponding model to determine the optimal transportation schedule.b. Solve the model using northwest-corner method and stepping-stone method.

Find the given details below: Transportation Schedule From/To Customer 1 Customer 2 Customer 3…

Answered: Consider the following problem: A…

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

Valles Galactic Industries (VGI) owns a small company (VGI-Durango Sur) that manufactures various electronic products for original equipment manufacturers. Customer companies provide engineering designs, materials lists, and some unique materials. VGI-DS provides labor and space for the manufacturing and assembly operations and stocking a variety of inventory items for production, such as wire, cables, some electronic components, etc. Thus, VGI-DS orders a variety of components and raw materials by contract. The labor pool is primarily composed of about 100 retirees picking up extra cash by working four to six-hour shifts. Thus, the assembly operations must be simple and easy to teach. Skilled employees must do several raw material conversions for packaging—there are currently three such employees. VGI-DS receives forecasts from VGI headquarters for planned production for two years on a rolling quarterly basis. Staff at VGI-DS develop schedules and inventory plans based on this…
The Petoskey Potato Chip Company produces 3 varieties of gourmet potato chip. The varieties and average daily demand are given below: Bar-B-Que: 325 cases/day Sour Cream & Onion: 215 cases/day Classic Cut: 360 ases/day The company runs 24 hours/day and can produce 1,300 cases of potato chips per day. Each case of potato chip costs $20 to produce and Petoskey assumes 18% of this cost as the annual holding cost. It takes Petoskey 5 hours to setup for production of a different variety at a cost of $715. Calculate the minimum cost cycle time in days. Answer: 25.2 How is this calculated?
ABC Apple Juice Company produces and markets fresh fruit juice. During the apple harvest season, trucks bring apples from the fields to the process plant during a workday that runs long hours from 7AM. On peak days, approximately 3,000 kg of apples are trucked in per hour. Trucks dump their contents in a holding bin with a storage capacity of 9,000 kg. When the bin is full, incoming trucks must wait until it has sufficient available space. A conveyor moves apples from bin to the processing plant. The plant is configured to process apples at the rate of 2,000 kg per hour. Trucks arrive uniformly between 7:00AM to 5:00PM. Each truck holds about 1,000 kg of apples. The truck drivers are paid at the rate of $10 per hour. As ABC makes fresh juice, it does not store apples. Processing plant starts at 10:00AM and ends when all the apples received during the day have been processed. It takes 2 hours to clean the empty plant that must be kept ready for the next day production. Trucks are owned…
A company possesses two manufacturing plants, each of which can produce three products, X, Y, and Z, from a common raw material. However, the proportion in which the products are produced differs in each plant, and so are plant's operating costs per hour. Data on production per hour and costs are given below, together with current orders in hand of each product. Products Operating cost per hour Y Plant A 4 9. Plant B 4 2 10 Orders on hand 50 24 60 Formulate the above as a linear programming problem. Find the number of production hours needed to fulfill the orders on hand at minimum cost using the using Big M method.
Companies like Microsoft and Apple started selling tablets in place of laptops. Many customers switched their purchases from laptops to Tablets. Most of the functions of laptops were also performed by the tablets. Many laptop producers started losing customers. The competitive force mentioned in this scenario is O a. Rivalry among existing competitors. O b. Bargaining power of the suppliers. O c. Threat of substitutes. O d. Bargaining power of the producers.
Golf World, Incorporated (GWI) sells products and services for the sport of golf. One of its key business units specializes in the repair and reconditioning of golf carts. GWI enters into contracts with a number of golf clubs throughout the U.S. in which the clubs send their carts to GWI for a complete reconditioning: motor, frame repair where necessary, and replacement of seat covers and canvas tops. The clubs usually will cycle 10–15% of their carts through this process each year. Because GWI's business has been growing steadily, it is very important to complete the reconditioning of the carts within a budgeted time and cost. The firm uses weighted-average process costing to keep track of the costs incurred in the reconditioning process. GWI's golf cart repair and reconditioning unit has the following information for the month of November, in which 1,200 carts were started for reconditioning: Beginning WIP: 150 units, 50% complete for materials ($16,600) and 30% complete for…
Your company offers a weekly consolidation service from Toronto to Frankfort , via Lufthansa Airways. The carrier has given you a 1000 kg (or less) buying rate of CAN $2.27/kg and a plus 1000 kg buying rate of CAN $1.85/kg. You sell this service to clients who ship 700 kg (or less) at a rate of CAN $2.95/kg and for clients who ship in excess of 700 kg at a rate of CAN $2.55/kg. A) Shipper: J&J Company 123 John Street Toronto, ON, Canada, L5R 2N3 Shipment: 140 cartons of books Total weight: 426 kg Dimensions of each carton: 15 cm x 49 cm x 47 cm B) Shipper: R&R Company 432 Avenue Road Toronto, ON, Canada, R2S 1A3 Shipment: 380 cartons of umbrellas Total weight: 700 kg Dimensions of each carton: 39 in x 18 in x 19 in What is the profit on this shipment? full calculation
Recently, while eating lunch with your family at a local cafeteria, you observe a practice that is somewhat unusual. As you reach the end of the cafeteria line, an adding machine operator asks how many persons are in your party. He then totals the food purchase on the trays for all of your family and writes the number of persons included in the group on the adding machine tape. He hands you the tape and asks you to pay when you finish eating. Near the end of the meal, you decide you want a piece of pie and coffee so you return to the line, select your food, and again go through the line. The adding machine operator goes through the same procedures, but this time he staples the second tape to the original and returns it to you. When you leave the cafeteria, you hand the stapled adding machine tapes to the cash register operator, who totals the two tapes, takes your money, and puts the tapes on a spindle. a. What internal controls has the cafeteria instituted for its operations? b. How…
The distribution of daily demand for rental trucks at a vehicle rental company is shown in the following table: Relative Frequency Demand 0.07 0 0.14 1 0.15 2 0.14 3 0.12 4 0.08 5 0.3 6 Trucks are rented by the day only and the company makes $14 per rented truck per day. The rental company keeps four trucks at this location. Assuming that the stocking decision is optimal, what is the implied range of excess cost per truck per day? a. 0 and 186 b. 8.58064 and 14 c. 14 and 24.8889 d. 6 and 8.58064 e. 34.2759 and 79.3333
14
The Tubular Ride Boogie Board Company has manufacturing plants in Tucson, Arizona and Toronto, Ontario. You have been given the job of coordinating distribution of the latest model, the Gladiator, to outlets in Honolulu and Venice Beach. The Tucson plant, when operating at full capacity, can manufacture 620 Gladiator boards per week, while the Toronto plant, beset by labor disputes, can produce only 410 boards per week. The outlet in Honolulu orders 500 Gladiator boards per week, while Venice Beach orders 530 boards per week. Transportation costs are as follows. Tucson to Honolulu: $10 per board; Tucson to Venice Beach: $5 per board. Toronto to Honolulu: $20 per board; Toronto to Venice Beach: $10 per board. (a) Assuming that you wish to fill all orders and ensure full capacity production at both plants, is it possible to meet a total transportation budget of $9,900? O Yes O No If so, how many Gladiator boards are shipped from each manufacturing plant to each distribution outlet? (If…
PROBLEM The management of the Book Warehouse Company wishes to apply the Miller-Orr model to manage its cash investment. They have determined that the cost of either investing in or selling marketable securities is $100. By looking at Book Warehouse’s past cash needs, they have determined that the variance of daily cash flows is $20,000. Book Warehouse’s opportunity cost of cash, per day, is estimated to be 0.03%. Based on experience, management has determined that the cash balance should never fall below $10,000. 1. How much is the cost per transaction?(Use a number, no decimal value, no commas, no currency, no space) * 2. How much is the return point based on the Miller-Orr model of cash management? (Use a number, no decimal value, no commas, no currency, no space) * 3. How much is the upper limit based on the Miller-Orr model of cash management?(Use a number, no decimal value, no commas, no currency, no space) * PLEASE ANSWER ALL QUESTIONS. THANKS!

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS