Write the formulas that calculate the total production time used for casting, machin- ing, and final...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write the formulas that calculate the total production time used for casting, machin- ing, and final assembly. Enter a mathematical formula in the objective cell, and then enter formulas to link the objective cell with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results. Create a constraints table in the worksheet that identifies the constraints in this problem. Use Solver to determine the optimal combination of valves to build to maximize profit. Produce an answer report of your solution. Which constraints could you modify to maximize the total profit? Place your recommendations in a text box on the answer report worksheet. Item Valve 102-45 Valve 102-46 Valve 102-47 Constraints Casting time (C9) Machining time (D9) Final Assembly time (E9) Number Produced (H5 H7) Number Produced (H5 H7) Number Produced (H5:H7) Set-Up Cost $ 975.00 $1,100.00 $ 1,150.00 Time Used Production Time per Unit (in Hours) Casting Machining Final Assembly Unit Cost 0.30 $ 0.30 $ 0.30 S 1.10 3.30 3.00 0.00 1.80 1.50 1.20 0.00 0.00 List Price 36.00 $ 108.00 45.00 $ 135.00 42.00 S 126.00 Total Number Produced 0.00 Min Max $ Profit Write the formulas that calculate the total production time used for casting, machin- ing, and final assembly. Enter a mathematical formula in the objective cell, and then enter formulas to link the objective cell with the variable cells. Add sample values to the variable cells to ensure that your worksheet is set up correctly and produces the expected results. Create a constraints table in the worksheet that identifies the constraints in this problem. Use Solver to determine the optimal combination of valves to build to maximize profit. Produce an answer report of your solution. Which constraints could you modify to maximize the total profit? Place your recommendations in a text box on the answer report worksheet. Item Valve 102-45 Valve 102-46 Valve 102-47 Constraints Casting time (C9) Machining time (D9) Final Assembly time (E9) Number Produced (H5 H7) Number Produced (H5 H7) Number Produced (H5:H7) Set-Up Cost $ 975.00 $1,100.00 $ 1,150.00 Time Used Production Time per Unit (in Hours) Casting Machining Final Assembly Unit Cost 0.30 $ 0.30 $ 0.30 S 1.10 3.30 3.00 0.00 1.80 1.50 1.20 0.00 0.00 List Price 36.00 $ 108.00 45.00 $ 135.00 42.00 S 126.00 Total Number Produced 0.00 Min Max $ Profit
Expert Answer:
Answer rating: 100% (QA)
To begin we need to add formulas to calculate the total production time us... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these finance questions
-
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...
-
The Whitt Window Company is a company with only three employees that makes two different kinds of handcrafted windows: a wood-framed and an aluminum framed window. They earn $60 profit for each...
-
The fund-basis financial statements of the City of Cottonwood have been completed for the year 2017 and appear in the first tab of the Excel spreadsheet provided with this exercise. In addition, the...
-
According to the Internal Revenue Service (IRS), the chances of your tax return being audited are about 1 in 100 if your income is less than $1 million and 9 in 100 if your income is $1 million or...
-
In Section 11.3, we mention that a causal complex cepstrum x[n] is equivalent to the minimum-phase condition of Section 5.4. Remember that x[n] is the inverse Fourier transform of X(e j? ) as defined...
-
In March 1976, Sue made a taxable gift of $200,000. In arriving at the amount of her taxable gift, Sue elected to deduct the $30,000 specific exemption formerly available. In 2014, Sue makes her next...
-
Babcock and Wilcox boiler has water tubes: (a) Vertical (b) Horizontal (c) Inclined (d) None of the above
-
The Swiss economist Alexander Swoboda has argued that the Eurodollar markets early growth was fueled by the desire of banks outside the United States to appropriate some of the revenue the United...
-
Required information The following Information applies to the questions displayed below] Simon Company's year-end balance sheets follow At December 31 points Assets eflook 10 Cash Accounts...
-
Dorothy is considering a new part-time business venture where she would monogram linens and other items. To do this, she would need to upgrade her current sewing machine. Here is what she quickly...
-
ST = {(xxyyCR?xy is convex.
-
Award: 10.00 points 61. Award: 10.00 points An individual contributed $100,000 of cash and pledged another $50,000 to an NFPO to cover the $50,000 salary of its executive director for the current...
-
Patient volume and salaries are variable expenses that are hard to predict. Most urgent cares operate on incentive bonuses for providers, sick calls may require giving overtime to employees that are...
-
5 Woof pic manufactures one product, a luxury dog food which sells at 20. Calculate the following values from the last six months results ending 30 April: Month January February March April May June...
-
A company launched business App. For smart mobile phones, the users who installed the app. in 2 0 1 4 were 1 4 2 0 0 0 users, and they increase by 1 0 % each succeeding year. a ) Determine the number...
-
We talked about the Medicare "parts" or "plans" that cover different types of services, and how they are each separately funded. We also talked about when each is projected to be insolvent, in part...
-
( Question Three What are the basic domains of Artificial Intelligence (Al) Applications? Give one real-world example illustrating how each domain can help businesses. 2 Marks
-
Making use of the tables of atomic masses, find the velocity with which the products of the reaction B10 (n, ) Li7 come apart; the reaction proceeds via interaction of very slow neutrons with...
-
You are given the following linear programming model in algebraic form, with x1 and x2 as the decision variables and constraints on the usage of four resources: Maximize Profit = 2x1 + x2 Subject to...
-
Allen Furniture is a manufacturer of hand-crafted furniture. At the start of January, Allen employs 20 trained craftspeople. They have forecasted their labor needs over the next 12 months as shown in...
-
You are given the following linear programming model in algebraic form, with x1 and x2 as the decision variables: Minimize Cost = 40x1 + 50x2 Subject to Constraint 1: 2x1 + 3x2 ( 30 Constraint 2: x1...
-
Why is the analyzing step of the process crucial to the success of a MedImmune proposal? In the discussion, draw students attention to the intersection of medical, legal, and social issues. Why is...
-
How does the Clinical Trial Application guide described in the example make the composing process for a new document easier? How is it informed by the evaluation process? What metaphors or analogies...
-
What are the advantages and disadvantages of the following other options: making an announcement on the companys internal website, sending a memo to each employee, sending an email to each employee,...
Study smarter with the SolutionInn App