2 number of units3 profit4 constraints5 Underwriting6 Administration7 Claims8910SRM0000LHS0= <=<=<SIGNRHS11121314 Part B15 Step 1: Use the formulated problem as in part A with the return and constraint coefficients to set up Excel sheet1617 Step 218 Setting up the worksheet19 Key in the profit coefficients per iNSURANCE type in range B3:c3 The Primo Insurance Company is introducing two new product lines: special risk insuranceand mortgages. The expected profit is $5 per unit on special risk insurance and $2 per unit onmortgages.Management wishes to establish sales quotas for the new product lines to maximize totalexpected profit. The work requirements are shown belowDepartmentUnderwritingAdministrationWork-Hours per UnitSpecialRiskMortgageWork-HoursAvailabled) Solve graphically submit on scanned graph paper(e) Solve in excel using the template provided (2,4008001,200Claimsa) Identify verbally the decisions to be made, the objective and the constraints(b) Formulate the problem in table form(c) Formulate the problem algebraically(

As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Answered: a) Identify verbally the decisions to…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 30P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Workshape Manufacturing has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors purchase the same product. The customer activities and costs for the previous quarter are as follows: Activity JIT distributors Non-JIT distributors Sales Orders 500 30 Sales Calls 30 30 Service Calls 200 90 Average Order Size 90 1,400 Manufacturing Cost/Unit $50 $50 Customer Costs: Processing Sales Orders $160,000 Selling Goods $155,000 Servicing Goods $195,000 Total $500,000 Calculate the activity rate for selling goods. (Note: Round answer to two decimal places.) a.$2,200.50 per sales call b.$9,400.60 per sales call c.$3,550.66 per sales call d.$2,583.33 per sales call e.$4,800.40 per sales call
Tally Corp. sells softwares during the recruiting seasons. During the current year, 14,000 software packages were sold resulting in $460,000 of sales revenue, $110,000 of variable costs, and $50,000 of fixed costs. Contribution margin per software is
Financial objectives for the Henhouse Brewing Company, a craft brewery, include Multiple Choice Improving security and stability of information technology capabilities to prevent breaches and outages. reducing product development time by one-third to half the current rate of 24 months. boosting internal cash flows by 7 percent to fund new brewing research and development activities. developing stronger national and global distribution capabilities than competitors. introducing five new products over the next 10 years.
uiz Tools Enabled: Chapter 4 The Art of Modelling with S. Saved Help Save & Exit 100% A student prepared the following spreadsheet model to calculate the final price of clothing items which are sold at a discount. To be complete, the student included a calculation of sales tax in the final price, qiven the original price (200), discount (0.21), and sales tax rate (0.04) shown below. A B Collapse 1 2 Original Price 3 Discount (X) 4 Discount (S) 5 Net Price 6 Sales Tax(X) 7Sales Tax(S) 8 Final Price 200 0.21 B2 x B3 = 82 - B4 0.04 - ROUND(85 x B6,2) -ROUND (B5 + 87,2) Determine what values the spreadsheet should display. (Round your answer to 2 decimal places.) Cell Value B4 (Discount in dollars) B5 (Net Price) B7 (Sales tax in dollars) B8 (Final Price) Mc Graw Hill 2 of 5 HUAWEI PrSc Ins Esc F3 F10 F11 F12 F1 F2 F5 F6 F7 FB F9 F4 %23 96 & 2 6. 8. Tab R IT Y A F G K C V N M Alt Ctrl Alt
The following data pertain to Aurora Electronics for the month of February. Static Budget Actual Units Sold 10,000 9,000 Sales revenue $120,000 $103,500 Variable manufacturing cost $40,000 $36,000 Fixed manufacturing cost $20,000 $20,000 Variable Selling and administrative cost $10,000 $9,000 Fixed selling and administrative cost $10,000 $10,000 Compute the sales-price and sales-volume variances for February.
Preliminary plans are under way for the construction of a new stadium for a major league baseball team. City officials have questioned the number and profitability of the luxury corporate boxes planned for the upper deck of the stadium. Corporations and selected individuals may buy the boxes for $310,000 each. The fixed construction cost for the upper deck area is estimated to be $4,960,000, with a variable cost of $155,000 for each box constructed. (a) What is the break-even point for the number of luxury boxes in the new stadium? X = (b) Preliminary drawings for the stadium show that space is available for the construction of up to 52 luxury boxes. Promoters indicate that buyers are available and that all 52 could be sold if constructed. (i) What is your recommendation concerning the construction of luxury boxes? Build the luxury boxes. Do not build the luxury boxes. (ii) What profit is anticipated (in dollars)? (Enter a negative value if a predicted loss.)
Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 26,720 2,600 2 $ 37,555 3,964 3 $ 41,361 4,299 4 $ 32,751 3,398 5 $ 36,022 3,630 6 $ 33,811 3,336 7 $ 33,139 3,372 8 $ 39,671 4,093 9 $ 39,912 4,222 10 $ 48,568 5,463 11 $ 43,627 4,551 12 $ 40,390 4,289 13 $ 35,644 3,694 14 $ 34,330 3,573 15 $ 38,260 3,836 16 $ 27,424 3,210 17 $ 31,732 5,195 18 $ 31,005 4,260 19 $ 28,552 3,689 20 $ 31,049 4,546 21 $ 26,588 3,058 22 $ 25,515 2,744 23 $ 29,899 4,997 24 $ 31,204 5,838 25 $ 29,099 3,964 26 $ 32,795 5,007 27 $ 29,650 4,572 28 $ 30,970 4,665 29 $ 29,429 3,841 30 $ 28,846 3,174 Required: a. Estimate the labor…
Can you help me with these three review questions A sports manufacturer produces skateboards and rollerblades. The same wheels are used for both products. For the next week, the master production schedule for skateboards shows a need for 147 units, while the master production schedule for rollerblades shows a need of 149 pairs. 4 wheels are required to manufacture a skateboard, and 8 wheels are required to manufacture one pair of rollerblades. What are the gross requirements for wheels to meet the requirements on the master production schedules for the next week?
A goldsmith makes two types of jewelry. A model A ring is made with 1 g of gold and 1.5 g of silver and sells for 25 UM.Another model B ring sells for 30 UM and is made of 1.5 g of gold and 1 g of silver. If you only have 750 gof each metal, how many rings should be made of each type to obtain maximum profit?Requested:- Make Initial Table of the problem.- Obtain the Case Variables- Obtain the Objective Function- Get Restrictions- Create the Simplex Table- Obtain the Optimal Solution and the Slack Variables.Solve this operational research exercise.
Deforrest Marine Motors manufactures engines for the speedboat racing circuit. As part of their annual planning cycle, they forecasted demand for the next four quarters. The number of available days of production and the anticipated demand are given below. Employees Production Rate Production Cost Backorder Cost Overtime Cost Overtime Limit Demand Q1 2,400 6,019,000 They also estimated many of the costs required to conduct operations planning. Some of these key figures are listed below. 30 70 units/employee/quarter Q2 2,200 $1,000/unit $200/unit/quarter $1,500/unit <= 25% of Reg. Production Q3 1,700 Q4 1,800 Hire Cost Fire Cost Subcontracting Cost Subcontracting Limit Inventory Cost Initial Inventory $1,200/employee $800/employee $1,800/unit 400 units maximum $100/unit/quarter 280 units Deforrest Marine Motors wishes to maintain the current number of employees for the entire year to follow a level strategy balanced with inventory and backorders as needed. What is the total cost of this…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS

a) Identify verbally the decisions to be made, the objective and the constraints( b) Formulate the problem in table form( c) Formulate the problem algebraically(