Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Management

Authors: Richard L. Daft, Dorothy Marcic

10th edition

1305887093, 1305502213, 9781305887091, 978-1305502215

More Books

Students also viewed these General Management questions

Question

Hello using gririth third edition chapter 6 please help

Answered: 1 week ago

Question

Hello using grifth edition three chapter 6

Answered: 1 week ago

Question

Py:- verify that: (s) - 0 RGJ R (2) = O -S S 1 es

Answered: 1 week ago