ACC 312 Study Guide - Midterm Guide: Payment Card, Deferral, Current Asset

Hands-On Project 10-12

IMPROVING DECISION MAKING: USING SPREADSHEET SOFTWARE TO ANALYZEA DOT- COM BUSINESS

Software skills: Spreadsheet downloading, formatting, andformulas

Business skills: Financial statement analysis 10- 12

Pick one e- commerce company on the Internet— for example,Ashford, Buy. com, Yahoo, or Priceline. Study the Web pages thatdescribe the company and explain its purpose and structure. Use theWeb to find articles that comment on the company. Then visit theSecurities and Exchange Commission’s Web site at www. sec.gov to access the company’s 10- K ( annual report) formshowing income statements and balance sheets. Select only thesections of the 10- K form containing the desired portions offinancial statements that you need to examine, and download theminto your spreadsheet. Instructions below provide more detailedinstructions on how to download this 10- K data into a spreadsheetand information on financial statements. Create simplifiedspreadsheets of the company’s balance sheets and income statementsfor the past three years.

• Is the company a dot- com success, borderline business, orfailure? What information provides the basis of your decision? Why?When answering these questions, pay special attention to thecompany’s three- year trends in revenues, costs of sales, grossmargins, operating expenses, and net margins.

• Prepare a PowerPoint overhead presentation (with a minimum offive slides), including appropriate spreadsheets or charts, andpresent your work to your professor and classmates. An examplePowerPoint slide presentation is attached for your review in thislearning module folder in Blackboard.

As needed: Students can find material on understanding financialstatements on financial Web sites such as Ameritrade(www.ameritrade.com) or the Small Business Knowledge Basehttp://www.bizmove.com/finance/m3b2.htm.

Downloading the Data into a Spreadsheet

Use the Convert Text to Columns Wizard in your spreadsheetsoftware to arrange the 10-K data you downloaded into spreadsheetcolumns and rows. From the Excel menu, select Data and then selectthe Text to Columns option. The software brings up a Wizard toconvert the imported text into spreadsheet columns. Although youcan decide to create line breaks, it may be easiest to accept thedefault settings (Fixed Width, General format) and then adjustcolumn widths after the Wizard has arranged the data in spreadsheetcolumns.

Financial Statements

Financial statements are used to evaluate the performance of abusiness and diagnose its strengths and weaknesses. The two primaryfinancial statements are income statements and balance sheets. Theincome statement, also called an operating statement or profit andloss statement, shows the income and expenses of a firm over aperiod of time, such as a year, a quarter, or a month. Gross profitis calculated by subtracting the cost of goods sold from revenues,or sales. The gross margin is calculated by dividing gross profitby revenues (or sales). Net profit (or loss) is calculated bysubtracting all other expenses, including operating expenses andincome taxes from gross profit. Operating expenses are all businesscosts (such as expenditures for sales and marketing, general andadministrative expenditures, and depreciation) other than thoseincluded in the cost of goods sold. Net margins arecalculated by dividing net profit (or loss) by revenues (orsales).

A balance sheet provides a snapshot of a company’s financialassets and liabilities on a given date, usually the close of anaccounting period. It lists what material andintangible assets the business owns and what money the businessowes either to its creditors (liabilities) or to its owners(shareholders’ equity, also known as net worth). At any given timea business’s assets equals the sum of its liabilities plus its networth. Current assets include cash, securities, accountsreceivable, or other investments that are likely to be convertedinto cash within one year. Liabilities are outstanding obligationsof the firm. Current liabilities are debts that are due within oneyear. Long-term debt consists of liabilities that are not due untilafter a year or more. If too much debt has been used to finance thefirm’s operations, problems may arise in meeting future interestpayments and repaying outstanding loans. By examining a series ofbalance sheets, one can identify and analyze trends in thefinancial strength of a business.

KRAYDEN’S CYCLE COMPONENTS INTRODUCTION: COMPANY, PRODUCT, AND SUPPLY CHAIN

Krayden’s Cycle Components (KCC) is a high-end specialty fabricator that manufactures one product with many variants. The basic product is known as a rolling chassis, a key component used in manufacturing motorcycles. While there are variations across the industry, a rolling chassis typically consists of a motorcycle frame, front forks, wheels and tires, and handlebars.1

KCC is a first-tier supplier to an original equipment manufacturer (OEM) that produces motorcycles in three versions: Sport, Cruising, and Retro. The OEM purchases KCC product and attaches its well-known proprietary engine and gearbox, wiring and gauges, seat, fenders, various components, and gas tank with iconic emblem. The OEM is KCC’s sole customer as it essentially requires KCC’s full capacity.

