Hello, I have a homework problem that requires the use of Excel Solver. I am uns
ID: 371412 • Letter: H
Question
Hello, I have a homework problem that requires the use of Excel Solver. I am unsure of how to solve the problem, please help me. In addition, please show me the information used for the "set objective", "changing variable cells" and "constraints" used in the Excel Solver.
Using the data from the chart, complete the dorian model below, also add the integer constraints, which are: “CompactCar, MidsizeCar, LargeCar, MidsizeVan, LargeVan” in the excel solver.
Data
Vehicle Type Compact Car Midsize Car Large Car Midsize Minivan Large Minivan
Steel (tons)/unit 1.5 3 5 6 8
Labor hours/unit 30 25 40 45 55
Minimum production (if any) 1000 1000 1000 200 200
Profit contribution/unit $2,000 $2,500 $3,000 $5,500 $7,000
Dorian Auto production model
Labor hours/unit 30 25 40 45 55
Minimum production (if any) 1000 1000 1000 200 200
Profit contribution/unit $2,000 $2,500 $3,000 $5,500 $7,000
Explanation / Answer
1. Does your selected business have differentiated products or services? If so, what is the basis for this differentiation from the competition?
Yes, they have unique product, it is differentiated through processing of meats and quicker delivery services . This is realized due to its
.Processing plants
.Volume of supply capability
.Great supply chain network
It produces several different products, like Buffalo wings, boneless Buffalo wings and is an innovator in the industry.
2. Does your firm have a cost-leadership position in this business? If so, can you identify which cost drivers it uses effectively to hold this position?
They do not have acost-leadership position, but are differentiated due to their range of products, service and volume of operations.
And it has its own chicke and meat producers, to facilitate the volume business, without being a cost leader.
3. What is your firm’s approach to the market? If it segments the market, identify the scope of competition it is using.
It does not segment its market. It works on B2B business, and approaches the blanket way.It supplies products to each type of food outlets, and generally depends on the large contracts and partnerships.
They supply to all type of restaurants.
They sell at supermarkets.
It supplies to Prisons as well.
So by ditributing to multiple channels they target a large spectru of markets, though there is partnerships based on segments its mostly to most frequented restaurant chains.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.