BigEssays Logo

solve 3 problem on Excel sheet about Capacity Analysis

Hi, this question: "solve 3 problem on Excel sheet about Capacity Analysis" has been answered but we do not resell delivered works. Order your custom solution today. Get 30% discount.

Hi, the question: "solve 3 problem on Excel sheet about Capacity Analysis" has been answered previously by our writers. The full homework question is provided below for confirmation. However, the full answer delivered is not provided since, at BigEssays, we never resell answers. We maintain 100% Privacy. For a customized solution to this question, place your order now. Start with checking how much it'll cost. Get a 30% discount for this question.

Excellent
Reviews
Reviews
TrustPilot
Flawless
4.9/5
4.8/5

"At BigEssays, Your homework assignment is always in good hands."

Price Checker

Know how much it'll cost upfront.

Full Question

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

 

BigEssays Ad

Related Questions

Big Essays Order

Reveron Questions

Attached. Running Head: EMERGING CATEGORY OF CYBER THREAT EMERGING CATEGORY OF CYBER THREAT Name:Date: 1 EMERGING CATEGORY OF CYBER THREAT 2 According to Bucci, a

Full Question
Big Essays Order

Organizational Behavior

MAT 510 Strayer University The Mortgage Approval and Time Study Case study Case Study: Mortgage Approval Time StudyRead the following case study:A major financial services

Full Question
Big Essays Order

costco Assigment

Strategy Features That Differentiated BJ’s BJ’s had developed a strategy and operating model that management believed differentiated the company from Costco and Sam’s Club: Offering

Full Question

Just a Sec,

Where Should we Send your 30% Discount Code?

Just a Sec,
Not sure we are the best?

We'll Send you a 30% Discount Code to Get Started.