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:
Gulf States Manufacturing Budgeted Income Statement For Year 2
Sales Revenue ($1,800,000×1.15×1.04) | $2,152,800 |
Manufacturing Costs; | |
Materials ($321,000×1.15×1.13) | $417,139.50 |
Variable Cash Costs ($439,000×1.15×.97) | $489,704.50 |
Fixed Cash Costs ($177,000×.90) | $159,300 |
Depreciation(Fixed)($217,000 -$16,350 +$22,800) | $223,450 |
Total Manufacturing Costs | $1,289,594 |
Marketing and Administrative Costs; | |
Marketing (Variable , Cash)($232,000×1.15) | $266,800 |
Marketing Depreciation | $57,000 |
Administrative(Fixed, Cash)($228,000×1.11) | $253,080 |
Administrative Depreciation | $20,000 |
Total Marketing and Administrative Costs | $596,880 |
Total Costs | $1,886,474 |
Operating Profit | $266,326 |
Would be helpful if you show in excel with calculations Gulf States Manufacturing has the following...
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...
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 The following information is available for year 1 for Pepper Products: 13 The following information is available for year 1 for Pepper Products: 58, 189, Bee 10 points $ 478.ee 485, Bee 935, ee 2,851, Bee Besk Sales revenue (320, Bee 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...
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...
13-51. Prepare Budgeted Financial Statements (LO 13-6) eXcel The following information is available for year 1 for Pepper Products. $2,850,000 Sales revenue (200,000 units) Manufacturing costs $168,000 Materials 142,400 327,600 Variable cash costs Fixed cash costs Depreciation (fixed) Marketing and administrative costs 999,000 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...
The following information is available for year 1 for Pepper Products: $3,510,000 $ 208,000 177,000 408,000 1,244,000 Sales revenue (130,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 525,000 186,000 633,000 94,000 $3,475,000 35,000 All depreciation charges are fixed and are expected to remain the same for year 2. Sales volume is expected to fall by 6 percent,...
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: 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 (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: $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...