Continuation of E6-25A: High-low method (Learning Objective 4)
Refer to Broadway Floral’s data in E6-25A. Use the high-low method to determine Broadway Floral’s cost equation for van operating costs. Use your results to predict van operating costs at a volume of 16,500 miles.
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 |
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Managerial Accounting (5th Edition)
- S2-4 Classify costs as direct or indirect (Learning Objective 3) Classify each of the following costs as a direct cost or an indirect cost, assuming that the cost object is the Juniors Department (clothing and accessories for teenage and young women) in the Stow Kohl's department store. (Kohl's is a chain of department stores and m has stores located across the United States.) a. Juniors Department sales clerks b. Cost of Juniors clothing gedeweue c. Cost of hangers used to display the clothing in the store d. Electricity for the building e. Cost of radio advertising for the store f. Juniors clothing buyers' salaries (these buyers buy for all the Juniors Departments of Kohl's stores) DESSUGA aitened ane g. Depreciation of the building r in thearrow_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_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
- 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_forwardAssume 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_forwardEnrichment Activity 4: I'll show you my figure & give me your solution! Direction: Read and understand the problem below calculate the cost of goods sold and gross profit. Write your answer on a separate sheet of paper. (10 minutes) Problem A Shoe keeper had bought 1.00 footballs for Ph.30.00 each. One football player comes and bought 10 footballs for 50.00 each. Calculate the cost of goods sold. Show your solution. Problem B XYZ Company has Beginning Inventory Php. 100,000, New Purchases amounting to Php. 450,000 and Ending Inventory is Php. 35,000. Find the cost of goods sold for XYZ Company. Problem C I sell T-shirts, I bought them from the manufacturer for 500.00 for each tshirt. I sold them at 800.00 each. In the month of February, I decided to buy 10 pieces of t -shirts and only seven t-shirts were sold. Compute the cost of goods sold and gross profit. Show your solution.arrow_forward
- Cathy 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_forwardE8-51B. Sell as is or process further (Learning Objective 7) OrganicPlus processes organic milk into plain yogurt. OrganicPlus sells plain yogurt to hospitals, nursing homes, and restaurants in bulk, one- gallon containers. Each batch, processed at a cost of $830, yields 750 gallons of plain yogurt. OrganicPlus sells the one-gallon tubs for $6.00 each and spends $0.10 for each plastic tub. Management has recently begun to reconsider its strategy. OrganicPlus wonders if it would be more profitable to sell individual-sized portions of fruited organic yogurt at local food stores. OrganicPlus could further process each batch of plain yogurt into 16,000 individual portions (3/4 cup each) of fruited yogurt. A recent market analysis indicates that demand for the product exists. OrganicPlus would sell each individual portion for $0.40. Packaging would cost $0.07 per portion, and fruit would cost $0.12 per portion. Fixed costs would not change. Should OrganicPlus continue to sell only the…arrow_forwardClassify costs and make a quality-initiative decision (Learning Objective 5) Sinclair Corp. manufactures radiation-shielding glass panels . Suppose Sinclair is consider-ing spending the following amounts on a new TOM program :Strength-testing one item from each batch of panels ......................... . Training employees in TOM ................................................................. . Training suppliers in TOM .................................................................... . Identifying preferred suppliers that commit to on-time delivery ofperfect quality materials ................................................................... .Sinclair expects the new program to save costs through the following:Avoid lost profits from lost sales due to disappointed customers ....... Avoid rework and spoilage ................................................................. .. Avoid inspection of raw materials ........................................................ . Avoid…arrow_forward
- 58-5 Special order decision (Learning Objective 3) Shilling Manufacturing produces and sells oil filters for $3.25 each. A retailer has offered to purchase 20,000 oil filters for $1.55 per filter. Of the total manufacturing cost per filter of $2.10, $1.30 is the variable manufacturing cost per filter. For this special order, Shilling would have to buy a special stamping machine that costs $8,000 to mark the customer's logo on the special order oil filters. The machine would be scrapped when the special order is complete. This special order would use manufacturing capacity that would other- wise be idle. No variable nonmanufacturing costs would be incurred by the special order. Regular sales would not be affected by the special order. Would you recommend that Shilling accept the special order under these conditions?arrow_forwardE-LEARNING COST ACCOUNTING ASSIGNMENT Answer all the THREE Questions. 1 Mr Gardens, the financial controller of Sugarland Ltd, accidentally tossed the company's cost records into a wastebasket which had been light .On realising that mistake, he rushed to the roaring blaze and managed to retrieve only a few of the records. From the salvaged records, he managed to determine the following facts about the current year 2020: (i) Sales totaled sh 1,000,000 during 2020. (ii) The beginning inventories for the year were: work in progress sh 120,000; Finished goods sh 60,000. (iii) There were no closing inventories of raw materials. (iv) Direct labor is equal to 25% of conversion cost; direct, labor is also equal to 40% of prime cost. (v) The work in progress inventory decreased by sh 20,000 during the year. (vi)Gross margin during the year was 55% of sales. (vii) Manufacturing overheads amounted to sh 240,000 in the year. (iv) Administrative expenses for 2014 were twice as great as net income…arrow_forwardUse ABC to allocate manufacturing overhead (Learning Objective 2)Several years after reengineering its production process, King Corporation hired a new controller, Christine Erickson . She developed an ABC system very similar to the one used by King's chief rival. Part of the reason Erickson developed the ABC system was because King's profits had been declining, even though the company had shifted its product mix toward the product that had appeared most profitable under the old system . Before adopting the new ABC system, the company had used a plantwide overhead rate, based on direct labor hours developed years ago .For the upcoming year, King's budgeted ABC manufacturing overhead allocation rates are as follows :ActivityMaterials handling .......................... Machine setup ................................ Insertion of parts ............................ Finishing .........................................Allocation BaseNumber of partsNumber of setupsNumber of partsFinishing…arrow_forward
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningEssentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage Learning