Sales representatives sell two products A and B. Based on historical data there is an average 20 euro commission for every call on product A and a 10 euro commission for every call on product B. Data also shows that sales representatives spend about 3 hours per call for product A and 2 hour for product B. The company requires at least 25 calls per month for each product and not more than 100 calls per month on any one product. How should the sales representatives allocate their monthly 165 working hours between making calls selling products A and B if they want to maximize their commission? a) Mathematically formulate the LP model for maximizing commissions (=primal problem) b) Mathematically formulate the dual problem of the primal problem. Implement both LP models (primal and dual) using Excel Solver. c) Report the optimal objective functions, decision variable values and the shadow prices of both the primal and dual problems. d) Confirm that these numbers are in line with the properties known to hold between primal and dual problems. Report these results

Sales representatives sell two products A and B. Based on historical data there is an average 20 euro commission for every call on product A and a 10 euro commission for every call on product B. Data also shows that sales representatives spend about 3 hours per call for product A and 2 hour for product B. The company requires at least 25 calls per month for each product and not more than 100 calls per month on any one product. How should the sales representatives allocate their monthly 165 working hours between making calls selling products A and B if they want to maximize their commission? a) Mathematically formulate the LP model for maximizing commissions (=primal problem) b) Mathematically formulate the dual problem of the primal problem. Implement both LP models (primal and dual) using Excel Solver. c) Report the optimal objective functions, decision variable values and the shadow prices of both the primal and dual problems. d) Confirm that these numbers are in line with the properties known to hold between primal and dual problems. Report these results

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter12: Queueing Models

Section: Chapter Questions

Problem 59P

See similar textbooks

Similar questions

