# LOG307: Ding Bakery makes three different tarts from pineapple and flour: Pineapple Tarts, Pineapple Balls: Optimization and Simulation for Decision-Making Assignment, SUSS

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
Get A Free Quote

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

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?

Write My Assignment
##### Hire a Professional Essay & Assignment Writer for completing your Academic Assessments

Native Singapore Writers Team

100% Plagiarism-Free Essay
Highest Satisfaction Rate
Free Revision
On-Time Delivery

The post LOG307: Ding Bakery makes three different tarts from pineapple and flour: Pineapple Tarts, Pineapple Balls: Optimization and Simulation for Decision-Making Assignment, SUSS appeared first on Singapore Assignment Help.