Question: Find the solution in excel. ABC Organization got the job of sending technical consultants to the technology fair that will start on Saturday and continue

Find the solution in excel.Find the solution in excel. ABC Organization got

ABC Organization got the job of sending technical consultants to the technology fair that will start on Saturday and continue for 14 days. The number of technical consultants required for 14 days has been determined as 25, 20, 12, 14, 16, 18, 25, 30, 30, 12, 14, 18, 20, 25, respectively. Each technical consultant is hired from the technical consultant company. A total of 150 dollars is paid to the technical consultant company and the insurance for each technical consultant hired. Each technical consultant is paid 100 dollars per day. 50 dollars must be paid to the technical consultancy company for each technical consultant who is more than the amount of planned in the fair hall. A 75 dollar indemnity is paid to the technical consultant company for each tech. consultant fired. Use this data to plan a 14-day technical consultant workforce that will minimize the total cost. Find the solution in Excel. P.S: Once you pay for the amount of 150 dollars for the company and insurance to hire a consultant, the next day it will be adequate to pay fee daily for the employee, which will cost 100 dollars. If you do not want the employee to be there, then you are obliged to fire the employee and pay 75 dollars. Otherwise, you can keep the employee there and pay 50 dollars for the consultancy company in addition to his daily fee

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!