DJA Trucking Co. owns several truck used in hauling crushed stones from three different plantsto three road projects in Pampanga. The contractor in charge of the project gives the company theff.ProjecABCF/TXYZRequirementper week150175140ABP100 P200150175200500CP75225125PlantsXYZAvailableper week145160160Compute for the optimal hauling schedule and the total transportation costs. (Use stepping stoneand Least Cost Method (minimum entry method))

Answered: DJA Trucking Co. owns several truck…

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

Greek Circle manufacturing makes and sells specialty hubcaps for the retail automobile after market. GC’s forecast for its wire-wheel hubcap is 2,000 units next year, with an average daily demand of 4 units. However, the production process is most efficient at 8 units per day. If the Setup costs are $10, the Carrying Costs are $0.50 per unit per year, what is the Optimum Production Order Quantity? So the company produces 8 per day but uses only 4 per day. The company wants to solve the optimum number of units per order. (Note. The plant schedules production of this hubcap only as needed, during the 250 days per year the shop operates). If the Setup costs are $10, the Carrying Costs are $0.50 per unit per year, what is the Optimum Production Order Quantity.
7. Shipments of Product Q from a plant to a wholesaler are made in lots of 400. The wholesaler's average demand for Q is 150 units per week. Lead time from plant to wholesaler is 5 weeks. The wholesaler pays for the shipments when they leave the plant. The plant has proposed several new lead time and lot size options to the wholesaler (see table below). If the wholesaler's goal is to minimize total cycle plus pipeline inventories, which option should the wholesaler select? OPTION CURRENT 1 2 3 SHIPMENT LOT SIZE 400 500 800 1,000 PLANT-TO- WHOLESALER LEAD A. option #1 B. option #2 C. option #3 D. remain with the current option TIME 5 4 3 2
A hospital treating COVID patients needs to buy gloves, gowns, and masks for the health care professionals working at the facility. The hospital has two suppliers who can supply the items. The cost, and the maximum number of each item each supplier can provide is given below: Supplier A Supplier B Gloves (cost, max units) ($0.30/unit, 20,000) ($0.35/unit, 11,000) Gowns Masks ($2.00, ($2.50, 5000) 10,000) ($1.75, 7000) ($2.55, 9,500) The hospital immediately needs 30,000 units of gloves, 5500 units of gowns, and 12,500 masks. To account for the economies of scale in logistics, the Supplier A has a requirement of at least 25,000 units in the order, while Supplier B has a requirement of a minimum order size of 10,000 units and a maximum order size of 20,000. What is is the minimum total cost of order that the hospital needs to pay to the suppliers to get the items?
40. An import/export firm has leased 20,000 cubic feet of storage space to store six items that it imports from the Far East. The relevant data for the six items it plans to store in the warehouse are Space per Unit (feet) Annual Demand Item (units) Cost per Unit DVD 32-inch flat screen TV 1,600 Blank DVD's 800 $200.00 150.00 30.00 12 18 8,000 (box of 10) Blank CD's 12,000 18.00 2 (box of 50) Compact stereo Telephone 400 1,200 250.00 24 12.50 3 Setup costs for each product amount to $2,000 per order, and holding costs are based on a 25 percent annual interest rate. Find the optimal order quantities for these six items so that the storage space is never exceeded. (Hint: Use a cell location for the Lagrange multiplier and experiment with different values until the storage constraint is satisfied as closely as possible.)
Item X is a standard item stocked in a company's inventory of spare parts. Each year, the firm uses about 2,000 units of Item X, which costs Php 1,000 per unit. Storage costs, which include insurance and cost of capital, amount to 18 percent of item unit cost. Placing an order for more of Item X costs Php 400. The company operates 360 days per year and Item X is received 9 days after placement of order.
II. Financial information of the business which produces and sells three types of electronical motors is given below: Production Sale Direct Model Quantity (U) Price ($) Material($) Norm 5.000 800 120 Pluger 4.000 1.500 450 Elevator 1.000 2.500 700 Direct Production Labor ($) Time (DLH/U) 80 250 300 4 5 8 Total fixed costs are only 1.750.000$. a. Calculate the BEP for each model, b. Choose the model to prioritize with reasons, c. Compute the common BEP of all models, d. Compute the profit if all the capacity is sold, e. Compute the sale price of each model to get a profit of 5.150.000$.
The fixed quantity version of EOQ compares and contrasts with the fixed interval version. Where will each of the scenarios be used?
bus ules des cussions zzes Please refer to the Network Diagram below. Let Xij represent the number of units shipped from i to j, where i= 1, 2, 3 and j-4, 5, 6. The objective function is to minimize overall transportation cost while making sure all demand is met. Answer each question independently of the other questions. Unit shipping costs are intentionally hidden from the diagram. Supply 100 50 50 Plants 2 Retailers Demand 50 25 110 Under which of the following situations (consider them separately) would we have demand shortages? I. Route 1-6 is removed.
A bagel store orders cream cheese from three suppliers, Cheesy Cream Corp. (CCC), Super Smooth & Sons (SSS), and Bagel's Best Friend Co. (BBF). One month, the total order of cheese came to 100 tons. (The store does do a booming trade.) The costs were $80, $50 and $65 per ton from the three suppliers respectively, with the total cost amounting to $6,710. Given that the store ordered the same amount from CCC and BBF, how many tons of cream cheese were ordered from each supplier? Cheesy Cream Corp.____ tons Super Smooth & Sons ____tons Bagel's Best Friend Co. _____tons
13.2 A company manufactures component parts for machine tools in North America and ships them to Southeast Asia for assembly and sale in the local market. The components are shipped by sea, transit time averages 6 weeks, and the shipping costs $2700 per shipment. The company is considering moving the parts by air at an estimated cost of $7500; the shipment taking 2 days to get there. If inventory in transit for the shipment costs $125 per day, should they ship by air?

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