Excel File Edit View Insert Format Tools Data Window Help acc 202f Q Search Sheet Home Insert Page Layout Formulas Data Review View Share A Calibri (Body)AA B 1 , d. A. _- Wrap Text peg Sort 8 Filter Merge & Center, $ , % , .00.00 conditional Format Cell Insert Delete Format Formatting as Table Styles 813 1.jpeg You are a manager for Peyton Approved, a pet supplies manufacturer. This responsibility requires you to create budgets, make pricing decisions, and analyze the results of operations to determine if changes need to be made to make the company more efficient. 2 You will be preparing a budget for the quarter July through September 2015. You are provided the following information. The budgeted balance sheet on June 30, 2015, is: eyton Approved Bitzeted Balance Sheet 30 n is 6 ASSETS 7 Cash 8 Accounts receivable 9 Raw materials inventory 10 Finished goods inventory 11 Total current assets 12 Equipment 13 Less accumulated depreciation 14 Total assets 42,000 259,900 35,650 578,630 720,000 240,000480,000 $1,058,630 16 LIABILITIES AND EQUITY 17 Accounts payable 18 Short-term notes payable 19 Taxes payable 20 Total current liabilities 21 Long-term note payable 63,400 24,000 97,400 300,000 Instructions Budgets Ready