USE EXCEL SOLVER YOU CAN ONLY DO C AND D PLEASESEEEE 1) The Primo Insurance Company is introducing two new product lines: special riskinsurance and mortgages. The expected profit is $10 per unit on special risk insuranceand $20 per unit on mortgages. Management wishes to establish sales quotas for thenew product lines to maximize total expected profit. The work requirements are asfollows:DepartmentUnderwritingAdministrationClaimsWork-Hours per UnitSpecial RiskMortgage230230Work-HoursAvailable2, 4008001,500REQUIREMENTS:a) Formulate the appropriate linear programming model for this problem.b) Develop the standard form of the LP model for simplex application.c) Obtain simplex tableaus for Iteration 0 and Iteration 1.d) Obtain the optimum solution using the Excel Solver.

Answered: Image /qna-images/answer/46a5d13c-b62b-4e17-88d3-a282ff4f454a.jpg

REQUIREMENTS: a) Formulate the appropriate linear programming model for this problem. b) Develop the standard form of the LP model for simplex application. c) Obtain simplex tableaus for Iteration 0 and Iteration 1.

REQUIREMENTS: a) Formulate the appropriate linear programming model for this problem. b) Develop the standard form of the LP model for simplex application. c) Obtain simplex tableaus for Iteration 0 and Iteration 1.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

2. Jamila wants to set up a manufacturing unit, so she meets with Rashid, a humanresource manager at her company. Rashid explains that in order to decide on thehuman resource needs for the unit, they should conduct a workflow analysis. Shesuggests they start by defining the outputs of the process. To do this, what shouldJamila define?A) the processes that will be involved in manufacturingB) the number of people required for productionC) the type of products that will need to be manufacturedD) the special equipment, facilities, and systems needed for productionE) the data and information needed by the work unit
Construction Management: The daily manpower required for a hotel Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 SundayMinimum required number of people 19 12 10 10 18 38 28 According to the policyEach employee [must take 2 consecutive days off and work for 5 consecutive days] For every regular employee hired, the weekly salary is 6000. You help the company plan:(A) At least how many people need to be employed? weekly fee?(B) How will each employee be given time off? Continuing from the previous question, you want to hire temporary staff to reduce costs and support peak manpower demandFor every regular employee hired, the weekly salary is 6000.The salary of each temporary staff is 2600 yuan per day. You help the company plan:(A) Complete Design and Employment Plan(B) And arrange vacations for each regular employee?
A manager has 5 subordinates and 5 tasks in his department. Each subordinate differs in efficiency. His estimate the task each would do cost given in the following table. By applying the assignment method, how the task should be allocated to his people so the total cost of his department is minimum? And how much? Cost (in thousand USD$) Task 1 2 3 4 5 Subordinate A 9 10 11 8 8 B 9 8 9 9 8 C 9 9 8 8 8 D 9 8 8 8 9 E 9 8 8 9 8
A steel workshop PT BESI KUAT wants to improve its productivity to make hookssmall iron by changing the layout of the workshop in the form of a workstation. The repair shop hasmake observations of the activities of workers in the workshop and arrange these activitiesin tabular form below Activity Duration ( Sec) predessor A 17 None B 15 A C 18 B D 8 B E 12 B F 6 C,D,E G 14 F The workshop aims to produce 225 small metal hooks for 2 hours. Based on this information, please answer the questions below. i. Sketch a precedence diagram of the above activityii. Calculate the cycle time and the minimum number of workstations that must be builtiii. Make a grouping of these workstationsiv. Calculate the efficiency of the work with the workstation
Bill’s Bar & Grill is open seven nights a week. Business isbusiest on Th ursday, when there is a concert in the park across thestreet. Bill wants a workforce schedule that allows each employeetwo consecutive days off each week. He believes that he needs fouremployees every day except on Th ursday, when he believes heneeds six employees. Develop a workforce schedule for Bill
The Prime Manufacturing Company is a garment factory that employs about 1250 employees of varied skills. About 75 percent are women who are mostly in the production department. Men employees are assigned in the maintenance department and as operators of machines used in garment production. Women are mostly in the sewing department, packaging, and quality control. Mr. Duztin Fernando was hired to head the HR department. Prior to his assignment at Prime Manufacturing Company, Rod was in a construction firm, a medium-sized organization. His main concern was preparing the payroll and handling employees’ records. The Human Resource Department is composed of 5 employees, a payroll clerk, a personnel assistant, two supervisors, and Mr. Duztin Fernando as Manager. The record of Duztin Fernando in his academic achievements is quite satisfactory. His Bachelor’s degree is in the field of Engineering. Performance in the previous employment is quite satisfactory. The…
Ekumfiman ceramic ltd produces ceramic vases for the hotels and supermarket in Ghana. Major customers include shoprite, melcom, holiday inn, airport view and flower people. The output and cost figures for the 4 weeks in April, 2020 are shown in the table below. The cost of labour and materials are GHS 9 an hour and GHS 5 a pound respectively. Weeks 1 2 3 4 Units of out put 3000 5000 6000 8000 Number of workers 5 5 6 7 Materials 320 590 780 1100 Hours per worker per week 50 60 68 80 1. Calculate the labour productivity in hours for each of the 4 weeks. 2. Calculate the total factor productivity for each week. 3. Calculate the total factor productivity for the month .
The table below contains information about an environmental clean-up project in the township of Hiles. Shorten the project threethree weeks by finding the minimum-cost schedule. Assume that project indirect costs and penalty costs are negligible. Identify activities to crash while minimizing the additional crash costs. Activity Normal Time (weekweeks) Crash Time (weekweeks) Cost to Crash ($ per weekweek) Immediate Predecessor(s) A 55 44 300300 None B 77 44 5050 None C 77 66 300300 A D 77 66 250250 A E 11 11 long dash— B F 33 33 long dash— C, D G 55 44 200200 D, E H 44 22 200200 F I 22 22 long dash— G Part 2 Fill in the table below with the activity times after crashing to show the resulting schedule. (Enter your responses as…
Amanufacturer is designing a product layout for a new product production. It plans to use a production line for 8 hours per day in order to meet forecasted demand of 150 units per dayThe product requires 7 tasks in total. These tasks are namely, ABC, DE, Fand GrespectivelyTask A does not have any predecessor to start. To start Task B, it requires Task A to be completedStarting tasks C needs, the task B to be completed. Also starting task D needed task B to be completed. Task E can only start upon completion of Task C. Whereas starting task F needs the completion of both the tasks and E. Finally, starting task G needed, task F to be completed. The processing times for tasks, AB 3, C, D, E, F , and Gare are2.4,2.2,0.9, . 10.12. 1.8. are 1.5 minutes respectively. What should be the cycle time in minutes? .4.80 O2.67. c 4.56 d is the correct answer e3.20
A college provides free tutoring services for its students 7 days a week, and the daily requirements for tutors are: Day M T W Th F S Su Requirements 5 4 7 3 6 3 4 Find the minimum number of tutors required if each tutor works 4 days a week and has 3 consecutive days off. Give preference to Saturday and Sunday off in case of a tie. (Hint: Look for group of 3 days with the lowest requirements). Specify the work schedule for each tutor. How much slack does your schedule generate for each day?
10.6 This optional problem requires knowledge of statistics. Heywood Home Healthcare is evaluating a project with the following net cash flows and probabilities: Time 0 Year 1 Year 2 Year 2 Year 3 Year 4 Prob = 0.2 ($100,000) 20,000 20,000 20,000 20,000 30,000 Prob = 0.6 ($100,000) 30,000 30,000 30,000 30,000 40,000 Prob = 0.2 ($100,000) 40,000 40,000 40,000 40,000 50,000 The year 5 values include salvage value. Heywood’s corporate cost of capital is 10 percent. What is the project’s expected NPV on the basis of the scenario analysis? What is the project’s standard deviation of NPV? Assume that Heywood’s managers judge the project to have lower-than-average risk. Furthermore, the company’s policy is to adjust the corporate cost of capital up or down by 3 percentage points to account for differential risk. Is the project financially attractive?
b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.