I am having trouble answering question 4. Here is the data and the question. Can you hep me in any way possible? Cost dataRegular-time labor cost per hourOvertime labor cost per hourSubcontracting cost per unit (labor only)Holding cost per unit per periodBack-order cost per unit per periodHiring cost per employeeFiring cost per employeeCapacity dataBeginning workforceBeginning inventoryLabor standard per unitRegular time available per periodOvertime available per periodSubcontracting maximum per periodSubcontracting minimum per periodDemand dataPeriod 1Period 2Period 3Period 4Problem DataPeriod 5Period 6 labint bogATAK5500 units4600 units7600 units5800 units6560 units4000 units$12.00$16.00$75.00$8.00$15.00$500.00$350.00210 employees400 units6 hours160 hours30 hours1000 units500 unitsbrzdyda qolave 3. Although the BackPack Company has always used a level aggre-gate plan, Tameka is interested in evaluating chase aggregate plansalso. She has asked you to calculate how many hires and fires wouldbe necessary to adjust capacity to meet demand exactly each period.If necessary, incur some undertime. Calculate the number of workersneeded each period.4. Now that you have calculated the number of workers needed eachperiod in Problem 3, Tameka wants to see how the plan would actu-ally work. You need to:a. Show what would happen if this plan were implemented.b. Calculate the costs associated with this plan.c. Evaluate the plan in terms of cost, customer service, opera-tions, and human resources.

Chase plan refers to the plan in which the number of workers/employees are hired and fired to…

3. Although the BackPack Company has always used a level aggre- gate plan, Tameka is interested in evaluating chase aggregate plans also. She has asked you to calculate how many hires and fires would be necessary to adjust capacity to meet demand exactly each period. If necessary, incur sonte undertime. Calculate the number of workers needed each period. 4. Now that you have calculated the number of workers needed each period in Problem 3, Tameka wants to see how the plan would actu- ally work. You need to: a. Show what would happen if this plan were implemented. b. Calculate the costs associated with this plan. c. Evaluate the plan in terms of cost, customer service, opera- tions, and human resources.

3. Although the BackPack Company has always used a level aggre- gate plan, Tameka is interested in evaluating chase aggregate plans also. She has asked you to calculate how many hires and fires would be necessary to adjust capacity to meet demand exactly each period. If necessary, incur sonte undertime. Calculate the number of workers needed each period. 4. Now that you have calculated the number of workers needed each period in Problem 3, Tameka wants to see how the plan would actu- ally work. You need to: a. Show what would happen if this plan were implemented. b. Calculate the costs associated with this plan. c. Evaluate the plan in terms of cost, customer service, opera- tions, and human resources.

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

I just joined a manufacturing firm producing bath soap and washing powder, The company set up a department to deal with stock control. My supervisor asked me to narrate the functions of the stock controller. What would I tell him
You manage the chemical stockroom at Enterprise Pharmaceuticals. Chemicals are purchased and storedcentrally. Departments are billed for whatever they use. It is your job to tell employees that on the first ofnext month the weekday stockroom hours will change from 1-3 p.m. to 9-11 a.m. Most of Enterprise’sshipments during the week arrive in the afternoon, and shifting the stockroom hours will allow your staff todo an inventory and shelve new stock without interruption. You’re willing to fill weekday requests thatarrive in the afternoon, but a 15 percent markup will be added.The stockroom will also be adjusting its weekend hours; so beginning on the first of next month, Saturdayorders will only be filled between the hours of 8 a.m. and 12 p.m. The stockroom will be closed Saturdayafternoons and Sundays.You should send “courtesy copies” (CC:) to your fellow department managers as well as Tim Johnson, Vice President of Enterprise Pharmaceuticals. Answer the following questions also: Who…
Imagine that you are the chief operations officer (COO) of Amazon.com. You are interested in creating a competitive advantage for your company (compared to other online retailers) in that you wish to be able to provide to your customers faster shipping than you have been able to provide with your existing set of warehouses and fulfillment centers. It has been decided that using overnight shipping on every order (which would, of course, be about as quick as shipping could be) has been eliminated as a possibility due to being prohibitively expensive. Describe what you would recommend as the COO to improve the speed with which Amazon.com customers receive the products that they have ordered. What negative consequences or disadvantages, if any, do you see as a result of your proposed solution?
"MacGyver Corporation manufactures a product called Miracle Goo, which comes in handy for just about anything. The thick tarry substance is sold in six-gallon drums. Two raw materials are used; these are referred to by people in the business as A and B. Two types of labor are required also. These are mixers (labor class I) and packers (labor class II). You were recently hired by the company president, Pete Thorn, to be the controller. You soon learned that MacGyver uses a standard-costing system. Vari-ances are computed and closed into Cost of Goods Sold monthly. After your first month on the job, you gathered the necessary data to compute the month’s variances for direct material and direct labor. You finished everything up by 5:00 p.m. on the 31st, including the credit to Cost of Goods Sold for the sum of the variances. You decided to take all your notes home to review them prior to your formal presenta-tion to Thorn first thing in the morning. As an afterthought, you…
The following are examples of fixed expense except: a.) staff travel b.) promotion c.) speaker fees d.) food and beverage
I need correct and non plagiarised answer. I will rate accordingly. What is the difference between Quantity Production and Flow Line Production?
Explain the following in respect of the Inventory: a) Characteristics b) Need
The spreadsheet model for Sam’s Bookstore containsa two-way data table for profit versus order quantityand demand. Experiment with Excel’s chart types tocreate a chart that shows this information graphicallyin an intuitive format. (Choose the format you wouldchoose to give a presentation to your boss.)
The number of times during an operating period that the average inventory was sold. O a. inventory turnover O b. return on investment O c. debt-to-assets ratio O d. working capital
Please do not give solution in image format thanku Outsourcing has become the major trend in operations management. (a) Explain what is outsourcing and discuss which activities firms can outsource and those which firms should not outsource. (b) Discuss why should firms should control outsourced activities.
A _______ analysis can aid in spotting prospective dangers and difficulties and in creating backup strategies to reduce these risks. Question 10 options: financial SWOT periodic district
Senior management is also considering residual income as a performance measure. Comment on the performance on the two divisions based on residual income. (Word limit: 50 exclude supporting computations)