Six new staff have been appointed by ABC store as sales people. Below is a table showing the number of customers each serves. The daily target for the department is 180 clients and each individual has been given a target of 10 clients per day. Name of rep Kate Lerato Mpho Cathy Modishe Tshepo Total Number of new customers 10 5 8 2 11 4 40 % Output per day of the total number of clients (10/40) x 100 = 25 (5/40) x 100 = 12.5 (8/40) x 100 = 20 (2/40) x 100 = 5 (11/40) x 100 = 27.5 (4/40) x 100 = 10 100 % Output per day of the expected 10 clients per day (10/10) x 100 = 100 (5/10) x 100 = 50 (8/10) x 100 = 80 (2/10) x 100 = 20 (11/10) x 100 = 110 (4/10) x 100 = 40 Answer the following questions based on the table above: a. Who serves the most customers in the store? b. Who serves the least customers in the store? c. How many customers in total are served in a day by all the sales people?

Six new staff have been appointed by ABC store as sales people. Below is a table showing the number of customers each serves. The daily target for the department is 180 clients and each individual has been given a target of 10 clients per day. Name of rep Kate Lerato Mpho Cathy Modishe Tshepo Total Number of new customers 10 5 8 2 11 4 40 % Output per day of the total number of clients (10/40) x 100 = 25 (5/40) x 100 = 12.5 (8/40) x 100 = 20 (2/40) x 100 = 5 (11/40) x 100 = 27.5 (4/40) x 100 = 10 100 % Output per day of the expected 10 clients per day (10/10) x 100 = 100 (5/10) x 100 = 50 (8/10) x 100 = 80 (2/10) x 100 = 20 (11/10) x 100 = 110 (4/10) x 100 = 40 Answer the following questions based on the table above: a. Who serves the most customers in the store? b. Who serves the least customers in the store? c. How many customers in total are served in a day by all the sales people?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section4.8: Data Envelopment Analysis (dea)

Problem 42P

See similar textbooks

Similar questions

Lusail Food aims to produce (30,000) units next year. After studying the time, it turned out that each unit needs: Productive work of four hours per unit (job as a production worker) Marketing work of two hours per unit (Job: Marketing Officer) Administrative work of three hours per unit (Job: Administrative)? Currently working in the company: 14 production workers, 6 marketing staff, and 12 administrators. If you know that the average number of annual working hours available is 2500 hours. What is required is to determine the size of the workforce required for the coming year using workload analysis. Number of production units: Unit Next year Function Required working hours / one unit Annual working hours available to the employee next year Required working hours for next year Required workforce for next year Current number of employees For the current year Surplus or deficit In the workforce Next year Production Factor…
XYZ Company produces and sells 2 products, Lambda and Gamma, and the production process goes through two departments. Traditionally Manufacturing Overhead (M/O) cost is applied on the basis of direct labor hours (DLH); estimated M/O cost is $ 5,757,500 and the estimated DLH is $12,250 for the most recent period.The team decided to replace traditional plantwide costing system to activity-based costing system. There are 3 activity cost pools which represent 3 activity areas at the plant. Direct Labor wage rate is $ 30 per hour. Compute total cost per unit (for lambda and gamma) using activity-based approach. (round your numbers).
The Company makes TSHIRTS at their facility in chicago and Minnesota. The process involves three departments: Cutting, Stuffing, and Sewing. Eddie Edwards is the Manufacturing Manager for acme She has developed a monthly production plan for the next half year: Month 1 2 3 4 5 6 Planned Production (units) 65,000 72,000 74,000 71,000 80,000 82,000 Jamie has also collected some data about each of the production departments: Department Time required per pillow (hours) Total Production Hours Available (monthly) Cutting .25 24,000 Stuffing .45 34,000 Sewing .85 60,000 Jamie needs to assess the capacity implications that the monthly production plan holds for her facilities. Please answer the following questions concerning her situation. a) Calculate the projected monthly capacity utilization (as a percentage of production hours available) for each of the three departments. b) Which department is of greatest concern for Eddie? Why?. c) Please suggest two ways that Eddie might be able to…
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows: Machine Cost A $ 60,000 B $ 50,000 C $ 60,000 Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Product AnnualDemand A B C 1 16,000 3 4 4 2 10,000 6 5 1 3 15,000 1 3 6 4 17,000 5 3 4 Click here for the Excel Data File a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 10 hours a day, 240 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole…
In planning its operations for the year based on sales forecast of P 6,000,000, the company prepared the following estimated data:Cost and expensesVariableFixedDirect materialsP 1,600,000Direct labor1,400,000Factory overhead600,000900,000Selling expenses240,000360,000Administrative expenses60,000140,000P 3,900,000P 1,400,000What would be the amount of sales in pesos at the break- even point?a. P2,250,000c. P4,000,000b. P3,500,000d. P5,300,000
A manager must decide which type of machine to buy, A, B, or C. Machine costs (per individual machine) are as follows: Machine Cost A $ 60,000 B $ 50,000 C $ 60,000 Product forecasts and processing times on the machines are as follows: PROCCESSING TIME PER UNIT (minutes) Product AnnualDemand A B C 1 16,000 3 4 4 2 10,000 6 5 1 3 15,000 1 3 6 4 17,000 5 3 4 a. Assume that only purchasing costs are being considered. Compute the total processing time required for each machine type to meet demand, how many of each machine type would be needed, and the resulting total purchasing cost for each machine type. The machines will operate 10 hours a day, 240 days a year. (Enter total processing times as whole numbers. Round up machine quantities to the next higher whole number. Compute total purchasing costs using these rounded machine quantities. Enter the resulting total purchasing cost as a whole number. Omit the "$" sign.) Total…
At the end of Avondale Industries’ fiscal year, the training and development office reviewed its budget and found that, due to the cancellation of two training programs, there were still funds left to spend. With just two weeks in which to spend the money, the training director put together a program to train employees who were transferring from the avionics division to the new adhesives and sealants division. The training was held but there was not enough time to consult with managers in the adhesives and sealants division to set learning objectives for the skills needed in the new division. A month later, the training director was asked to provide another training as the employees did not have the knowledge, skills, and abilities for their new jobs. Why is it important that a thorough analysis of training needs be conducted prior to holding a training program? Understanding the needs of the new division will help supervisors identify which employees need the training the most.…
Tribal Systems, Inc., is opening a new plant and has yet todecide on the type of process to employ. A labor-intensiveprocess would cost $10,000 for tools and equipment and$14 for labor and materials per item produced. A more automated process costs $50,000 in plant and equipment buthas a labor/material cost of $8 per item produced. A fullyautomated process costs $300,000 for plant and equipmentand $2 per item produced. If process selection were basedsolely on lowest cost, for what range of production wouldeach process be chosen?
The following processes - Tameka, Tamia, and Christian - have the following cost structure: Show all work in Excel with formulas Process Fixed Cost per Year Variable Cost per Unit Tameka $120,000 $3.00 Tamia 90,000 4.00 Christian 80,000 4.50 a. What is the most economical process for a volume of 8,000 units? b. How many units per year must be sold with each process to have annual profits of $50,000 if the selling price is $6.95 per unit? c. What is the break-even volume for each process?
A TV factory plans to add production lines for its new product and plans to produce as many as 800 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. Draw a diagram of the production process.b. With the diagram that you have described above, can the production process run properly according to the plan? Explain the process of each workstation that you have created!.
The Betterbilt Construction Company designs and builds residential mobile homes. Thecompany is ready to construct, in sequence, 16 new homes of 2,400 square feet each. Thesuccessful bid for the construction materials in the first home is $64,800, or $27 per square foot.The purchasing manager believes that several actions can be taken to reduce material costs by8% each time the number of homes constructed doubles. Based on this information,a. What is the estimated cumulative average material cost per square foot for the first fivehomes?b. What is the estimated material cost per square foot for the last (16th) home?
Direct Materials and Direct Labor Variance Analysis Shasta Fixture Company manufactures faucets in a small manufacturing facility. The faucets are made from brass. Manufacturing has 50 employees. Each employee presently provides 32 hours of labor per week. Information about a production week is as follows: Standard wage per hour $12.00 Standard labor time per unit 15 min. Standard number of lbs. of brass 1.5 lbs. Standard price per lb. of brass $11.00 Actual price per lb. of brass $11.25 Actual lbs. of brass used during the week 11,124 lbs. Number of units produced during the week 7,200 Actual wage per hour $12.36 Actual hours for the week (50 employees × 32 hours) 1,600 Required: a. Determine the standard cost per unit for direct materials and direct labor. Round the cost per unit to two decimal places. Direct materials standard cost per unit $fill in the blank 1 Direct labor standard cost per unit $fill in the blank 2 Total standard cost per unit $fill in…