KCC manufactures each frame from steel tubing but purchases a variety of parts from suppliers. Workers at KCC attach these parts to the frame to complete the rolling chassis. Figure 1 illustrates the supply chain. The suppliers of wheels, front forks, and handlebars are second-tier suppliers. These vendors provide parts that are ready to be attached to the frame. The tire vendor is considered a third-tier supplier. The company that builds the wheels acquires tires (that meet contract specifications directly negotiated by the OEM) and provides a complete wheel assembly ready to be attached to the front fork and rear frame.

KCC has had numerous problems with delivery and quality over the past several years. Because the problems have been so acute, the company has employed four different plant managers in the last five years. Management acknowledges the supply chain has difficulties; unfortunately, there is virtually no room for error in meeting delivery schedules and product quality targets. Further, KCC has been under increased scrutiny from its stockholders because earnings have deteriorated over the past three years. See Tables 1-4 for KCC’s financial information (income statement, balance sheet, statement of cash flows, and unit cost information).

The economic recession that ended around the summer of 2009 has enabled the OEM to expand production and sales. The company’s sales have increased by 1,000 units per year since 2010. By 2015, KCC was delivering 30,000 units to the OEM; management believes this level of output represents capacity. Thus, production above 30,000 units is not possible without staff overtime or an investment in additional plant resources that will increase hourly throughput. Management at KCC has received notice that the OEM plans to increase production by 3,750 units next year (12.5%) and to demand price concessions of $200 per unit as specified in the contract.

THE PRODUCT MIX AND OUTSOURCED PARTS

The OEM produces motorcycles for three different market niches; therefore, KCC produces three distinctly different frame geometries as follows.

Sport bikes emphasize speed and agility. Customers expect rapid acceleration and responsive handling.

Cruising bikes emphasize power and comfort. They allow riders to enjoy long-distance touring.

Retro bikes appeal to customers who appreciate classic designs. They are typically smaller than cruising bikes and more stable than sport bikes.

For each frame geometry, the OEM offers three possible handlebar types. Because riders are various sizes, handlebars can be configured in a variety of heights, widths, and lengths (straight bars or bars pulled back toward the rider).

The OEM offers three different wheel set possibilities. Wheel sets consist of one front wheel and one rear wheel. The different wheel designs are:

Chrome spokes.

Cast aluminum polished (silver) alloy wheels.

Cast aluminum anodized (black) alloy wheels.

The OEM offers four unique tire choices for each frame type. Thus, KCC could purchase as many as 12 different tire models to meet market demand (three frame types x four different tires per frame). Factors that differentiate the tires include:

Bias-ply (characterized by a round profile and tall sidewalls).

Radial (characterized by a flat profile and short sidewalls).

Grip (soft—better road grip but shorter tread life; hard—poorer road grip, but longer tread life).

Tread design (differences in the number of grooves in the tire pattern).

Number of layers (known as plies) from which the tire is constructed; using more layers results in a stiffer tire.

The OEM contracts directly with the tire manufacturer to supply specific tires to the wheel manufacturer. Much engineering effort has gone into identifying the proper tires and wheels for each type of motorcycle. The wheel vendor receives and mounts the appropriate tire on the wheel set and then delivers the set to KCC. The tire manufacturer sells its products to different OEMs, as well as to aftermarket customers.

Recently, the OEM has complained to KCC about chassis that vibrate and exhibit poor handling qualities when the completed motorcycle is test driven. Engineers at KCC have traced the source of the problem to the tire manufacturer. A wheel/tire combination that is not balanced properly causes vibration and is a control and safety issue. The solution requires placing the wheel/tire set on a machine to determine the location of the imperfection causing the imbalance. A small weight is attached to the wheel to offset the tire imperfection and to remove the vibration. Because of pressure from the OEM to deliver a quality chassis, KCC purchased a wheel balancing machine and tested each set before installing it on their chassis. The quality delivered to the OEM has improved, but management at KCC is unhappy because the OEM refuses to increase the contract price to help offset KCC’s additional cost of equipment and labor.

The supply chain has additional complications. One of KCC’s suppliers (a second-tier supplier that produces handlebars) is also a subsidiary of the holding company that owns KCC. This supplier has contracts with manufacturers of bicycles, scooters, and power chairs. On several occasions, this supplier has missed scheduled deliveries. When confronted, management explained they had external customers whose orders must be filled. At certain times of the year, demand exceeds the supplier’s ability to meet it. As a result, KCC management has scrambled to find suitable suppliers (at much greater cost) in order to meet their own delivery schedules.

