Question: Question 1: (6 points) Calculate the workload for each workstation. The time to produce a product in a workstation is: The quantity to produce multiplied

Question 1: (6 points) Calculate the workload for each workstation. The time to produce a product in a workstation is: The quantity to produce multiplied by the execution time found in the operation of the corresponding routing. Do it just using formulas (3 points) and do the same work but using at least one pivot table (3 points). Bonus (1 point): The time unit is the second. Give the workload for each workstation in hours and minutes (i.e. 10h 36 minutes). if the workload exceeds a certain user-defined threshold, the workstation should appear highlighted

Execution time/Unit Quantity to produce 100 30 12 50 Product Product 1 Product 2 Product 3 Product 4 Product 5 Routing Routing 1 Routing 2 Routing 3 Routing 4 Routing 5 Product Product 1 Product 2 Product 3 Product 4 Product 5 10 80 20 100 120 10 12 18 35 5 Routing Routing 1 Routing 1 Routing 1 Routing 1 Routing 2 Routing 2 Routing 2 Routing 3 Routing 3 Routing 3 Routing 3 Routing 4 Routing 4 Routing 4 Routing 4 Routing 4 Routing 5 Routing 5 Routing 5 Operation Worcenter Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 10 workstation 2 Op 20 workstation 3 Op 30 workstation 4 Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 50 workstation 5 Op 10 workstation 2 Op 20 workstation 3 Op 30 workstation 4 8 25 28 2 5 25 90 9 6 16 Each product has a routing Each routing has different operations Each operation needs a workstation during the execution time Today we have to plan the quantity to produce of the 5 products. Execution time/Unit Quantity to produce 100 30 12 50 Product Product 1 Product 2 Product 3 Product 4 Product 5 Routing Routing 1 Routing 2 Routing 3 Routing 4 Routing 5 Product Product 1 Product 2 Product 3 Product 4 Product 5 10 80 20 100 120 10 12 18 35 5 Routing Routing 1 Routing 1 Routing 1 Routing 1 Routing 2 Routing 2 Routing 2 Routing 3 Routing 3 Routing 3 Routing 3 Routing 4 Routing 4 Routing 4 Routing 4 Routing 4 Routing 5 Routing 5 Routing 5 Operation Worcenter Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 10 workstation 2 Op 20 workstation 3 Op 30 workstation 4 Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 10 workstation 1 Op 20 workstation 2 Op 30 workstation 3 Op 40 workstation 4 Op 50 workstation 5 Op 10 workstation 2 Op 20 workstation 3 Op 30 workstation 4 8 25 28 2 5 25 90 9 6 16 Each product has a routing Each routing has different operations Each operation needs a workstation during the execution time Today we have to plan the quantity to produce of the 5 products

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I am looking for some help on finding the answers for these. Thank you! M2 Group Assignment Instructions Complete the Assignment, name it as GroupXX_Assign2.xls (where XX is your Group Name), and...

Mail - Suare X Central Pipe X Content X Content X Bb Microsoft W X Course Her( X Logout | Lib x reading resp x reading resp x how to scre X C ccsu.blackboard.com/ultra/courses/_69519_1/cl/outline OK...

Final_Exam_Macro Question 1 (2 points) Purchasing-power panty theory does not hold at all times because many goods are not easily transported and the same goods produced in different countries may be...

PLS HELP ME 6. (4p) Consider a Heckscher-Ohlin model with two countries, Home and Foreign, and two factors of production, land (T) and labor (L). Land and labor are used to produce two goods, gadgets...

QUESTION 1 1 points Save Answer 2.50 2.00- 1.50 Quantity 20 Refer to the market graph shown above. A black market where the price is $2.00 could result from a price ceiling set at $1.50 O floor set...

Q1. The Learning Activity titled "The Production Possibilities Curve" explains concepts that relate the production possibilities curve to scarcity and opportunity cost. Look at Figure 1.3 and select...

QUESTION 1 2 points Save A company manufactures three models of TV's. Below are the relevant details: Space required Model Yearly for Number of No of Operations Processing time per of TV Production...

Workstation Capacity (mins) Aggregate Workload D 2,400 Workstation Processing Time Requirements, Per Unit of Product Product A B D V 30 5 5 15 5 Time required on each w 5 5 10 15 workstation (minutes...

Please help me with the following questions. you are required to submit supporting calculations on all questions that require calculations. Some questions do not require calculations. If a question...

A [100 Marks] Answer ALL questions in this section. Question 1 (6 Marks) Entity Z is trying to obtain a cost estimate for the costs of repairs. The following monthly repair costs have been recorded...

In a typical month, the Any Day Corporation receives 100 checks totaling $67,000. These are delayed three days on average. What is the average daily float?

Prove that: X 3x sin 3x +sin 2x -sin x = 4 sin x cos -Cos 2 2

Question Content Area In which type of corporate reorganization do shareholders receive stock in at least two other corporations in exchange for all the stock in the original corporation? a . "Type D...

Hem 1 2020/2021 (page 32 of 34) Uniten Software Testing S1 2020/2021 Identify the suitable tool to be used for the following statements: 1. Due to the complexity and high number of requirements, the...