Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. A. XCountry Train Inc. specializes in trans-American moves for businesses and individuals through the delivery of containers. For every container the company loads on its trans-American rail, the business must pay the rail owners $8,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.10. Harry plans to charge $0.50 per pound to his customers. What would the total revenue be for this?

Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. A. XCountry Train Inc. specializes in trans-American moves for businesses and individuals through the delivery of containers. For every container the company loads on its trans-American rail, the business must pay the rail owners $8,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.10. Harry plans to charge $0.50 per pound to his customers. What would the total revenue be for this?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section9.5: Multistage Decision Problems

Problem 18P

See similar textbooks

Similar questions

1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. a. XCountry Train Inc. specializes in trans-American moves for businesses and individuals through the delivery of containers. For every container the company loads on its trans-American rail, the business must pay the rail owners $8,000. In addition, containers are weighed and for each pound of weight, the company must pay $0.10. Harry plans to charge $0.50 per pound to his customers. The company finds out that to maintain the integrity of its containers, each container could only hold an average of 30,000 pounds. What would the company have to charge customers to make $8,000 in profit on each container?
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell A brokerage firm is considering investment options for its clients. If the market is good the clients could get a net profit of $120,000 for Fund A, $100,000 for Fund B, and $80,000 for Fund C. If the market is fair, they could get a net profit of $20,000 for Fund A, $40,000 for Fund B, and $30,000 for Fund C. If the market is poor, clients would lose $30,000 for Fund A, $50,000 for Fund B, and $15,000 for Fund C. They must Fund one to invest in for their clients. An economist group offers to do a market study for $2,000. They know the following probabilities: P(good market Fund A | favorable study) = 0.6 P(fair market Fund A | favorable study) = 0.3 P(poor market Fund A | favorable study) = 0.1…
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. A brokerage firm is considering investment options for its clients. If the market is good the clients could get a net profit of $120,000 for Fund A, $100,000 for Fund B, and $80,000 for Fund C. If the market is fair, they could get a net profit of $20,000 for Fund A, $40,000 for Fund B, and $30,000 for Fund C. If the market is poor, clients would lose $30,000 for Fund A, $50,000 for Fund B, and $15,000 for Fund C. They must Fund one to invest in for their clients. An economist group offers to do a market study for $2,000. They know the following probabilities: P(good market Fund A | favorable study) = 0.6 P(fair market Fund A | favorable study) = 0.3 P(poor market Fund A | favorable study) = 0.1…
Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell A brokerage firm is considering investment options for its clients. If the market is good the clients could get a net profit of $120,000 for Fund A, $100,000 for Fund B, and $80,000 for Fund C. If the market is fair, they could get a net profit of $20,000 for Fund A, $40,000 for Fund B, and $30,000 for Fund C. If the market is poor, clients would lose $30,000 for Fund A, $50,000 for Fund B, and $15,000 for Fund C. They must Fund one to invest in for their clients. An economist group offers to do a market study for $2,000. They know the following probabilities: P(good market Fund A | favorable study) = 0.6 P(fair market Fund A | favorable study) = 0.3 P(poor market Fund A | favorable study) = 0.1…
Can i get help with at least 3-4 questions.... i am running out of tutor questions so doing most questions would really help me out right now Questions? Find the optimal solution and the maximum profit. In which plant there will be idle capacity and how many units (in thousands)? Do alternative optimal solutions exist? Justify your answer. If they exist, use the stepping stone algorithm and find the second optimal solution. Present your analysis in a graphically neat manner. Use any drawing technique you like – just make sure it looks fairly professional. Produce the third optimal solution by taking a combination of 20% of the first optimal solution and 80% of the second one. Attach all relevant exhibits from Excel’s Solver calculations. Use PrintScreen, edit/copy/paste, etc. – whatever you like.
Diamond mining is the act of digging into large amounts of unrefined ore to discover precious gems or nuggets. Similarly, data mining is the act of digging into large amounts of raw data to discover unique nontrivial useful patterns. Data is cleaned up, and then special tools and techniques can be applied to search for patterns. Diving into clean and nicely organized data from the right perspectives can increase the chances of making the right discoveries. A skilled diamond miner knows what a diamond looks like. Similarly, a skilled data miner should know what kinds of patterns to look for. The patterns are essentially about what hangs together and what is separate. Therefore, knowing the business domain well is very important. It takes knowledge and skill to discover the patterns. It is like finding a needle in a haystack. Sometimes the pattern may be hiding in plain sight. At other times, it may take a lot of work, and looking far and wide, to find surprising useful patterns. Thus,…
We are currently learning about Linear Programming in Management Science. I need help with this case. Answer should include: Decision Variables, Objective Function, and Constraints (including non-negativity constraints if necessary). All in Mathematical Expressions. Thank you!
I do appreciate the answer but that's not what the question was asking it's just asking for the equations for each one starting with the min x1+x2+x3 etc followed with nodes 1 through 7 with the same format please reassess the question and thank you I provided the model from the problem as an image If that helps.
State whether the following statements are TRUE (T) or FALSE (F) An activity can depict a single action or some logical combination of actions depending on the required level of detail to achieve the objectives of the business process analysis. Business Process Modeling Notation (BPMN) start events are shown using ovals and flowchart start events are shown using circles. In Unified Modeling Language (UML) primary keys cannot by NULL. An aggregation relationship is a form of generalization relationships. Business rules set criteria for branching in activity models. To be valuable business partners, accountants must understand how the business delivers value to its employees. The main financial benefit of Customer Relationship Management practices reduces the cost of goods sold. Documentation helps with training but won't help with regulatory compliance issues Documentation can be thought of as a tool for information transmission and communication. Business Process Modeling…
Portfolio management and investment portfolio management are the same thing. Choose one: true false
Provide an example of a business decision where business analytics should always be used and justify your answer. Are there any critical resource requirements needed to support business analytics in this situation? What if these requirements can't be met?
accounting Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Do not provide Excel Screet shot rather use tool table Answer completely. The Lowlands publishing company has decided to launch a new magazine for financial special-ists with the brand new title The Daily Financial Times. The problem is that this has not been done before. The Lowlands management does not have a clue how many copies will be sold and they think it will be somewhere between 60 000 and 120 000 copies. The magazine sells for €4 and the variable cost to print is €1.20. Unsold magazines are destroyed. Required: 1. Prepare a results matrix (or pay-off table) for different levels of demand: 60 000, 80 000, 100 000 and 120 000. 2. Suppose Lowlands management wants to avoid being blamed afterwards for having selected the wrong production plan, what production level should they then choose? 3. What strategy should be chosen if management wants to…