3. National Disc Corp. produces the discs used in producing Xbox and PlayStation discs. Theirlocal plant runs 24 hours a day, 7 days a week. In a given day, there are requirements for thetotal number of employees that must be at the plant. These are given below.Employees NeededHours12am - 4am4am - 8am8am-12pm12pm - 4pm4pm - 8pm8pm-12am81016211812Employees can either work 8-hour or 12-hour shifts, starting at the times stated above (12-hour shifts can start only at 12 am/pm or 8 am/pm). Those working 8-hour shifts cost thecompany $40 per hour in benefits, and those working 12-hour shifts cost the company $60per hour. Develop a linear program that can be used to determine how National shouldstaff the local plant so as to minimize labor costs (you do not need to solve the model).Be sure to clearly identify your variables.

National Disc Corp. produces the discs used in producing Xbox and PlayStation discs. Their local plant runs 24 hours a day, 7 days a week. In a given day, there are requirements for the total number of employees that must be at the plant. These are given below.

National Disc Corp. produces the discs used in producing Xbox and PlayStation discs. Their local plant runs 24 hours a day, 7 days a week. In a given day, there are requirements for the total number of employees that must be at the plant. These are given below.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

File Edit View Sign Window Help Home Tools eh U & O PS1 → X Module 1 Linear Pr... 2 / 2 H 0 Q 87% 3. Scheduling at the Bank of Tacoma The Bank of Tacoma is open Monday through Friday from 9am to 5pm. From past experience, the bank knows that it needs the number of tellers shown in the table below at various times of the day. Bank of Tacoma hires two types of tellers. Full-time tellers work 9am to 5pm, 5 days a week, with 1 hour off each day for lunch. The bank determines when a full-time employee takes his or her lunch hour, but each teller must go between 11am and noon, noon and 1pm, or between 1pm and 2pm. Full-time employees are paid $24 per hour, including a paid lunch hour. The bank can also hire part-time tellers. Each part-time teller works exactly three consecutive hours each day, starting at any specified hour (e.g., 10am-1pm), the same time every day of the week. A part-time teller is paid $16 per hour. To maintain adequate quality of service, the bank has decided that at all…
The library uses a library management system (LMS) through which 10 books can be issued to its employees per day. To keep track of each book, there is a function that gets the details such as title, faculty name, date of borrowing, and the duration required. The issue) function determines whether the books requested should be granted or not based on the value (cost), year of publication, and the number of books being requested if the book costs more than Rs 1000 or is published in the current year, or if the book count is one, then the book is to be issued for no more than two days. Also, the LMS keeps track of the top 5 books in the library to determine which book is more valuable than another. Your task is to create a LMS based on the above scenario by creating a structure and implementing the functions required (Not Use pointers to the defined structure).
Compute the volumes of cut and fill between stations 88+30 to 88+68 using the slope stake notes in the table on the following page. Use the average end area equation except for when the section produces a pyramid. In those situations, use the equation for a pyramid. Assume: Base Widths: cut = 50 ft; fill = 40 ft | Side Slopes: 2:1 | Gradient: -2% SURFACE GRADE STA L CL R ELEV. (ft) ELEV. (ft) C18.1 C10.2 92+00 891.6 874.63 C17.0 61.2 45.4 0 0 0 0 91+52 8575.6 875.59 0.0 25 20 20 25 F6.9 F11.4 91+00 864.5 876.63 F12.1 33.8 42.8 F8.2 F10.1 90+50 867.3 877.63 F10.3 36.4 40.2 F12.8 90+05 875.3 878.53 F3.2 20 45.6 C16.3 F12.2 89+73 879.2 879.17 57.6 44.4 C17.4 F8.3 89+59 885.6 879.45 C6.1 59.8 14 36.6 C10.2 F7.3 89+43 879.8 879.77 45.4 34.6 F16.1 89+08 873.7 880.47 F6.8 20 52.2 C16.8 F12.9 88+68 881.3 881.27 58.6 45.8 C24.0 88+30 890.9 882.03 C8.9 73.0 25
A company manufactures 3 products in 2 different factories. The cost of production and time required for production for each product varies depending on which factory produces it. The time and cost required for production of each product in each factory is provided in the tables in this worksheet. Demand for products 1, 2 and 3 are 200, 240 and 100 units, respectively. There are a total of 3,000 hours available in each factory. Additionally, at least 60% of the total units of Product 1 must be produced in Factory A, and at least 40% of of the total units of Product 2 must be produced in Factory B. Create a linear programming model and use the Solver add-in to determine the optimal production plan that will minimize total cost. Note: The cost is per unit not per hour. All demand must be met.
Please show me all the steps
A large apple farm distributes their apples in boxes that they can source from any one of a number of nearby box manufacturers. Each box manufacturer makes only one box type that holds a specific number of apples - so a box from one manufacturer might hold 24 apples, while a box from another might hold 13. The apple farm can only choose one box supplier each year (a decision they make each year based on price), but they can then order an unlimited number of boxes of that type. The farm likes to be prepared, and creates large batches of apples to pack before the decision about which box type to use has been made. The farm also likes to limit waste, and tries to set the number of apples in these large batches such that they can fill an integer number of boxes perfectly with no apples left over. In creating these batches, although the farm doesn't yet know the exact capacity of the boxes they will buy, they know a list of possible values the box capacity will take. For example, if the…
8
The tables below are actitvites slack times and number of workers required respectively. A-B B-D D-E A-D T1. (slack) A-D B-E B-C C-E 8 6 4 1 T2. (workers) B-E B-C C-E 3 2 3 4 3 2 2 Q2. In the above table, the completion times of the activities BD and DE are on average 6 hours and 8 hours, respectively, and if the variances of the completion times of the same activities are 16 and 9 hours, respectively. a. What is the expected total completion time of the project? b. What is the probability that the project will be completed in 20 hours in total?
For example, if a company has a certain amount of income or a certain number of workers, it may be eligible to submit its tax return early.
Please do it in excel A company would like to invest on a project. The rate the company uses to justify their investments, i.e. the MARR is 25% per year (compounded yearly). Their estimations about the projects are as follows: Initial Cost: ($300,000)The Study Period: 15 yearsSalvage (Market) Value of the Project: 20% of the initial cost Operating costs in the first year are estimated to be ($7,500) and these operating costs are estimated to increase by 5% per year. Construct cash flow table and determine the minimum amount of annual revenue ($ per year?) that makes this investment an attractive option for the company? (i.e. what is Equivalent UNIFORM (Annual) Cost, EU(A)C?)
Explore the concept of IoT (Internet of Things) and its relationship with embedded software development. What are the key considerations when developing embedded software for IoT devices?
3G R 4G O 53% D 17:57 CMPG 121 Final... Loyalty points are awarded by a company based on the amount a customer spend. Loyalty points can be used immediately with the current transaction or can be accumulated. The number of loyalty points per transaction is calculated as follows: For purchases of R 500.00 or less, 1 loyalty point will be awarded per R 50.00 spent. For purchases of more than R 500.00 the following applies: • For the first R 500.00, 1 loyalty point will be awarded per R 50.00 spent For the remainder of the amount, 2 loyalty points will be awarded per R50.00 spent. Examples: For purchases of R 460.00, 9 loyalty points will be awarded. For purchases of R 660.00, 10 loyalty points will be awarded for the first R 500.00 and 6 loyalty points for the remaining R 160.00 = 16 loyalty points For purchases of R 1250.00, 10 loyalty points will be awarded for the first R 500.00 and 30 loyalty points for the remaining R 750.00 = 40 loyalty points The monetary value of the loyalty…