Question

In: Accounting

Problem 13-53 & 13-54 (Algo) (LO 13-4, 5, 6) [The following information applies to the questions...

Problem 13-53 & 13-54 (Algo) (LO 13-4, 5, 6)

[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 2 budget estimates:

Sales revenues (18,000 units) $ 1,620,000
Manufacturing costs
Materials $ 289,000
Variable cash costs 395,000
Fixed cash costs 159,000
Depreciation (fixed) 195,000
Marketing and administrative costs
Marketing (variable, cash) 208,000
Marketing depreciation 51,000
Administrative (fixed, cash) 204,000
Administrative depreciation $ 18,000
Total costs $ 1,519,000
Operating profits $ 101,000


All depreciation charges are fixed. Old manufacturing equipment with an annual depreciation charge of $16,150 will be replaced in year 2 with new equipment that will incur an annual depreciation charge of $22,600. Sales volume and prices are expected to increase by 10 percent and 6 percent, respectively. On a per-unit basis, expectations are that materials costs will increase by 8 percent and variable manufacturing costs will decrease by 2 percent. Fixed cash manufacturing costs are expected to decrease by 6 percent.

Variable marketing costs will change with volume. Administrative cash costs are expected to increase by 6 percent. Inventories are kept at zero. Gulf States operates on a cash basis.

Estimate the cash from operations expected in year 2. (Do not round intermediate calculations. Round your final answers to the nearest whole dollar amounts.)

GULF STATES MANUFACTURING

Cash Basis Budgeted Income Statement - For Year 2

Sales Revenue $
Manufacturing Costs:
Materials $
Variable Cash Cost $
Fixed Cash Cost $
Depreciation Fixed $
Total Manufacturing Cost $
Marketing and Admin Cost:
Marketing (variable, cash) $
Marketing Depreciation $
Administrative (fixed, cash) $
Administrative depreciation $
Total Marketing and Admin Costs $
Total Costs $
Operating Profits $

Solutions

Expert Solution

THE SOLUTION IS PROVIDED WITH ALL THE WORKINGS IN THE ABOVE TABLE


Related Solutions

Problem 13-53 & 13-54 (Algo) (LO 13-4, 5, 6) [The following information applies to the questions...
Problem 13-53 & 13-54 (Algo) (LO 13-4, 5, 6) [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 2 budget estimates: Sales revenues (18,000 units) $ 1,620,000 Manufacturing costs Materials $ 289,000 Variable cash costs 395,000 Fixed cash costs 159,000 Depreciation (fixed) 195,000 Marketing and administrative costs Marketing (variable, cash) 208,000 Marketing depreciation 51,000 Administrative (fixed, cash) 204,000 Administrative depreciation $...
Required information Problem 10-53 (LO 10-2, LO 10-3) [The following information applies to the questions displayed...
Required information Problem 10-53 (LO 10-2, LO 10-3) [The following information applies to the questions displayed below.] Evergreen Corporation (calendar-year-end) acquired the following assets during the current year: (ignore §179 expense and bonus depreciation for this problem): (Use MACRS Table 1 and Table 2.) Date Placed Original Asset in Service Basis Machinery October 25 $ 76,000 Computer equipment February 3 14,500 Used delivery truck* August 17 27,500 Furniture April 22 157,500 *The delivery truck is not a luxury automobile. Problem...
Problem 7-42 (LO 7-2) (Algo) [The following information applies to the questions displayed below.] Dahlia is...
Problem 7-42 (LO 7-2) (Algo) [The following information applies to the questions displayed below.] Dahlia is in the 32 percent tax rate bracket and has purchased the following shares of Microsoft common stock over the years: Date Purchased Shares Basis 7/10/2010 490 $ 19,110 4/20/2011 390 17,472 1/29/2012 590 19,234 11/02/2014 340 12,988 If Dahlia sells 1,070 shares of Microsoft for $63,130 on December 20, 2020, what is her capital gain or loss in each of the following assumptions? (Do...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 46,500 64,600 Interest expense...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 780,000 $ 924,200 Cash $ 20,500 $ 31,000 Cost of goods sold 589,100 648,500 Accounts receivable, net 33,400 58,400 Interest expense 7,600...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions...
Required information Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 780,000 $ 924,200 Cash $ 20,500 $ 31,000 Cost of goods sold 589,100 648,500 Accounts receivable, net 33,400 58,400 Interest expense 7,600...
Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.]...
Problem 13-5A Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows. Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 890,200 Cash $ 19,500 $ 32,000 Cost of goods sold 590,100 642,500 Accounts receivable, net 36,400 51,400 Interest expense 9,300 17,000 Merchandise...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed...
Problem 13-5A Comparative ratio analysis LO A1, P3 [The following information applies to the questions displayed below.] Summary information from the financial statements of two companies competing in the same industry follows.    Barco Company Kyan Company Barco Company Kyan Company Data from the current year-end balance sheets Data from the current year’s income statement Assets Sales $ 770,000 $ 880,200 Cash $ 19,500 $ 34,000 Cost of goods sold 585,100 632,500 Accounts receivable, net 37,400 57,400 Interest expense 7,900...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT