Question
Please assist and show the answer on excel and how you get them using solver A production scheduler must develop an aggregate plan for the
Please assist and show the answer on excel and how you get them using solver
A production scheduler must develop an aggregate plan for the next two quarters of next year. The highly automated plant produces graphics terminals for the computer products market. The company estimates that 700 terminals will need to be shipped to customers in the first quarter and 3200 in the second quarter. It takes an average of 5 hours of labour to produce each terminal and only 9 000 hours of straight labour are available. Overtime can be used, but the company has a policy of limiting the amount of overtime in each quarter to 10 percent of the straight time labour available. Labour costs R120 per hour at the straight-line rate and R180 per hour at the overtime rate. If a terminal is produced in one quarter and shipped in the next quarter, a carrying cost of R500 is incurred. The objective is to determine how many terminals should be produced on straight-line and overtime in each of first and second quarter to minimise straight-time labour, overtime labour and carrying costs.
a) Solve this model using SOLVER or LINDO.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started