Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts, in Norfolk who want 200 donuts and in South Sioux City who want 200 donuts. Joe has distributors in Wisner and Laurel who will get the donuts and take them to the final destinations. Joe has to decide how much each distributor will take to each location. The locations have the following numbers to identify the locations: Wayne 1, Laurel 2, Wisner 3, Tilden 4, Norfolk 5, and South Sioux City 6. It costs 10 cents per donut to get donuts from Wayne to the distributors in both Laurel and Wisner. The costs per donut to go from Laurel to Tilden, Norfolk and South Sioux City are 15, 10, and 15 cents, respectively. Similarly, from Wisner to these locations, respectively, are 13, 9 and 16 cents. A-How many donuts are shipped on each route and what is the minimum cost of the shipping? List every route using city names, not numbers and include those routes where even 0 is shipped. B-Would the shipping amounts change if the cost of shipping from Wayne to Laurel changed to 6 cents? Yes or no? As you explain why, indicate where you look on the reports? C-What does the reduced cost of 0.01 on the variable X36 mean? Also mention what x36 means. D-What would happen to the total cost of shipping if Tilden only wanted 99 donuts? Explain where you are finding this on the report. Objective Cell (Min) Cell $J$3 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name Cost Name x12 x13 x24 x25 x26 x34 x35 x36 Name Wayne Laurel $J$6 $J$7 $J$8 $J$9 South Sioux City Wisner Tilden Norfolk Original Value 0.98 Original Value Final Value Integer Contin Contin 1 1 1 1 1 1 1 1 Final Value 111 Cell Value 500 0 0 100 200 200 200 300 0 0 200 100 200 0 Contin Contin Contin Contin Contin Contin Formula Status Slack $J$4<=$L$4 Binding 0 $J$5-$L$5 Binding 0 $J$6-$L$6 Binding 0 $J$7=$L$7 Binding 0 $J$8-$L$8 Binding 0 $J$9-$L$9 Binding 0 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name x12 x13 x24 X25 x26 x34 x35 x36 Name Wayne Laurel Wisner $J$6 $J$7 $J$8 $J$9 South Sioux City Tilden Norfolk 0.1 0.01 0.01 0.01 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 0 0.02 0.01 0 0 0 0.01 200 300 0 0 200 100 200 0 1E+30 1E+30 0.01 0.02 0.01 1E+30 0.01 0.02 0.01 1E+30 1E+30 1E+30 0.01 Final Shadow Value Price 500 0 -0.1 0 -0.1 0 100 0.23 200 0.19 200 0.25 0.1 0.15 0.1 0.15 0.13 0.09 0.16 Constraint Allowable Allowable Decrease R.H. Side Increase 500 0 0 1E+30 200 0 0 0 300 100 0 100 200 0 200 200 0 200 Joe Bagov makes 500 donuts in Wayne and has customers in Tilden who want 100 donuts, in Norfolk who want 200 donuts and in South Sioux City who want 200 donuts. Joe has distributors in Wisner and Laurel who will get the donuts and take them to the final destinations. Joe has to decide how much each distributor will take to each location. The locations have the following numbers to identify the locations: Wayne 1, Laurel 2, Wisner 3, Tilden 4, Norfolk 5, and South Sioux City 6. It costs 10 cents per donut to get donuts from Wayne to the distributors in both Laurel and Wisner. The costs per donut to go from Laurel to Tilden, Norfolk and South Sioux City are 15, 10, and 15 cents, respectively. Similarly, from Wisner to these locations, respectively, are 13, 9 and 16 cents. A-How many donuts are shipped on each route and what is the minimum cost of the shipping? List every route using city names, not numbers and include those routes where even 0 is shipped. B-Would the shipping amounts change if the cost of shipping from Wayne to Laurel changed to 6 cents? Yes or no? As you explain why, indicate where you look on the reports? C-What does the reduced cost of 0.01 on the variable X36 mean? Also mention what x36 means. D-What would happen to the total cost of shipping if Tilden only wanted 99 donuts? Explain where you are finding this on the report. Objective Cell (Min) Cell $J$3 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name Cost Name x12 x13 x24 x25 x26 x34 x35 x36 Name Wayne Laurel $J$6 $J$7 $J$8 $J$9 South Sioux City Wisner Tilden Norfolk Original Value 0.98 Original Value Final Value Integer Contin Contin 1 1 1 1 1 1 1 1 Final Value 111 Cell Value 500 0 0 100 200 200 200 300 0 0 200 100 200 0 Contin Contin Contin Contin Contin Contin Formula Status Slack $J$4<=$L$4 Binding 0 $J$5-$L$5 Binding 0 $J$6-$L$6 Binding 0 $J$7=$L$7 Binding 0 $J$8-$L$8 Binding 0 $J$9-$L$9 Binding 0 Variable Cells Cell $B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $H$10 $I$10 Constraints Cell $J$4 $J$5 Name x12 x13 x24 X25 x26 x34 x35 x36 Name Wayne Laurel Wisner $J$6 $J$7 $J$8 $J$9 South Sioux City Tilden Norfolk 0.1 0.01 0.01 0.01 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 0 0.02 0.01 0 0 0 0.01 200 300 0 0 200 100 200 0 1E+30 1E+30 0.01 0.02 0.01 1E+30 0.01 0.02 0.01 1E+30 1E+30 1E+30 0.01 Final Shadow Value Price 500 0 -0.1 0 -0.1 0 100 0.23 200 0.19 200 0.25 0.1 0.15 0.1 0.15 0.13 0.09 0.16 Constraint Allowable Allowable Decrease R.H. Side Increase 500 0 0 1E+30 200 0 0 0 300 100 0 100 200 0 200 200 0 200
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided in the images you sent we can answer the questions as follows A How many donuts are shipped on each route and what is the minimum cost of the shipping List every rout... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Peter Corporation paid $150,000 on January 1, 2020 for a 35% interest in Sand Inc. On January 1, 2020, the book value of Sand's stockholders' equity consisted of $200,000 of common stock and $200,000...
-
Find the x and y intercept For the equation y= 2 x+1, Part: 0/3 Part 1 of 3 (a) Find the x-intercept. The x-intercept is DD
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
This exercise shows that the multiplier may be interpreted as a rate of change in general. Assume that the maximum of (x, y) subject to g(x, y) = c occurs at a point P. Then P depends on the value...
-
Express the following angles in radians: (a) 30o. (b) 57o, (c) 90o, (d) 360o, (e) 420o. Give as numerical values and as fractions of .
-
Using Planck's formula, derive the approximate expressions for the space spectral density uw of radiation (a) In the range where hw < < kT (Rayleigh-Jeans formula); (b) In the range where hw < < kT...
-
Financial statement analysis is a process whereby the basic financial statements are reviewed and evaluated to assess a firms financial health and/or performance. Calculating financial ratios is an...
-
PRM Energy Systems, Inc. (PRM), owned technology patents that it licensed to Primenergy to use and to sublicense in the United States. The agreement stated that all disputes would be settled by...
-
According to the reading, Gu , X . , Kannan, P . K . , & Ma , L . ( 2 0 1 9 , March 2 0 ) . How companies can get the most out of a freemium business model . Harvard Business Review, how does a firm...
-
Steelcase Inc. is one of the largest manufacturers of office furniture in the United States. In Grand Rapids, Michigan, it produces filing cabinets in two departments: Fabrication and Assembly....
-
Sanjay a good employee. His employer, Astra Company, a CCPC, rewards Sanjay with stock options for 100 shares on June 22nd, 2020. The options have an exercise price of $21 and the price was $23 on...
-
A project has an investment of $160,000 in year 0 and an additional investment of $20,000 at the end of year 1. Project starts producing net cash inflows of $50,000 end of years years 2-7 (years 2 to...
-
Social Media Marketing Are You LinkedIn? Did you know networking is still the most effective way to find a job? Some individuals wait to use LinkedIn until they graduate or are looking for a job....
-
Prior to beginning work on this discussion, read the 2017 Sarbanes Oxley Compliance Survey Links to an external site. from Protiviti consulting firm, and the Section 302: Corporate Responsibility for...
-
Does Eowyn need to adjust her consumption of swords and dresses after the price change? What adjustments should she make? Explain why using the consumer equilibrium condition. Show how you set up the...
-
A step-index optical fiber has a core diameter of 62 m, it's numerical aperture is 0.298 and the operating wavelength is 1200 nm. Calculate the number of modes. V=( d NA)
-
Failure to follow the directions will lead to a grade deduction o The Exam must be handwritten o You are to choose and handwrite 2 essays for the exam from the list below Each essay will have a...
-
When the concentration of a strong acid is not substantially higher than 1.0 10-7 M, the ionization of water must be taken into account in the calculation of the solution's pH. (a) Derive an...
-
Compare the role of women in your country to their role in other cultures. How do the different roles affect womens behaviour as consumers and as business people?
-
Which marketing tasks should be handled by the exporter and which ones by its intermediaries in foreign markets?
-
Why are strategic alliances used in new product development?
-
Highpoint Company is evaluating five different capital expenditure proposals. The companys cutoff rate for net present value analyses is 12%. A 10% salvage value is expected from each of the...
-
Landover Amusement Park is considering the construction of a new facility to house a curved, multistory movie screen. The facility will cost \($400,000\) and be useful for 10 years, with no salvage...
-
Tate Company is considering a proposal to acquire new equipment for its manufacturing division. The equipment will cost \($192,000,\) be useful for four years, and have a \($12,000\) salvage value....
Study smarter with the SolutionInn App