i) ii) 5. Susan Wesley obtains monthly production cost information from the financial accounting department of Bikes Unlimited for the last 12 months. Total Production Costs Reporting Period (Month) July August September October November December January February March April May June $230,000 250,000 260,000 220,000 340,000 330,000 200,000 210,000 240,000 380,000 350,000 290,000 Level of Activity (Units Produced) 3,500 3,750 3,800 3,400 5,800 5,500 2,900 3,300 3,600 5,900 5,600 5,000 Determine the equation of the total mixed cost function, using the high-low method. Prepare the scatter gram, and use the "line of best fit" to determine the company's fixed cost per month and the variable cost per unit.

i) ii) 5. Susan Wesley obtains monthly production cost information from the financial accounting department of Bikes Unlimited for the last 12 months. Total Production Costs Reporting Period (Month) July August September October November December January February March April May June $230,000 250,000 260,000 220,000 340,000 330,000 200,000 210,000 240,000 380,000 350,000 290,000 Level of Activity (Units Produced) 3,500 3,750 3,800 3,400 5,800 5,500 2,900 3,300 3,600 5,900 5,600 5,000 Determine the equation of the total mixed cost function, using the high-low method. Prepare the scatter gram, and use the "line of best fit" to determine the company's fixed cost per month and the variable cost per unit.

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Betty DeRose, Inc. manufactures and sells a single product. Information related to the cost of producing this product for the past six months is provided below: Units Produced 5,360 4,840 7,580 4,930 6,110 7,620 Month June July August September October November Total Cost Incurred $126,017 $118,831 $155,833 $119,246 $136,932 $157, 195 Betty DeRose, Inc. expects to produce 6,495 units of this product during December. Using the high-low method, calculate Betty DeRose, Inc's expected total cost incurred for December.
Acacia Manufacturing has compiled the following information from the accounting system for the one product it sells: $45 per unit Sales price Fixed costs (for the month) Marketing and administrative Manufacturing overhead Variable costs (per unit) Marketing and administrative Direct materials Manufacturing overhead Direct labor Units produced and sold (for the month) Required: a. Calculate the product costs per unit Note: Round your answer to 2 decimal places. b. Calculate the period costs for the period. $ 23,100 $ 8,400 Exercise 2-55 (Static) Components of Full Costs (LO 2-6) a. Product costs per unit b. Period costs $2 $ 13 $3 $9 21,000
Zachary Corporation paid one of its sales representatives $8,500 during the month of March. The rep is paid a base salary plus $11 per unit of product sold. During March, the rep sold 170 units. Required Calculate the total monthly cost of the sales representative's salary for each of the following months. Month Number of units sold i Total variable cost Total fixed cost Total salary cost $ April 210 0 $ May 120 0 $ June 220 0 $ July 130 0
Robin Inc. provides the following manufacturing costs for the Third quarter of the year in the table below. Manufacturing Costs for the Third Quarter Months Production in Units Total Costs July 3,800 $59,550 August 4,200 $62,450 September 5,500 $71,875 Using the high-low method, determine the variable costs per unit. (Round intermediate calculations and your final answer to two decimal places.) Group of answer choices $14.37 $13.07 $7.25 $15.67
Current Attempt in Progress The controller of Oriole Industries has collected the following monthly cost data for use in analyzing the behavior of maintenance costs. Month January February March April May June Total Maintenance Costs $2,860 3,160 3,760 4,660 3,360 5,260 Total Machine Hours 320 370 520 670 520 720
The following information pertains to the first year of operation for Crystal Cold Coolers Inc.: Number of units produced Number of units sold Unit sales price Direct materials per unit Direct labor per unit Variable manufacturing overhead per unit Fixed manufacturing overhead per unit ($224,000/2,800 units) Total variable selling expenses ($11 per unit sold) Total fixed general and administrative expenses Complete this question by entering your answers in the tabs below. Required: Prepare Crystal Cold's full absorption costing income statement and variable costing income statement for the year. Full Absorption Costing 2,800 2,400 340 60 45 13 80 Variable Costing $ 26,400 $ 60,000
The manufacturing costs of Mocha Industries for three months of the year are as follows: Month Total Cost Production April $79,092 1,440 units May 80,136 2,020 units June 81,756 2,920 units a. Using the high-low method, determine the variable cost per unit. Round your answer to two decimal places.fill in the blank 1 of 1$ per unit b. Using the high-low method, determine the total fixed costs.
Robin Inc. shows the following manufacturing costs for the Third quarter of the year: Production Total in Units Costs July 3,800 $59,550 August 4,200 $62,450 September 5,500 $71,875 Using the high-low method, determine the total fixed costs. (Round intermediate calculations to two decimal places, and the final calculation to the nearest dollar.) $39,875 $27,550 $39,875 $32,000
Intercontinental, inc., provides you with the following data for its single product Sales price per unit $ 50.00 Fixed costs (per month) Selling, general, and administrative (SG&A) 1,350,000 Manufacturing overhead 2,700,000 Variable costs (per unit) Direct labor 7.00 Direct materials 12.00 Manufacturing overhead 10.00 SG&A…
Fanning Corporation paid one of its sales representatives $4,000 during the month of March. The rep is paid a base salary plus $11 per unit of product sold. During March, the rep sold 150 units. Required Calculate the total monthly cost of the sales representative's salary for each of the following months. Month April May June July Number of units sold Total variable cost Total fixed cost Total salary cost 190 100 200 110 24 $
The following product costs are available for Arrez Company on the production of DVD cases: direct materials, $1,120; direct labor, $15.50; manufacturing overhead, applied at 150% of direct labor cost; selling expenses, $1,450; and administrative expenses, $950. The direct labor hours worked for the month are 90 hours. Round your answers to two decimal places. A. What are the prime costs? $fill in the blank 1 B. What are the conversion costs? $fill in the blank 2 C. What is the total product cost? $fill in the blank 3 D. What is the total period cost? $fill in the blank 4 E. If 1,400 equivalent units are produced, what is the equivalent material cost per unit? $fill in the blank 5 F. What is the equivalent conversion cost per unit?
The table below shows monthly data collected on production costs and on the number ofunits produced over a twelve month period Month Total Production Cost Level of Activity(Units Produced) July $230,000 3,500 August 250,000 3,750 September 260,000 3,800 October 220,000 3,400 November 340,000 5,800 December 330,000 5,500 January 200,000 2,900 February 210,000 3,300 March 240,000 3,600 April 380,000 5,900 May 350,000 5,600 June 290,000 5,000 Varible cost per unit = $60.00 The total mixed cost equationThe total mixed cost equation = y=a+bx y = $26,000 + $60xTo solve the equation, total no. of units can be added at 'x' place. Scatter diagram attached. Showing Outliers a) Using the line of best-fit, determine the company’s fixed costper month and thevariable cost per unit. (Use 0 & 5,000 units.)b) In view of the department’s cost behaviour pattern, which of the two methodsappear more appropriate? Explain your answer