Reference no: EM13198702

Marty the marketing manager would like you to review one of his marketing strategies he has put together.

He is aiming at offering 'experience packages' for patients with a point of difference being the main focus. Patients will come in and be pampered and has come up with 3 packages which offer varying degrees of medical treatment. You are however a little concerned about the figures in his proposal.

The packages consist of either a luxurious, customary or standard experience. The packages use all the same equipment and cost the same to prepare but depending on the type of service there is a difference in cost. An estimated cost of each package is below including the budgeted cost limit.

	Standard	Customary	Luxurious	Available Budget
Price	$250.00	$400.00	$500.00
Direct labour	$75.00	$125.00	$200.00	$1000
Preparation	$50.00	$50.00	$50.00	$500
Clean-up	$50.00	$75.00	$75.00	$500
Variable overhead	$50.00	$100.00	$150.00	$500

Required:

a)  Formulate a linear program to determine the expected mix of medical treatments to ensure the maximum profit is obtained. Provide all workings and solve using a computer package (eg solver in excel) to generate the ideal solution.

You have reviewed Marty budget and think his figures are incorrect and the available budget for direct labour is more like $2,000.00, preparation is $1000, clean-up is $1,500 and variable overhead is more realistic at $1,750. Re-run solver to see if the outcome has changed and make comment.