Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017: Maintenance Machine Health Number of Shipping Costs Units Month Costs Hours Insurance Employees Shipped 7,160 $4,500 $4,452 $4,600 $4,850 $8,600 $8,600 S8,600 $8,600 $8,600 January February March $25,776 $29,664 165 68 120 75 8,240 $28,674 $23,058 $21,294 $3,282 230 92 7,965 April May 318 105 6,405 $5,166 $4,760 $4,910 $4,960 $5,070 $5,250 $5,271 $4,760 460 89 5,915 $8,600 $8,600 $8,600 $8,6 $8,600 $8,600 $8,600 June 280 87 9,245 340 $31,428 $30,294 $25,110 $25,866 $20,124 $34,596 July August September 93 8,730 8,415 6,975 7,185 5,590 9,610 360 88 420 95 October 495 102 November 510 97 December 275 94

Stein Corporation wants to find an equation to estimate some of their monthly operating costs for the operating budget for 2018. The following cost and other data were gathered for 2017: Maintenance Machine Health Number of Shipping Costs Units Month Costs Hours Insurance Employees Shipped 7,160 $4,500 $4,452 $4,600 $4,850 $8,600 $8,600 S8,600 $8,600 $8,600 January February March $25,776 $29,664 165 68 120 75 8,240 $28,674 $23,058 $21,294 $3,282 230 92 7,965 April May 318 105 6,405 $5,166 $4,760 $4,910 $4,960 $5,070 $5,250 $5,271 $4,760 460 89 5,915 $8,600 $8,600 $8,600 $8,6 $8,600 $8,600 $8,600 June 280 87 9,245 340 $31,428 $30,294 $25,110 $25,866 $20,124 $34,596 July August September 93 8,730 8,415 6,975 7,185 5,590 9,610 360 88 420 95 October 495 102 November 510 97 December 275 94

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

