Ga Manufactures Packing Machine Order Cutting Welding Assembly Painting Model Q300 Generat Q35533934

GA manufactures packing machine in order ofcutting-welding-assembly-painting. The model Q300 will generate anet profit of $ 30,000 per unit and the model Q250 will generate anet profit of $ 25,000 per unit. The time required to produce onemachine is shown in the following table. Cutting – Welding -Assembly – Painting process can be put into work for 240 hours, 200hours, 240 hours and 200 hours for 1 week respectively.

Time required for each process (hr)

Meanwhile, the production engineering department has recentlydeveloped a strong adhesive from a German laboratory. Using thisadhesive, welding and assembly operations can be completed in 1hour each, regardless of product model. The model Q300 uses 6pounds of adhesive when used in the welding process and 3 pounds ofadhesive in the assembly process. The model Q250 uses 8 pounds forthe welding process and 6 pounds for the assembly process whenusing the adhesive.

Since the welding process and the assembly process areindependent of each other, the use of the adhesive can beindependently applied to each process, and a product model can beproduced partially using an adhesive, or a part thereof can beproduced according to a conventional method. However, when usingadhesives, the cost of purchasing adhesives must be deducted fromthe sales net profit per product. Buying glue costs $ 0.2 thousanda pound.

Adhesive Usage (pound/1unit)

1. Calculate the optimal production schedule and total salesrevenue when no adhesive is used
2. Set up an optimal production plan when operating the process bymixing the existing method with adhesive use and calculate thetotal sales profit.

• Find answers using Excel Solver.

Located near HC University, Cocos is a restaurant serving avariety of western meals. In Cocos there are two current /full-time employees, all of whom work four hours from 11:00 am,then rest for one hour and again for four hours. All otheremployees work four hours from 1:00 pm and then rest for one hourand again for four hours. For busy hours, use a 4-hour part-timeworker, Saturday is the busiest day, and Saturday from 11:00 am to10:00 pm.

To minimize the expenditure of wages, but to maintain the bestservice for the customer, we plan to hire and schedule 4 hourshifts of part-time employees. The hourly wage for part-timeemployees is 6,000 won. The table below shows the number ofemployees (including all staff and part-time employees) required bySaturday’s time zone in Cocos.

Number of employees required per hour

(a) Set up a minimum-cost part-time worker’s employment andscheduling. What is the total wage of part-time employees? How many(alternate) part-time employees are needed? Also, is there anystaff that will remain in the time zone?

(b) It is assumed that a part-time employee can choose to workbetween 3 hours or 4 hours. So what about the minimum cost ofpart-time staffing and scheduling? How many (alternate) part-timeemployees are needed? How much is the cost advantage over theprevious one?

• Find answers using Excel Solver.