managementdata in doc "tuna dta" need to open with software "stata",

- Must know how to use CAPSIM, understand Financial Reports. This interdisciplinary approach to the study of the process of strategic management includes strategic analysis planning, implementation, evaluation, and control from the perspective of top management in profit-making U.S. and international corporations, as well as public and nonprofit organizations. Capsim Foundation Simulation is used extensively. - Pick the best Porter Strategy recommended. - History off assignment can be found: http://hubpages.com/education/Capsim-Simulation-The-Human-Resources-Module- Use source: https://www.mindtools.com/pages/article/newSTR_82.htm - Attached guidelines for writing and other attachments (results of my Capsim performance that will help answer the questions) Please incorporate the following: Name Porter's Strategy (I used Porter's strategy: Cost focus (elaborate on this all throughout as the strategy) and connect it to a Vision Statement on page 1. Also please make sure to give a Summary statement of your data and goals for the future at the end, indicate in conclusion/last page. Tell the Board of Directors a compelling story of the company through the visual communication of data, and create trust that you know the North Star of the company and how to navigate there. Cost Focus means emphasizing cost-minimization within a focused market. Low cost such as Walmart, Costco, Etc. Please use below for reference: https://www.mindtools.com/pages/article/newSTR_82.htm Sources must be APA format and url link must be provided when used. It is important to incorporate responses based on the results from the Fast Track rounds, Annual Reports, Financial Summaries & Round Analysis (all are attached). Source to be used: http://poseidon01.ssrn.com/delivery.php?ID=529106093087075011122066082007010126029069029053059024023104081010119071109096108023033010062037057098105109081083120106000002005049053081003094108126114121115093095037000080027121119082113078022092107093065090090003122079023011080073086119072116007&EXT=pdf or http://papers.ssrn.com/sol3/papers.cfm?abstract_id=2367527 then open PDF in browser to view article 2 1/2 pages should reflect the instructions for writing (above) /Capstone Component 1: Executive Summary & half page for the Capstone Component 2: Professional Reflection Please review below to ensure results will be "Proficient" attached as "OL_421_Final_Project_Guidelines_and_Rubric-4" Instructor Feedback: This activity uses an integrated rubric in Blackboard. Students can view instructor feedback in the Grade Center. For more information, re Round Analysis ?Industry Results ?Debrief ?Round Analysis Round Analysis Round Analysis for Year 2022 Round 7 - F74193_013. Each Team can earn a maximum of 5 stars. Stars represent an overall performance evaluation, much like the stars in the Morningstar ratings. One star is issued for each of the following: • Contribution margin over 30% • Zero emergency loan • For total units across entire product line: satisfy at least 95% of demand for their products and can not carry more than 90 days of inventory. • Increase in stock price over last year • Profit greater than zero Company Profit Margin Emer Loan Inventory Stock Price Total Grand Andrews 3 19 Baldwin 5 31 Chester 5 33 Digby 5 32 Erie 5 33 Ferris 5 33 Hello Andrews Team! For Round 7 you earned a total of PROFITS : You earned one star because your profits were $ 1,315,846. Profits are listed on page 1 of the Foundation FastTrack . Losses are usually the result of insufficient margin caused by a high cost structure and too low prices. Profit can also suffer from excessive expenditures in selling and advertising, heavy interest payments on debt, and losses on liquidation (scrapping) of inventory when retiring a product line. ANALYSIS - Congratulations! You turned a nice profit for the year. CONTRIBUTION MARGIN: You earned no stars because your corporate contribution margin is 22.4%. Contribution margin is defined as: Sales - (Direct Labor + Direct Materials + Inventory Carry) Sales It is reported on Page 1 of the Foundation FastTrack as an aggregate average of each team's product portfolio. A good benchmark for contribution margin is 30%. A product-by-product margin computation is available on the Income Statement portion of your company's annual reports. ANALYSIS - Watch your margins. It's difficult to maintain long-term success with contribution margins below 30%. Investments in cost reduction strategies (automation/capacity expansion) should be considered, as should price increases. Also check your MTBF against the Customer Buying Criteria on segment analysis pages of the simulation reports. You may be offering customers more reliability than they care about. EMERGENCY LOANS: You earned one star, because you avoided an emergency loan. Emergency loans are listed on Page 1 of the Foundation FastTrack. The simulation gives you every benefit of a doubt, but if you are out of cash at the end of the year, "Big Al" arrives to give you just enough cash to bail you out -- at a 7.5 percentage point premium, of course. In the real world we often refer to emergency loans as "a liquidity crisis", "Chapter 11", or simply "Bankruptcy." ANALYSIS - You have good cash management. To diagnose your emergency loan, examine your Cash Flow statement. It represents the net flow of money into and out of your checking account. A positive number indicates an inflow, a negative number an outflow. For example, find the "Inventory" line. If your inventory position increased compared to last year, you had to pay for the additional inventory, and that resulted in a cash outflow. On the other hand, if you sold all of your old inventory, that represented a cash inflow. INVENTORY: You earned no stars for your year-end inventory position. The ideal year-end inventory position is one unit in each product line. In that case you would know that every potential sale was made, and that inventory carrying cost was minimized. This is the goal of "Just In Time" inventory systems. In the simulation, however, you cannot adjust production during the year to meet demand. Therefore, you must balance the risk of losing sales to competitors because of stock outs against the cost of carrying additional inventory should your demand exceed your expectations. At some point inventories become excessive. A good benchmark would be, "inventory levels should not exceed 60 days (two months) of Sales." For example, if your product's sales are $12 million, inventories should not exceed $2 million. To earn a star of your inventory management, each product must satisfy two conditions: 1 Teams must satisfy at least 95% of the demand they generate across the entire product line. Actual Total Industry Unit Sales/Potential Industry Unit Sales >= 95%.(on a per team basis) 2 Teams cannot carry more than 90 days of inventory defined as Total Unit Inventory/Total Units Sold<=25%. ANALYSIS -CHECK FOR STOCK OUTS. You may have under-produced and turned away customers. Examine the ACTUAL VS. POTENTIAL graphs for each segment analysis in the simulation reports. This will indicate how badly your stock out hurt you. ANALYSIS -CHECK FOR EXCESSIVE INVENTORY LEVELS. On the Production Analysis (page 4), compare "Units Sold" with "Units in Inventory". Inventory should be less than 1/6th of unit sales. Inventory consumes cash, drags down your performance measures, and in extreme cases drives emergency loans. Inventory carry overheads chew into profits. Typical problems include: 1 Overly optimistic sales forecasts. Previous year customer demands (and segment growth rates) are listed for each market segment pages. Compare your sales forecast figures against segment demand. Were sales expectations unrealistic? For example, if the segment demand ceiling was 3 million units, and there are six teams with products in the segment, a "fair share" starting point is 500 thousand units per team. If you have a better than average product, your sales will be higher. Below average products produce below average demand. But unless your product is dramatically better or worse than the other products in the segment, you demand will be somewhere between 50% and 150% of average. This is discussed further in the help files on the website under "How do we develop a unit sales forecast?" 2 Sometimes teams confuse the relationship between sales forecasts, production schedule, and production capacity. ? Sales Forecasts only affect proformas. They are a tool - not a management "decision." When you enter a forecast, you force the software to use your number to drive the Income Statement. When the simulation is processed on the web site, actual sales depend upon the actions of your competitors. ? Production Schedule (on the Production spreadsheet of the student software) is the actual production for the year. This is added to the starting inventory. Production occurs in monthly increments. ? Production Capacity is the size of the factory. If the Capacity is 500 thousand, you can produce up to one million units by running 100% overtime. All units produced above 500 thousand will be affected by time-and-a-half overtime charges. You buy or sell capacity, or simply leave it idle and unused. STOCK PRICE: You earned one star because your stock price rose last year by $ 0.75. Stock price is affected by performance, asset base, debt, dividend policy, and number of shares outstanding. In a year of aggressive investment in plant expansion and automation, you would expect that the necessary debt load would cause some uneasiness on the part of shareholders. But, if the stock price dips more than $15.00, it may be a warning sign of too much debt. The stock price can also suffer in profitable years. For example, liquidation of plant brings in cash, but makes shareholders wonder about the long term competitive ramifications. Paying dividends in excess of profits, or obtaining a Big Al emergency loan, will have a negative effect on stock price. ANALYSIS - You did a good job for shareholders. Your annual meeting should turn into a nice celebration! May we suggest Maui? The management team can expect swift approval of a proposed increase in your compensation package.