6. Given the information provided below, compute the procurement, oversight, transportation, order cycle inventory, pipeline inventory costs, and total supplychain costs for an air conditioner coil purchased from the supplier Entity, Inc. The order size is Q = 14,000 units and the supply chain operates 365 days a year.Do not round intermediate calculations. Round your answers to the nearest dollar.Cost toOversightStore OneOrder LeadCertifiedAnnualPrice perCost perTransport Cost Order CostUnit OneTime inSupplierDemand (D)Unit (P)Unit (0)per Unit (Ct)(Co)Year (Ch)Days (L)Entity, Inc.238,000$17.00$1.98$5.90$270$3.6059Procurement cost:$Oversight cost:Transportation cost:$Order cycle cost:Inventory holding cost:24Pipeline invenory cost:$Total supply chain costs:$

The total supply chain is the combination of the different costs that are summed up to reach the…

Answered: Certified Annual Price per Cost per…

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

128 A company has a factory that is designed so that it is most efficient (average unit cost is minimized) when producing 28,500 units of output each month. However, it has an absolute maximum output capability of 35,000 units per month, and can produce as little as 7,000 units per month without corporate headquarters shifting production to another plant. If the factory produces 18,900 units in October, what is the capacity utilization rate in October for this factory? Note: Round your answer to 1 decimal place.
QUESTION 4 Suppose the following are the seasonal indices for the first three quarters of the year for a quarterly series: Quarter Seasonal Index Q1 72.4 Q2 85.3 Q3 109.6 Remember that the seasonal indices should average 100 so you should be able to infer the seasonal index for Q4. Furthermore, suppose that the estimated coeffcients from a regression of the deseasonalized series on Time are given below: Coefficients Intercept 2,506 Time 71.3 If the original value of the series in a Q1 was 2,040, then what is the seasonally adjusted value? (please round your answer to 1 decimal place)
A candy company has 144 kg of chocolate-covered nuts and 78 kg of chocolate-covered raisins to be sold as two 3 different mixes. One mix will contain half nuts and half raisins and will sell for $7 per kg. The other mix will contain 4 nuts and raisins and will sell for $9.50 per kg. Complete parts a. and b. 1 4 (a) How many kilograms of each mix should the company prepare for the maximum revenue? Find the maximum revenue. The company should prepare kg of the first mix and kg of the second mix for a maximum revenue of $
Your company, Drones, INC, must decide on their path forward in regard to new or expanded facilities for drone production. The table below shows the potential profits/losses for each decision alternative in each of 4 market conditions (states of nature). Note that the numbers in red (with a minus sign) are losses. NOTE: I have provided some extra columns and rows for your computations. NOTE THAT THE OBJECTIVE IS TO MAXIMIZE PROFIT. STATES OF NATURE FOR POTENTIAL MARKETS FOR DRONES DECISION EXCELLENT GOOD FAIR POOR ALTERNATIVES OPEN 2 NEW $600,000 $400,000 -$200,000 -$500,000 PLANTS FOR PRODUCTION OPEN 1 NEW $500,000 $200,000 -$100,000 -$300,000 PLANT FOR PRODUCTION EXPAND $150,000 $75,000 $0 -$100,000 CURRENT PLANT DO NOTHING $0 $0 $0 $0 6.
Q1. General Appliance Corp. produces refrigerators at three plants: Marietta, Minneapolis and Phoenix. They ship them to major retail outlets in Chicago, Los Angeles and New York City. The accounting, production and marketing departments have provided the following information in the given tables; Plant capacities over the next planning period, retail outlet demand and unit cost of shipping between any plant and retail outlet. The company would like to minimize the cost of their transportation network by identifying how many units to ship between each plant and retail outlet. 1. Formulate this linear optimization problem by clearly listing the decision variables, objective function and constraints. 2. Create a spreadsheet model for this problem and solve it using Solver. What is the minimum cost? Plant Supply Marietta 1200 Minneapolis 800 Phoenix 1600 Retail Outlet Demand Chicago 650 Los Angeles 1450 New York City 1500…
5. Daniel is planning to earn money over the summer mowing lawns in the neighborhood to buy a scooter. The scooter he wants costs $2,200. He will be charging $19.1/lawn and estimates his costs to be $2.7/lawn. How many lawns must he mow in order to pay for the scooter entirely through his earnings? a. 115.18 b. None of the other options. c. -134.15 d. 134.15 e. 112.48 f. 2562.20
hh.2
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?

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