Prepare the Income Statement using the Absorption Costing method. The following information was extracted from the accounting records of Hilton Manufacturers for the year ended September 2024: UNITS Inventory at the beginning of the year Nil Production for the year 28 500 Sales for the year 24 000 Selling price per unit R82 R Direct Materials cost per unit 22 Direct Labour cost per unit 11 Variable Manufacturing overheads per unit 7 Variable selling and administrative cost per unit 5 Fixed manufacturing overhead cost 274 000 Fixed selling and administrative cost 95 000
Following is the revenue and cost data for Metlock Ltd. in the manufacturing of luxury shower curtains for the year ended December 31, 2022: NewsVariable manufacturing costs $34 per curtainVariable selling and administrative expenses $8 per curtain Fixed manufacturing overhead $53,900Fixed selling and administrative expenses $184,800 Units produced and sold 7, 700Selling price $84 per curtain. Prepare an income statement using absorption costing. Prepare an income statement using variable costing.
Harris Company manufactures and sells a single product. A partially completed schedule of the company's total costs and costs per unit over the relevant range of 65,000 to 105,000 units is given below: Required: 1. Complete the schedule of the company's total costs and costs per unit as given in the relevant tab below. 2. Assume that the company produces and sells 95,000 units during the year at a selling price of $9.36 per unit. Prepare a contribution format income statement for the year. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Complete the schedule of the company's total costs and costs per unit as given in the relevant tab below. (Round the per unit variable cost and fixed cost to 2 decimal places.) Total cost Variable cost Fixed cost Total cost Cost per unit: Variable cost Fixed cost Total cost per unit $ $ $ 65,000 Units Produced and Sold 85,000 214,500 430,000 644,500 $ 0.00 $ 43,000 43,000 $ 0.00 $ 105,000 43,000 43,000 0.00
Marlin Company has the following projected costs for manufacturing and selling and administrative expenses: (Click the icon to view the projected costs.) Prepare a schedule of cash payments for Marlin for January, February, and March. Determine the balances in Prepaid Property Taxes, Accounts Payable, and Utilities Payable as of March 31. (Assume the company started operations in January. If an input field is not used in the table leave the input field empty; do not enter a zero.) Cash Payments Direct Materials: Accounts Payable balance, January 1 January-Direct material purchases paid in February February-Direct material purchases paid in March Total payments for direct materials Direct Labor: Total payments for direct labor January February March Total Data table Direct materials purchases Direct labor costs Depreciation on plant Utilities for plant Property taxes on plant Depreciation on office Utilities for office Property taxes on office Office salaries Print January February…
On April 1, 2019, James Co. purchased 9%, P4,000,000 face value bonds of Mighty Co. forP3,740,000. In addition, James Co. paid P10,000 commission and P11,727 taxes related tothe purchase. The bonds are dated April 1, 2019 and will mature on April 1, 2022. Interestis paid every April 1 and October 1.Required: (Use continuous factors and round off all computations to the nearest peso.)1. Assume the business model of James Co. is to collect contractual cash flows. What isthe carrying amount of the investment in bonds on December 31, 2019? Round offeffective interest rate to nearest two decimal places. e.g. 12.3456% -> 12.34%,12.19999% -> 12.20%, 0.0920001 -> 0.0920 or 9.20%2. Assume the bonds are classified as "trading securities." The fair value on December 31.2019 is 96. If P1,000,000 face value bonds are sold at 97 plus accrued interest onNovember 1, 2020, how much is the total cash received from the sale?3. Assume that the bonds are classified as "Financial Asset-FVOCI." The…
Compute for the total cost per month using costing labor cost by the given data Compute for the percentage weight of the monetary benefit, non monetary benefit, and deferred monetary benefit Compute for the percentage of cost relevant to the sales of total labor cost, given that there are 40 employees in the company and the revenue of the company is 2,500,000 monthly.
Assume that a company provided the following cost formulas for three of its expenses (where q refers to the number of hours worked): Rent (fixed) $ 3,000 Supplies (variable) $ 4.00q Utilities (mixed) $150 + $0.75q The company’s planned level of activity was 2,000 hours and its actual level of activity was 1,900 hours. If these are the company’s only three expenses and the company uses revenue formula of $8.40q for budgeting purposes, what net operating income would appear in the company’s flexible budget?
Required information [The following information applies to the questions displayed below.] Hudson Co. reports the contribution margin income statement for 2019. HUDSON Co. Contribution Margin Income Statement For Year Ended December 31, 2019 Sales (10,600 units at $300 each) Variable costs (10,600 units at $240 each) Contribution margin $3,180,000 2,544,000 636,000 480,000 Fixed costs Pretax income 156,000 1. Assume Hudson Co. has a target pretax income of $172,000 for 2020. What amount of sales (in dollars) is needed to produce this target income? 2. If Hudson achieves its target pretax income for 2020, what is its margin of safety (in percent)? (Round your answer to 1 decimal place.) 1. Amount of sales 2. Margin of safety
Can somebody check my work on the variable costing income statement in the screenshot attached? Summarized data for 2019 (the first year of operations) for Gorman Products, In. are as follows Sales (70,000 units) $2,800,000 Production costs (80,000 units): Direct materials 880,000 Direct labor 720,000 Manufacturing overhead: Variable 544,000 Fixed 320,000 Operating expenses: Variable 175,000 Fixed 240,000 Depreciation on equipment 60,000 Real estate taxes 18,000 Personal property taxes (inventory and equipment 28,000 Personnel department expenses 30,000 Problem b) Prepare an income statement based on variable costing
Calculate the Return on Investment from the following responsibility report data using total revenue as the base: Responsibility report data Account Actual Revenues Clothing revenue $473,158 Clothing accessories revenue 18,757 Expenses Associates wages $41,704 Managers wages 22,906 Cost of clothing sold 254,631 Cost of accessories sold 5,969 Equipment/fixture repairs 960 Utilities 1,539 Round to two decimal places. Be sure to enter the answer as a percentage but do not include the % sign.
Complete this question by entering your answers in the tabs below. Sims Company, a manufacturer of tablet computers, began operations on January 1, 2019. Its cost and sales information for this year follows. Manufacturing costs Direct materials $ 35 per unit Direct labor $ 55 per unit Overhead costs Variable $ 30 per unit Fixed $ 7,350,000 (per year) Selling and administrative costs for the year Variable $ 775,000 Fixed $ 4,500,000 Production and sales for the year Units produced 105,000 units Units sold 75,000 units Sales price per unit $ 360 per unit Required 1 Required 2 Prepare an income statement for the year using variable costing. SIMS COMPANY Variable Costing Income Statement Net income (loss)
can you show work and show how to do it in excel?