Business Finance
OPM 352 Widener University Operation Management Tasks Calculations Worksheet

opm 352

Widener University

OPM

Question Description

Can you help me understand this Management question?

please find the attached file

all the answer must be in excel file with all the steps

Unformatted Attachment Preview

20SP OPM 352 HW Assignment 5 Total 30 pts Submit as a single Excel spreadsheet. All calculations are to be done in Excel. All work must be shown and answers to the questions must be clearly labeled on the Excel spreadsheet or no credit will be given. Problem 1 A local charity makes up food boxes for the homebound. Volunteers are only available for 4 hours a day, 2 days a week. They want to make 100 boxes each week. There are three components to making a food box: • • • Selecting the canned goods Packing the goods into the box Sealing and stacking the box Currently, they have a total of 9 volunteers, and they are distributed evenly across the tasks. - Selecting canned goods Packing goods into the box Sealing and stacking the box Time it takes a volunteer to complete the task (minutes) 12 Number available volunteers Hours Available/ # Days/Week volunteer /day 3 4 2 18 3 4 2 7 3 4 2 What is the process capacity per day given the current resource distribution? Can they meet their target of 100 boxes/week? What is the current bottleneck? If you assume that every volunteer can do every job, how would you reassign the volunteers and what is your new process capacity per day? Note: volunteers work the whole time at their activity, there are no partial volunteers. 20SP OPM 352 HW Assignment 5 Total 30 pts Submit as a single Excel spreadsheet. All calculations are to be done in Excel. All work must be shown and answers to the questions must be clearly labeled on the Excel spreadsheet or no credit will be given. Problem 2 The Amazing Shed Company produces three different kinds of sheds: The Basic, The Superior, and The Deluxe. Each of the sheds uses the same resources: Fab and Assembly Teams, Paint Teams and Inspection Teams. Information on each shed is listed below: Fab and Assembly Team Paint Team Inspection Team Basic Shed: # Hours Required (unit load) 3 Superior Shed: # Hours Required (unit load) 3.5 Deluxe Shed: # Teams # Hours Available Required (unit load) 3.7 3 # Hours Available per Team per day 7 1 1.2 1.25 1.5 2 1.5 7 6 2 2 The company has received orders for 15 Basic, 10 Superior, and 15 Deluxe sheds to be completed in one week. (Assume 5 days in the week). a) Can the company meet its order requirements and why? b) What is the bottleneck resource? c) Assume that the company makes a profit of $190 per Basic Shed, $220 per Superior Shed and $230 per Deluxe Shed. How much money is the company making per week? d) It costs the company $800 to add one team, should the company add the team? If so, where should the team be assigned? Explain. e) What is the minimum number of teams needed for each resource pool (assume partial teams are allowed and calculate to 2 decimal places) to meet the current orders? f) Using the original resource mix and the given profits per shed, which type of shed is the most profitable for the company? 20SP OPM 352 HW Assignment 5 Total 30 pts Submit as a single Excel spreadsheet. All calculations are to be done in Excel. All work must be shown and answers to the questions must be clearly labeled on the Excel spreadsheet or no credit will be given. Problem 3 A company requires an inspection team to evaluate every product produced. The team spends 1.5 hours on each product. The inspection teams can only work 6.5 hours per day on inspecting products even though the teams themselves work 8 hours a day. The 1.5-hour difference is due to additional paperwork, clean-up and meetings. a) What is the current number of products that can be handled per day per inspection team (effective capacity)? b) If all of the waste (paperwork etc.) was removed, how many products could be handled per day per team (new effective capacity)? c) What is the CWF (Capacity Waste Factor)? ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Attached.

problem 1

Time it takes a volunteer to
Number available
complete the task (minutes)(T) volunteers(N)
Selecting canned goods
Packing goods into the box
Sealing and stacking the box

a)

12
18
7

What is the process capacity per day given the current resource distribution?
minimum units per week
days per week
capacity per day

b)

3
3
3

80
2
40

Can they meet their target of 100 boxes/week?
No because the capacity produced per week is 80 units

What is the current bottleneck?

c)

boottleneck is packing goods into the box component since it has a
d)

If you assume that every volunteer can do every job, how would you reassign the volunteers a
Time it takes a
volunteer to
complete the task
(minutes)(T)
Selecting canned goods
Packing goods into the box
Sealing and stacking the box
Number available
volunteers will be assigned as follows
volunteers(N)

Selecting canned goods
Packing goods into the box
Sealing and stacking the box

problem 2

12
18
7
capacity per week
In units
3
120
4
106.66
2
137.14

Demand per week
Fab and Assembly T...

brianreyes958 (4350)
UIUC

Anonymous
I was on a very tight deadline but thanks to Studypool I was able to deliver my assignment on time.

Anonymous
The tutor was pretty knowledgeable, efficient and polite. Great service!

Anonymous
I did not know how to approach this question, Studypool helped me a lot.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
Similar Questions
Related Tags