Find the optimal production schedule

Assignment Help Other Subject

Reference no: EM132365599

Questions -

Q1. eGo is an electric scooter manufacturer in Texas. The plant currently employs 80 workers who operate for 22 days a month, eight hours each day. Workers are paid $12 per hour for normal working hours and $18 per hour for overtime. Overtime is limited to a maximum of 25 hours per month per employee. One worker can assemble a scooter every 12 minutes. Component costs for each scooter is $40. Carrying inventory from one month to the next incurs a cost of $5 per scooter per month. Assume the starting inventory of 24,500 units and eGo wants to end the year with the same level of inventory. eGo is making production plans for the coming year. Below table shows the forecasted monthly demand.

Month	Demand	Month	Demand
January	58,000	July	76,000
February	81,000	August	67,000
March	70,000	September	75,000
April	93,000	October	54,000
May	61,000	November	58,000
June	82,000	December	66,000

(a) Assuming no backlogs, no subcontracting, no layoffs, and no new hires, solve the aggregate planning to find the optimal production schedule. (Hint: First, formulate the problem and then use Excel Solver to find the optimal results.)

(b) Assume A third party is offering to produce scooters at a cost of $44 per unit (including the component costs). Solve the aggregate planning problem to determine how eGo should use the third party. (Hint: Reformulate the problem by adding the third party option into the model and again use Excel Solver to find the optimal results.).

Q2. Discuss how eGo can respond to predictable demand variability by managing supply and demand. (Hint: Relate to the sales and operations planning strategies in Chapter 9 of the textbook.)

Attachment:- Assignment Files.rar

Reference no: EM132365599

Questions Cloud

How would you use individual and group assessment : How would you use individual and group assessment? How would you apply assessment in a way appropriate to the development of the children.

Examine trends and issues in assessment of adult learners : Develop a one to two (1-2) page executive summary in which you describe the project's key elements and findings. (Assume this will be read by one or more.

How did your project help you find new strategies : How did your project help you find new strategies to implement as a teacher? How did it aid you in finding new resources to use as a teacher of literacy.

Why characteristics of the student population will change : How do you think the face of higher education and the characteristics of the student population will change as a result of changes in the marketplace?

Find the optimal production schedule : Assuming no backlogs, no subcontracting, no layoffs, and no new hires, solve the aggregate planning to find the optimal production schedule

How it has shaped look of your chosen type of institution : Public education in particular was affected by the influence of the first Morrill Act. For this question, reflect on influences that have shaped the growth.

How will your experience affect your willingness : Reflect on a time when you were required to work with a group on a project or to solve a problem. What was your experience? Did you enjoy working in the group?

Does use of technology help students achieve learning goals : Opinions concerning the impact of technology on teaching and learning are divided. Review the Visible Knowledge Project blog to see the results of their.

What types of learning outcomes can be achieved : Games, simulations, and virtual "worlds" provide learners with an opportunity to engage in an immersive and interactive environment that requires knowledge.

User Account

All Pages