Business 2400 – Decision Modeling Report Writing - Management Assignment Help

Assignment Task:

Task:

Instructions For questions 2 to 5, you are not required to write the objective function and constraints separately from the LINGO or the Excel Solver models. Please see the detailed comments below for each of these questions.
1. (15 marks) Nancy is planning a birthday party for two friends born on the same month and day. There will be just one cake, with blue candles for Stephanie and red candles for William, one for each year. Stephanie will be 50, and William will be 52. Nancy goes to the store and finds that Type A boxes of candles sell for $7, and contain 20 blue candles and 15 red ones, while Type B boxes of candles sell for $5, and contain 6 blue candles and 11 red ones. She doesn’t want to carry more than five boxes home.
If you wish, print this page to use the graphpaper below.

(a) Defining variables X1 and X2, formulate this integer model.

(b) On a 6 by 4 graph, plot the constraints, show the feasible region for the con- straints, show all the feasible dots for integer solutions, and the trial and optimal isovalue lines. By inspection, state the optimal values for X1, X2, and compute the OFV.
2. (20 marks) A firm wishes to produce a single product at one or more locations so that the total monthly cost is minimized subject to demand being satisfied. At each location there is a fixed charge to be paid if any are produced (but is nil otherwise), and a variable cost which depends on whether the units are produced on regular time or on overtime. Each location has capacity restrictions on regular and overtime production. The relevant data are:

Plant Fixed Regular Time Overtime
Location Cost Unit Cost Capacity Unit Cost Capacity
1 2100 3.80 1200 4.60 500
2 1900 2.90 1500 4.10 600
3 2300 4.20 1800 5.60 800
4 1700 3.40 2000 4.20 550
5 2700 3.60 2900 5.10 650
6 2000 3.10 3000 4.90 900

Demand is for 8000 units per month.
(a) Write the algebraic model for this problem. You are not required to submit this part, except that the list of variables must be submitted in Word or pdf, or these must appear at the top of the file in part (b).
(b) Solve the model using LINGO or the Excel Solver.
(c) State the solution in words.
3. (20 marks) Before the COVID-19 pandemic, a beef slaughterhouse in Alberta would operate one shift per day with a 10,000 kg of product (meat) per shift capacity. Now, because of the need for physical distancing, they can process only 4000 kg of prod-uct per shift, so they are considering operating on two shifts or even three shifts per day.
They buy the cattle from nearby farms in Alberta for only $0.80 per kg of animal, but only 40% of each animal is meat, making the effective cost $0.80/0.4 = $2.00 per kg of meat. The supply per day at this price is limited to 20,000 kg of animal, or 8000 kg of meat. However, there is another 5000 kg of animal available per day from further away, but this would cost $1.00 per kg of animal because of the extra costs of shipping.

This Business 2400  Management Assignment has been solved by our Management 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.

Be it a used or new solution, the quality of the work submitted by our assignment Experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.