ACCESS IN BB-ACC202
null Edition
ISBN: 9780135375587
Author: Pearson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 6, Problem 6.25AE
Create a scatterplot (Learning Objective 3)
Melody Leigh, owner of Broadway Floral, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Leigh wants to set the delivery fee based on the distance driven to deliver the flowers. Leigh wants to separate the fixed and variable portions of her van operating costs so that she has a better idea of how delivery distance affects these costs. She has the following data from the past seven months:
Month | Miles Driven | Van Operating Costs |
January | 15,500 | $5,390 |
February | 17,400 | $5,280 |
March | 15,400 | $4,960 |
April | 16,300 | $5,340 |
May | 16,500 | $5,450 |
June | 15,200 | $5,230 |
July | 14,400 | $4,680 |
Requirements
- 1. Prepare a scatterplot of Broadway Floral’s volume (miles driven) and van operating costs.
- 2. Does the data appear to contain any outliers? Explain.
- 3. How strong a relationship is there between miles driven and van operating costs?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
You wish to take an Excel course. You may enroll at one within your school or you may take a community class at the local library. You've gathered the following information to aid in your decision-making process:
Costs/Benefits
College Course
Community Course
Cost
$4,300
$1,190
Distance to course
0.20 miles (walking distance)
18 miles (driving distance)
Timing of course
Weekday
Weekend
Number of meetings
16
8
Qualitative considerations
Convenience, quality of instruction
Flexibility, brief duration
Pretend transportation (gas, mileage, and parking) cost $220 per class session at the library. If you consider solely the cost - including transportation - of each alternative, which would you choose?
Multiple Choice
College course
Community course
Both alternatives
Neither alternative
Profit Planning and Control
This case is a manufacturer and could make specialty bikes, ski or outdoor equipment, computers, food like chocolates, saltwater taffy, cookies, or donuts, etc.
Create the balance sheet, income statement, and statement of the cash flow from the following information.
Use the following information for the learning experiences
Sales volume units = 11,000
Sales price/unit = $100
Variable manufacturing costs/unit = $60
Fixed manufacturing costs = $210,000
Fixed sales & administration costs = $190,000
Business income tax rate = 25%
Current assets = $250,000 (Cash $50,000, Accounts Receivables $100,000, Inventory $100,000)
Fixed assets = $750,000
Current liabilities = $200,000 (Accounts Payable $100,000, Short Term Debt $100,000)
Long Term Debt = $300,000
Owners' Equity = $500,000
he Shining Stars primary school was the recent recipient of a technology grant to source and implement a school management system. The school administrator is not technology savvy and therefore sought advice from three of the board members who were knowledgeable in the information systems and technology field.
One director advised the administrator to purchase an off-the-shelf solution which would allow the school to get the system configured and up and running in a short period with reasonable costs.
The second advised the administrator to invest in the development of a unique system to meet the custom requirements of the school’s administration. He suggested that this would create a closer fit to the school’s needs compared to purchasing software, but will cost more.
The third director suggested using an open source solution which would have little if any upfront costs but may take some time to set up.
i) Identify the…
Chapter 6 Solutions
ACCESS IN BB-ACC202
Ch. 6 - (Learning Objective 1) A graph of a variable cost...Ch. 6 - (Learning Objective 2) Which of the following is...Ch. 6 - (Learning Objective 2) In the cost equation...Ch. 6 - Prob. 4QCCh. 6 - Prob. 5QCCh. 6 - (Learning Objective 3) Which of the following is...Ch. 6 - Prob. 7QCCh. 6 - (Learning Objective 5) Which of the following is...Ch. 6 - Prob. 9QCCh. 6 - Prob. 10QC
Ch. 6 - Identify cost behavior (Learning Objectives 1 2)...Ch. 6 - Prob. 6.2SECh. 6 - Compute fixed costs per unit (Learning Objective...Ch. 6 - Prob. 6.4SECh. 6 - Predict and graph total mixed costs (Learning...Ch. 6 - Prob. 6.6SECh. 6 - Prepare and analyze a scatterplot (Learning...Ch. 6 - Prob. 6.8SECh. 6 - Use the high-low method (Learning Objective 4)...Ch. 6 - Prob. 6.10SECh. 6 - Prob. 6.11SECh. 6 - Prob. 6.12SECh. 6 - Write a cost equation given regression output...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Identify cost behavior graph (Learning Objectives...Ch. 6 - Prob. 6.18SECh. 6 - Prob. 6.19SECh. 6 - Prob. 6.20AECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Prob. 6.22AECh. 6 - Prob. 6.23AECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatterplot (Learning Objective 3) Melody...Ch. 6 - Continuation of E6-25A: High-low method (Learning...Ch. 6 - Continuation of E6-25A: Regression analysis...Ch. 6 - Regression analysis using Excel output (Learning...Ch. 6 - Prob. 6.29AECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Performing a regression analysis to predict...Ch. 6 - Prob. 6.33AECh. 6 - Prob. 6.34AECh. 6 - Compare absorption and variable costing (Learning...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare a contribution margin income statement...Ch. 6 - Prepare income statements using variable costing...Ch. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.40AECh. 6 - Prob. 6.41BECh. 6 - Prepare income statement in two formats (Learning...Ch. 6 - Use unit cost data to forecast total costs...Ch. 6 - Prob. 6.44BECh. 6 - Sustainability and cost estimation (Learning...Ch. 6 - Create a scatter plot (Learning Objective 3) Tammy...Ch. 6 - Continuation of E6-46B: High-low method (Learning...Ch. 6 - Prob. 6.48BECh. 6 - Prob. 6.49BECh. 6 - Prob. 6.50BECh. 6 - Using the high-low method to predict overhead for...Ch. 6 - Using regression analysis output to predict...Ch. 6 - Prob. 6.53BECh. 6 - Prob. 6.54BECh. 6 - Prob. 6.55BECh. 6 - Prob. 6.56BECh. 6 - Prob. 6.57BECh. 6 - Prob. 6.58BECh. 6 - Prob. 6.59BECh. 6 - Prepare a variable costing income statement given...Ch. 6 - Prob. 6.61BECh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prob. 6.64APCh. 6 - Prob. 6.65APCh. 6 - Prob. 6.66APCh. 6 - Analyze cost behavior at a hospital using various...Ch. 6 - Analyze cost behavior (Learning Objectives 1, 2,...Ch. 6 - Prepare traditional and contribution margin income...Ch. 6 - Prob. 6.70BPCh. 6 - Prob. 6.71BPCh. 6 - Prob. 6.72SCCh. 6 - Cost Behavior in Real Companies Choose a company...Ch. 6 - Ethics of building inventory (Learning Objective...Ch. 6 - Prob. 6.76ACT
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- (Learning Objective 2: Distinguish a capital expenditure from an immediate expense)LimeBike, located in San Mateo, California, is a startup founded in 2017. Its mission isto make shared bicycles accessible and affordable. The company has taken the basic idea ofshared bicycles and eliminated the need to return the bike to a docking station, which may notbe near the cyclist’s destination. LimeBike charges $1 per 30 minutes of riding, or $0.50 perride for students.To use LimeBike, you first use the LimeBike app to locate one of the citrus-colored bikesnear your location. Once you are at the bike, you scan the QR code on the bike or enter thebike’s plate number into the app to unlock the bike. When you are finished using the bike, youpark the bike by a bike rack or post––anywhere that is legal and visible. Once you press downthe back-wheel lock, the trip is finalized and your payment is processed by LimeBike’s app.LimeBike does not depend on government funding, making it appealing to…arrow_forwardTriad Children's Center(TCC), a non-profit organization, uses relevant cost analysis to determine whether new services are desirable. TCC is looking at adding a new education program for grade school children who are having difficulty with the reading and math skills. The following relevant cost are expected if the program is accepted:arrow_forwardThe Shining Stars primary school was the recent recipient of a technology grant to source and implement a school management system. The school administrator is not technology savvy and therefore sought advice from three of the board members who were knowledgeable in the information systems and technology field. One director advised the administrator to purchase an off-the-shelf solution that would allow the school to get the system configured and up and running in a short period with reasonable costs. The second advised the administrator to invest in the development of a unique system to meet the custom requirements of the school’s administration. He suggested that this would create a closer fit to the school’s needs compared to purchasing software, but will cost more. The third director suggested using an open-source solution which would have little if any upfront costs but may require some customization. The school administrator must decide about which solution to go with.…arrow_forward
- Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.You are required to submit this assignment to LopesWrite. Please refer to the directions in the Student Success Center.Paul Duncan, financial manager of EduSoft Inc., is facing a dilemma. The firm was founded 5 years ago to provide educational software for the rapidly expanding primary and secondary school markets. Although EduSoft has done well, the firm's founder believes an industry shakeout is imminent. To survive, EduSoft must grab market share now, and this will require a large infusion of new capital.Because he expects earnings to continue rising sharply and looks for the stock price to follow suit, Mr. Duncan does not think it would be wise to issue new common stock at this time. On the other hand, interest rates are currently high by historical standards, and the firm's B rating means that interest payments on a new debt issue would be prohibitive.…arrow_forwardIn an effort to raise the demand for reading tests, managers are planning to lower the price from $36 per test to $20 per test, the current price of the math test. They believe that doing so will increase the demand for reading tests to 60,000. Prepare a contribution format income statement reflecting Abado’s new pricing and demand structure. Abado Profiles provides testing services to school districts that wish to assess students’ reading and mathematical abilities. Last year Abado evaluated 60,000 math tests and 20,000 reading tests. An income statement for last year follows. Math Testing Reading Testing Total Per Unit Total Per Unit Total Company Sales revenue $1,200,000 $20 $720,000 $36 $1,920,000 Variable expenses 840,000 14 360,000 18 1,200,000 Contribution margin $360,000 $6 $360,000 $18 720,000 Fixed expenses 360,000 Operating income $360,000arrow_forwardBE5.7 - Using Excel to Determine Profitability Given a Constrained Resource Student Work Area PROBLEM Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated. Rachel wants to use her knitting skills to make a little extra money so she can enjoy a theatre weekend with her besties. She’s got the pattern down for a hat, scarf, and mittens, but she realizes that her available time is limited. She should be able to sell as many of any item as she can make, but she wants to make sure she’s making the best use of her time. Cost and time information are provided here. Calculate the contribution margin per unit of the scarce resource for each item. Hat Scarf Mittens Hat Scarf Mittens Contribution margin per Time in minutes 20 30…arrow_forward
- P10-53B Determine transfer price at a manufacturer under various scenarios (Learning Objective 4) Assume the Small Components Division of Lang Manufacturing produces a video card used in the assembly of a variety of electronic products. The division's manufacturing costs, and variable selling expenses related to the video card are as follows: Cost per unit Direct materials $ 14.00 Direct labor $ 4.00 Variable manufacturing overhead $ 8.00 Fixed manufacturing overhead (at current production level) $ 9.00 Variable selling expenses $ 10.00 The Computer Division of Lang Manufacturing can use the video card produced by the Small Components Division and is interested in purchasing the video card in-house rather than buying it from an outside supplier. The Small Components Division has sufficient excess capacity with which to make the extra video cards. Because of competition, the market price for this video card is $30 regardless of whether the…arrow_forwardLearning curve, cumulative average-time learning model. Northern Defense manufactures radar systems. It has just completed the manufacture of its first newly designed system, RS-32. Manufacturing data for the RS-32 follow: Calculate the total variable costs of producing 2, 4, and 8 units.arrow_forwardFNG Paint (Pty) Ltd produces finger paint and sells them to pre‐schools. The following information relates to a set of finger paint. A set of finger paint is considered to be one unit. Direct labour needed for the first set of paint 4 hoursDirect labour costs per unit R30 per hourDirect material costs per unit R25Total Fixed costs R2 000Learning curve 80% Using the learning curve theory and information provided above, calculate the expected average cost for one set of paint should four and sixteen sets be produced, respectively. Round off to two decimal places.arrow_forward
- a) You have been recruited by Education-For-ALL (EFA), an NGO providing teaching and learning support for Students of Second Cycle Schools in Ghost Town, as a Cost Accounting Tutor. During a lesson on the topic “Nature and Scope of Cost Accounting”, a student raised his hand and asked you about what difference there is, if any, between cost accounting and financial accounting. Based on the scope, timing, users of accounting information, reports and standards, explain, with examples, the difference between cost accounting and financial accounting. Define the term Cost, and explain how cost of a product is ascertained when: i. a product is self-constructed or manufactured in-house. ii. a product is a finished product that has been imported. iii. a product is a finished product that has been purchased. Cost accounting as a sub accounting system provides cost information for financial accounting and managerial accounting. List two (2) each of the information cost accounting provides…arrow_forwardThe Allegheny School of Music has hired you as a consultant to help in analyzing the behavior of the school’s costs. Use the account-classification method of cost estimation to classify each of the following costs as variable, fixed, or semivariable. Before classifying the costs, choose an appropriate measure for the school’s activity. 1.Salaries and fringe benefits of the school’s full-time teachers. 2.Salaries and fringe benefits of the school’s full-time administrative staff. 3.Cost of buying books, sheet music, and other academic materials that are supplied to the students by the school. 4.Repairs on musical instruments. The school employs a full-time repair technician. Repair jobs that are beyond the technician’s capability are taken to a local musical-instrument dealer for repairs. 5.Fee charged by a local public accounting firm to audit the school’s accounting records. 6.Wages of the school’s part-time assistant recital instructors. These employees are hired on a tem-porary…arrow_forwardPLEASE ONLY ANSWER QUESTIONS 2,3 AND 4 Alameda Tile sells products to many people remodeling their homes and thinks that it could profitably offer courses on tile installation, which might also increase the demand for its products. The basic installation course has the following (tentative) price and cost characteristics. Tuition $ 430 per student Variable costs (tiles, supplies, and so on) 240 per student Fixed costs (advertising, salaries, and so on) 91,200 per year Required: a. What enrollment will enable Alameda Tile to break even? b. How many students will enable Alameda Tile to make an operating profit of $51,300 for the year? c. Assume that the projected enrollment for the year is 840 students for each of the following (considered independently): 1. What will be the operating profit (for 840 students)? 2. What would be the operating profit if the tuition per student (that is, sales price) decreased by 5 percent? Increased by 22 percent? 3.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license