Managerial Accounting (5th Edition)
5th Edition
ISBN: 9780134128528
Author: Karen W. Braun, Wendy M. Tietz
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
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…
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…
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
- 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 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_forwardTechPro 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_forward
- A marketing professor at Givens College is interested in the relationship between hours spent studying and total points earned in a course. Data collected on 156 students who took the course last semester are provided in the tile MktHrsPts. Develop a scatter chart for these data. What does the scatter chart indicate about the relationship between total points earned and hours spent studying? Develop an estimated regression equation showing how total points earned is related to hours spent studying. What is the estimated regression model? Test whether each of the regression parameters β0 and β1 is equal to zero at a 0.01 level of significance. What are the correct interpretations of the estimated regression parameters? Are these interpretations reasonable? How much of the variation in the sample values of total point earned does the model you estimated in part (b) explain? Mark Sweeney spent 95 hours studying. Use the regression model you estimated in part (b) to predict the total points Mark earned.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_forwardYou are the accountant for the Best Outdoor Living company which manufactures various outdoor furniture. The furniture is sold by specialty stores and through internet outlets. You are responsible for reviewing costs and creating standards costs based on the information you have reviewed. One of your former colleagues has recently started a company to collect and sell data on industry benchmarks. You are offered the chance to receive benchmarks from other outdoor furniture companies for free if you will provide the standard and actual costs for the last three years of your company. As creation of the standards is a tedious process, you feel this data would be helpful in your job. Review the IMA’s ethical guidelines, under Reading Preparation and identify the conflict with the guidelines. What are the relevant factors in this situation and how you should handle this, and what you would recommend to the Controllerarrow_forward
- 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?arrow_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_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_forward
- 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 costarrow_forwardProfit 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,000arrow_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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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