Question

In: Accounting

Part 2 Consider the budgeted income statement for Happy Turtles for the month ended 30 June...

Part 2

Consider the budgeted income statement for Happy Turtles for the month ended 30 June 2017 below:-

                                                     

$                    

$

Sales                                              

Less:   Cost of Goods Sold

                           

290,000

            Inventory, 31 May 2017

50,000

            Purchases                         

              192,000

            Available for sale             

              242,000

            Inventory, 30 June 2017

(40,000)

                                                     

                           

202,000

Gross profit                                   

                           

88,000

Less:   Operating expenses

                   Wages                                                                                        36,000

                   Utilities                                                                          5,000

                   Advertising                                                                                10,000

                   Depreciation                                                                                1,000

                   Office expenses                                                            4,000

                   Insurance and property taxes                                                    3,000                (59,000)

       Operating profit                                                                                                                                 29,000

                                                                                                                                       =====

Additional information:

  • The cash balance on 31 May 2017 $15,000.
  • Sales proceeds are collected as follows: 80% the month of sale; 10% the second month; and 10% the third month; explain what % will be use and why the other % will not be use.
  • Accounts receivable are $ 44,000 on 31 May 2017 consisting of $ 20,000 from April 2017 sales and $24,000 from May 2017 sales, show the calculation and write process of getting the answer.
  • Accounts payable on 31 May 2017 are $ 145,000.
  • Happy Turtles pay 25% of purchases during the month of purchase and the remainder during the following month, what is the month of purchase, specify your answers.
  • All operating expenses requiring cash are paid during the month of recognition, except that insurance and property taxes are paid annually in December for the forthcoming year.
  • do we put amortization on the cash budget, write the reason.

Required:

Prepare a cash budget for June 2017. Confine your analysis to the given data. Ignore income taxes.

Solutions

Expert Solution

The answer has been presented in the supporting sheets. All the parts has been solved with detailed explanation and formulas and format. For detailed answers refer to the supporting sheets.

ekkarill92 answered 3 months ago
Next > < Previous

Related Solutions

The income statement of Booker T Industries Inc. for the current year ended June 30 is...
The income statement of Booker T Industries Inc. for the current year ended June 30 is as follows: 1 Sales $510,600.00 2 Cost of merchandise sold 294,400.00 3 Gross profit $216,200.00 4 Operating expenses: 5 Depreciation expense $39,000.00 6 Other operating expenses 105,910.00 7 Total operating expenses 144,910.00 8 Income before income tax $71,290.00 9 Income tax expense 22,690.00 10 Net income $48,600.00 Changes in the balances of selected accounts from the beginning to the end of the current year...
The income statement of Booker T Industries Inc. for the current year ended June 30 is...
The income statement of Booker T Industries Inc. for the current year ended June 30 is as follows: 1 Sales $510,600.00 2 Cost of goods sold 294,400.00 3 Gross profit $216,200.00 4 Operating expenses: 5 Depreciation expense $39,000.00 6 Other operating expenses 105,910.00 7 Total operating expenses 144,910.00 8 Income before income tax $71,290.00 9 Income tax expense 22,690.00 10 Net income $48,600.00 Changes in the balances of selected accounts from the beginning to the end of the current year...
The income statement of Booker T Industries Inc. for the current year ended June 30 is...
The income statement of Booker T Industries Inc. for the current year ended June 30 is as follows: 1 Sales $510,600.00 2 Cost of goods sold 294,400.00 3 Gross profit $216,200.00 4 Operating expenses: 5 Depreciation expense $39,000.00 6 Other operating expenses 105,910.00 7 Total operating expenses 144,910.00 8 Income before income tax $71,290.00 9 Income tax expense 22,690.00 10 Net income $48,600.00 Changes in the balances of selected accounts from the beginning to the end of the current year...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions). Salaries and wages expenses $ 460 Research and development expense $ 114 Depreciation expense 90 Income tax expense 430 Sales revenue 5,830 Loss on disposal of plant assets 46 Interest expense 161 Cost of goods sold 2,800 Advertising expense 499 Rent expense 105 Sales returns and allowances 230 Utilities expense 60 Assume a tax rate of 34%....
Suppose in its income statement for the year ended June 30, 2017, The Clorox Company reported...
Suppose in its income statement for the year ended June 30, 2017, The Clorox Company reported the following condensed data (dollars in millions). Salaries and wages expense $450 Research and development expense $110 Depreciation expense 85 Income tax expense 198 Sales revenue 8,225 Loss on disposal of plat assets 45 Interest expense 210 Cost of goods sold    5,440 Advertising expense 490 Rent expense 115 Sales returns and allowances 225 Utilities expense 65 a) Prepare a multiple-step income statement Calculate...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions). Salaries and wages expenses $ 460 Research and development expense $ 114 Depreciation expense 90 Income tax expense 702 Sales revenue 7,430 Loss on disposal of plant assets 46 Interest expense 161 Cost of goods sold 3,600 Advertising expense 499 Rent expense 105 Sales returns and allowances 230 Utilities expense 60 Assume a tax rate of 34%.  ...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported...
Suppose in its income statement for the year ended June 30, 2022, The Clorox Company reported the following condensed data (dollars in millions). Salaries and wages expenses $ 460 Research and development expense $ 114 Depreciation expense 90 Income tax expense 770 Sales revenue 7,830 Loss on disposal of plant assets 46 Interest expense 161 Cost of goods sold 3,800 Advertising expense 499 Rent expense 105 Sales returns and allowances 230 Utilities expense 60 Assume a tax rate of 34%....
Absorption Costing Income Statement On June 30, 2016, the end of the first month of operations,...
Absorption Costing Income Statement On June 30, 2016, the end of the first month of operations, Smithey Manufacturing Co. prepared the following income statement, based on the variable costing concept: Sales (90,000 units) $990,000 Variable cost of goods sold: Variable cost of goods manufactured (110,000 units x $8 per unit) $880,000 Less ending inventory (20,000 units x $8 per unit) 160,000 Variable cost of goods sold 720,000 Manufacturing margin $270,000 Variable selling and administrative expenses 9,000 Contribution margin $261,000 Fixed...
Financial information related to Organic Products Company for the month ended June 30, 20Y9, is as follows: Net income for June $ 115,000
Financial information related to Organic Products Company for the month ended June 30, 20Y9, is as follows:Net income for June                                     $ 115,000Dividends paid in June                                       25,000Common stock, June 1, 20Y9                           180,000Common stock issued in June                           50,000Retained earnings, June 1, 20Y9                    1,630,000a. Prepare a statement of stockholders’ equity for the month ended June 30, 20Y9.b. Why is the statement of stockholders’ equity prepared before the June 30, 20Y9, balance sheet?
Keeper Corporation’s income statement for the year ended June 30, 2014, and its comparative balance sheets...
Keeper Corporation’s income statement for the year ended June 30, 2014, and its comparative balance sheets for June 30, 2014 and 2013 follow. Keeper Corporation Income Statement For the Year Ended June 30, 2014 Sales $ 234,000 Cost of goods sold 156,000 Gross margin $ 78,000 Operating expenses 45,000 Operating income $ 33,000 Interest expense 2,800 Income before income taxes $ 30,200 Income taxes expense 12,300 Net income $ 17,900 Keeper Corporation Comparative Balance Sheets June 30, 2014 and 2013...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT