Project #8163 - Quantitative Analysis

Given:

Company A produces and sells a popular pet food product packaged under two brand names, with formulas that contain different proportions of the same ingredients. Company A made this decision so that their national branded product would be differentiated from the private label product. Some product is sold under the company’s nationally advertised brand (Brand X), while the re-proportioned formula is packaged under a private label (Brand Y) and is sold to chain stores.

Because of volume discounts and other stipulations in the sales agreements, the contribution to profit from the Brand Y product sold to distributors under the company’s private brand is only $12.50 per case compared to $100 per case for national label product Brand X.

There are four ingredients involved in this problem. The recipes specifying the use of each ingredient in the two product brands are given in the template. Also note, an ingredient may either be in limited supply or may have government regulations requiring a minimum or maximum amount of an ingredient.

Task:

 

Note: Macros must be enabled to open and use the Simulation Template spreadsheet.

 

A. Set up the system of four constraints that are plotted, as shown on the graph in the attached “Simulation Template, showing all work necessary to arrive at the equations.

 

1. Explain why each constraint is a minimum or a maximum constraint.

 

2. Identify the objective function.

 

 

 

B. Determine the profit if the company produces a combination of cases of Brand X and Brand Y that lies on the black-dashed objective function line (profit line) as shown on the graph in the attached “Simulation Template”.

 

 

 

C. Determine optimum production with the greatest amount of profit by doing the following:

 

1. Determine how many cases of Brand X should be produced during each production period, showing all your work.

 

2. Determine how many cases of Brand Y should be produced during each production period, showing all your work.

 

3. Explain how the feasible region of the provided graph was used to arrive at your calculations for parts C1 and C2.

 

 

 

Note: Partial cases are allowed as part of the solution.

 

 

 

D. Determine the total contribution to profit that would be generated by the production levels you gave in parts C1 and C2, showing all of your work.


 

PLEASE NOTE THAT ALL WORK MUST BE SHOWN AS INDICATED ON THE ASSIGNMENT

Subject Mathematics
Due By (Pacific Time) 06/23/2013 02:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy