Overtime or SubcontractMonthDemandRegularProductionJan.Feb.MarchAprilMayJuneTotal000d. Determine the cost of the chase production plan.Total cost if workforce size adjustedTotal cost if overtime production usedTotal cost if subcontracting usedOvertime orSubcontractProductionX Answer is not complete.EndingInventory0Workers Required(4,000cases/worker)Hire0Firelayoff0 MonthJanuaryFebruaryMarchAprilMayJuneTotal DemandAverage Monthly DemandTABLE 13-4 Soda Galore Planning DataCurrent workforce6 workersAverage monthly output per worker4,000 cases per month.0.80 per case per monthInventory holding costRegular wage rateRegular production hours/month/workerOvertime wage rateHiring costSubcontracting costFiring/layoff costBeginning inventory4,000 (all safety stock)Assume that employees negotiate an increase in the regular production wage rate to $40 per hour and $60 per hour for overtime.Assume Soda Galore always plans to hold at least 4,000 cases of safety stock to meet unanticipated customer demand. Also assumethat hiring and layoff/firing, if necessary, occur at the beginning of the month.a. Using the planning information and the newly negotiated wage rates, develop a six-month production plan based on levelproduction. (Leave no cells blank - be certain to enter "0" wherever required.)ActGo toDemand Forecast16,000 cases24,000 cases32,000 cases32,000 cases24,000 cases136,000 cases264,000 cases44,000 cases$$36.00 per hour250 hours$54.00 per hour$1,000 per worker$3.20 per case$1,500 per worker

Note that, there is no information related to questions b and c, so we have answered the first…

Answered: Month January February March April May…

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

Start Time 10:30 AM 11:00 AM 12:00 PM 4:00 PM 5:00 PM 6:00 PM End Time 2:00 PM 3:00 PM 4:00 PM 8:00 PM 9:00 PM 10:30 PM Hours Worked 3.5 4 4 4 4 4.5 ● Employees Scheduled Employees Needed Surplus or (Shortage) ● Total Hours Employees 11:00 2 1 8 0 2 3 7 3 25 100.50 0 0 0 0 2 2 0 12:00 12:00 1:00 2:00 1 1 1 1 0 0 0 0 10 6 4 1 0 0 0 12 12 0 1 1 1 0 0 0 12 10 2 sing Scenario Manager 1. Create a Scenario Summary for the two options: 3:00 0 1 1 0 0 0 4:00 0 0 1 0 0 0 10 2 3 2 7 0 4:00 5:00 0 0 0 1 0 0 3 9. Keep the Solver Solution by generating an Answer Report. This w sheet titled Answer Report 2 Rename the sheet to Option 2 and chang Green. 3 0 a. Name the first scenario as Option 1. b. Use D4:D9 as the changing cells. c. Do not change the values in Scenario Values fields. d. Click OK 6: e. Add another scenario. f. Name it Option 2. g. Use D4:D9 as the changing cells. h. Use the following values for each of the respective fields: • 2 8 2 3 . 7 3 i. Click OK j. Select Option 1 and click…
Resource Allocation Your salami manufacturing plant can order up to 1,000 pounds of pork and 2,400 pounds of beef per day for use in manufacturing its two specialties: Count Dracula Salami and Frankenstein Sausage. Production of the Count Dracula variety requires 1 pound of pork and 3 pounds of beef for each salami, while the Frankenstein variety requires 2 pounds of pork and 2 pounds of beef for every sausage. In view of your heavy investment in advertising Count Dracula Salami, you have decided that at least one third of the total production should be Count Dracula. On the other hand, because of the health-conscious consumer climate, your Frankenstein Sausage (sold as having less beef) is earning your company a profit of $5 per sausage, while sales of the Count Dracula variety are down and it is earning your company only $1 per salami. Given these restrictions, how many of each kind of sausage should you produce to maximize profits, and what is the maximum possible profit (in…
It takes a lawyer 120 minutes to serve one customer. Demand is 2 customers per 6-hour day. The lawyer has a wage rate of $150 per hour. a. What is the cost of direct labor for the lawyer expressed in $ per customer? 800 8 per customer b. What is the labor utilization of the lawyer? (Enter your answer as a decimal between O and 1 (not a percentage) rounded to 2 decimal places.) 66.67 %24
Which of the following relates to How many employees should be scheduled? 1.Group of answer choices 2.Operations Planning 3.Operations Process 4.Capacity Planning 5.Production-Method Decisions
There are many factors that can affect the demand for labor. All of them EXCEPT? A. Extracurricular labor cost B. Productivity of the chosen labor C. The number of recruitment D. The age distribution of the labor market
Manpower demand forecasting is influenced primarily by two important factors that is volume of output and level of productivity. Explain it in 1000 words.
Which among the following refers to chase method? Stable output rates and workforce Worker levels and production output are stable The cost of adjusting output rates and/or workforce levels Tends to be the preferred strategy of many organizations, including labor unions.
A new start-up company is conducting a SOP meeting in order to "plan ahead" to effectively address the seasonal variation appearing in the annual demand of its products. Pedro, the planning manager is considering to use a planning horizon of 6 months and utilize the following information: Demand Forecast No. of Working Days Month January 1,800 22 February 1,500 19 March 1,100 21 April 900 21 May 1,100 22 June 1,600 20 Cost Breakdown Cost (Php) Material 100 per unit Inventory Holding 5 per unit per month Marginal Stock-out 10 per unit per month Marginal Cost of Subcontracting* 20 per unit 1,000 per worker Hiring and Training Layoff 1,500 per worker Regular Labor Cost per Hour Overtime Labor Cost per Hour *Cost of buying less material costs 15 per worker per hour 20 per worker per hour Starting and Operating Conditions Current Inventory 400 units Current Workforce 38 workers Labor Hours per Unit 5 worker-hours / unit Regular Labor Time per Employee per Day 8 hours Inventory at the End of…
Creating detailed schedules and operating plans on a short term basis is the responsibility of which type of manager Question 6 options: front line middle top team leaders
The following data relato to direct labor information for product C for the month of Octobor is as follows: Standard rato PO.10 por hour Actual rato paid P6.00 por hour Standard hours allowed for actual production 1500 hours Labor Efficioncy Variance P600 unfavorable What is the actuol hours workod? Solect one A 1400 RL600 C1402 Fir D 1508 Tim
i want the sol
20:02 O 49 ll 82%i Q. Jack is concemed about his company's corporate image and has decided against using hires and fires, Instead, he has asked you to consider a chase aggregate plan using the current workforce supplemented by either overtime or undertime demand exactly. He has asked for the following information from you: change capacity to match (a) How many production hours would be required each period to produce the exact quantity needed? (b) How many regular-time production hours are available each period? (c) How many overtime production hours would be needed each period? (d) Show what would happen if this plan were implemented. (e) Calculate the costs associated with this plan. (f) Evaluate the plan in terms of cost, customer service, operations, and human resources. (g) Compare this chase strategy with level strategy and conclude which is better. ?

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