Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134067254
Author: Braun
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 6, Problem 6.46BE
Create a scatter plot (Learning Objective 3)
Tammy Lotta, owner of Fourth Street Floral, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Lotta wants to set the delivery fee based on the distance driven to deliver the flowers. Lotta 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,800 | $5,460 |
| February | 17,300 | $5,680 |
| March | 14,600 | $4,940 |
| April | 16,000 | $5,310 |
| May | 17,100 | $5,830 |
| June | 15,400 | $5,420 |
| July | 14,100 | $4,880 |
Requirements
- 1. Prepare a scatterplot of Fourth Street Floral’s volume (miles driven) and van operating costs.
- 2. Do the data appear to contain any outliers? Explain.
- 3. How strong of a relationship is there between miles driven and van operating expenses?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Assume that you have decided to drive your car to Florida for the spring break. A classmate learns about your plans and asks about
riding along with you.
Required:
Select how you would apply each of the following cost concepts to the task of determining how much, if any, cost you would take into
consideration for the purposes of setting a price to be charged for taking the classmate with you.
a. Differential cost
b. Allocated cost
c. Sunk cost
d. Opportunity cost
How to allocate? Based on number of people, weight, number
of suitcases, or what?
What are other opportunities for you to earn revenue? What is
the cost of alternative travel for your classmate?
What costs have already been incurred and cannot be
recovered, even if you don't make the trip?
What costs will differ if a friend comes along?
Assume that you have decided to drive your car to Florida for the spring break. A classmate learns about your plans and asks about
riding along with you.
Required:
Select how you would apply each of the following cost concepts to the task of determining how much, if any, cost you would take into
consideration for the purposes of setting a price to be charged for taking the classmate with you.
a. Differential cost
b. Allocated cost
c. Sunk cost
d. Opportunity cost
BE5.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…
Chapter 6 Solutions
Managerial Accounting (5th Edition)
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
- 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 alternativearrow_forwardCalculating costs using traditional and activity-based systems Bubba and Danny are college friends planning a skiing trip to Killington before the new year. They estimated the following for the trip: Requirements Bubba suggests that the costs be shared equally. Calculate the amount each person would pay. Danny does not like the idea of sharing the costs equally because he plans to stay in the room rather than ski. Danny suggests that each type of cost be allocated to each person based on the above-listed allocation bases. Using the activity allocation for each person, calculate the amount that each person would pay based on his own consumption of the activity.arrow_forwardhe 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…arrow_forward
- TechPro offers instructional courses in e-commerce website design. The company holds classes in a buildingthat it owns. Classify each of TechPro’s costs below as (a) variable (V) or fixed (F) and (b) direct (D)or indirect (I). Assume the cost object is an individual class.1. Depreciation on classroom building2. Monthly Internet connection cost3. Instructional manuals for students4. Travel expenses for salesperson5. Depreciation on computers used for classes6. Instructor wage (per class)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_forwardMementos Academy is assessing whether to outsource its student enrolment processes. The general process followed by staff in the enrolment office is to first validate students’ prior academic record (e.g., secondary school results) and send an offer of enrolment, provide degree advice and enter students’ study program details into the student record system, and collect fees. The following table shows the costs associated with these three processes: Cost Validation Student records Fees collection Staff salaries 70,400 43,900 39,700 Data processing 9,200 32,500 7,900 Telephone 1,700 4,600 3,000 Postage - 1,500 4,000 Consumables 3,700 45,900 11,800 Electricity 1,600 3,100 3,000 Equipment depreciation 12,200 35,800 31,900 Insurance…arrow_forward
- Your friend, Suzie Chang, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie's product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow. Factory rent Company advertising Wages paid to assembly workers Depreciation for salespersons' vehicles Screws Utilities for factory Assembly supervisor's salary Sandpaper President's salary $ 3,020 1, 010 30, 300 2,070 510 840 3,550 105 5,190 4,080 Plastic tubing Paint Sales commissions Factory insurance Depreciation on cutting machines Wages paid to painters Assume that Suzie Chang has decided to begin production of her outdoor children's toy. 280 1, 390 1,070 2,180 7,800 Required: 1 & 2. Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for direct materials (DM), direct labor (DL), or manufacturing overhead…arrow_forwardYour friend, Suzie Chang, has designed a new type of outdoor toy that helps children learn basic concepts such as colors, numbers, and shapes. Suzie's product will target two groups: day care centers in warm climates and home school programs. Her company is Jiffy Jet and costs for last month follow. Factory rent Company advertising Wages paid to assembly workers Depreciation for salespersons' vehicles Screws Utilities for factory Assembly supervisor's salary Sandpaper President's salary Plastic tubing Paint Sales commissions Factory insurance Req 1 and 2 $ 3,050 1,050 30,600 2,200 580 880 1,210 1,060 Depreciation on cutting machines 2,090 Wages paid to painters 8,150 Assume that Suzie Chang has decided to begin production of her outdoor children's toy. Required: 1 & 2. Identify each of the preceding costs as either a product or a period cost. If the cost is a product cost, decide whether it is for direct materials (DM), direct labor (DL), or manufacturing overhead (MOH) and also…arrow_forwardKara Meyer, owner of Flower Power, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Meyer wants to set the delivery fee based on the distance driven to deliver the flowers. Meyer wants to separate the fixed and variable portions of her van operating costs so that she has a better idea how delivery distance affects these costs. She has the following data from the past seven months: (Click the icon to view the data.) Read the requirements. Requirement 1. Determine the company's cost equation (use the output from the Excel regression). (Ro y = x + Data table Month January.. February March April May June July Miles Driven 16,400 17,500 15,000 16,100 17,300 15,600 14,500 Print Van Operating Costs $5,480 $5,400 $4,950 $5,270 $5,740 $5,440 $4,680 Done - Xarrow_forward
- The 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_forwardAlameda 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. Need Assistance with Req C2, Req C3, Req C4arrow_forwardCathy Gwynn for a class project is analyzing a "Quick Shop" grocery store. The store emphasizes quick service, a limited assortment of grocery items, and higher prices. Cathy wants to see if the store hours (currently 0600 to 0100) can be changed to make the store more profitable. Daily Sales in Time Period the Time Period 0600–0700 $ 40 0700–0800 80 0800–0900 120 0900–1200 400 1200–1500 500 1500–1800 600 1800–2100 800 2100–2200 200 2200–2300 60 2300–2400 120 2400–0100 40 The cost of the groceries sold averages 70% of sales. The incremental cost to keep the store open, including the clerk's wage and other operat- ing costs, is $22 per hour. To maximize profit, when should the store be opened, and when should it be closed?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,
Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSON
Intermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill Education
Financial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Inspection and Quality control in Manufacturing. What is quality inspection?; Author: Educationleaves;https://www.youtube.com/watch?v=Ey4MqC7Kp7g;License: Standard youtube license