Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

PBA4804 Decision Support Systems For Managers

tag 0 Download 3 Pages / 632 Words tag 13-07-2021

Question:

The Delux Nut Company produces a deluxe mix composed of almonds, cashews, peanuts and walnuts.The deluxe mix must contain at least 10% of each kind of nut. At least half of the mix must be composed of almonds and cashews and it can contain at most 20% peanuts. The company also produces a companion mix composed of cashews, walnuts and raisins. This mix must contain at least 10% cashews, at least 30% walnuts, and between 20% and 40% raisins. Raisins are available in unlimited supply at a purchasing cost of R3,60 per kilogram. The quantities of nuts available and the purchasing costs in rand per kilogram are as follows:

Both mixes are sold in 100 g packages. The company must produce at least 4 000 packages of the deluxe mix and at least 5 000 packages of the companion mix.
(a) Formulate an LP model for this problem. 
(b) Solved the LP using LINGO or SOLVER 
(c) Write down the optimal purchasing plan and the associated purchasing costs.
(d) The suppliers inform the company that the availability of almonds has been reduced to 200 kg and that of peanuts to 100 kg. How will this influence the optimal plan and purchasing costs Give reasons for your answer. 
(e) An extra 50 kg of walnuts can be bought at R11,00 per kg. Would you make use of this offer Give reasons for your answer.

(f) Assume that the optimal plan is obtained from the original available quantities of nuts. The company now decides that it must produce at least 4 500 packages of the deluxe mix. Will the total purchasing costs be influenced? Give reasons for your answer.
(e) The supplier of peanuts announces a 40% increase in price. What will the effect of this be? Give reasons for your answer.

The Bloom & Blossom Company wants to expand its activities. In the next few years a number of large capital amounts will become untied, and they wish to plough these back into the company. The amounts that will become available at the beginning of each year are given in the following table:
 Year Amount
1 R150 000
2 R135 000
3 R210 000
4 R120 000
5 R 90 000

Four projects are being considered. The capital needed per year for each project (in R1 000) and the present value of the net return (in R1 000) on each project are given in the table below.
Capital needed Net
Project 1 2 3 4 5 return
1. Expand plant in Alberton 30 60 81 60 30 240
2. Build new plant in Port Elizabeth 60 30 120 60 60 300
3. Enlarge small machine capacity in Rosslyn 30 15 60 30 0 120
4. Enlarge large machine capacity in Rosslyn 90 60 30 30 30 210.

If a project is selected, it has to be completed as a whole. Money not used can be invested at 12% per annum for a year. Bloom & Blossom wants to select one or more of the projects in such a way that the net return on the chosen projects will be a maximum. Formulate the problem as linear integer programming model. Do not solve the model!
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 3 pages

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). PBA4804 Decision Support Systems For Managers. Retrieved from https://myassignmenthelp.com/free-samples/pba4804-decision-support-systems-for-managers/cashew-and-raisins.html.

"PBA4804 Decision Support Systems For Managers." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/pba4804-decision-support-systems-for-managers/cashew-and-raisins.html.

My Assignment Help (2021) PBA4804 Decision Support Systems For Managers [Online]. Available from: https://myassignmenthelp.com/free-samples/pba4804-decision-support-systems-for-managers/cashew-and-raisins.html
[Accessed 02 February 2023].

My Assignment Help. 'PBA4804 Decision Support Systems For Managers' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/pba4804-decision-support-systems-for-managers/cashew-and-raisins.html> accessed 02 February 2023.

My Assignment Help. PBA4804 Decision Support Systems For Managers [Internet]. My Assignment Help. 2021 [cited 02 February 2023]. Available from: https://myassignmenthelp.com/free-samples/pba4804-decision-support-systems-for-managers/cashew-and-raisins.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.