FREE Trial

A manufacturer of nylon carpets produces rolls of carpeting at four factories and ships them to distributors in five locations The following table shows the capacities at the factories and the demands at the distributors for the next quarter, all

A manufacturer of nylon carpets produces rolls of carpeting at four factories and ships them to distributors in five locations The following table shows the capacities at the factories and the demands at the distributors for the next quarter, all given in thousands of rolls. Also shown are the unit transportation costs between each factory and each distributor, stated in cost per roll.
To Distributor: D1 D2 D3 D4 D5 Capacity 40 50 50 22 15 18 18 20 From F1 From F2 From F3 From F4 16 11 12 24 17 22 21 15

a. What is the minimum-cost distribution plan for the quarter?
b. What is the cost of the distribution plan in part (a)? c. Suppose instead that demand at D4 increases and demand at D3 decreases, each by 1,000 rolls. What is the new optimal cost, assuming that the schedule can be revised? (Answer this question using the pattern in the optimal solution, not by rerunning the model.)

Distribution
The word "distribution" has several meanings in the financial world, most of them pertaining to the payment of assets from a fund, account, or individual security to an investor or beneficiary. Retirement account distributions are among the most...
Transcribed Image Text:

To Distributor: D1 D2 D3 D4 D5 Capacity 40 50 50 22 15 18 18 20 From F1 From F2 From F3 From F4 16 11 12 24 17 22 21 15 20 18 17 15 14 24 21 60 Demand 30 36 48 24 42

This problem has been solved!


Do you need an answer to a question different from the above? Ask your question!
  • Tutor Answer

a The spreadsheet model is displayed in Figure 1 In the decision module the decision variables appear in an array of the same size At the right of eac…View the full answer


answer-question
Related Book For  answer-question
Management Science The Art of Modeling with Spreadsheets

Management Science The Art of Modeling with Spreadsheets

ISBN: 978-1118582695

4th edition

Authors: Stephen G. Powell, Kenneth R. Baker

See More Books
Question Details
Chapter # 9
Section: Exercises
Problem: 3
Posted Date: September 15, 2017 00:23:43
See More Questions

Students also viewed these Numerical Analysis questions

