University | Singapore University of Social Science (SUSS) |
Subject | LOG307: Optimization and Simulation for Decision-Making Assignment |
LOG307: Optimization and Simulation for Decision-Making Assignment, SUSS, Singapore: Ding Bakery makes three different tarts from pineapple and flour: Pineapple Tarts, Pineapple Balls
Question 1
Ding Bakery makes three different tarts from pineapple and flour: Pineapple Tarts, Pineapple Balls, and Nyonya Pineapple Tarts. The demand forecast for next week, percentages of pineapple and flour, and net profit for each product are shown in the following table.
Stuck with a lot of homework assignments and feeling stressed ?
Take professional academic assistance & Get 100% Plagiarism free papers
Ding Bakery has 620 kilograms of pineapple and 510 kilograms of flour for use next week. These products are made using three different machines. The availability of the machines next week is as follows: 35 hrs for Machine I, 32 hrs for Machine II, and 38 hrs for Machine III. The following table summarises the time required by each product on each machine.
Assume you have been tasked to find the production plan that maximises the total profit.
Question 1a
Formulate an LP model for this problem.
Question 1b
Set up a spreadsheet model for this problem.
Determine the optimal solution using the Solver. Comment on your results.
Question 1c
If you want to change the production of any product, which one would you recommend and why?
Hire a Professional Essay & Assignment Writer for completing your Academic Assessments
Need assistance with LOG307 assignments? Look no further. Our Do My Assignment Singapore service is here to help. With our dedicated team of experts and reliable online assignment help, Singapore students can rest assured that their assignments are in capable hands, allowing them to focus on mastering optimization and simulation for decision-making.
Tags:-
- Imagine that you are currently working for a precision medicine startup: Machine Learning Paper Review in Precision Medicine, Written Assignment 1, NUS, Singapore
- Go Business offers PSG solutions for enterprises in Singapore: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Design an ontology based on- Accidents can be categorised as chemical, electrical, fire, kinetic or liquid: Collective Intelligence and Entrepreneurship, Assignment 1, JCU, Singapore
- Project Control Monitoring, Assignment, HU, Singapore: Deliberate Project MONITORING AND CONTROL or PMC Identification
- DSM500: Final Project Report, Coursework 2, UOL, Singapore
- DSM080: Financial Markets, Assignment, UOL, Singapore: A grapefruit juice futures contract is for 15,000 pounds of frozen grapefruit juice
- DSM080: Financial Markets, Assignment, UOL, Singapore: The share price of a certain stock today is $42.50, and five-month European style call options with a strike price of $45 currently sell for $4.25.
- DSM080: Financial Markets, Assignment, UOL, Singapore: A trader who is working in the gold markets is able to borrow money at the interest rate of 7% per annum
- DSM080 Financial Markets, Assignment, UOL, Singapore: A dollar-based American corporation has decided that it will have to pay 6 million UK pounds in three months
- Principle of Finance Assignment, UCD, Singapore: National Gaming Inc. (National) operates the weekly lottery in the country
UP TO 15 % DISCOUNT