For the data presented in the figure below A B C 1 Inputs-Costs, Capacities, Demands 2...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For the data presented in the figure below A B C 1 Inputs-Costs, Capacities, Demands 2 3 Supply Region 4 N America S. America 5 6 Europe 7 Asia Demand Regio Production and Transportation Cos N America S America Europe 81 117 102 115 142 8 Africa 9 Demand 10 11 Decision Variables 12 13 Supply Region 14 N. America 15 S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints 21 Supply Region Excess Capacity 22 N. America 23 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmet Demand 29 30 Objective Function 31 Cost- 12 S 23,751 ០០០០ 12 92 77 105 60030 125 100 8 OOOOO 8 Demand Region - Production Allo Plants N. America S. America Europe 0 0 D 0 0 N. America S. America Europe 0 0 101 108 95 90 103 14 70040 10 E 0 6,000 4,500 6,500 4,100 4,000 Fixed Low Fixed High Cost (5) Capacity Cost (5) Capacity 20 F OOOOO G 10 9,000 10 6,750 10 9.750 Plants (1-open) (1-open) 10 6,150 10 6,000 0 1 0 1 H 88888 20 20 20 20 1- Assuming that the unit cost in the above excel snapshot is given per 1,000, 000 units, and the resulting demand allocation is shown in 1000 units. Then, what is the variable cost of shipping from Asia to Europe? 2- What is the cell formula for the unmet demand for Europe? 3- What is the cell formula for the excess capacity of Asia? For the data presented in the figure below A B C 1 Inputs-Costs, Capacities, Demands 2 3 Supply Region 4 N America S. America 5 6 Europe 7 Asia Demand Regio Production and Transportation Cos N America S America Europe 81 117 102 115 142 8 Africa 9 Demand 10 11 Decision Variables 12 13 Supply Region 14 N. America 15 S. America 16 Europe 17 Asia 18 Africa 19 20 Constraints 21 Supply Region Excess Capacity 22 N. America 23 S. America 24 Europe 25 Asia 26 Africa 27 28 Unmet Demand 29 30 Objective Function 31 Cost- 12 S 23,751 ០០០០ 12 92 77 105 60030 125 100 8 OOOOO 8 Demand Region - Production Allo Plants N. America S. America Europe 0 0 D 0 0 N. America S. America Europe 0 0 101 108 95 90 103 14 70040 10 E 0 6,000 4,500 6,500 4,100 4,000 Fixed Low Fixed High Cost (5) Capacity Cost (5) Capacity 20 F OOOOO G 10 9,000 10 6,750 10 9.750 Plants (1-open) (1-open) 10 6,150 10 6,000 0 1 0 1 H 88888 20 20 20 20 1- Assuming that the unit cost in the above excel snapshot is given per 1,000, 000 units, and the resulting demand allocation is shown in 1000 units. Then, what is the variable cost of shipping from Asia to Europe? 2- What is the cell formula for the unmet demand for Europe? 3- What is the cell formula for the excess capacity of Asia?
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
For the data presented in problem 14 draw an earned value chart similar to the one presented in Figure 11-5.
-
For the data presented in Table 11.9, construct a confidence ellipse for β0 and β1 with confidence coefficient 0.95. Table 11.9 Data for Exercise 1 87427 00077 12100 67890...
-
For the data presented in Table 11.9, construct a confidence interval for β0 with confidence coefficient 0.95. Table 11.9 Data for Exercise 1 87427 00077 12100 67890 49433 y-000 340 .3 .2...
-
ABC Ltd prepares its financial statements to 31 October each year. Its trial balance at 31 October 2019 was as follows: Premises-cost Manufacturing plant-cost Office equipment-cost Accumulated...
-
Necessary Toys Companys condensed income statements for two years follow. After the end of 2014, the company discovered that an error had resulted in an $18,000 understatement of the 2013 ending...
-
The results of a series of CD triaxial tests on a medium dense, cohesionless sand are summarized in the table below. The void ratios for all the test specimens were approximately the same at the...
-
What is an antigen?
-
Selected financial information from Syntex Corporation is reproduced below: 1. NOA turnover (average NOA equals ending NOA) is 2. 2. NOPAT margin equals 5%. 3. Leverage ratio (average NFO/average...
-
Suppose that the signals x[n], x[n] and x3[n] are given by x[n] = cos (2n). x2[n] = sin( 2n 25 and x3[n] = 2/20 (a) Determine whether x[n] is periodic. If so, determine the number of samples per...
-
Q1 JE # 1 JE # 2 JE # 3 JE # 4 Business Insurance Annual Expense Coverage Period Here is the billing schedule of the insurance carrier. Invoice Schedule Invoice Amount Installment 1 Installment 2...
-
Sue and Al form a partnership. Sue invests $20,000 and Al invests $25,000. In the first year, the partnership earns $60,000. Sue withdraws $7,500 and Al withdraws $12,000. Each receives a salary of...
-
1).Gary was recently widowed and is meeting with Harvey to discuss his estate planning. Gary has two grown children, both married, however one is currently having some trouble with his marriage and...
-
Option 2: Is online shopping a threat for the retail stores in the malls? Why, or why not? Write a preliminary essay explaining your answer.
-
Olive Ltd produces various cooking oils. It is considering production of a new blend of vegetable oil, which will have earnings before interest and tax (EBIT) of $40,000 p.a. Olive can produce this...
-
Evaluate the limt limx2 4x2-11x+6 x-2
-
The Client wants to better understand how floors and ceilings work with respect to itemized deductions. As such, you have have been asked to prepare a functional spreadsheet emulating Schedule A to...
-
Zanny Mouldings has the following estimated costs for the year ahead: Directly used materials $25,100 Direct labor costs $62,300 factory chief salary $37,800 Ad spend 34.000 $ Heating and lighting...
-
The graph of an equation is given. (a) Find the intercepts. (b) Indicate whether the graph is symmetric with respect to the x-axis, the y-axis, or the origin. -3 6 -6 3 x
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-7. Ivan sold the following securities during the year and received a Form 1099-B that...
-
Sally and Charles Heck received the following dividends and interest during 2012: Assuming the Hecks file a joint tax return, complete Schedule B of Form 1040 (on page 2-33) for them for the 2012 tax...
-
Diego, age 28, married Dolores, age 27, in 2012. Their salaries for the year amounted to $46,479 and they had interest income of $3,500. Diego and Dolores' deductions for adjusted gross income...
-
In 2019, Maggy (34 years old) is an employee of YBU Corp. YBU provides a 401(k) plan for all its employees. According to the terms of the plan, YBU contributes 50 cents for every dollar the employee...
-
In 2019, Nitai (age 40) contributes 10 percent of his $100,000 annual salary to a Roth 401(k) account sponsored by his employer, AY Inc. AY Inc. matches employee contributions to the employees...
-
In 2019, Susan (44 years old) is a highly successful architect and is covered by an employee-sponsored plan. Her husband, Dan (47 years old), however, is a Ph.D. student and unemployed. Compute the...
Study smarter with the SolutionInn App