’s Business Model Stacey Blacker Date : 2nd September 2013 Contents Chapter Description Pg No 1.0 Introduction 2.0 Stakeholder Analysis 3.0 External Analysis 4.0 Internal Analysis 5.0 Conclusion 6.0 References 1.0 – Introduction 400-600 words • Introduce the company o History & Explanation • Competitor Analysis o Bowman’s Clock – Plot the company o Differentiation – What does it do? Primark is an affordable fashion retailer operated by the Irish company Penneys who are a subsidiary of Associated British Foods PLC. In June 1969 Penneys first store was opened in Dublin. By 1973 there were 18 Penneys stores in Ireland and Primark began trading in the UK. By 1994 there were 66 Primark and Penneys stores across the UK and Ireland.
2. The first step is to estimate the unit cost of services extended by the company on its value adding processes. Sl. No Activity No. of Table 1 operations Cost Incurred (USD) Ref of cost given in column: 4 Unit Cost (USD) 1 2 3 4 5 6 A Handling of cartons B Shipping of cartons C Desktop delivery 2000 dly 440000 Para 3(c) 220/ dly D Set up of manual E Enter individual F Validate EDI orders 8000 orders 40000 Para 3(d) G General & Selling in Warehouse by freight 80000 cartons 75000 cartons 16000 orders 150000 lines 600000 Para 3(d) 4160000 Para 3(a) 52/ 450000 Para 3(b) 6/ carton Carton 160000 Para 3(d) order lines of each order (i) (ii) (iii) 10/order 4/line 5 / order Expense USD 42500000 of Annual Sales 200000 Para 3(e) 0.47% of sales 3.
Prepare contributions margins in part (1) with all revisions included. 3. For the original estimates, compute each of the following: (a) Break-even point for the given sales mix. (b) Margin of safety for the estimated sales volume. 3 Part A and B (Original Estimates) | Comp Paper | Napkins | Place mats | Poster Board | Total | Volume | 30000 | 120000 | 45000 | 80000 | | Selling price | 14 | 7 | 12 | 8.5 | | Material cost | 6 | 4.5 | 3.6 | 2.5 | | Units per hour | 6 | 10 | 5 | 4 | | Variable overheads | 9 | 6 | 12 | 8 | | Variable overheads per unit | 1.5 | 0.6 | 2.4 | 2 | | | | | | | | Sales (Volume*Selling Price) | 420000 | 840000 | 540000 | 680000 | 2480000 | Material cost | 180000 | 540000 | 162000
Exercise 1 (SQL) Given following relations: Customers (cid, cname, city, discnt) Agents (aid, aname, city, percent) Products (pid, pname, city, quantity, price) Orders (ordno, month, cid, aid, pid, qty, dollars) Write the following queries in SQL: [40 points] 1. For each agent taking an order, list the product pid and the total quantity ordered by all customers FROM that agent. 2. We say that a customer x orders a product y in an average quantity A if A is avg(qty) for all orders rows with cid=x and pid=y. Is it possible in a single SQL statement to retrieve cid values of customers who order all the products that they receive in average quantities (by product) of at least 300?
Barilla – Case Study Criteria • Title Page • Table of Contents • Executive Summary • Body of Report o Issue Identification o Environmental and Root Cause Analysis o Alternative and Options o Recommendations o Implementations o Monitor and Control • Conclusions • References, Exhibits, and Appendixes Notes: Implement the JITD system within the 18 Barilla controlled depots, representing 35% of the total Dry Product sales. Those products are distributed to the small independent shops which carry an inventory of two weeks. Small shop owners purchase through Brokers that deal with Barilla’s internal purchasing and distribution personnel Supermarkets – Page 265 course readings The remaining Dry Products (65%) are purchased through – 70% distributed to Supermarket chains, with 30% going to Independent Supermarkets. Supermarkets – Large Distributor (GD) – internally owned distribution network Independent Supermarkets – Organized Distributors (OD) – centralized buying organization for a large number of independent supermarkets The sales aspect greatly affects the OD distributors, where sale people are driven to increase the sales at a location. In contrast, GD’s which represent 70% of the Dry Products distributed to the Supermarkets chains are not driven by sales people.
Clarkson Lumber Company Case Study I Please read the case “Clarkson Lumber Company”, and finish the following questions: 1. Please finish the following common-size financial statements and financial ratios Common-size income statement (20%) 2009 2010 2011 Net sales 100.00% 100.00% 100.00% cost of goods sold 75.39% 75.75% 75.77% Gross profit 24.61% 24.25% 24.23% Operating expenses 21.29% 20.62% 20.80% Earnings before interest and taxes 3.32% 3.62% 3.43% Interest expense 0.79% 1.21% 1.24% Net income before income taxes 2.53% 2.42% 2.19% Provision for income taxes 0.48% 0.46% 0.49% Net income 2.05% 1.96% 1.70% Common-size balance sheet (30%) 2009 2010 2011 Cash 4.7% 4.5% 3.4% Accounts receivable, net 33.3% 35.5% 37.0% Inventory 36.7% 37.3% 35.9% Current assets 74.6% 77.4% 76.3% Property, net 25.4% 22.6% 23.7% Total assets 100% 100% 100% Notes payable, bank 5.2% 23.8% Note payable to Holtz, current portion 8.6% 6.1% Notes payable, trade 7.8% Accounts payable 23.2% 29.4% 23.0% Other current liabilities 4.6% 3.9% 4.6% Term loan, current portion 2.2% 1.7% 1.2% Current liabilities 29.9% 48.8% 66.5% Term loan 15.2% 10.4% 6.1% Note payable, Mr. Holtz 8.6% 0.0% Total Liabilities 45.2% 67.8% 72.6% Net worth 54.8% 32.2% 27.4% Total liabilities and Net Worth 100% 100% 100% Financial ratios (Please use the year-end amount.) (20%) 2009 2010 2011 Asset management Days sales in receivables 38 43 48 Days sales in inventory 55 59 62 Days payables Fixed asset turnover 12.5 13.2 11.6 Total asset turnover 3.2 3.0 2.8 Liquidity Current ratio 2.5 1.6 1.1 Quick ratio 1.3 0.8 0.6 Profitability Profit margin 0.021 0.020 0.017 ROA 0.065 0.059 0.047 ROE 0.12 0.18 0.17 Financial leverage Total debt
The accompanying graph shows all of the possibilities for the number of refrigerators and the number of TVs that will fit into an 18-wheeler. a) Write an inequality to describe this region. b) Will the truck hold 71 refrigerators and 118 TVs? c) Will the truck hold 51 refrigerators and 176 TVs? To better help you follow my work I will start out with the question as seen above as part 1 and for the other questions that I was asked to do by my instructor as part 2.
Purchase Order Form 8 5. Delivery Note 10 6. Sales Invoice 12 7. Credit Note 14 8. Statement of Account and Remittance Advice 16 References 21 1. Pro forma Cash Receipt You are to prepare pro forma cash receipt for use in the company’s shops.
In the past the company has observed an arc income elasticity of +2.5 for microwave ovens. Forecast 2011 sales given that the price is reduces to $325 and that per capita disposable income increases to $7,000. Assume that the price and income effects are independent and additive. | 2. Lenny's, a national restaurant chain, conducted a study of the factors affecting demand (sales).
Management of logistics activities and costs including customer service, Inventory, transportation, lot quantity costs, warehousing, and information systems. INSTRUCTOR: Dr. Michael Knemeyer Fisher Hall, 548 (614) 292-2507 (office) (614) 292-0879 (fax) (937) 532-3036 (cell) E-mail: knemeyer.4@osu.edu Class Website: https://carmen.osu.edu OFFICE HOURS: By appointment. Required Text: Contemporary Logistics Management, 10th Edition, Murphy and Wood, (Prentice Hall, 2010); ISBN 13 978-0-13-611077-0, Retail 87.10 - $207.05 (OSU Bookstore; www.ohiostate.bkstore.com), $36.76 - $133.17 (Amazon; www.amazon.com) Additional course materials including PowerPoint slides, assignments and outside readings will be available either from Carmen (https://carmen.osu.edu/), Business Source Complete (http://library.ohio-state.edu/screens/databases.html) or as class handouts. Course To provide an understanding of the key logistics concepts and the ObjectiveS: issues affecting the movement and storage of goods. Particular