Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 4QP
Summary Introduction
To develop: A spreadsheet model for the problem and solve it using solver.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Tokyo Company needs the resources indicate below to produce its products
Product
Labor (hr./unit)
Material (Ib./unit)
Profit (S/unit)
$3
2.
2.
3.
4.
Tokyo Company has a daily labor capacity of 240 available hours and a daily supply of 400 pounds
of material. The general linear programming formulation for this problem is as follows
maximize 2 3 + Sxy + 2
subject to
Sx + 2 + 4xy s 240
4x + Gry + 3y s 400
Management has developed the following set of goals, arranged in order of their importance to
the firm
(1) Because of recent labor relations difficulties, management wants to avoid underutilization of
normal production capacity
(2) Management has established a satisfactory profit level of S500 per day
(3) Overtime is to be minimized as much as possible
(4) Management wants to minimize the purchase of additional materials to avoid handling and
storage problems.
I need a detailed assistance to solve the following problem in: Operations Analysis.
1) A trucking company maintains an inventory of trucks that varies monthly. The ending inventory of trucks during the first 8 months of the year (January to August) were 26, 38, 31, 22, 13, 9, 16, 5, respectively. The monthly inventory holding cost is proportional to the monthly ending inventory. Trucks incur the following costs
Each truck costs the company $8,000.
Interest rate on the cost of capital is 20% per annum (annually).
Each truck incurs a storage cost of 3% per annum of the truck cost.
Each truck incurs a liability insurance cost of 2% per annum of the truck cost. The carrying cost is the total of all costs (capital, storage and insurance.)
What is the monthly carrying cost per truck?
What is the total carrying cost incurred by the company over the 8 months (January to August)?
What is the estimated average annual carrying cost?
Please answer Arjent please fast
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?arrow_forwardAssume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.arrow_forwardNo chatgpt used i will give 5 upvotes typing pleasearrow_forward
- B. For each of the following, you are to set up a linear program and solve the problem using the Excel Solver. 5. Freshly Baked Hub has 3 warehouses and 3 branches store. The following table shows the shipping costs between each warehouses and store, the warehouse capabilities and store capacities. Branch Store To Capabilities From Y A P 350 P 400 P 280 7,000 B P 197 P 510 P 370 8,000 P 470 P 630 P 285 12,000 Сарacity 6,000 14,000 7,000 27,000 Linear Program: Solver Solution: х1 x2 х3 х4 х5 х6 х7 х8 х9 Decision: Constraints: Total Sign Capability 1 2 3 4 5 Minimize C: Warehousearrow_forward2arrow_forwardW2arrow_forward
- The accompanying tableau represents the shipping costs and supply-and-demand constraints for supplies of purified water to be shipped to companies that resell the water to office buildings. Use the Stepping Stone Method to find an optimal solution for graph "a".arrow_forwardplease give a clear solution to each part. I do not need explanationsarrow_forwardCompany aims to determine the optimal number of products to be produced in order to maximize the total profit. a) Formulate the problem using algebraic method. b) Solve the model using the graphical method (indicate optimal solution and profit). C) again). Use graphical method to determine the shadow price for each of these resources (based on the definition of shadow price and by increasing each resource by one unit and solving the problem d) Use the Excel solver to do parts b and c. e) follow: Using Solver Table generate the optimal solution and the total profit for each resource as e1: Consider unit profit for product 1 (use range from 0 to 4 and increment of 1) e2: Consider unit profit for product 2 (use range from 0 to 4 and increment of 1) е3: Consider simultaneous changes for both unit profits in part e1 and e2 using given ranges. e4: Consider available resource of Raw material 1 (use range from 2 to 14 and increment of 1) e5: Consider available resource of Raw material 2 (use…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,