UrLink Company is a newly formed company specializing in high-speed Internet service for home and business. The owner, Lenny Kirkland, had divided the company into two segments: Home Internet Service and Business Internet Service. Each segment is run by its own supervisor, while basic selling and administrative services are shared by both segments.
Lenny has asked you to help him create a performance reporting system that will allow him to measure each segment's performance in terms of its profitability. To that end. the following information has been collected on the Home Internet Service segment for the first quarter of 2017.
Budget | Actual | |
Service revenue | $25,000 | $26,200 |
Allocated portion or: Building |
11,000 | 11,000 |
Advertising | 5,000 | 4,200 |
Billing | 3,500 | 3,000 |
Property taxes | 1,200 | 1,000 |
Material and supplies | 1,600 | 1,200 |
Supervisory salaries | 9,000 | 9,500 |
Insurance | 4,000 | 3,900 |
Wages | 3,000 | 3,250 |
Gas and oil | 2,800 | 3,400 |
Equipment depreciation | 1,500 | 1,300 |
Instructions
(a) Prepare a responsibility report for the first quarter of 2017 for the Home internet Service segment.
(b) - Write a memo to Lenny Kirkland discussing the principles that should be used when preparing performance reports.
Want to see the full answer?
Check out a sample textbook solutionChapter 10 Solutions
Managerial Accounting: Tools for Business Decision Making 7e Binder Ready Version + WileyPLUS Registration Card
- Taylor Construction builds custom homes in Dallas, Texas. Brandon Taylor knows that his future depends on the quality of the homes he builds and the service he provides to customers. Most new-customer sales arise from word-of-mouth advertising by former customers.Identify the balanced scorecard perspective for each measure in the exercise.    Perspective  a. Number of customer complaints   Internal business processesCustomerLearning & growthFinancial  b. Employee turnover   Learning & growthFinancialInternal business processesCustomer  c. Net profit per house constructed   Learning & growthFinancialInternal business processesCustomer  d. Turnaround time on customer design changes   Learning & growthInternal business processesCustomerFinancial  e. Hours of training per employee   Learning & growthFinancialInternal business processesCustomer  f. Average labor cost per house   CustomerLearning &…arrow_forwardWalker Accounting Software is marketed to small accounting firms throughout the U.S. and Canada. Owner George Walker has decided to outsource the company's help desk and is considering three providers: Manila Call Center (Philippines), Delhi Services (India), and Moscow Bell (Russia). The following table summarizes the data Walker has assembled. Which outsourcing firm has the best rating? (Higher weights imply higher importance and higher ratings imply more desirable providers.) In the following table, compute the weighted average score for each of the three providers (enter your responses rounded to one decimal place). Weight Manila Delhi Moscow Criterion Flexibility (W) (A) (B) 0.50 Trustworthiness 0.10 Price 0.20 Delivery 0.20 5689 3 7 6 7 7 J1208 (C) 9 9 Total weighted score:arrow_forwardSonos, Incorporated designs, develops, manufactures, and sells multi-room audio products. The Sonos sound system provides customers with an immersive listening experience created by the design of its speakers and components, a proprietary software platform, and the ability to stream content from a variety of sources over the customer's wireless network or over Bluetooth. In an earlier year, it reported the following on its income statement (dollars in millions). Net sales Costs and expenses Cost of sales Research and development Selling, general, and administrative Operating income (loss) Interest and other incone (expenses), net Loss before provision for income taxes Provision for income taxes Net loss The company's beginning and ending assets were $762 and $816, respectively. Transaction a b. $ 1,326 Required: Listed here are hypothetical additional transactions. Assuming that they also occurred during the fiscal year, complete the following tabulation, indicating the sign of the…arrow_forward
- Ascendex Sdn Bhd is an online company that supplies a range of IT products. Its product line includes IT hardware and software. Their main customers are government agencies and private company. The company employs a combination of manual procedures and a networked accounting system with distributed terminals in several departments. After years of satisfactory performance, however, Ascendex Sdn Bhd is now experiencing operational inefficiencies and accounting errors. Your firm has been hired to evaluate Ascendex’s business processes and internal controls. Ascendex’s expenditure cycle is described in the following paragraphs. PURCHASE SYSTEM PROCEDURES Ascendex’s transactions are initiated when the purchasing department clerk reviews the inventory file for items that need to be replenished. The clerk selects a vendor, adds a record to the digital purchase order (PO) File, and prints four hard copies of the PO. One copy is filed in the department; the second copy is sent to the receiving…arrow_forwardJanet has a small business which is a spa and beauty retreat where she also employs a few staff. With her growing operation she has identified the need to implement a computerized accounting information system. In order to have a system that meets her needs exactly and also to save cost, she has asked you to create a simple, customized solution for her business. Her immediate need is for a customer sales information system, so that is what you will now create.  Janet’s receptionist maintains a client file that contains each client’s full name, cellphone number, favourite treatment (if known), and special considerations (e.g. allergies). When a client wants to come in for spa or beauty services, they first call Janet’s receptionist for a reservation. The receptionist books a time in her appointment book, noting a unique identifier for the visit, the date and time of the appointment, what service or services the client will receive, the total price, and which staff member will serve the…arrow_forwardDowntown! is a rapidly growing web-based retailer with about 100 management and technical support employees at its headquarters office in Florida. Mary Estrada, the firm’s IT manager, is planning a new information system that will give users better access to sales and marketing data and trends. She has a concern, however. She knows that users often request reports but use only a small portion of the data. In many offices she sees inboxes filled with printed reports gathering dust. Mary asked for your opinion: What if new system users could design most of their own reports without assistance from the IT staff, by using a powerful, user-friendly report writer program? Do you think they would request as many reports or the same types of reports? What are the pros and cons of giving users total control over output?arrow_forward
- Aaron McKinney is a cost accountant for Majik Systems Inc. Martin Dodd, Vice President of Marketing, has asked Aaron to meet with representatives of Majik Systems’ major competitor to discuss product cost data. Martin indicates that the sharing of these data will enable Majik Sys-tems to determine a fair and equitable price for its products. Would it be ethical for Aaron to attend the meeting and share the relevant cost data? Explain your answer.arrow_forwardAt Jeekes PolyChem Products LLC, customers needs are translated into product specifications by the design or engineering department. Which of the following objectives of production management is addressed by Jeekes Polychem Products LLC? a. Right time b. Right quality c. Right quantity d. Right cost Mr. Saud bought a new mobile phone for himself.  He explained to his friend that the mobile phone has a camera, Facebook facility, and music facility in addition to the basic functions like phone calls and messaging. Which dimension of "product quality" is Mr. Saud referring to? a. Features b. Aesthetics c. Reputation d. Conformancearrow_forwardABC bank offers a Business Grant to encourage a fresh graduate to become an entrepreneur. However, to apply this Business Grant, you need to explain in general the overview of your business. Therefore, using the Business Model Canvas approach, develop your strategy to run ANY BUSINESS IDEA by illustrating Business Model Canvas based on NINE (9) areas, including customer segment, value proposition, marketing channels, customer relationships, key partners, key activities, key resources, cost structure, and revenue stream.arrow_forward
- Retail companies with today’s online, as well as in-store sales have a lot of data to keep track of! Keeping track of sales, costs, and profits daily is essential to making the most of a business. This exercise illustrates how to use the skills presented in this Module to generate the data needed daily by a retail company. Create the following calculated columns. a) In I4, and J4, use a VLOOKUP function that will look up the Product Price and Product Cost based on the Product Sold column which lists an ID number. [Hint: The Product Table sheet lists the Price and Cost] If any error messages appear, check the Range Lookup. b) In K4, use a formula to calculate Profit. Hint: Profit =(Product Price-Product Cost)*Units Sold Format columns I, J, and K as currency with two decimal places. Make a copy of the Sales sheet and rename it Online Sales by Date. Place this sheet to the right of the Sales sheet. Answer the following question by filtering the data accordingly. a) What was the…arrow_forward! Required information [The following information applies to the questions displayed below.] Cranshaw Business Services (CBS) operates an information technology (IT) consulting firm out of two offices: Detroit and Los Angeles. Corporate services, such as legal, finance, and personnel, are centralized at the main office and the costs of these services are allocated to the two offices for the purposes of profitability assessment. The Detroit office is the original unit of the company and is well established, having long-time clients from the automotive and other manufacturing industries. The Los Angeles office is new with a smaller, much more varied, clientele. The costs of personnel services at CBS are currently allocated on the basis of the number of employees in each office. The annual costs of the personnel department total $440,000. Data for the fiscal year just ended show the following: Number of employees Number of new hires Number of employees departing a. Using current…arrow_forward! Required Information [The following Information applies to the questions displayed below.] Cranshaw Business Services (CBS) operates an Information technology (IT) consulting firm out of two offices: Detroit and Los Angeles. Corporate services, such as legal, finance, and personnel, are centralized at the main office and the costs of these services are allocated to the two offices for the purposes of profitability assessment. The Detroit office is the original unit of the company and is well established, having long-time clients from the automotive and other manufacturing Industries. The Los Angeles office is new with a smaller, much more varied, clientele. The costs of personnel services at CBS are currently allocated on the basis of the number of employees in each office. The annual costs of the personnel department total $350,000. Data for the fiscal year just ended show the following: Number of employees Number of new hires Number of employees departing Detroit 380 Los Angeles…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeFinancial Reporting, Financial Statement Analysis...FinanceISBN:9781285190907Author:James M. Wahlen, Stephen P. Baginski, Mark BradshawPublisher:Cengage Learning