PROCESS DESCRIPTION

KCC receives an order from the OEM exactly three hours before the specific chassis is needed on the OEM’s assembly line. The company employs four production line workers who are cross-trained to perform multiple functions.

Figure 2 illustrates the manufacturing process for KCC, a manufacturing cell that includes the following processes:

Step 1. Tube cutting and assembly. Steel tubes arrive by forklift at Step 1, the cutting and welding process.

Cutting. Using a computer numerically controlled (CNC) machine, steel tubes are bent and cut to proper angles and lengths that match the engineering design specifications for each frame type—Sport, Cruising, or Retro.

Welding. After the tubes are cut, they are clamped to a jig that holds them stationary at the proper angle for welding. A robot tack-welds each joint, which is a temporary weld to hold the assembly in preparation for final welding. Once the frame is completely assembled by tack welds, the robot permanently welds the joints.

Step 2. Weld cleanup and preparation. The welded metal frame advances to the next process where the welds are smoothed and polished, then to a cleaning bath where the frame is cleansed of oils and surface contamination prior to the powder coating process.

Step 3. Powder coating. KCC powder coats, rather than paints, the frames. Consistent with environmental sustainability issues, the powder coating process emits almost zero volatile organic compounds (VOCs). In addition, any overspray can be captured and reused. Powder coating is a dry powder that does not require a solvent. The powder coating is robotically sprayed within a booth by a nozzle that imparts a negative electrical charge to the powder. The powder electrostatically adheres to the grounded frame. The frame is heated to approximately 400 degrees Fahrenheit for around three minutes to melt the powder that flows to produce a smooth, strong, glossy finish.

Step 4. Fork assembly. The forks are manually attached to the frame.

Step 5. Tire balancing. The wheel/tire set is tested for balance, and any necessary modifications are made.

Step 6. Wheel/tire assembly. The wheel/tire assembly is manually attached to the frame.

Step 7. Handlebar mounting. The handlebars are mounted on the frame.

Step 8. Loading the frames. The frames are carefully loaded into a cargo trailer for transport.

KCC’S JUST-IN-TIME/ JUST-IN-SEQUENCE INVENTORY SYSTEM

The OEM produces motorcycles for eight hours each weekday. KCC makes eight deliveries (once per hour) during this period. The frames are delivered just-in-time (JIT) and just-in-sequence (JIS). JIS delivery implies the first frame unloaded from the truck is the next frame needed for production by the OEM. KCC is linked to the OEM’s production information system via an electronic data interchange system. The system identifies the appropriate frame geometry, handlebar type, wheel type, and tire specifications for each order.

Management at KCC has been working to improve operating efficiency and profitability. Because KCC operates according to Lean principles, the company strives to hold minimal parts inventory. Thus, on-time delivery and the quality of purchased parts are crucial to keep production lines operating at desired output levels. If KCC causes the OEM to stop its line because of delivery or quality problems, the contract allows the OEM to bill KCC for lost production time at a rate of $2,000 per minute.2 The OEM believes this clause is justified because it loses contribution margin if production is brought to a halt. In some cases, KCC has passed these costs along to second-tier suppliers that caused KCC to miss a delivery.

KCC has met on several occasions with its suppliers to try to resolve supply issues. Vendors have been frustrated by the Lean system demanded by KCC. To reduce their exposure to line stoppage costs, some second-tier suppliers have responded by increasing inventory levels. Additionally, some suppliers have purchased redundant manufacturing equipment on key production processes that can be used if the primary equipment fails, further adding to manufacturing costs.

Management at the OEM believes in developing long-term strategic partnerships with its suppliers. Thus, each supplier is rewarded with a multiyear contract. The OEM prefers to use a single supplier for each component, rather than to contract with two (or more) different companies for a component. KCC has the exclusive contract to produce rolling chassis for the OEM, and has recently been awarded the next contract covering five years of production. As a result, KCC made significant investments in retooling and plant modernization during the current year. Unfortunately, the investments did not increase KCC’s capacity sufficiently to meet expected demand.

THE MANAGEMENT DILEMMA

KCC’s management operates as one participant in a complex supply chain. They are managing relationships involving multitier suppliers and a demanding delivery schedule. Further, stockholders are expressing concern over KCC’s declining profitability in recent years. Management has not developed a plan for addressing the increase in production required by the OEM, nor have they developed an understanding of the financial consequences of accepting the new contract.

Question:

The OEM produces its final product in three versions with many variants. How many unique product combinations are possible? Explain. What are some examples of complexity (and related costs) that result from offering three product versions with many variants? What challenges does this complexity present for management accountants?