Premium Essay

Scm 4380

In:

Submitted By elrinanguyen
Words 4877
Pages 20
Business Strategy Management Explanation

[Instructions for using this document: Keep the bold section headings in place. Provide the requested information and answer the corresponding questions. Your team should answer each question as thoroughly as possible, giving the instructor insight into how your team arrived at its management decisions. The tone of your writing should be as if you are justifying your management decisions to your boss for leading a start-up company.]

Company Code: TT

Team Member Names (Alphabetical by Last name):
Jonathan Anzures
Briana Lee
Elrina Nguyen
Inga Vogel

How did your team use SOLVER? List the details of EACH solver model you created including: Objective, Changing Cells, and Constraints (if any). Do not list cell references – describe the variables used in the solver model. At least one working solver model MUST be used in your Excel file and the Excel file you turn in must demonstrate one meaningful, working solver model.
Team TT used solver to determine the optimal prices for each product per DC. We began by setting our objective cell as the total average profit margin percentage. We maximized our objective through our changing cells of the price for each product for each DC. For our constraints, we set each price to be greater than or equal to the total variable + fixed costs per product. In addition, we created a cell to calculate a price of 5% and 10% greater than the DC10 price for the 1kg products, and a price of 5% and 10% greater than the DC12 price for the 500g products.
Objective: Total Average Profit Margin Percentage
Changing Cells: Product Prices Per DC
Constraints: Price >= Total Variable + Fixed Costs Per Product DC12 Price >= (DC10 Price*.05+DC10 Price) DC12 Price <= (DC10 Price*.10+DC10 Price) DC14 Price >= (DC12 Price*.05+DC12 Price)

Similar Documents

Premium Essay

Uh Scm 4380 Annual Report

...Company NN December 4, 2013 Company NN December 4, 2013 Annual Report Letter to Stockholders Annual Report Letter to Stockholders Letter to Stockholders To our Stockholders, Thank you for supporting Company NN. The last four quarters has definitely been a challenging one for the Cereal industry where many cereal companies compete in the same market. Company NN has been striving to become the first choice in cereal that provides customers with the best quality and the best price. In order to achieve this, it requires a long-term strategy that will be executed fully over the next few years. In the last four quarters, we have successfully launched the six customer tailored products for three regions. For each distribution channel, we chose specific packages to meet our distributors’ requirement on packaging. By investing in reduction of setup time, we were able to change our production faster in order to meet changes in customers’ preference and market trend. We also invested in production equipment thereby reducing batch size to support our LEAN manufacturing philosophy. In doing so, we successfully attained production flexibility while incurred only a small amount of extra interest expense due to the early investment in long-term equities that spread out investment cost during the whole machine life. Also, our credit rating was consistently the best in the industry, proving that we are headed in the right direction. With the highest AAA credit rating, we had...

Words: 2778 - Pages: 12

Premium Essay

You Are an Entrepreneur

...Assignment 1: You Are an Entrepreneur! ENTERPRENEUR Introduction My family and I own a small family owned community business called Snacks, Snacks, and More Snacks! We provide freshly prepared mini sandwiches, mini quiche and an assortment of baked goods. Snacks are replenished throughout the day to ensure food is fresh and hot, based upon the customer’s availability. We strive for perfection and are committed to provide a clean and safe work environment for the employees. We pride ourselves in stimulating the economy by expanding our workforce to include hiring a diverse group of people. We are committed to generate profitable growth for both the company and employees. Mission Our Mission is to provide a variety of snacks at an affordable price so that customers can purchase more in smaller quantities. Our mission allows our company to create a solid customer base that will gain their loyalty to our business as we grow out our business in family based communities. Values Our main priority is to satisfy our customers with quality services and products, to maintain a constant customer base. We will cater to our customers in a professional manner by offering quality, competitively priced merchandise delivered with courtesy and professionalism. Chart of Accounts CHART OF ACCOUNTS | Balance Sheet Accounts |   |   |   |   |   |   |   |   |   | ASSETS |   | LIABILITIES |   |   |   |   |   |   |   |   |   | 1000 | CASH |   | 2000 |   | PAYABLES | 1010...

Words: 2115 - Pages: 9

Premium Essay

Importance Of Customer Satisfaction

...would mean for the poor in the country. It is difficult to ascertain fully the employment potential of the telecom sector but the enormity of the opportunities can be gauged from the fact that there were 3.7 million Public Call Offices in December 2005 up from 2.3 million in December 2004. The Total Revenue of Indian Telecom Services company is likely to exceed ₹2000 billion (US$32 billion) ( US$44 Bnapprox) for FY 11–12 based on FY 10–11 nos and latest quarterly results. These are consolidated numbers including foreign operation of BhartiAirtel. The major contributions to this revenue are as follows: • Airtel₹65060 (US$1,000) • Reliance Communications ₹31468 (US$500) • Idea ₹16936 (US$270) • Tata Communications ₹11931 (US$190) • MTNL ₹4380 (US$70) • TTML ₹2248 (US$36) • BSNL ₹32045 (US$510) • Vodafone India ₹18376 (US$290) • TataTeleservice₹9200 (US$150) • Aircel₹7968 (US$130) • SSTL ₹600 (US$9.50) • Uninor₹660 (US$10) • Loop ₹560 (US$8.90) • Stel₹60 (95¢ US) • HFCL ₹204 (US$3.20) • Videocon Telecom ₹254 (US$4.00) • DB Etisalat/ Allianz ₹47 (75¢ US) • Grand Total ₹2019 billion (US$32 billion) CHAPTER-2 PROFILE OF THE ORGANIZATION 2.1 About BharthiAirtel: BhartiAirtel Limited is an Indian multinational telecommunications Services Company headquartered in New Delhi, India. It operates in 20 countries across South Asia, Africa, and the Channel Islands. Airtel provides GSM, 3G and 4G LTE mobile services, fixed line broadband and voice services depending upon the...

Words: 9813 - Pages: 40

Premium Essay

B2B Advantages and Disadvantages

...This page intentionally left blank Te n t h E d i t i o n MODERN DATABASE MANAGEMENT Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcano Director of Marketing: Patrice Lumumba Jones Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Operations Specialist: Ilene Kahn Senior Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia © vuifah Manager, Visual Research: Karen Sanatar Permissions Project Manager: Shannon Barbe Media Project Manager, Editorial: Denise Vaughn Media Project Manager, Production: Lisa Rinaldi Supplements Editor: Kelly Loftus Full-Service Project Management: PreMediaGlobal Composition: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2011, 2009, 2007, 2005, 2002...

Words: 193467 - Pages: 774