Madonna's Latest Album - Optimisation & Decision Models - Business Analytics Assignment Help

Download Solution Order New Solution
Internal Code: 1ABGBA

Madonna's Latest Album  Business Analytics Assignment Help

Assignment Task:  You have been assigned to arrange the songs on the cassette version of Madonna's latest album. A cassette tape has two sides (side A and side B). The length and type of each song are given in the table below: (a) Formulate an integer linear program that determines an arrangement of the songs such that the songs on each side of the cassette total between 14 and 16 minutes in length. (b) How does the integer linear program from (a) change if each side of the cassette must have exactly two ballads? (c) How does the integer linear program from (a) change if side A of the cassette must have at least three hit songs?  (d) How does the integer linear program from (a) change if either song 5 or song 6 (but not both) must be on side A of the cassette (e) If songs 2 and 4 are both on side A, then song 5 must be on side B. How would you change the integer linear program from (a) to reflect this? SuperMalls Inc. runs a chain of shopping malls across the UK. Recently, SuperMalls has purchased a 10,000 sq ft building in central London, and the board is wondering how they should rent out space in order to maximise profits. The following table presents the different types of shops that have shown an interest in renting space at the mall, together with the required space per shop, the minimum and maximum number of each shop type that SuperMalls wants to have at the mall, as well as the anticipated profits that each shop would generate (in £1,000s). (a) Assume that SuperMalls receives a profit contribution of 3% from each shop at the mall. How many shops of each type should SuperMalls have in the mall in order to maximise its profits? Derive an Integer Program that solves the problem. Do not solve the problem! (b) Explain how to formulate the following constraints that could be added to the Integer Program in part (a):
  1. The cumulative number of clothes and shoe shops should be between1 and 3.
  1. The overall space occupied by the clothes and shoe shops should not exceed 2,000 sq ft
  1. If there is a shoe store, then there should be at least one clothing store.
(c) Consider again the problem from part (a), but assume now that the profits of each shop depend on the number of shops of that type that are present in the mall: For example, 1 department store generates £30,000 profits per year and requires 2,000 sq ft of space, whereas 2 department stores generate 2 * £25,000 profits per year and require 2 * 2,000 sq ft of space and 3 department stores generate only 3 * £20,000 profits per year while requiring 3 * 2,000 sq ft of space. How many shops of each type should SuperMalls now rent out to in order to maximise its profits? Derive a Binary Program that solves the problem. Do not solve the problem!
This Business Analytics Assignment  has been solved by our Business experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.