Design an assembly line to manufacture cupcakes from scratch. - Assume the bakery operates for 1 eight-hour shift per day. - Assume a unit is equal to 1 dozen cupcakes and 40 units/day are required Balance the assembly line. Measure the efficiency Assignment format: The best way to do this is in Excel. You can use cell borders and insert shapes to build the assembly line. Use the math functions in Excel to balance your line and calculate efficiencies.

Design an assembly line to manufacture cupcakes from scratch. - Assume the bakery operates for 1 eight-hour shift per day. - Assume a unit is equal to 1 dozen cupcakes and 40 units/day are required Balance the assembly line. Measure the efficiency Assignment format: The best way to do this is in Excel. You can use cell borders and insert shapes to build the assembly line. Use the math functions in Excel to balance your line and calculate efficiencies.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section: Chapter Questions

Problem 111P

See similar textbooks

Similar questions

Operations Management Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Do not provide Excel Screet shot rather use tool table Answer completely.
Williams Performance Co. manufactures sports cars. After making a sale, the salesperson sends thecar to be detailed before the customer takes it home. Detailing the car takes 30 minutes at a cost of$15 per hour for direct labor and $5 per car for materials. If the company is open 5 days per week andsells an average of five cars per day, what is the average cost per 5-day week for detailing cars?
1) Create a business scenario/description. 2) Based on the business description created, construct an Order Processing flow chart that is appropriate for the business.
The following diagram shows the flow process, raw material costs, and machine processing time for three products: A, B, and C. There are three machines (W, X, and Y) used in the production of these products; the times shown are in required minutes of production per unit. Raw material costs are shown in cost per unit of product. The market will take all that can be produced. %media:version_20.jpg% a. Assuming that sales personnel are paid on a commission basis, which product should they sell? O Product A O Product B O Product C b. On the basis of maximizing gross profit per unit, which product should be sold? O Product B O Product A O Product C c. To maximize total profit for the firm, which product should be sold? K Prev 2 of 7 Next >
Explain the following with example. If diagram required mention it for better understanding Earned Value Management Accounting vs Controlling
Please ignore diagram in the picture. The focus is on filling out the table based on information provided in bold text. You have an upstream department that feeds two downstream packing departments: Pack Singles and Pack Multis. Those Packing departments feed a Shipping department that loads the outbound truck. 40% of your Pick volume goes to Pack Singles and has a packing rate 171 units per labor hour. 70% of the Pick volume goes to Pack multis and has a pack rate rate of 266 units per labor hour. Your pickers pick both single and multis items all day at an overall average rate of 114 units per labor hour. All units process go through the ship process at a rate of 570 units per hour. If you have 102 people and must pack 47,880 ints in pack multis over a 10 hour shift, fill out table below: Department % Volume Rate Daily volume Number of people Pick Pack single 12 Pack multus Ship
The following diagram shows the flow process. Raw material cost, and machine processing time for three products: A, B, and C. There are three machines (W, X and Y) used in the production of these products; the times shown are in required minutes of production per unit. Raw material costs are shown in cost per unit of product. The market will take all that can be produced. Selling price A B C $ 55 $60 $ 75 $ 10----Y (2 min) $10---Y (5 min) $10---X (4 min) $ 15---W (3 min) $20---X (5 min) $15---Y (4 min) $ 15---X (2 min) $15—W (6 min) $ 30—W (6 min) Assuming that sales personnel are paid on a commission basis, which product should sell? A, B or C? On the basis of maximizing gross profits per unit, which product should be sold? A, B, or C 3.To maximize total profit for the firm, which…
A TV factory plans to add production lines for its new product and plans to produce as many as 200 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. What is the cycle time for the production of the new product? (note: in seconds)b. What is the minimum number of workstations?
A TV factory plans to add production lines for its new product and plans to produce as many as 800 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. What is the cycle time for the production of the new product? (note: in seconds)b. What is the minimum number of workstations?c. Draw a diagram of the production process.d. With the diagram that you have described above, can the production process run properly according to the plan? Explain the process of each workstation that you have created!.
A TV factory plans to add production lines for its new product and plans to produce as many as 800 units per hour. The production process, production time, and the production process to continue the next production process are described in the table below: (1 day = 8 working hours) Production Process Production Time (s) The production process that follows the next production according to the list below A 12 - B 15 A C 8 A D 5 B,C E 20 D Based on the data above. a. Draw a diagram of the production process.b. With the diagram that you have described above, can the production process run properly according to the plan? Explain the process of each workstation that you have created!.
Note: Use manual computation not in excel.
Dave Grubbs of Grubbs Auto Body has ﬁve cars waiting for Economy Detailing. An Economy Detailing consists of a wash and then a hand wax. Cars cannot be waxed until they are washed. ROUND UP (39/5) & (39/10). Wash (hours) Wax (hours) (J)aguar 39/5 5 (C)adillac 5 3 (F)ord 1 39/10 (H)onda 2 1 (L)exus 4 4 What schedule produces the shortest time span in which these orders can be completed? Sequence: ____ , _____ , _____ , ______ , ______ Create a Gantt chart for the optimal sequence (shortest time span). How many hours does it take to complete the ﬁve orders? For the schedule in question “a”, how many hours is the waxing task idle? When will Dave ﬁnish the Cadillac? What is the average order completion time?