Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q1. TonTon Company manufactures two types of products: type A and type B. The labor and raw material requirements as well as profit for each

image text in transcribed
Q1. TonTon Company manufactures two types of products: type A and type B. The labor and raw material requirements as well as profit for each product are provided in the following table. Profit ($) Product Type A Product Type B Availability (per month) Labor Hour 2 4 800 Raw material 1 (kg) 8 10 no limit Raw material 2 (kg) 4 3 500 2 It is assumed that the amount of products can have fractional values. In order to determine the amount of products that will be produced, Ton Ton has set the following goals. The first goal is the most important goal Goal 2 is considered to be 0.8 times as important as the Goal 1, while Goal 3 is considered to be half as important as the first goal. Goal 1: The monthly profit should be at least $170. Goal 2: No more than 1,000 kgs of raw material 1 should be used per month. Goal 3: At least 55 units of type A should be produced. Formulate this goal programming problem and provide the Excel solution. Q1. TonTon Company manufactures two types of products: type A and type B. The labor and raw material requirements as well as profit for each product are provided in the following table. Profit ($) Product Type A Product Type B Availability (per month) Labor Hour 2 4 800 Raw material 1 (kg) 8 10 no limit Raw material 2 (kg) 4 3 500 2 It is assumed that the amount of products can have fractional values. In order to determine the amount of products that will be produced, Ton Ton has set the following goals. The first goal is the most important goal Goal 2 is considered to be 0.8 times as important as the Goal 1, while Goal 3 is considered to be half as important as the first goal. Goal 1: The monthly profit should be at least $170. Goal 2: No more than 1,000 kgs of raw material 1 should be used per month. Goal 3: At least 55 units of type A should be produced. Formulate this goal programming problem and provide the Excel solution

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

Step: 3

blur-text-image

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

Guide To Audit Data Analytics

Authors: AICPA

1st Edition

1945498641, 978-1945498640

More Books

Students also viewed these Accounting questions

Question

The company has fair promotion/advancement policies.

Answered: 1 week ago