Required:Estimate the cash from operations expected in year 2.GULF STATES MANUFACTURINGCash Basis Budgeted Income StatementFor Year 2Manufacturing costs:Total manufacturing costsMarketing and administrative costs:Total cash marketing and administrative costsTotal cash costs Required information(The following information applies to the questions displayed below.)Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2budget estimates:Sales revenues (37,500 units)Manufacturing costsMaterialsVariable cash costsFixed cash costsDepreciation (fixed)Marketing and administrative costsMarketing (variable, cash)Marketing depreciationAdministrative (fixed, cash)Administrative depreciationTotal costs$2,500,000$ 400,000545,000216,000267,000285,00067,800270,30025,200$2,076,300$ 423, 700Operating profitsAll depreciation charges are fixed. Old manufacturing equipment with an annual depreciation charge of $29,100 will bereplaced in year 2 with new equipment that will incur an annual depreciation charge of $42,000. Sales volume and pricesare expected to increase by 8 percent and 3 percent, respectively. On a per-unit basis, expectations are that materialscosts will increase by 6 percent and variable manufacturing costs will decrease by 5 percent. Fixed cash manufacturingcosts are expected to decrease by 9 percent.Variable marketing costs will change with volume. Administrative cash costs are expected to increase by 10 percent.Inventories are kept at zero. Gulf States operates on a cash basis.Required:Estimate the cash from operations expected in year 2.

Sales revenue 37,500 * 1.08 * 66.67(approx.) * 1.03 2,781,000 Manufacturing costs: Material…

Answered: Estimate the cash from operations…

Business

Accounting

Estimate the cash from operations expected in year 2.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter28: Statistics And Linear Regression (stats)

Section: Chapter Questions

Problem 1R

See similar textbooks

Similar questions

