How do i do this excel using solver. Sales RegionsPlant locationsEastMidwestSouthWestPlant CapacityLos Angeles$5.0$3.5$4.2$2.210,000Atlanta$3.2$2.6$1.8$4.812,000New York City$2.5$3.1$3.3$5.414,00036,000Regional Demand9,0006,0006,00013,00034,000Decision variablesShipment volume (in units)Objective functionMinimize total shipment costsSales RegionsPlant locationsEastMidwestSouthWestLos AngelesAtlantaNew York CityDemand SatisfactionTotal receivedTotal requiredEast>=9,000Midwest>=6,000South>=6,000West>=13,000Capacity availabilityTotal ShippedTotal capacityLos Angeles<=10,000Atlanta12,000New York City14,000<=

In this cost situation you have to determine which solution will minimize total costs while meeting…

Answered: How do i do this excel using solver.

Survey of Accounting (Accounting I)

8th Edition

ISBN:9781305961883

Author:Carl Warren

Publisher:Carl Warren

Chapter12: Differential Analysis And Product Pricing

Section: Chapter Questions

Problem 12.4E

See similar textbooks

Similar questions

Nottage Company has four separate operating segments: East West North South Sales to outsiders $188000 $126000 $65000 $43000 Inter segment transfers 16000 6000 13000 8000 What revenue amount must one customer generate before it must be identified as a major customer? Choose the correct.a. $39,600b. $42,200c. $46,500d. $49,200
9
Q7 Consider the following data from two divisions of a company, P and Q: Divisional P Q Sales $ 1,500,000 $ 1,000,000 Operating Income $ 600,000 $ 450,000 Investment $ 4,000,000 $ 2,750,000 If both divisions were presented with an opportunity to invest in a project that is estimated to achieve an ROI of 15%, what will the units likely decide? Multiple Choice Division P will not invest; Division Q will invest. Division P will invest; Division Q will not invest. Neither unit will invest in the projects. Division P will be indifferent; Division Q will not invest. Division P will invest; Division Q will be indifferent.
Division Northeast Southeast West Sales $ ? $10,980,000 $ ? Net operating income $ ? $878,400 $432,000 Average operating assets $1,000,000 $ ? $ ? Margin 5.00% 7.20% Turnover 4 ? Return on investment (ROI) 14.40% 14.40%
plzz solve
Presented here is selected information for three regional divisions of Pronghorn Compa Contribution margin Controllable margin Average operating assets Minimum rate of return (a) North Division West Division North South Division $300,800 $141.000 $940.000 12 % Divisions Compute the return on investment for each division. $501.000 $360.800 $1,640,000 West % % % 14 % South $399,600 $210.000 $1,400,000 9 %
Exercise 11-13 (Algo) Transfer Pricing Situations [LO11-3] Skip to question [The following information applies to the questions displayed below.] In each of the cases below, assume Division X has a product that can be sold either to outside customers or to Division Y of the same company for use in its production process. The managers of the divisions are evaluated based on their divisional profits. Case A B Division X: Capacity in units 100,000 95,000 Number of units being sold to outside customers 100,000 74,000 Selling price per unit to outside customers $ 55 $ 30 Variable costs per unit $ 26 $ 14 Fixed costs per unit (based on capacity) $ 7 $ 5 Division Y: Number of units needed for production 21,000 21,000 Purchase price per unit now being paid to an outside supplier $ 50 $ 28 Exercise 11-13 (Algo) Part 1 Required: 1. Refer to the data in case A above. Assume in this case that $3 per unit in variable selling costs can be avoided on…
View Policies Current Attempt in Progress rt For its three ivestment centers, Gerrard Company accumulates the following data: II $1,900,000 $4075,000 $4,069,00 Sales Controllable margin 1,330,000 2,037,500 3,662,10 Average operating assets 5,068,000 7,993,000 12,028,00 The centers expect the following changes in the next year: (I) increase sales 14%; (II) decrease costs $376,000; (III) decrease average operating assets $491,000. Compute the expected return on investment (ROI) for each center. Assume center I has a controllable margin percentage of 70%. (Round ROI to 1 decimal place, e.g. 1.5%.) The expected return on investment
Exercise 11-13 (Algo) Transfer Pricing Situations [LO11-3] [The following information applies to the questions displayed below.] In each of the cases below, assume Division X has a product that can be sold either to outside customers or to Division Y of the same company for use in its production process. The managers of the divisions are evaluated based on their divisional profits. Case A B Division X: Capacity in units Number of units being sold to outside customers Selling price per unit to outside customers 95,000 95,000 96,000 79,000 $ 50 $ 30 Variable costs per unit Fixed costs per unit (based on capacity) Division Y: $ 28 $ 12 $ 6 $ 4 Number of units needed for production 17,000 17,000 Purchase price per unit now being paid to an outside supplier $ 43 $ 24 Exercise 11-13 (Algo) Part 2 Required: 2. Refer to the data in case B above. In this case, there will be no savings in variable selling costs on intracompany sales. a. What is the lowest acceptable transfer price from the…
Q35 Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z Sales $ 1,483,000 $ 805,000 $ 5,005,000 Operating Income 216,100 59,700 263,800 Investment in assets 625,600 292,500 3,179,600 The return on sales (ROS) for Division Z is: (Round your percentages to one decimal place.) Multiple Choice 7.4%. 8.3%. 5.3%. 14.6%. 20.4%.
Question 10.2 Provide the missing data for the following situations: Red Division White Division Green Division Sales A $10,000,000 E Net operating income $240,000 $500,000 $288,000 Total assets B C $1,600,000 Return on investment 0.16 0.10 F Return on sales 0.05 D 0.14
Using the data below for the Ace Guitar Company: A Region B Region Sales $521,500 $968,500 Cost of goods sold 198,200 368,000 Selling expenses 125,200 232,400 Service department expenses Purchasing $250,300 Payroll accounting 166,900 Allocate service department expenses proportional to the sales of each region. Determine the divisional income from operations for the A and B regions. For interim calculations, round percentages to one decimal place. A Region $ B Region $

SEE MORE QUESTIONS

Recommended textbooks for you

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

Financial & Managerial Accounting

Accounting

ISBN:

9781285866307

Author:

Carl Warren, James M. Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Cornerstones of Cost Management (Cornerstones Ser…

Accounting

ISBN:

9781305970663

Author:

Don R. Hansen, Maryanne M. Mowen

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS