The Pee Tool Shop has four heavy presses it uses to stamp out prefabricated metal covers and housings for electronic consumer products. All four presses operate differently and are of different sizes. Currently the firm has a contract to produce three products. The contract calls for 400 units of product 1; 570 units of product 2; and 320 units of product 3. The time (in minutes) required for each product to be produced on each machine is as follows: Required: USE MS EXCEL BY SOLVING BE DETAILED WITH FORMULAS EXAMPLE (SUMPRODUCTB1:B2)
Q: Find the activity duration (t), latest start (LS) and latest finish (LF) times for activity A.
A: Given: Early start (ES) = 5 Early finish (EF) = 16
Q: tributed across these warehouses: if some of the relevant products are maintained in Tashkent, a…
A:
Q: What is mean by operation management
A: Business operations are the activities that occurred within a company on a regular basis to run a…
Q: With the evolution of RFID instead of UPC, how will this capability make the production grow and…
A: RFID:- The Radio Frequency Identification (RFID) technology has been around since the 1940s, but…
Q: How might globalization be a problem for a successful national company that is intent on going…
A: Globalization refers to the process by which a company or organization expands its function,…
Q: The government is auctioning off oil leases at two sites. At each site, 150,000 acres of land are to…
A: Land for auctioning = 150,000 acres Also, no bidder can receive more than 45% of the land being…
Q: Difference between purchasing and procurement
A: Purchasing and procurement are the two distinct activites that are carried out at the time of…
Q: Efficient inventory management is important to a company mainly because of the position of…
A: Inventory control system in Malaysia: Inventory control system make it feasible for associations to…
Q: What are the considerations involved in making the decision to provide services in-house or to…
A: Outsourcing can be broadly defined as a process where the services or operations are given out to a…
Q: Differentiate between locating a service company as opposed to locating a manufacturing.
A: Together with advertising, HR, and perhaps finance, operations are one of a company's key functional…
Q: QUESTION 2: Identify the different stages of a project job cycle
A: A project management life cycle is a process with different stages like initiating, planning,…
Q: Formulate and solve the following linear program: You are trying to create a budget to optimize the…
A: Maximize Z = 2F + 3S + 5E subject to F + S + E <= 1500 F + S <= 1100 S <= 800 E…
Q: Distinguish between internal and external stakeholders in systems analysis
A: A stakeholder can be stated as the individual or party in the organization that can either affect or…
Q: idering his decision of buying the brackets and is considering making the brackets in-house. He has…
A: Given: D=Demand=200 C=order cost=$18.50 h=holding cost=$1.60 Lead time=2 days
Q: The Operations Manager of supermarket has received the following customer complaints for a 4-week…
A: A check sheet is a quality tool where the data related to the defects/complaints are collected and…
Q: What exactly is an evaluation plan?
A: As the roadmaps are used to facilitate the progress in the journey, same as the evaluation plan…
Q: Consider the transportation problem having the cost and requirement table a. Write the linear…
A: a. Let S represent Source and D represent destination
Q: Choose the best answer. The Production Planning Hierarchy: Box "C" A B CD Strategic Planning…
A: STRATEGIC PLANNING: Strategic planning in production can be defined as an overall planning which is…
Q: Max X s.t. Regular % constraint 0 X DeCaf % constraint 0 X Pounds of Regular 800 X Pounds of DeCaf…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: How does teamwork affect work performance and the possibility to win a game?
A: Teamwork can be stated as essential to the growth and success of the organization. Each living…
Q: 1. When is the best time to do the cycle count? and give examples of cycle count methodologies.
A: The cycle count method provides the correct amount of stock available in the warehouse. This method…
Q: How to determine B3:B5 and B:7 to B12
A: The given question is an employee scheduling question, which is solved using a linear programming…
Q: nd weights. The company exported its products solely to the US market, but with declining sales…
A: 1) Parveen materials producing sold articles of clothing under confidential brand names and not…
Q: plain, What are the issues with Balanced Scorecard?
A: The Balanced Scorecard is a strategic management system developed by Dr. Robert S. Kaplan and Dr.…
Q: Walmart (WMT) is robotic janitors in some of its stores. Walmart has purchased several Autonomous…
A: 1. From the above mentioned fact, it is very much evident that the costs of the robots are fixed…
Q: CASE 2. "The Possibility"Restaurant Angela Fox and Zooey Caulfield were food and nutrition majors at…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Solve using the simplex method (Use Excel Solver) Maximize P = 6 x1 + 3x2 subject to…
A: Given LP- Objective Function-Max P = 6X1 + 3X2Constraints- Subject to -2X1 + 3X2 ≤ 9…
Q: which of these is not true about DMADV options are Addresses the to-be process Reduces/…
A: DMADV is nothing but the acronym for Define, Measure, Analyze, Design, and Verify. DMADV is…
Q: Required: 3. Identify and explain the shadow prices for each of the resource constraints. 4. Which…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: For the Petroco Service Station problem, what would your excel file that shows exponentially…
A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…
Q: why and how companies should manage inventory level?
A: Inventory level:- The amount of inventory you have available across your whole distribution network…
Q: alysis, we assume that there are infinite cookie trays and infinite empty space for co at each order…
A: Given: Resources Processing times Worker 1 & bowl 8min/order Worker 1 & trays…
Q: A toy company makes stuffed animals. Their biggest sellers are their bunny (b) and dog (d)…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: What is the importance of Inventory Management? Cite examples on how to handle management
A: Inventory management is a strategic area in the supply chain operations and has an impact on the…
Q: When it comes to product quality, how crucial is the role of software today?
A: Product quality is one of the important factors for customers to consider during product selection.…
Q: sify the source of conflict in the scenarios described. Employees at Best Enterprises do not know…
A: A complaint is for the most part characterized as a case by a worker that the person is unfavorably…
Q: A company produces two types of tables, T1 and T2. It takes 2 hours to produce the parts of one unit…
A:
Q: Illustration 5.3 Volkswagen's governance crisis Spring 2015 saw a boardroom battle at one of the…
A: To what extent does Volkswagen reflect the strengths and weaknesses of the stakeholder model of…
Q: True or False If the term of the sale is FOB destination point, the Seller will shoulder the cost…
A: Transporting of goods is moving the goods from one place to another. These are various types of…
Q: What are the most important considerations for acquiring new technology or improving current systems…
A: Various considerations that has to be considered while improving the systems or acquiring the newest…
Q: The following reflects the types of processes aligned with the process analysis method: a.…
A: Explanation: Method analysis in the context of ergonomics is a technique for assessing the…
Q: Need help computing the mad with both a=.20 and b =.20 values
A: Given data is
Q: s false regarding control charts? Select one: a. Control charts that have values above the upper…
A: Option a is false Control charts that have values above the upper control limits imply that…
Q: fferentiation by Price, Promotion and Place usually are quite short term and can be copied by…
A: Yes completely agreed to the above points because Product differentiation methodologies are the…
Q: CASE 3. Burger Doodle The manager of a Burger Doodle franchise wants to determine how many sausage…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: are 168 and 18, respectively. Find the set of feasible solutions graphically for the number of each…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Question ONE Consider the narrative below and use it to answer the questions that will follow: At…
A:
Q: Question 4 Fortis Utility Company uses 2,000 units per year which it stores at $0.50 per unit per…
A: 4) a) Given, annual demand, d =2000 units Ordering cost, o = $ 100…
Q: s may use to aid in supply ch
A: The organization can keep its stores loaded and provided through its proficient process for dealing…
Q: Brenda Mage, an undergraduate accountancy major at Ateneo de Zamboanga University, is attempting to…
A:
Step by step
Solved in 2 steps with 4 images
- Data Products, Inc., packages and distributes a variety ofpersonal computer-related products. A time study hasbeen conducted for a job packaging 3.5-inch personalcomputer diskettes for shipment to customers. The jobrequires a packager to place 20 diskettes in a rectangularplastic bag, close the bag with a twist tie, and place thefilled bag into a bin, which is replaced by another workerwhen it is filled. The job can be broken into four basic elements. The elemental times (in minutes) were ob-tained from the time study for 10 job cycles shown in the following table. a. Using an allowance factor of 16%, determine the stan-dard time for this job. b. Determine the number of cycles for this time studysuch that the company would be 95% confident that theaverage time from the time study is within 4% of thetrue average cycle time.b) A company receives parts from suppliers to be used in its manufacturing departments. The quality control department must perform two operations when shipments are received: Operation A – draw a random sample, package, and deliver to testing; and Operation B – test the materials and issue a disposition report. There are currently six shipments waiting to be processed. The time estimates for processing these six shipments through quality control are given in the table below. Shipment Operation A (hours) Operation B (hours) A 1.5 1.0 В 1.1 2.7 1.2 1.4 D 0.7 1.6 E 1.6 1.5 F 1.9 2.9 Use Johnson's Rule to set the sequence of processing the shipments through Quality Control. i. ii. How much total time is required to process all the six shipments through Quality Control? Show all times on a Gantt Chart. w lu5. During the construction of a house, six joists of 24 ft each must be trimmed to the correct length of 23 ft. The operations for cutting a joist involve the following sequence: Operation 1. Place joist on saw horses 2. Measure correct length (23 ft) 3. Mark cutting line for circular saw 4. Trim joist to correct length 5. Stack trimmed joist in a designated area Time (seconds) 15 5 5 20 20 Three persons are involved: Two loaders must work simultaneously on operations 1,2, and 5, and one cutter handles operations 3 and 4. There are two pairs of saw horses on which untrimmed joists are placed in preparation for cutting, and each pair can hold up to three side-by-side joists. Suggest a good schedule for trimming the six joists.
- 1. Crispy chips company operates in two shifts every day. Each shift is for a duration of 8 hours. During the shift workers get a break of 1 hour. Following are the steps involved in chips manufacturing: Set Up Time (in mins) Run Time (in mins) Steps Peeling Cutting Blanching Dewatering Frying and Deoiling Flavoring & Packing 5 2 10 3 15 2 4 2 20 2 Chips are produced in batches of 100 and are packed in packets of 20. Identify the bottleneck process and determine the capacity of Crispy chips in terms of number of bags of chips.Medical Solutions, Inc. has the following claims it must complete in the next week (40 hours). The jobs are as follows: Claim Type Spinal injury Number of Claims Setup (Changeover) to Process (Work Time per Claim Type (hours) Cancer treatment 15 Hip replacement Order Quantity) 14 10 SI Claims Workload: hours Processing Time per Claim (hours) HR Claims Workload: hours 3.0 1.1 2.5 0.9 1.5 All claims of the same type are processed together. Is 40 hours enough capacity? (Hint: use Equation 10.3.) Round your answers to one decimal place. CT Claims Workload: hours 0.5 Total workload is hours while capacity is 40 hours. The work -Select-cancannotItem 5 be completed using regular time hours.Employees Layoffs at the University Medical Center The University Medical Center is medium-sized, 300-bed capacity hospital at Dasmarinas Cavites. The facilities have grown gradually over the years and are now the 2nd largest in the town of Dasmarinas. It is entirely nonunion and has never experienced an employee layoff since its inception. Sister Veronica Cornista, the Chief Executive Officer of the hospital for 8 years presented a rather bleak financial of the BOD. This according to her is the result of the declining occupancy rate which has affected the hospital’s revenues to such an extent that it ran a deficit for the first time last 1998. Such declines have not been unusual for this industry because of increasing competition. So far, the only response to these changes has been tightening of requirements for equipment or supply purchases. The projected deficit for the coming year is around 1,300,000 unless some additional revenues were identified or some additional savings…
- Final Te Question 2 Which of the following are permissible hours for the sale of alcohol in a grocery store? O Sunday, 11:00am to 6:00pm. O As long as the grocery store is open. O Monday to Sunday, 9:00am to 9:00pm. O Monday to Sunday, 7:00am to 11:00pm.How is the scheduling of patients in a doctor’s clinic simi-lar to and different from the scheduling of jobs in a factory?Assume that General Dynamics, which manufactures high-technology instruments for spacecraft, is considering the sale of a navigational unit to a government agency in India that wishes to launch its own communications satellite. The government agency plans to purchase 8 units, although it would also consider buying 16 units. General Dynamics has started a chart relating labor time required to units produced. Unit Produced (X) Time Required toProduce the Xth Unit 1 10,000 hours 2 8,000 hours 4 6,400 hours 8 ? 16 ? Required: a. Compute the labor time required to produce 8 and 16 units.b. Assume that labor time costs $125 per hour. Compare the cost of producing the 1st unit to the cost of producing the 16th unit. What is the percentage of the cost of the 16th unit to the cost of the 1st unit?
- A company receives parts from suppliers to be used in its manufacturing departments. The quality control department must perform two operation when shipments are received:i) Operation A-draw a random sample, package, and deliver to testing, andii) Operation B-test the materials and issue a disposition reportThere are currently six shipments waiting to be processed. The time estimates for processing these six shipments through quality control are:Shipment Operation A (hours) Operation B (hours)1 1.5 1.02 1.1 2.73 1.2 1.44 0.7…3 = noito This work cell will produce 617 units per day (8h x 60 m x 60 se) / 46.67 = 617 Takt time = 140/3 = 46.67 Copyright © 2017 Pearson Education, Ltd. Takt time design Creating plate printing cutting packaging Example: 100 Al-Nojoom Company for advertising has identified the following operations as necessary for the work cell for producing color posters. The customer expects delivery 1000 poster per day, and the work day 10 hours. 1. What is the takt time? Copyright © 2017 Pearson Education, Ltd. 2. How many employees are required? 3. If the number of employees assumed to be 9 employees. Find the quantity of products they able to produce. 4. If the work cell has 4 employees find the Total work time by hours needed to produce 600 units with the same operational time. operation Standard time 21.01 unitnos (min) 1.1 0.9 .75 1.25 1 9-33 sill nG a super 9-34b. The Healthy Food Restaurant, a 24-hour restaurant, faces changing requirements from hour tohour. More workers are needed for peak hours, and fewer are needed in between. The followingTable 6 (below) shows the worker requirement for the first 12 hours in the restaurant:Table 6. Staff Requirement at the Healthy Food RestaurantTime Period 10AM11AM12PM1PM2PM3PM4PM5PM6PM7PM8PM9PMRequirement 8 10 12 12 9 7 6 7 9 10 12 8AssignedOn DutyOverstaffed8(i) You are required to apply the first-hour principle to staff each hour with the required number ofcafeteria staff, showing how many staff are on duty each given hour, the number of staffyou have assigned to work each hour and any overstaffing for each hour. i. Schedule the staff to work in 8-hour shifts.