I need help with sheet 1. Any help that is possible.

Doggy World operates a chain of pet stores in the Midwest. The manager of each store reports to the regional manager, who in turn reports to headquarters in Chicago, Illinois. The actual and budgeted income statements for the Dayton store, the Ohio region (including the Dayton store), and the company as a whole (including the Ohio region) for July 2011 are: Requirements 1. Prepare a report for July 2011 that shows the performance of the Dayton store, the Ohio region, and the company as a whole. 2. As the Ohio manager, would you investigate the Dayton store on the basis of this report? Why or why not? 3. Should Doggy World prepare the master budget? Briefly discuss the benefits of budgeting. Base your discussion on Doggy World's performance report. Requirement 1 Prepare a report that shows the performance of the Dayton store, the Ohio region and the company as a whole. Begin with the company as a whole. Doggy World Responsibility Accounting Performance Report July 2011 Companywide Operating Income of Regions and Headquarter's Office Expense Budget Actual Variance Favorable (Unfavorable) Headquarter's office expense Ohio stores Stores in other regions Operating income $ - $ - $ - Now prepare the report that show the performance of the Ohio region. Doggy World Responsibility Accounting Performance Report July 2011 Ohio Operating Income of Stores and Region Manager's Office Expense Region manager's office expense Dayton Other Ohio stores Operating income Budget Variable Favorable (Unfavorable) - Actual $ - $ - $ - Finally, show the performance of the Dayton store. Doggy World Responsibility Accounting Performance Report July 2011 Dayton Budget Revenues and Expenses: Revenue Expenses: Cost of materials Salary expense Depreciation expense Utilities expense Rent expense Total expenses Operating income Variable Favorable (Unfavorable) Actual $ - $ - $ - $ - Requirement 2 As the Ohio region manager, would you investigate the Dayton store on the basis of this report? Requirement 3 Should Doggy World prepare the master budget? Briefly discuss the benefits of budgeting. Base your discussion on Doggy World's performance report. e reports to the nd budgeted and the company Ohio region, and the port? Why or why not? dgeting. Base your egion and the company basis of this report? geting. Base your The budget committee of Berg Office Supply has assembled the following data. As the business manager, you must prepare the budgeted income statements for May and June 2011. Requirement 1. Prepare Berg's budgeted income statements for May and June. Show cost of goods sold computations. Requirement 1 Before completing the budgeted income statements, calculate the budgeted cost of goods sold for May and June using the inventory, purchases, and cost of goods sold budget form. May June Beginning inventory + Purchases = Goods available for sale - Ending inventory = Cost of goods sold Now complete the budgeted income statements for May and June. Berg Office Supply Budgeted Income Statements May and June 2011 May Sales revenue Cost of goods sold Gross profit Operating expenses: Salaries & commission expense June Rent expense Depreciation expense Insurance expense Operating income Income tax expense Net income ost of goods budget form. Box Printing of Bloomington has applied for a loan. Bank of America has requested a budgeted balance sheet at April 30, 2011, and a budgeted statement of cash flows for April. As Box's controller, you have assembled the following information: Requirements 1. Prepare the budgeted balance sheet for The Box Printing at April 30, 2011. Show separate computations for cash, inventory, and stockholders' equity balances. 2. Prepare the budgeted statement of cash flows for April. 3. Suppose the Box Printing has become aware of more efficient (and more expensive) equipment than it budgeted for purchase in April. What is the total amount of cash available for equipment purchases in April, before financing, if the minimum desired ending cash balance is $21,000? (For this requirement, disregard the $16,900 initially budgeted for equipment purchases.) Requirement 1 Show separate computations for cash, inventory, and stockholders' equity balances. sold for May and June using the inventory, purchases, and cost of goods sold budget form. Use formulas in Excel - enter cash payments as negative numbers. Cash, at April 30, 2011 Beginning balance Cash inflows: Cash sales Collections Cash outflows: Payment of March liabilities Cash purchases Payment for April (credit) purchases Purchase of equipment Operating expenses paid Ending balance $ - Inventory, at April 30, 2011 Beginning balance Add: Purchases Less: Cost of goods sold Ending balance - Stockholders' Equity at April 30, 2011 Beginning balance Add: Revenues Less: Expenses Ending balance - Prepare the budgeted balance sheet for Box Printing at April 30, 2011. Fill in the blanks as needed. Box Printing Budgeted Balance Sheet April 30, 2011 Assets Current assets: Cash Accounts receivable Inventory Total curent assets Plant assets: Equipment Accumulated depreciaiton Total assets Liabilities Current liabilities: Accounts payable Accrued expenses payable Total liabilities $64,600.00 16,800.00 0.50 x 0.30 x 90,000 22,000 $103,400.00 97,800 80,900 + 16900 (13,500.0) Stockholders' Equity Stockholders' Equity Total liabilities and stockholders' equity 84,300 12,900 + 600 $ 187,700 18,600 0.50 x 37,200 19,800 0.60 x 33,000 38,400 149,300 187,700 Requirement 2 Box Printing Budgeted Statement of Cash Flows For the Month Ended April 30, 2011 Cash flows from operating activities: Receipts: Collection from customers 82,500 Total cash receipts Payments Purchases (38,000) Operating expenses (13,200) Total cash payaments Net cash inflow from operating activities Cash flows from investing activities: Acquisition of equipment (16,900) Net cash outflows from investing activities Cash flows from financing activities Net increase in cash Cash balance, April 1, 2011 Cash balance, April 30, 2011 Requirement 3 $ 82,500 (51,200) 31,300 (16,900) 14,400 $ 14,400 ed a budgeted balance sheet roller, you have ow separate ensive) equipment than or equipment purchases 000? (For this ity balances. s sold budget form. Fill in the blanks 50,400+31,100 8,600+10,800+18,600