Consider the information below for THREE questions.Modify the employee scheduling model in class so that each worker works 10 hours a dayin four consecutive days and then rest for three days in any 7-day cycle. Employees are paid$10 per hour on weekdays and $12 per hour on weekends. Change the objective so thatyou now minimize the weekly payroll. Use the the following spreadsheet output (screenshotwith purposely hidden information) to answer the questions.C9 Wed10 Thu11 Fri12 Sat13 SunA1 Employee scheduling model2 Hourly wage rates3 Weekday$104 WeekendS Hours per day$12106 Decision variables: number of employees starting their four-day shift on various days7 Mon8 Tue26 Employees required27B17 Tue18 Wed19 Thị20 Fri21 Sat22 Sun23 Constraint on employee availabilities24 Employees available172528 Objective to minimize29 Total employees30 Weekly payrollO 11620O 12150.O 1320074414 Result of decisions: number of employees working on various days (along top) who started their shift on various days (alongside)15Mon Tue WedThuFriSatSun16 MonO 1182017D1313S17151919XG1514X18H16Y13Q: Given the current values for the decision variables, what's the value in cellB30 which represents the weekly payroll?11

Linear programming is a mathematical technique that is also used in operations management…

Answered: Q: Given the current values for the…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

How much influence can the employee requirements for one, two, or three days have on the weekly schedule in the employee scheduling example? Explore this in the following questions: a. Let Monday’s requirements change from 17 to 25 in increments of 1. UseSolverTable to see how the total number of employees changes.b. Suppose the Monday and Tuesday requirements can each, independently of one another, increase from 1 to 8 in increments of 1. Use a two-way SolverTable to see how the total number of -employees changes.c. Suppose the Monday, Tuesday, and Wednesday -requirements each increase by the same amount, where this increase can be from 1 to 8 in -increments of 1. Use a one-way SolverTable to -investigate how the total number of employees changes.
ADVANCED ANALYSIS Linear equations for the consumption and saving schedules take the general form: C = a + bY and S = -a + (1-b)Y where C, S, and Y are consumption, saving, and national income, respectively. The constant a represents the vertical intercept, and b represents the slope of the consumption schedule. a. Use the following data to substitute specific numerical values into the consumption and saving equations. Instructions: If you are entering any negative numbers be sure to include a negative sign (-) in front of those numbers. C = $ Y. S = $ Y. b. What is the economic meaning of b? . What is the economic meaning of (1 – b)? .
Given the following data on inputs and outputs at a work center, determine the cumulative deviation and the backlog for each time period. The beginning backlog is 7.PERIOD1 2 3 4 5 6Input Planned 200 200 180 190 190 200Actual 210 200 179 195 193 194PERIOD1 2 3 4 5 6Output Planned 200 200 180 190 190 200Actual 205 194 177 195 193 200
Job Costing Johnson Inc. is a job-order manufacturing company that uses a predetermined overhead ratebased on direct labor hours to apply overhead to individual jobs. For the current year, estimated direct laborhours are 95,000 and estimated factory overhead is $617,500. The following information is for Septemberof the current year. Job A was completed during September, and Job B was started but not finished.[LO 4-3, 4-4, 4-5]September 1, InventoriesMaterials Inventory $ 7,500Work-in-Process Inventory (All Job A) 31,200Finished Goods Inventory 67,000Material purchases 104,000Direct materials requisitionedJob A 65,000Job B 33,500Direct labor hoursJob A 4,200Job B 3,500Labor costs incurredDirect labor ($8.50/hour) 65,450Indirect labor 13,500Supervisory salaries 6,000Rental costsFactory 7,000Administrative offices 1,800Total equipment depreciation costsFactory 7,500Administrative offices 1,600Indirect materials used 12,000Required1. What is the total cost of Job A?2. What is the total…
A manufacturing company produces single item product. Theproduction manager decide to arrange 6 periods for MPS. Data aboutdemand forecasts are 112, 157, 126, 176, 124 and 181 while data aboutcustomer orders are 128, 156, 196, 147, 152 and 175. On hand inventoryis 300 units and production batch is 300 units. The productionmanager also decide that 3 beginning periods are critical, so that nochanges are allowed. Arrange MPS for that situation ! When system’s bottleneck requires 10 minutes to finish a unit product,make analysis about capacity. What is your suggestion? please explain it using excel or attached the excel sheet
In this problem we have a company's aggregate production planning activities: Quarter Demand Forecast 1 41,500 2 45,000 3 25,000 4 62,500 Beginning Workforce = 87 workers Production per Employee = 500 units per quarter Hiring Cost = $850 per worker Firing Cost = $1,600 per worker Inventory Carrying Cost = $8 per unit per quarter Regular Production cost = $ 4 per unit If a Level Production strategy is used, the annual inventory cost is: 14000 69000 168000 O 172000
Because of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 units
Solve the following problem with Excel Solver: (Leave no cells blank be certain to enter "0" wherever required. Do not round intermediate calculations. Round your answers to 2 decimal places.) Maximize Z= 3X+17Y 3X+8Ys 74 3X+11Y ≤ 78 Y s 35 Decision for X Decision for Y Total profit Resource A Resource B Resource C Resources Used Resource A Resource B Resource C
List the system of inequalities which describe B in the graph below.ECON1003 Mathematics for Social Sciences Unit 3_Version 1 Page 33 6. Anya’s Jeans has production process organized in threedistinct stages: cutting; sewing and finishing. She produces threetypes of jeans, namely peddle-pushers, hipsters and low cuts. Thenumber of minutes each type requires in each production processin shown below.Type Cutting Sewing FinishingPeddle-Pusher 4 6 2Hipster 6 7 4Low Rider 9 3 6On average, there are 6400 minutes of cutting time, 3500 minutes ofsewing time and 2400 minutes of finishing time each day. Given thatthe company makes $10 profit on each peddle-pusher $ 50 on eachhipster and $60 on each low cut and that the company sells all thejeans made. List the system of inequalities for the cutting, sewingand finishing constraints.
Given this information on planned and actual inputs and outputs for a service center, determinethe work backlog for each period. The beginning backlog is 12 hours of work. The figures shownare standard hours of work.PERIOD1 2 3 4 5Input Planned 24 24 24 24 20Actual 25 27 20 22 24Output Planned 24 24 24 24 23Actual 24 22 23 24 24
Briefly describe the planning techniques listed as follows, and give an advantage and disadvantagefor each:a. Spreadsheetb. Linear programmingc. Simulation
HRD System at PT. Angin Ribut wants to add a sub system to handle employee leave and overtime. The leave allowance provided by PT Angin Ribut is 12 days per year, however each year it will increase by 1 day until the maximum leave allowance reaches 20 days. Leave can be taken per half day. More than three hours will count as half a day. Overtime process is similar to leave, can be taken per half day. Every time an employee applies for leave, he must get approval from his immediate supervisor. If approved, the annual leave allowance will be reduced according to the number of days on the leave request. For each agreement on overtime, the employee's leave allowance will increase according to the number of overtime days in the employee's request. An administrator is responsible for granting leave per year. The leave allowance will be forfeited if it is not used until March of the following year, except with the approval of the President Director, the leave allowance can be extended. The…

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

Q: Given the current values for the decision variables, what's the value in cell 830 which represents the weekly payroll?