Q:
The Ferguson Paper Company produces rolls of paper for use in adding machines, desk calculators, and cash registers. The rolls, which are 200 feet long, are produced in widths of 11/2, 21/2, and 31/2...
A:
a Let x i number of 10inch rolls of paper processed by cutting alternative i i 127 Min x 1 x 2 x 3 x......
Q:
Suppose 2% of cotton fabric rolls and 3% of nylon fabric rolls contain flaws. Of the rolls used by a manufacturer, 70% are cotton and 30% are nylon. What is the probability that a randomly selected...
A:
Let F denote the event that......
Q:
Bavarian Motor Company (BMC) manufacturers cars and SUVs in Europe and ships them to distributors in the U.S. Presently, BMC has an inventory of 200 cars and 140 SUVs in Newark, NJ and 300 cars and...
A:
a C ij of cars shipped from city i to city j S ij of SUVs shipped from city i to city j Y ij of rail......
Q:
This question is optional and will not be graded. We are interested in examining factors determining women's labor force participation. Use the data set mroz. dta and the do file ps5.2. do to answer...
A:
a Estimate the model using OLS What is the estimated partial effect of educ on inlf holding all othe......
Q:
How would you carry out the following transformation? More than one step isneeded. CH3CH2CH2CH2C=CH T ? CCH2CH2CH2 H
A:
Strategy The product contains a cisdisubstituted cyclopropane ring which can be formed from......
Q:
Kyler Recliners manufactures leather recliners and uses flexible budgeting and a standard cost system. Kyler allocates overhead based on yards of direct materials. The companys performance report...
A:
Requirement 1 KYLER RECLINERS Flexible Budget Budget Amounts per Unit Actual Units Recliners 1005 Sales 49500 497475 d Variable Manufacturing Costs Direct Materials 5340 a 53667 e Direct Labor 9000 b......
Q:
Consider a 30-cm-diameter pan filled with water at 15C in a room at 20C, 1 atm, and 30 percent relative humidity. Determine (a) The rate of heat transfer by convection, (b) The rate of evaporation of...
A:
Click to View...
Q:
Matt owns common shares of Maeb Inc. The adjusted cost base and paid-up capital of these shares is $300,000 and the FMV is $900,000. In the course of a capital reorganization, the following two...
A:
aThere is no deemed dividend because of the PUC reduction to give a total reduced PUC of 210000 which is less than the PUC of the old shares of 300000 There is also no deemed dividend because the rede......
Q:
Your Friend Ahmad will receive a bonus from his company after 6 Years equal to 15,000 but he need the money right now, so he ask you for a loan today and he will give you his bonus when he receives...
A:
To calculate how much you can lend your friend today in......
Q:
A teacher has given four tests to a class of five students and stored the results in the following matrix Discuss methods of matrix multiplication that the teacher can use to obtain the information...
A:
A B Class Average Test 1 Test 2 Test 3 Te......
Q:
Coastal Refining Company operates a refinery with a distillation capacity of 12,000 barrels per day. As a new member of Coastal's management team, you have been given the task of developing a...
A:
Coastal Refining Company operates a refinery with a distillation capacity of 12000 barrels per day which feeds crude oil into a pipestill Maximum available crude oil capacity per day is 10000 barrels......
Q:
The Texas Electronics Company (TEC) is contemplating a research and development program encompassing eight major projects. The company is constrained from embarking on all projects by the number of...
A:
Company TE has eight major projects The company cannot work on all the projects due to constraints o......
Q:
How many oxygen atoms are in 1.0 g of water?
A:
The mass of 1 mole of molecules is equal to the molecular mass o......
Q:
The temperature of a plane wall during steady one dimensional heat conduction varies linearly when the thermal conductivity is constant. Is this still the case when the thermal conductivity varies...
A:
No the temperature of a plane wall during steady one dimensional heat conduction does not vary......
Q:
Consider a function f(x) and its derivative df/dx. Does this derivative have to be a function of x?
A:
Yes the derivative dfdx also denoted as fx represents the rate of change of a fu......
Q:
When the thermal conductivity of a medium varies linearly with temperature, is the average thermal conductivity always equivalent to the conductivity value at the average temperature?
A:
No the average thermal conductivity of a medium with a linear variation of c......
Q:
Consider steady one-dimensional heat conduction in a plane wall, long cylinder, and sphere with constant thermal conductivity and no heat generation. Will the temperature in any of these mediums vary...
A:
No the temperature in none of these mediums will vary linearly in steady onedimensional heat conduct......
Q:
How is the order of a differential equation determined?
A:
The order of a differential equation is determined by the highest order derivative that appears in t......
Q:
Standard and Variant compete in the same market. The following budgeted income statements illustrate their cost structures: Income Statements Company Standard Variant Number of customers...
A:
a b Income Statements a b Company Standard Variant Number of customers n 300 300 Sales revenue n x 8......
Q:
Refrigerant-134a enters an adiabatic compressor as saturated vapor at 120 kPa at a rate of 0.3 m3/min and exits at 1-MPa pressure. If the isentropic efficiency of the compressor is 80 percent,...
A:
Also solved by EES on enclosed CD Refrigerant134a enters an adiabatic compressor with an isentropic......
Q:
Judy Johnson is choosing between investing in two Treasury securities that mature in five years and have par values of $1,000. One is a Treasury note paying an annual coupon of 5.06 percent. The...
A:
rie x x 103045......
Q:
If a stock has a beta coefficient, equal to 1.20, the risk premium associated with the market is 9 percent, and the risk-free rate is 5 percent. Based on application of the capital asset pricing...
A:
Computation of the Expected return using CAPM Formula......
Q:
If the cost of capital is 9 percent and an investment costs $56,000, should you make this investment if the estimated cash flows are $5,000 for years 1 through 3, $10,000 for years 4 through 6, and...
A:
This problem is a series of annuities that must be expressed in the present Years 13......
Q:
Canton Company makes two types of cell phones. Handy is a thin, pocket-size cell phone that is easy to carry around. Action is a palm-size phone convenient to hold while the user is talking. During...
A:
a Unitlevel activities assumption Cost to be allocated Cost driver Allocation rate 270000 500......
Q:
Suppose that River Cruises, which currently is all-equity-financed, issues $250,000 of debt and uses the proceeds to repurchase 25,000 shares. Assume that the firm pays no taxes and that debt finance...
A:
Given data Debt issued 25000000 Repurchase shares 2500000 Interest on debt 10 T......
Q:
Write an HDL module for the FSM with the state transition diagram given in Figure 3.69 from Exercise 3.22.? Data from Problem 3.22 Describe in words what the state machine in Figure 3.69 does. Using...
A:
SystemVerilog VHDL module fig369 input log......
Q:
For tax year 2020, the IRS assesses a deficiency against David for $500,000. Disregarding the interest component, what is Davids penalty if the deficiency is attributable to: a. Negligence? b. Fraud?
A:
a 100000 20 500000 b......
Q:
The executives of a company that produces electro-optical equipment for military use found it necessary to implement project management using a matrix. The project managers reported to corporate...
A:
This approach has serious longterm implications because the expertis......
Q:
The Multimedia Group has recently issued 20-year, unsecured bonds rated BB by Moody's. These bonds yield 443 basis points above the Bank of Ghana yield of 2.76%. The yield to maturity on these bonds...
A:
To calculate the yield to maturity on the Multimedia Group bonds we can use the following f......
Q:
Drago Company produces a line of brass-based products, one of which is a flow control valve (for regulating the flow of water). The production of this valve requires the use of specialized equipment...
A:
Click to View...
Q:
A firms stock earns $2 per share, and the firm distributes 40 percent of its earnings as cash dividends. Its dividends grow annually at 7 percent. a) What is the stocks price if the required return...
A:
First determine the dividend paid 2 X 4 80 a The value of th......
Q:
You are considering two stocks. Both pay a dividend of $1, but the beta coefficient of A is 1.5 while the beta coefficient of B is 0.7. Your required return is k 5 8% 1 115% 2 8%2b. a) What is the...
A:
a k A 08 15 0815 185 185 k B 08 15 087 129 129 b Valuatio......
Q:
A 100 g ball moving to the right at 4.0 m/s catches up and collides with a 400 g ball that is moving to the right at 1.0 m/s. If the collision is perfectly elastic, what are the speed and direction...
A:
Model Model the balls as particles We will use the Galilean transformation of velocities Equation 11......
Q:
In Exercises 1-4, use the diagram shown. What is the radius of the polygon? G- A E 5.5 8 6.8 F B D C
A:
From given diagram GEF is right angled triangle GF 2 GE 2 FE 2......
Q:
Marlot Limited reported the following information on cash flow for the year 2019. 1. Does Marlot Limited appear to be expanding or contracting its operations? 2. Describe the activities that could...
A:
1 Based on the provided cash flow information Marlot Limited seems to be slightly expanding its oper......
Q:
On 30 June 2019, the following figures were extracted from the general ledger of Nora Ltd. Additional information: On 30 June 2019, the directors of Nora Ltd resolved to: a. Provide for estimated tax...
A:
1 Income Statement and Note of Retained Profits for the Year Ended 30 June 2019 Income Statement for......
Q:
The following information is taken from the accounts of Registration Ltd for the year ended 31 December 2019: 1. What was the amount of cash received from customers? 2. What was the amount of cash...
A:
To answer your questions we need to calculate the cash received from customers and the cash paid to......
Q:
The income statement and balance sheet provide the following information for 2019. 1. Calculate cash flows for operations using the indirect method. 2. Why are the reasons for the difference between...
A:
Calculate Cash Flows for Operations using the Indirect Method The indirect method starts with the net income and adjusts for changes in noncash items......
Q:
Refer to case facts in A17-8. Data From A17-8 Benata Ltd. started operations in 20X5 and purchased buildings and equipment with an original cost of $400,000. Benata reported the following...
A:
If Benata Ltd is worried about having another loss in 20x9 they would want to carryback t......
Q:
Briefly discuss the implications of the financial statement presentation project for the reporting of stockholders equity.
A:
It is likely that the statement of stockholders eq......
Q:
Briefly explain at least three ways in which a business may expect to benefit from preparing a formal budget.
A:
A business may expect to benefit from preparing a formal budget in several ways i......
Q:
Are there situations in which a business owners conduct would be more reprehensible than the Baums behavior in this case? Explain.
A:
When behavior is motivated by greed or some other......
Q:
Give examples of situations in which a business might develop a request for proposal.
A:
There are number of examples in which business devel......
Q:
Holt Company purchased a computer for $8,000 on January 1, 2009. Straight-line depreciation is used, based on a 5-year life and a $1,000 salvage value . In 2011, the estimates are revised. Holt now...
A:
Annual depreciation expen......
Q:
What are some features that influence the properties of fiber-reinforced composites?
A:
The properties of fiberreinforced composites depend stro......
Q:
If angiosperms evolved from some type of gymnosperm, then the group gymnosperms is not natural. Why not? In cladistic terms, an incomplete group is a __________________group.
A:
In cladistics an incomplete group is termed a paraphyletic group A paraphyletic group consists o......
Q:
Marianne Schwartz, the owner of Handy Man Rentals, rents carpet cleaners to contractors and walk-in customers. She is interested in arriving at a forecast of rentals so that she can order the correct...
A:
Click to View...
Q:
Recent communication with the inhabitants of Neptune have revealed that they have a Celsius-type temperature scale, but based on the melting point (OoN)and boiling point (I OOoN)of their most common...
A:
Since the Neptunians know about perfect gas behavior we may assume that they will write p nR1 at bot......
Q:
Describe an incident when you had to listen attentively to act quickly enough to meet a deadline. What active listening skills did you demonstrate? If you had to do it over again, would you do...
A:
To meet the deadline I had to employ active listening skills 1 Focused Attention I listened intently......
Q:
Snappy Tiles is a small distributor of marble tiles. Snappy identifies its three major activities and cost pools as ordering, receiving and storage, and shipping, and it reports the following details...
A:
1 Snappys operating income in 2015 is as follows Total for 250000 Tiles 1 Per Unit 2 1 250000 Revenu......
Q:
Access the link below and assist with the question that follows https://smesouthafrica.co.za/basics-of-registering-a-business/ How will you go about to register a business at the CIPC?
A:
To register a company at the South African CIPC can be under different categories with different req......
Q:
Watch the following video online. https://youtu.be/vqwNt8rl3ng 1. Identify the internal environment mentioned in this video.
A:
According to the video the internal environment in which managers......
Q:
If the Wet Dog Surf Company borrows $33,000 at 9.00% and there are 4 compounding periods per year, calculate Wet Dog's Effective Annual Rate (APY) of interest.
A:
Click to View...
Q:
Explain why data normalization is crucial before conducting analysis on this e-commerce sales dataset.
A:
Data normalization is crucial before conducting analysis on an ecommerce sales dataset for several important reasons 1 Data Integrity Normalization helps ensure data integrity by reducing redundancy a......
Q:
Assume UBER makes 1,000,000 shares available to investors through a Dutch Auction IPO. The following orders have been listed below. What is the IPO price? How many shares does each investor get?...
A:
To determine the IPO price using a Dutch Auction we need to arrange the bids in descending order bas......
Q:
Write function where user is asked to make an entry, and the square of the entry is printed. Use a while loop with a try, except, else block to account for incorrect inputs. User will call the...
A:
Click to View...
Q:
Based on the half-written tic/tac toe game code below. Construct code for the "do_computer_move" function in the attachments. Follow what the algorithm and and signature says. Make sure the computer...
A:
Okay I made adjustments to the docomputermove and checkgameover and integrate the userclick function......
Q:
At the beginning of 2024, Ellingham Academy reported a balance in common stock of $167,000 and a balance in retained earnings of $67,000. During the year, the company issued additional shares of...
A:
SOLUTION Statement of Stockholders Equity ELLINGHAM ACADEMY Statement of Stockholders......
Q:
XYZ-Budget data six months to 30 June 2004 Product Alpha Product Sigma Material Cost per Product Unit $60 $45 Production line A- machine hours per unit 0.8 0.5 Production batch size units 100 200...
A:
ANSWER 1 Activity Based Budget for Production Line A Product Unit Based Costs Material Cost per Unit......
Q:
Charles owns an office building and land that are used in his trade or business. The office building and land were acquired in 1978 for $800,000 and $100,000, respectively. During the current year,...
A:
a 610000 720000 110000 b 130000 690000 56000......
Project Management A Systems Approach to Planning Scheduling and Controlling 10th Edition - ISBN: 978-047027870 - Free Book