The customer are complaining to the hotel general manager about the service provided from front desk and restaurant how can the general manager reduce variability and increase consistency
The revenue cycle is a method of defining and maintaining the processes used for the completion of an accounting process for recording revenue generated from services or products provided by the company, which include the accounting process of tracking and recording transaction from the beginning, normally which starts from receiving an order from the customer or entering in agreement with the customer, delivering an order to customer and end with getting payment from the customer. The figure on the next page describes the different business activities of four departments, including (1) Sales Department, (2) Accounting Department, (3) Warehouse/Shipping, and (4) Mailroom. Required: Based on the below figure, discuss the uncontrolled risks associated with the system as currently configured? And describe the controls that need to be implemented into the system to mitigate the risks in the given scenario.
Mr Smith is working as the director of credit collection department at SISHGC Building Supplies Limited. The credit collection department recently shifted from the legacy system to a new system that was installed four months ago. Mr Smith is not happy with this newly installed system. His complaint is that the data flow from the billing and account receivable departments is not occurring in the manner originally requested. Further, the updates to the database files are not occurring as frequently as he had envisioned. Thus, the hope that the new system would provide more current and timely information has not materialised. Mr Smith claims that the systems analysts spent three days interviewing him and other workers in his department. During that time, he and the other workers thought they had clearly conveyed their needs. At this stage, Mr Smith feels as if their needs were ignored, and their time was wasted. Required: Identify the issues in the system design process. How can these…
Relevant Costs and Quality Improvement Lightening Bulk Company is a moving companyspecializing in transporting large items worldwide. The firm has an 85% on-time delivery rate.Thirteen percent of the items are misplaced and the remaining 2% are lost in shipping. On average,the firm incurs an additional $65 per item to track down and deliver misplaced items. Lost items costthe firm about $300 per item. Last year, the firm shipped 6,000 items with an average freight bill of$200 per item shipped.The firm’s manager is considering investing in a new scheduling and tracking system costing$125,000 per year. The new system is expected to reduce misplaced items to 1% and lost items to0.5%. Furthermore, the firm expects total sales to increase by 10% with the improved service. Theaverage contribution margin ratio on any increased sales volume, after cost savings associated witha reduction in misplaced and lost items, is expected to be 37.5%.Required1. Based on a relevant cost analysis, should…
Justin is a carpenter and makes furniture which he sells via the internet. He needs a new machine with steel attachments to speed up the drilling process for his work. He contacts Fixing and Building Machines Ltd who recommends a machine which they claim is more than 10 times quicker and stronger than his old machine. Justin goes into Fixing and Building Machines Ltd. Before paying for the machine, he sees a sign on the wall behind the counter that has the words “Important Information: READ BEFORE PURCHASE! Fixing and Building Machines Ltd accepts no liability.....” in bold, red print at the top. However, the sign is falling down from the wall and the rest of the words are obscured by a large plant. Had Justin been able to read the rest of the sign, he would have read “....for loss howsoever caused.” Justin signs a document, buys this machine and takes it with him. When he tried it he found it to be no quicker than his old one and the attachments broke. He also found that it started…
How is a problem statement verified
Prybloxx primarily uses one courier company, AJAX Couriers, for all their deliveries. In some circumstances, where AJAX is too busy and does not have capacity to fulfil deliveries or they do not cover certain areas, only then will Prybloxx make use of a different courier company. Prybloxx has recently had a significant influx of customer complaints regarding goods that have not been delivered, delivered long after the agreed delivery time or damaged once they arrive at the customer. Prybloxx is aware of the effect that this could have on demand for their product, customer goodwill and are now investigating insourcing the delivery of their product to customers. Prybloxx has noted that they have two alternatives in insourcing this department – they can either purchase a local courier company that is considered a going concern or they can purchase all of the required assets and set up such a department themselves. Mr. Pranoto (production manager) has requested that you prepare a report…
What type of time-series components would you expect for the following products and services?a. Monthly sales of a retail florist.b. Monthly sales of milk in a supermarket.c. Daily demand in a call center.
Josh Smith, the materials manager at a retail store, has determined that a particular product experienced 5 turns last year, with an annual sales volume of $15 million. What was the average inventory value for this product last year? $2.5 million $2.75 million $3 million $5 million
THE CUSTOMERCiracasindo Perdana has been dedicated to beverage system business for the last 20 years, dealingwith the production and distribution of high-end beverages brands such as SUNFRESH NaturalFruit Juices, DOUWE EGBERTS Coffee and EQUAL Sweetener to entertain hospitality industry,including star hotels, restaurants, cafés, industrial catering, retail outlets like Hypermart, Carrefour,Ranch Market, Kem Chicks, etc. In addition, it supports beverages companies such as Arnott’s,Garuda Food, Tang Mas, Orang Tua, etc. The company has wide-ranging products and packagingwith about 150 items in total, and currently operates sales offices in 6 different regions from Jakartato Ujung PandanTHE CHALLENGECiracasindo has been applying business software system since 2003. As the company’s businessgrows, the need for a more comprehensive set of enterprise resources planning (erp) systemincreases. The current system cannot handle high capacity and the company’s growing expectationdue to its…
The sales department encourages its customers to forward the orders in any form, including mail, e-mail or fax. The sales clerk first converts these sales order into the standardised sales order. For this purpose, the sales representative requests the missing information, if any. When the order is received, the sales clerk checks the customer’s creditworthiness of the customer from his computer terminal. Sales clerk thinsk that checking the accounting record is not technical and he can perform these duties efficiently. Two years ago, the sales clerk requested the accounting department to provide him with a list of customers whose account receivables are written off. The sales clerk is still using thisinformation to check the creditworthiness of the customers. The sales clerk did not differentiate the new customers from the existing customers and he is using the same procedure to check the creditworthiness of the new customers. The customer’s order is rejected if the customer’s credit…
The mailroom receives checks and remittanceadvices from customers in payment of their accountsreceivable. The clerk reviews the documents for completenessand correctness, sends the checks to thecash receipts department, and sends the remittanceadvices to the AR department. The AR clerkreceives the remittance advices and updates the customers’AR records from the PC in the AR department.The cash receipts clerk receives the checks andposts them to the cash receipts journal from the PCin the department. The clerk then sends the checks tothe bank for deposit.RequiredPrepare a system flowchart of the proceduresdescribed previously.