Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates:
Sales revenues (16,000 units) | $ | 1,440,000 |
Manufacturing costs | ||
Materials | $ | 257,000 |
Variable cash costs | 351,000 | |
Fixed cash costs | 141,000 | |
Depreciation (fixed) | 173,000 | |
Marketing and administrative costs | ||
Marketing (variable, cash) | 184,000 | |
Marketing depreciation | 45,000 | |
Administrative (fixed, cash) | 180,000 | |
Administrative depreciation | $ | 16,000 |
Total costs | $ | 1,347,000 |
Operating profits | $ | 93,000 |
All depreciation charges are fixed. Old manufacturing equipment
with an annual depreciation charge of $15,950 will be replaced in
year 2 with new equipment that will incur an annual depreciation
charge of $22,400. Sales volume and prices are expected to increase
by 12 percent and 6 percent, respectively. On a per-unit basis,
expectations are that materials costs will increase by 10 percent
and variable manufacturing costs will decrease by 2 percent. Fixed
cash manufacturing costs are expected to decrease by 7 percent.
Variable marketing costs will change with volume. Administrative cash costs are expected to increase by 8 percent. Inventories are kept at zero. Gulf States operates on a cash basis.
1.
Required information
Required:
Prepare a budgeted income statement for year 2. (Do not round intermediate calculations.)
Required:
Estimate the cash from operations expected in year 2. (Do not round intermediate calculations.)
Gulf States Manufacturing has the following data from year 1 operations, which are to be used...
Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: Sales revenues (14,000 units) $ 1,260,000 Manufacturing costs Materials $ 225,000 Variable cash costs 307,000 Fixed cash costs 123,000 Depreciation (fixed) 151,000 Marketing and administrative costs Marketing (variable, cash) 160,000 Marketing depreciation 39,000 Administrative (fixed, cash) 156,000 Administrative depreciation $ 14,000 Total costs $ 1,175,000 Operating profits $ 85,000 All depreciation charges are fixed. Old manufacturing equipment with...
Would be helpful if you show in excel with calculations Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: 14 Required Information The following information applies to the questions displayed below.] 10 point Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: Eeck $1,800,000 Sales revenues (20,000 units) Manufacturing costs Materials Variable cash costs...
book contents p to pg go 13-48. Estimate Cash from Operations (LO 13 5) Refer to the data in Problem 13-47. Estimate the cash from operations expected in year 2 13-49. Prepare Budgeted Financial Statements (LO 13 4, 6) eXcel Gulf States Manufacturing has the following data from year 1 operations, which are to be used for developing year 2 budget estimates: $2,500,000 Sales revenue (37,500 units)... .. Manufacturing costs Materials.. $400,000 545,000 216,000 267,000 Variable cash costs Fixed cash...
The following information is available for year 1 for Pepper Products: $2,900,000 $ 168,000 152,400 327,600 989,000 Sales revenue (200,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 412,400 149,600 509,200 64,800 $2,773,000 $ 127,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by 4...
The following information is available for year 1 for Pepper Products: Sales revenue (210,000 units) $ 3,150,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 337,600 Depreciation (fixed) 1,009,000 Marketing and administrative costs Marketing (variable, cash) 412,400 Marketing depreciation 159,600 Administrative (fixed, cash) 509,200 Administrative depreciation 84,800 Total costs $ 2,823,000 Operating profits $ 327,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: Sales revenue (210,000 units) $ 3,150,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 327,600 Depreciation (fixed) 989,000 Marketing and administrative costs Marketing (variable, cash) 422,400 Marketing depreciation 159,600 Administrative (fixed, cash) 509,200 Administrative depreciation 84,800 Total costs $ 2,803,000 Operating profits $ 347,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: Sales revenue (200,000 units) $ 2,850,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 327,600 Depreciation (fixed) 999,000 Marketing and administrative costs Marketing (variable, cash) 422,400 Marketing depreciation 149,600 Administrative (fixed, cash) 509,200 Administrative depreciation 74,800 Total costs $ 2,793,000 Operating profits $ 57,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: Sales revenue (200,000 units) $ 3,000,000 Manufacturing costs Materials $ 168,000 Variable cash costs 142,400 Fixed cash costs 317,600 Depreciation (fixed) 989,000 Marketing and administrative costs Marketing (variable, cash) 432,400 Marketing depreciation 149,600 Administrative (fixed, cash) 519,200 Administrative depreciation 74,800 Total costs $ 2,793,000 Operating profits $ 207,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: Sales revenue (240,000 units) $ 3,840,000 Manufacturing costs Materials $ 226,000 Variable cash costs 192,000 Fixed cash costs 442,000 Depreciation (fixed) 1,348,000 Marketing and administrative costs Marketing (variable, cash) 570,000 Marketing depreciation 202,000 Administrative (fixed, cash) 687,000 Administrative depreciation 101,000 Total costs $ 3,768,000 Operating profits $ 72,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected...
The following information is available for year 1 for Pepper Products: $2,760,000 $ 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 164,000 140,000 323,000 985,000 416,000 147,000 500,000 74.000 52, 749,000 $ 11,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by...