Question: Please make an algebraic model for this question and solve on lingo or excel solver. thanks 2. A delivery service for cooked food has contracts

Please make an algebraic model for this question and solve on lingo or excel solver. thanks Please make an algebraic model for this question
Please make an algebraic model for this question
2. A delivery service for cooked food has contracts with many restaurants which do not have their own delivery service. Customers place their orders on-line with the delivery service, stating the items they wish to order and the restaurant at which the order will be made. The delivery service then sends each order to the restaurant, picks it up when it's ready, and delivers it to the customer. Though some delivery services work on a per-order basis, this one pays its drivers by the hour. Deliveries begin at 7 a.m. each day, and continue until 2:59 a.m. the next morning. Their drivers work two four-hour shifts per day. For some drivers, the two shifts are consecutive (effectively one eight-hour shift), but other workers work split-shifts, with a four hour gap between their shifts. All drivers earn a base rate of $17 per hour. In addition, there is a per-day bonus of $14 paid to each driver who works on a split-shift. The delivery service has the following daily requirements: Subject to meeting all its requirements for workers, the delivery service wishes to minimize its daily labour cost (regular and bonus). Formulate the model so that the $17 and the $14 are entered only once. (a) Formulate an algebraic model for the problem. If you wish to solve the models in Excel Solver, you will have to write them in standard form, i.e. all variables on the left-hand side, and a number of the right-hand side. If you use LINGO, you are not bound by this restriction. Submit the algebraic model in the single Word or pdf file. (b) Use LINGO or the Excel Solver to solve this model. Imbed the LINGO model and solution report files, or tabs of the model and Answer Report from the Excel file, into the single Word or pdf submission file

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!