Torres Company accumulates the following summary data for the year ending December 31, 2020, for its Water Division, which it operates as a profit center: sales—$1,935,600 budget, $2,243,000 actual; variable costs—$1,016,200 budget, $1,051,200 actual; and controllable fixed costs—$297,600 budget, $303,400 actual.Prepare a responsibility report for the Water Division for the year ending December 31, 2020. TORRES COMPANYWater DivisionResponsibility ReportFor the Year Ended December 31, 2020 Difference Budget Actual FavorableUnfavorableNeither Favorablenor Unfavorable Select an opening responsibility report item Contribution MarginControllable Fixed CostsControllable MarginFixed CostsGross ProfitNet Income/(Loss)SalesVariable Costs $Enter a dollar amount $Enter a dollar amount $Enter the difference Select an option…
Required information [The following information applies to the questions displayed below.] The following information is available for Fairmount Industries from year 1 operations: Sales revenue (55,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total cost Operating profits (losses) $ 1,670,000 $ 250,000 555,000 337,000 170,000 181,000 51,000 172,000 20,000 $ 1,735,000 $ (66,000) All depreciation charges are fixed. Old manufacturing equipment with an annual depreciation charge of $32,000 will be fully depreciated by the end of year 1 and will not be replaced with new equipment because it is still operating to specification Sales volume is expected to decrease by 2 percent. Sales price is expected to increase by 8 percent. On a per-unit basis, expectations are that materials costs will decrease by…
How would each of the following costs be classified if units produced is the activity base? a. Salary of factory supervisor ($120,000 per year) b. Straight-line depreciation of plant and equipment c. Property rent of $11,500 per month on plant and equipment
The cost data for Evencoat Paint for the year 2019 is as follows: Using the high-low method, express the companys maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Predict the maintenance costs i190,000 gallons of paint are produced. Predict the maintenance costs if 81,000 gallons of paint are produced. Using Excel, create a scatter graph of the cost data and explain the relationship between gallons of paint produced and equipment maintenance expenses.
Torres Company accumulates the following summary data for the year ending December 31, 2020, for its Water Division, which it operates as a profit center: sales-$2,062,700 budget, $2,288,100 actual; variable costs-$1,000,900 budget, $1,055,500 actual; and controllable fixed costs-$299,000 budget, $303,900 actual. Prepare a responsibility report for the Water Division for the year ending December 31, 2020. TORRES COMPANY Water Division Responsibility Report For the Year Ended December 31, 2020
Compute the residual income for the Manufacturing Division. Greenlink, Inc. produces environment-friendly construction material. The following information is available about the status and operations of the Manufacturing Division of Greenlink, which has a hurdle rate (minimum required rate of return) of 7%. Divisional identifiable average assets $ 414,459 Divisional income from operations $ 18,848 Divisional sales revenue $ 365,726
The following information is available for year 1 for Pepper Products: Sales revenue (120,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs. Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits $2,760,000 $164,000 140,000 323,000 985,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by 8 percent, but prices are expected to rise by 14 percent. Material costs per unit are expected to increase by 15 percent. Other unit variable manufacturing costs are expected to decrease by 8 percent per unit. Fixed cash costs are expected to increase by 7 percent. PEPPER PRODUCTS Budgeted Income Statement For Year 2 Manufacturing costs: 416,000 147,000 500,000 74,000 $2,749,000 11,000 Variable mar costs will change with unit volume. Administrative cash costs are…
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's ManufacturingIncome StatementMonth Ending August 31, 2018
The following information is available for Fairmount Industries from year 1 operations: Sales revenue (58,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits (losses) $ 1,685,000 $ 253,000 558,000 340,000 173,000 184,000 54,000 175,000 21,500 $ 1,758,500 $ (73,500) All depreciation charges are fixed. Old manufacturing equipment with an annual depreciation charge of $35,000 will be fully depreciated by the end of year 1 and will not be replaced with new equipment because it is still operating to specification. Sales volume is expected to decrease by 2 percent. Sales price is expected to increase by 8 percent. On a per-unit basis, expectations are that materials costs will decrease by 5 percent and variable manufacturing cash costs will increase by 4 percent. Fixed cash…
The following information is available for RCA Industries from year 1 operations: Sales revenue (65,000 units) Manufacturing costs Materials Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs Marketing (variable, cash) Marketing depreciation Administrative (fixed, cash) Administrative depreciation Total costs Operating profits (losses) $1,735,000 $ 260,000 565,000 347,000 180,000 191,000 61,000 182,000 25,000 $1,811,000 $ (76,000) All depreciation charges are fixed. Sales volume is expected to decrease by 2 percent. Sales price is expected to increase by 8 percent. On a per-unit basis, expectations are that materials costs will decrease by 5 percent and variable manufacturing cash costs will increase by 4 percent. Fixed cash manufacturing costs are expected to increase by 12 percent. Variable marketing costs will change with volume. Administrative cash costs are expected to decrease by 15 percent. Inventories are kept at zero. Fairmount…
Assume you are the department B manager for Marley's Manufacturing. Marley's operates under a cost-based transfer structure. Assume you receive the majority of your raw materials from department A, which sells only to department B (they have no outside sales). After calculating the operating income in dollars and operating income in percentage, analyze the following financial information to determine costs that may need further investigation. Marley's Manufacturing Income Statement Month Ending August 31, 2018 Dept. A Dept. B Sales $22,000 $52,000 Cost of goods sold 10,780 27,040 Gross profit $11,220 $24,960 Expenses: Utility expenses $880 $3,640 Wages expense 5,280 10,920 Costs allocated from corporate 1,980 14,560 Total expenses $8,140 $29,120 Operating income/(loss) in dollars $ $ Operating income/(loss) in percentage % Department B had an operating loss. Department A had an operating loss. Department B has a higher wage percent of sales. Department A receives a higher percent…
Required: a) Using Activity Based Costing, calculate the rate for each cost driver. b) Using activity based budgeting, prepare a budgeted yearly operating statement for Aero3D Ltd. Show the following separately, within the statement. i. The budgeted output for each product per year; ii. The contribution to profits for each product and in total before charging activity based costs; iii. The profit for each product and in total after charging activity based costs but before charging core costs (non-activity based costs); iv. The total profit after charging core based costs.