I need someone that has excellent Microsoft skill and a general budgeting and accounting knowledge.

I have attached the necessary files and the excel column turns green when the answer is right.

Everything below the red line in the excel file should be linked to the data above., which means we cannot enter any numbers below the red line. It requires the use of formulas, "if" formulas and many more. if you can solve it all Let me know. If not the transaction would be void. I have also completed 1/3 of the problem.

Stools Inc. produces three legged stools which are intended for use on uneven surfaces (they will not wobble). Each stool is made from three components; a wood seat, three wood legs, and a glider on the bottom of each leg. A firm is being formed to produce stools for Wally's Discount. The contract is for only one year with no renewal clause. Thus, Stool Inc. does not want any ending inventories in material or stools. The contract calls for 650,000 stools. Wally's Discount has a delivery schedule for each month. The stools are to be delivered on or before the end of the month according to the schedule. The Excel file is formatted for your master budget. There are several things in the data section which will make linking the budget easier. I started with a Balance Sheet for Stools Inc., you will notice that there are not any assets or liabilities, but link to the balance sheet as this would change next year. While the beginning balance could be zero this year, link to the beginning balance as if it has values greater than zero (example: Beginning working capital). The tentative price being discussed is $28.00 per stool. Wally's Discount will pay you 20% of each month's purchases in the month of purchase and the remaining 80% the following month. Wally's Discount wants: Month Stools January 30,000 February 45,000 March 60,000 April 80,000 May 90,000 June 65,000 July 50,000 August 45,000 September 50,000 October 60,000 November 45,000 December 30,000 Total 650,000 Each chair requires: One wood seat which requires 1 board foot of lumber (this is a measurement of lumber equal to a 1 inch thick board that is 1 foot long and 1 foot wide, or any combination of this) which costs $1,200 per thousand board feet. Three 2 inch round legs that are 16 inches long. This required 4 linear feet of 2 inch round stock which costs $1,600 per thousand linear feet. Three gliders are required, one for each leg. The gliders cost $135 per gross (gross = 144). Other components consist of \"Glue\" you can glue up 120 stools for each gallon of glue ($16.00 / gallon) \"Sand Paper\" used to finish the stool, it take one-half of a sheet to sand each stool ($8.00 / 100 sheets of sandpaper). \"Paint\" used on the stool, each gallon can paint 30 stools ($22.00 / gallon). \"Carton\" to ship the stool in (each stool takes one carton which costs $235.00 / 100) The different supplier's turnaround time make it prudent that you carry enough raw material inventories to avoid any untimely delays. For the seats you want 20% of next month's required production. For the legs you should have 30% of next month's required production. And for the gliders you should have 25% of next month's required production. You want enough glue for 10% of next month's required production. Enough sandpaper for 5% of next month's required production. Paint enough to paint 15% of next month's required production. And enough shipping cartons to meet 25% of next month's required production. Sixty percent of the purchases are paid in the month of purchase and the remaining amount is paid during the next month. To be certain that the deliveries will be meet, you want to have 4% of next month's sales finished at the end of the month. Remember that this is a one year only contract and there will be no ending inventories of raw material or stools. The labor force will consist of: (1) Assembly workers, (2) Finishing workers, (3) Assembly supervision, (4) Finishing supervision, (5) Janitors, (6) Repairmen, (7) Supervision for the janitors and repairmen. The work force is flexible and employees are hired and fired as needed. There is no guarantee that all of the employees will be employed for the full 167 hours each month. The assembly workers need one supervisor for each 60 workers, while the finishing workers require one supervisor for each 45 workers. Each assembly supervisor and finishing supervisor is paid $4,500 per month. Supervisors are hired and fired as needed. Equipment: Each assembly worker requires $168 worth of tools and can cut-out and assemble 5 stools per hour. Each finishing worker requires $215 worth of tools and can finish 4 stools per hour. Stools Inc. will need one forklift, which costs $9,500 each, for every 4 hanger bays that they rent. Also, they will need 3 paint booths, which cost $6,700, in each of the finishing workers bays. The small tools are depreciated over 5 years using the straight-line method. The forklifts and the paint booths are depreciated over 10 years using the straight-line method. You do not expect any of the equipment to have a salvage value at the end of life. Stools Inc. will have to rent physical facilities, hire manpower, purchase tools and equipment. There is an old Air Force hanger available for rent for $8,500 for each 2,800 square foot bay that you would like to use. There does not seem to be a limit to the number of bays. Each employee will need 350 square feet of work space each. Each four bays of the air plane hangar require one janitor who is paid $9.00 per hour for 167 hours per month. Also need repairmen who can service the needs of 50 assembly and finishing employees, is paid $11.00 / hour and also works 167 hours / month. The janitorial and repairmen's supervisor is paid $3,500 per month and only one is required. The average work month consists of 167 hours per man. Assembly and finishing workers are paid $14.00 per hour and overtime pays a 50% premium. Overtime can be used up to 250 hours per month. But, that rate cannot be sustained for very many months. There is a Shift Differential of $0.15 for employees that work the 2nd shift and $0.25 for employees that work the 3rd (Graveyard) shift. Utilities: Electricity is used to both run the machinery and heat and cool the building. The utility cost formula is $980 per bay (fixed) + $36 per thousand stools. The manufacturing facility requires $24,000 of insurance each year. Stools Inc. is responsible for the shipping. Each semi trailer will hold 1,728 stools and charges $673.00 for each load. Stools Inc. must ship the required number of chairs each month, but not more than the contract calls for, even if the semitrailer is not full. The Selling and Administrative department consists of a general manager and office staff. The general manager is paid $6,500 per month and the office staff earns $3,700 collectively. The office also requires $2,400 of insurance and $300 in utilities each month. Stools Inc. is starting $50,000 working capital being contributed by the firm. They are using their contract to negotiate a line of credit with the local bank. The bank requires that Stools Inc. will have a minimum balance of $20,000 at the end of each month and the bank will loan money to Stools Inc. in $10,000 increments @ 5.5% interest / year. Money is borrowed on the first of the month and paid back at the end of the month. At the end of each quarter the company will pay a $250,000 dividend. You are asked to make a master budget for the manufacturing of these stools. Stools Inc. management team wants you consider using multiple shifts when making the master budget. They would like to start with two shifts, but may want to change to either one or three shifts, depending on costs. Note: To help you out I am providing an Excel format that you can use to build your master budget. The word cells are protected, but the numbers can be changed. You will note that the input data is in yellow boxes. If you have any problems with formulas or linking you can contact me and I will try and help you get past any hurtles. Some formulas can get very complex. For example the financing section of the cash budget. Where you have to determine if Stools Inc. must borrow money and do they have the necessary funds at the end of each month to repay any of the debt. Once you have completed the budget, you are to: 1. Find the break-even price. 2. Would it be advantageous to run the factory more than one shift? (Give the answer in difference in Net Income.) 3. Suggest three other cost saving changes and the amount that each would increase Net Income. This is not an easy project. But, you are in upper level course and I know that each of you is capable of completing this project. Take it one schedule at a time. I think that I have them in the necessary order. When you are in management you will find that you will probably be required to use Excel to prepare budgets for the coming months and year. There will be an Excel quiz sometime this semester. If you get stumped, ask and attach your Excel file with your questions. 0.18 -0.08 -0.16 -0.12 -0.03 0.06 0.00 0.12 0.02 0.01 -0.17 -0.17 -0.11 0.00 -0.10 0.03 0.18 -0.02 -0.06 -0.14 0.13 -0.18 -0.07 -0.17 -0.10 -0.05 -0.16 -0.13 0.12 0.16 0.07 -0.06 -0.07 0.15 -0.20 -0.09 0.08 0.01 0.14 0.19 0.02 0.09 -0.09 -0.05 -0.20 -0.16 -0.12 0.16 -0.17 0.13 0.07 1.178 0.920 0.845 0.878 0.971 1.065 1.002 1.122 1.018 1.012 0.830 0.832 0.893 1.004 0.896 1.027 1.180 0.977 0.936 0.861 1.132 0.819 0.934 0.832 0.899 0.947 0.845 0.868 1.125 1.162 1.071 0.944 0.928 1.152 0.804 0.912 1.085 1.005 1.144 1.185 1.016 1.086 0.914 0.947 0.802 0.845 0.877 1.157 0.832 1.128 1.066 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0.00 0.10 0.14 -0.05 0.04 0.14 0.02 0.13 0.00 0.11 -0.19 0.11 -0.13 -0.16 0.16 0.01 0.06 0.08 -0.03 -0.05 0.01 0.02 -0.17 -0.10 0.05 -0.08 0.16 0.998 1.096 1.138 0.950 1.043 1.144 1.016 1.133 0.996 1.113 0.806 1.115 0.869 0.843 1.163 1.009 1.064 1.085 0.972 0.954 1.012 1.023 0.829 0.896 1.046 0.923 1.162 -0.10 0.16 -0.10 0.14 0.05 -0.11 0.07 0.15 0.09 -0.10 -0.19 -0.04 -0.06 0.09 -0.18 -0.16 -0.10 -0.19 0.00 -0.18 0.16 0.14 -0.16 0.05 0.09 0.14 0.13 0.898 1.155 0.905 1.141 1.045 0.892 1.075 1.147 1.091 0.896 0.812 0.964 0.944 1.088 0.825 0.842 0.901 0.806 1.000 0.821 1.157 1.142 0.844 1.046 1.085 1.139 1.133 #REF! #REF! #REF! #REF! #REF! Quantity Used per Stool #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! -0.14 0.01 -0.08 0.19 0.04 0.01 -0.01 -0.19 -0.11 -0.05 -0.19 0.17 0.03 -0.11 0.08 0.13 -0.18 0.09 0.19 0.03 0.06 0.16 0.07 -0.06 -0.20 -0.09 0.07 0.10 0.12 0.16 -0.19 -0.10 0.02 0.07 -0.14 -0.19 -0.02 0.01 -0.08 0.01 0.06 -0.18 0.13 0.16 0.20 -0.15 0.01 0.18 0.01 0.17 0.05 -0.04 0.07 0.17 0.862 1.015 0.917 1.193 1.040 1.006 0.985 0.806 0.888 0.951 0.809 1.173 1.034 0.893 1.083 1.127 0.817 1.095 1.187 1.029 1.061 1.158 1.074 0.939 0.805 0.907 1.068 1.097 1.121 1.157 0.813 0.901 1.020 1.069 0.858 0.813 0.976 1.009 0.924 1.008 1.057 0.825 1.127 1.157 1.200 0.854 1.009 1.177 1.015 1.168 1.048 0.957 1.068 1.173 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0.11 -0.14 0.01 0.08 -0.12 0.04 -0.10 -0.05 0.20 -0.06 0.15 -0.18 -0.12 0.05 -0.12 -0.12 0.16 0.04 0.15 0.07 0.14 -0.15 0.06 -0.16 0.19 0.11 -0.19 1.106 0.863 1.008 1.080 0.876 1.043 0.905 0.948 1.196 0.944 1.146 0.822 0.882 1.048 0.881 0.876 1.160 1.044 1.147 1.069 1.137 0.855 1.057 0.835 1.191 1.110 0.810 #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0 #REF! SCHEDULE 1 Sales Revneue First Quarter Budgeted Sales in Stools Selling Price per Stool Total Sales Accounts Receivable First Quarter Second Quarter Third Quarer Fourth Quarter #REF! #REF! #REF! SCHEDULE of Expected Cash Collections #REF! #REF! Cash Collections #REF! SCHEDULE 2 Production (Units) First Quarter Budgeted Sales (Sch 1) Add: Desired EI Total Needs Less: BI of Finished Goods #REF! #REF! #REF! #REF! Required Production #REF! SCHEDULE 3 Direct Materials Costs First Quarter Required Production of Stools #REF! 1" thick wood seat Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Board feet of Seat material Costs per board foot Cost of Seat material purchased #REF! Linear feet of Wood legs per stool Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Linear feet of Wood Legs Costs per linear foot Cost of leg material purchased #REF! Gliders Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gliders Cost per glider Cost of gliders purchased #REF! Indiirect Material Glue used to assemble the stools Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gallons of Glue Cost per Gallon Cost of Glue purchased Sand paper used in finishing Production needs Add: Desired ending inventory #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Total needs Less: Beginning inventory Sheets of Sandpaper Cost per Sheet Cost of Sandpaper purchased #REF! #REF! #REF! #REF! #REF! Paint used on the final coat Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gallons of Paint Cost per Gallon Cost of Paint purchased #REF! Cardboard carton used for shipping Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Cardoard Cartons Cost per Carton Cost of Cartons purchased #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! SCHEDULE of Expected Cash Disbursemen First Quarter 1 inch thick wood which is used for the seat #REF! 2 inch square legs #REF! Gliders which fit on the bottom of each leg. #REF! Glue used to assemble the stools #REF! Sand paper used in finishing #REF! Paint used on the final coat #REF! Cardboard carton used for shipping #REF! Cost of Material to be Purchased #REF! Accounts Payable First Quarter Second Quarter Third Quarter Fourth Quarter #REF! #REF! Cash Disbursements for Materials #REF! SCHEDULE 4 Direct Labor Costs First Quarter Required Production (Sch 2) Assembly Labor hours per Stool Total Assembly Labor Hours Number of Employees #REF! #REF! #REF! #REF! Finishing Labor hours per Stool Total Finishing Labor hours Number of Employees #REF! #REF! #REF! Total Direct Labor Hours Direct Labor Rate Total Direct Labor Cost #REF! #REF! #REF! Total Number of Employees #REF! SCHEDULE 5 Capital Additions Costs First Quarter Assembly Tools Finishing Tools Forklift Paint booths Cash Disbursements for Capital Add #REF! #REF! #REF! #REF! #REF! Number of Forklifts needed Number of Paint Booths needed #REF! #REF! Depreciation Table Assembly Tools - 5 year Finishing Tools - 5 year Forklift - 10 year Paint Booths - 10 year Total Dep. Expenses for the Quarter Assembly Tools Accumulated Dep. Finishing Tools Accumulated Dep. Forklifts Accumulated Depreciation Paint Booths Accumulated Dep. Total Accumulated Depreciation Bays used for Assembly Bays used for Finishing Total Bays Rented #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! SCHEDULE 6 Manufacturing Overhead Costs First Quarter Direct Labor Hours Janitor Repair man #REF! #REF! #REF! Rent Facility - Assembly Facility - Finishing #REF! #REF! Glue Sandpaper Paint Cartons #REF! #REF! #REF! #REF! Insurance Utilities Overtime #REF! #REF! #REF! Assembly Supervision Finishing Supervision Janitor & Repair Supervision #REF! #REF! #REF! Depreciation #REF! Total Manufacturing Overhead #REF! Less: Glue Sandpaper Paint Cartons Depreciation Cash disbursements for MOH #REF! #REF! #REF! #REF! #REF! #REF! Total Manufacturing Overhead Direct Labor Hours Overhead Rate Overhead Cost per Unit Total Unit Cost for the Quarter Unit Product Costs #REF! #REF! #REF! #REF! #REF! SCHEDULE 7 Ending Finished Goods Inventory Quantity Production Costs per Stool Direct Material Seat Legs Gliders #REF! #REF! #REF! Direct Labor Assembly #REF! Finishing #REF! Overhead #REF! Unit Product Costs SCHEDULE 8 Selling & Administrative Expenses First Quarter Office staff General Manager Insurance Utilities Shipping #REF! #REF! #REF! #REF! #REF! Total Cash disbursements from S&A Loads #REF! #REF! SCHEDULE 9 Cash First Quarter Beginning Cash Balance Add: Receipts: Cash Collections Total Cash Available #REF! #REF! #REF! Less Disbursements: Cash Disbursements for Materials Total Direct Labor Cost Cash Disbursements for Capital Add Cash disbursements for MOH Total Cash disbursements from S&A Dividends #REF! #REF! #REF! #REF! #REF! #REF! Total Disbursement #REF! Excess (Deficiency) of cash #REF! Financing Borrowings (at the beginning of Quarter) Repayments (at the end of the Quarter) Interest Total Financing #REF! #REF! #REF! #REF! Ending Cash Balance #REF! Debt #REF! SCHEDULE 10 Income Statement First Quarter Sales Cost of Goods Sold Over/Under Applied Overhead Gross Margin Selling and Administrative Expenses Net Operating Income Interest Expenses Net Income #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! SCHEDULE 11 Statement of Budgeted Retained Earnings First Quarter Beginning Balance Add: Net Income Less Dividends Ending Retained Earnings #REF! #REF! #REF! #REF! SCHEDULE 12 Cash Flow First Quarter Operating Activities Budgeted Cash Sources Sales Revenue Budgeted Cash Uses Raw Material Direct Labor Factory Overhead Total Cash disbursements from S&A Interest Net Change in Cash From Operating #REF! #REF! #REF! #REF! #REF! #REF! Investing Activities Capital Assets - Cash Inflows Capital Assets - Cash Outflows Net Change in Cash from Investing #REF! #REF! Financing Activities Borrowing Money Paying Back Money Net Change in Cash from Financing #REF! #REF! #REF! #REF! Net Change in Cash Beginning Cash Balance Ending Cash Balance #REF! #REF! #REF! SCHEDULE 13 Balance Sheet First Quarter Assets Cash Accounts Receivable Raw material #REF! #REF! Seats Legs Gliders Glue Sandpaper Paint Cartons Total Assets #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Liabilities and Equity Accounts Payable Liabilities Total Liabilities #REF! #REF! #REF! Equity #REF! Total Liabilities and Equity #REF! Check numbers (Assets - Lia. -Equity #REF! Finished Stools Assembly tools Accumulated Depreciation - 5 year Finishing Tools Accumulated Depreciation - 5 year Forklifts Accumulated Depreciation - 10 year Paint Booths Accumulated Depreciation - 10 year #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Used per Stool #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Overtime Pay #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! 0 #REF! #REF! 0 #REF! #REF! 0 Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! LE of Expected Cash Collections #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Accounts Recievable #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! LE of Expected Cash Disbursements for Materials Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter #REF! Third Quarter #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Accounts Payable #REF! #REF! #REF! #REF! Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Costs Total board foot linier feet gliders #REF! per board foot #REF! per linier foot #REF! per glider #REF! #REF! #REF! hours #REF! per hour #REF! hours #REF! per hour #REF! Hours #REF! per hour #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter Third Quarter Fourth Quarter 2008 Total #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! Second Quarter #REF! #REF! #REF! Third Quarter #REF! #REF! #REF! Fourth Quarter #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! unts Recievable #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! #REF! unts Payable Name Stools Inc. Manufactures wood stools. These un January 1/1/2013 Balance Sheet Assets Cash 50,000.00 Accounts Receivable 0.00 Raw material Seats 0.00 Legs 0.00 Gliders 0.00 Glue used to assemble the stools 0.00 Sand paper used in finishing 0.00 Paint used on the final coat 0.00 Cardboard carton used for shipping 0.00 Finished Stools 0.00 Assembly tools 0.00 Accumulated Depreciation - 5 year 0.00 Finishing Tools 0.00 Accumulated Depreciation - 5 year 0.00 Forklifts 0.00 Accumulated Depreciation - 10 year 0.00 Paint Booths 0.00 Accumulated Depreciation - 10 year 0.00 Total Assets 50,000.00 Liabilities and Equity Accounts Payable Liabilities Total Liabilities February 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.00 0.00 0 0 0 Equity 50,000.00 0 Total Liabilities and Equity 50,000.00 SCHEDULE 1 Sales Budget Stools Inc. has landed a contract with Wally's Discount Stores. The contract calls for Stools Inc. to supply the following Wally's Discount Store will pay Stools Inc. $28.00 per stool Month January February Stools Sold 30,000 45,000 Original Values in Bold Black 30000 45000 Percentage of sales collected in the month of the sale Percentage of sales collected in the first month after the sale 20% 80% SCHEDULE 2 Production Budget Ending Inventory 4% 0.04 percentage of next month production SCHEDULE 3 Materials Budget Component Quantity Needed Per Stool 1 inch thick wood which is used for the seat 1 Board Foot 2 inch round legs 4 linear feet per stool Gliders which fit on the bottom of each leg. 3 per glider Other Components Glue used to assemble the stools Sand paper used in finishing Paint used on the final coat Cardboard carton used for shipping Stools per quantity 120 2 30 1 stools per gallon stools per sheet stools per gallon per stool Component Due to delivery schedules from the suppliers Stools Inc. wants: 1 inch thick wood which is used for the seat 20% of next months production 2 inch round legs 30% of next months production Gliders which fit on the bottom of each leg. 25% of next months production Other Components Glue used to assemble the stools 10% of next months production Sand paper used in finishing 5% of next months production Paint used on the final coat 15% of next months production Cardboard carton used for shipping 25% of next months production Stools Inc. pays 0.60 40% In the moth of purchase in the following month 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Year End Inventories (quantities) Seats Legs Gliders Finished Stools Glue used to assemble the stools Sand paper used in finishing Paint used on the final coat Cardboard carton used for shipping SCHEDULE 4 & 6 Labor Budget 2 Number of shifts Labor requirements Assembly Supervision: 60 Maximum number of employees that one superviso Direct Labor workers 5 Stools per hour of employee time Supervision: 45 Maximum number of employees that one superviso Direct Labor workers 4 Stools per hour of employee time Supervision: Direct Labor workers $4,500.00 $14.00 $7.00 0.15 0.25 Finishing Labor Rate: Shift Differential / supervisor/month per hour Overtime Bonus Pay 2nd shift 3rd shift 167 Max. number of hours per month per employee wit 250 Max. number of hours per month with Overtime Labor hours per employee per month Month January 167 Assembly Finishing Number of employees in Assembly Number of employees in Finishing Number of employees comes from the Labor Budget SCHEDULE 6 Manufacturing Overhead Have to determine an APPLIED overhead rate Insurance $24,000 24000 February 167 167 167 167 167 per year SCHEDULE 6 Ending Finished Goods Inventory Budget Stools Inc. leases its manufacturing facilities. Stools Inc. is leasing a part of a larger building and pays according to how Item: Facility 350 Square feet required by each direct laborer 2,800.00 Number of square feet in a bays $8,500.00 per Bay per Month Supervision for Janitors & Repairmen $3,500.00 per month Janitor $9.00 per hour 4 bays cleaned and maintained by one Janitor 167 Janitor and repairman hours per month each Repair man $11.00 50 per hour number of employees that require 1 repair man Utilities $980.00 $36.00 Fixed Costs per bay Variable cost per 1,000 Stools SCHEDULE 9 Capital Additions Budget Assembly Tools $168 Per employee Finishing Tools $215 per employee Forklift Paint Booths $9,500 4 $6,700 3 each number of bays that each forklift can service for a paint both Paint both in each finishing bay SCHEDULE 7 Selling & Administrative Expenses Budget 673 $673.00 Because Stools Inc. is shipping as often as they can fill a semi-trailer th In order to ship the required number of chairs needed to meet the sales Office staff General Manager Insurance Utilities Minimum balance Borrowings in January $3,700.00 $6,500.00 $2,400.00 $300.00 $20,000.00 $10,000.00 5.50% Interest is paid at the beginning of the following mo February Dividends 0 0 0 0 Note: There should not be any numbers entered into the cells BUDGETED COSTS SCHEDULE 1 Sales Budget January Budgeted Sales in Stools Selling Price per Stool Total Sales February 30,000 $28.00 840,000.00 45,000 $28.00 1,260,000.00 SCHEDULE of Expected Cash Collections Accounts Receivable 0.00 January 168000.00 672000 February 252000.00 March April May June July August Septemger October November December First Quarter Second Quarter Third Quarer Fourth Quarter Cash Collections 168,000 924,000 SCHEDULE 2 Production Budget January February Budgeted Sales (Sch 1) Add: Desired EI Total Needs Less: BI of Finished Goods Required Production 30,000 1,800 31,800 0 31,800 45,000 2,400 47,400 1,800 45,600 SCHEDULE 3 Direct Materials Budget January February Required Production of Stools 31,800 1" thick wood seat Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Board feet of Seat material Costs per board foot Cost of Seat material purchased 1.00 Linear feet of Wood legs per stool Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Linear feet of Wood Legs Costs per linear foot Cost of leg material purchased 4 Gliders 31,800 9,120 40,920 0 40,920 $1.20 $49,104.00 127,200 54,720 181,920 0 181,920 $1.60 $291,072.00 3 45,600 1.00 45,600 12,160 57,760 9,120 48,640 $1.20 $58,368.00 4 182,400 72,960 255,360 54,720 200,640 $1.60 $321,024.00 3 Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gliders Cost per glider Cost of gliders purchased Indiirect Material Glue used to assemble the stools Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gallons of Glue Cost per Gallon Cost of Glue purchased 95,400 34,200 129,600 0 129,600 $0.94 $121,500.00 0.01 136,800 45,600 182,400 34,200 148,200 $0.94 $138,937.50 0.01 265.0 38.0 303.0 0.0 303.00 $16.00 $4,848.00 380.0 50.7 430.7 38.0 $393 $16.00 $6,282.67 Sand paper used in finishing Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Sheets of Sandpaper Cost per Sheet Cost of Sandpaper purchased 0.5 15,900.0 1,140.0 17,040.0 0.0 17,040.0 $0.08 $1,363.20 0.5 Paint used on the final coat Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Gallons of Paint Cost per Gallon Cost of Paint purchased 0.033 1,060.0 228.0 1,288.0 0.0 1,288.0 $22.00 $28,336.00 0.033 Cardboard carton used for shipping Production needs Add: Desired ending inventory Total needs Less: Beginning inventory Cardoard Cartons Cost per Carton Cost of Cartons purchased 22,800.0 1,520.0 24,320.0 1,140.0 23,180.0 $0.08 $1,854.40 1,520.0 304.0 1,824.0 228.0 1,596.0 $22.00 $35,112.00 1 31,800 11,400 43,200 0.0 43,200 $2.35 $101,520.00 SCHEDULE of Expected Cash Disbursements for Materials January 1 45,600 15,200 60,800 11,400.0 49,400 $2.35 $116,090.00 February 1 inch thick wood which is used for the seat 2 inch round legs Gliders which fit on the bottom of each leg. Glue used to assemble the stools Sand paper used in finishing Paint used on the final coat Cardboard carton used for shipping Cost of Material to be Purchased $49,104.00 $291,072.00 121,500.00 4,848.00 1,363.20 28,336.00 101,520.00 $597,743.20 Accounts Payable January February March April May June July August Septemger October November December First Quarter Second Quarter Third Quarter Fourth Quarter 0.00 $358,645.92 Cash Disbursements for Materials $358,645.92 $58,368.00 $321,024.00 138,937.50 6,282.67 1,854.40 35,112.00 116,090.00 $677,668.57 $239,097.28 $406,601.14 $645,698.42 SCHEDULE 4 Direct Labor Budget January February Required Production (Sch 2) Assembly Labor hours per Stool Total Assembly Labor Hours 31,800 0.20 6,360 45,600 0.20 9,120 Finishing Labor hours per Stool Total Finishing Labor hours 0.25 7,950 0.25 11,400 14,310 $14.00 $200,340.00 20,520 $14.00 $287,280.00 20.00 24 28.00 35 Total Direct Labor Hours Direct Labor Rate Total Direct Labor Cost Number of Employees per shift (Assembly_) Number of Employees per shift (Finishing) Total Number of Employees SCHEDULE 5 Capital Additions Budget January Assembly Tools Finishing Tools Forklift Paint booths Cash Disbursements for Capital Add Bays used for Assembly Bays used for Finishing Total Bays Rented Number of Forklifts needed Number of Paint Booths needed February 3,360.00 5,160.00 1,344.00 2,365.00 3 3 6 2 9 4 5 9 3 15 Depreciation Table Assembly Tools - 5 year Finishing Tools - 5 year Forklift - 10 year Paint Booths - 10 year Total Dep. for the months purchases Assembly Tools Accumulated Dep. Finishing Tools Accumulated Dep. Forklifts Accumulated Depreciation Paint Booths Accumulated Dep. Total Accumulated Depreciation SCHEDULE 6 Ending Finished Goods Inventory Budget Quantity Production Costs per Stool Direct Material Seat Legs Gliders 1 board foot 4 linier feet 3 gliders Direct Labor Assembly Finishing 0.20 hours 0.25 hours Overhead Hours Unit Product Costs SCHEDULE 7 Manufacturing Overhead January February Direct Labor Hours Janitor Repair man Rent Facility - Assembly Facility - Finishing Glue Sandpaper Paint Cartons Insurance Utilities Overtime Shift Differential Assembly Supervision Finishing Supervision Janitor & Repair Supervision Depreciation Total Manufacturing Overhead Less: Glue Sandpaper Paint Cartons Depreciation Cash disbursements for MOH Overhead Rate Overhead Cost per Unit Monthly Unit Cost Total Unit Product Costs Over/Under Applied SCHEDULE 8 Selling & Administrative Expenses Budget January Office staff February General Manager Insurance Utilities Shipping Total Cash disbursed from S&A Loads SCHEDULE 9 Cash Budget January February Beginning Cash Balance Add: Receipts: Cash Collections Total Cash Available Less Disbursements: Cash Disbursements for Materials Total Direct Labor Cost Cash Disbursements for Capital Add Cash disbursements for MOH Total Cash disbursed from S&A Dividends Total Disbursement Excess (Deficiency) of cash Financing Borrowings (at the beginning of tne month) Repayments (at the end of the month) Interest Total Financing Ending Cash Balance Debt SCHEDULE 10 Budgeted Income Statement January Sales Cost of Goods Sold Over/Under Applied Overhead Gross Margin Selling and Administrative Expenses Net Operating Income February Interest Expenses Net Income SCHEDULE 11 Statement of Budgeted Retained Earnings January February January February Beginning Balance Add: Net Income Less Dividends Ending Retained Earnings SCHEDULE 12 Cash Flow Budget Operating Activities Budgeted Cash Sources Sales Revenue Budgeted Cash Uses Raw Material Direct Labor Factory Overhead Total Cash disbursed from S&A Interest Net Change in Cash From Operating Investing Activities Capital Assets - Cash Inflows Capital Assets - Cash Outflows Net Change in Cash from Investing Financing Activities Borrowing Money Paying Back Money Dividends Net Change in Cash from Financing Net Change in Cash Beginning Cash Balance Ending Cash Balance SCHEDULE 13 Budgeted Balance Sheet January Assets Cash Accounts Receivable Raw material Seats Legs Gliders Glue Sandpaper Paint Cartons Work in Process Finished Stools Assembly tools Accumulated Depreciation - 5 year Finishing Tools Accumulated Depreciation - 5 year Forklifts Accumulated Depreciation - 10 year Paint Booths Accumulated Depreciation - 10 year Total Assets Liabilities and Equity Accounts Payable Liabilities Total Liabilities Equity Total Liabilities and Equity February March April May June July May June July Last Years 0.00 Max Men 0.00 Max Men 0.00 Max Forklifts 0.00 Max Paint Booths s for Stools Inc. to supply the following during 2008 28 March April 60,000 60000 0.2 80,000 80000 90,000 90000 65,000 65000 50,000 50000 e of next month production 1 4 3 120 2 30 1 Cost per Component $1,200 per 1,000 Board Feet $1,600 per 1,000 Linear Feet $135 per Gross Lots Quantity Needed Per Stool 0.0083333333 Gallons Per Unit 0.5 Sheets Per Unit 0.0333333333 Gallons Per Unit 1 he suppliers Stools Inc. wants: nths production nths production nths production 0.2 0.3 0.25 nths production nths production nths production nths production 0.1 0.05 0.15 0.25 of purchase 0.6 1200 1600 135 Cost per Component $16 $8 $22 $235 $1.20 $1.60 $0.94 per Gallon per 100 Sheets per Gallon per 100 cartons umber of employees that one supervisor can handle 60 hour of employee time 0.2 Hours per stool 5 umber of employees that one supervisor can handle 45 hour of employee time 0.25 Hours per stool 4 4500 14 er of hours per month per employee without Overtime er of hours per month with Overtime March April 167 May 167 167 167 June 167 167 167 July 167 167 167 167 167 167 167 167 $2,000.00 Per month rger building and pays according to how many bays (area) of the building they require. The building is huge and Stools Inc. can lease all or t required by each direct laborer square feet in a bays ed and maintained by one Janitor repairman hours per month each 350 2800 8500 3500 9 4 167 employees that require 1 repair man 11 50 st per 1,000 Stools 980 36 $0.04 Cost per Stool bays that each forklift can service n each finishing bay Depreciation 5 168 5 years straight-line 215 5 5 years straight-line 9500 4 6700 3 10 10 years straight-line 10 10 years straight-line 1728 per Semi-Trailer load of 1,728 Stools as often as they can fill a semi-trailer there is a very small "Ending" finished goods inventory mber of chairs needed to meet the sales, the last load for the month may not be a full load. per month per month per month per month 3700 6500 2400 300 increments interest rate aid at the beginning of the following month March 20000 10000 0.075 0.0046 Interest Rate Per month April May 250,000 June 0 250000 0 0 July 250,000 250000 0 0 0 ntered into the cells below this line. Ever cell should be linked with othe March April 60,000 $28.00 1,680,000.00 May 80,000 $28.00 2,240,000.00 June 90,000 $28.00 2,520,000.00 July 65,000 $28.00 1,820,000.00 50,000 $28.00 1,400,000.00 2,016,000.00 364,000.00 1,456,000.00 Collections 1008000 336,000.00 1,344,000.00 448,000.00 1,792,000.00 504,000.00 280,000.00 1,344,000 March 1,792,000 April May 60,000 3,200 63,200 2,400 60,800 March 60,800 16,080 76,880 12,160 64,720 $1.20 $77,664.00 4 243,200 96,480 339,680 72,960 266,720 $1.60 $426,752.00 3 1.00 80,400 17,800 98,200 16,080 82,120 $1.20 $98,544.00 4 321,600 106,800 428,400 96,480 331,920 $1.60 $531,072.00 3 65,000 2,000 67,000 2,600 64,400 June 80,400 89,000 12,880 101,880 17,800 84,080 $1.20 $100,896.00 4 356,000 77,280 433,280 106,800 326,480 $1.60 $522,368.00 3 50,000 1,800 51,800 2,000 49,800 July 89,000 1.00 1,736,000 July 90,000 2,600 92,600 3,600 89,000 May 60,800 2,380,000 June 80,000 3,600 83,600 3,200 80,400 April 1.00 2,296,000 64,400 1.00 49,800 1.00 64,400 9,960 74,360 12,880 61,480 $1.20 $73,776.00 49,800 9,040 58,840 9,960 48,880 $1.20 $58,656.00 4 4 257,600 59,760 317,360 77,280 240,080 $1.60 $384,128.00 3 199,200 54,240 253,440 59,760 193,680 $1.60 $309,888.00 3 182,400 60,300 242,700 45,600 197,100 $0.94 $184,781.25 241,200 66,750 307,950 60,300 247,650 $0.94 $232,171.88 0.01 193,200 37,350 230,550 48,300 182,250 $0.94 $170,859.38 149,400 33,900 183,300 37,350 145,950 $0.94 $136,828.13 0.01 0.01 0.01 0.01 506.7 67.0 573.7 50.7 $523 $16.00 $8,368.00 670.0 74.2 744.2 67.0 $677 $16.00 $10,834.67 741.7 53.7 795.3 74.2 $721 $16.00 $11,538.67 0.5 40,200.0 2,225.0 42,425.0 2,010.0 40,415.0 $0.08 $3,233.20 0.5 44,500.0 1,610.0 46,110.0 2,225.0 43,885.0 $0.08 $3,510.80 0.5 30,400.0 2,010.0 32,410.0 1,520.0 30,890.0 $0.08 $2,471.20 0.033 2,680.0 445.0 3,125.0 402.0 2,723.0 $22.00 $59,906.00 0.033 2,966.7 322.0 3,288.7 445.0 2,843.7 $22.00 $62,560.67 0.033 0.5 0.033 2,026.7 402.0 2,428.7 304.0 2,124.7 $22.00 $46,742.67 1 1 60,800 20,100 80,900 15,200.0 65,700 $2.35 $154,395.00 March 267,000 48,300 315,300 66,750 248,550 $0.94 $233,015.63 89,000 16,100 105,100 22,250.0 82,850 $2.35 $194,697.50 May 415.0 37.7 452.7 41.5 $411 $16.00 $6,578.67 0.5 32,200.0 1,245.0 33,445.0 1,610.0 31,835.0 $0.08 $2,546.80 1 80,400 22,250 102,650 20,100.0 82,550 $2.35 $193,992.50 April 536.7 41.5 578.2 53.7 $524 $16.00 $8,392.00 24,900.0 1,130.0 26,030.0 1,245.0 24,785.0 $0.08 $1,982.80 0.033 2,146.7 249.0 2,395.7 322.0 2,073.7 $22.00 $45,620.67 1,660.0 226.0 1,886.0 249.0 1,637.0 $22.00 $36,014.00 1 1 64,400 12,450 76,850 16,100.0 60,750 $2.35 $142,762.50 June 49,800 11,300 61,100 12,450.0 48,650 $2.35 $114,327.50 July $77,664.00 $426,752.00 184,781.25 8,368.00 2,471.20 46,742.67 154,395.00 $901,174.12 $98,544.00 $531,072.00 232,171.88 10,834.67 3,233.20 59,906.00 193,992.50 $1,129,754.24 $271,067.43 $540,704.47 $360,469.65 $677,852.54 $811,771.90 March $100,896.00 $522,368.00 233,015.63 11,538.67 3,510.80 62,560.67 194,697.50 $1,128,587.26 $451,901.70 $677,152.35 $1,038,322.19 April $73,776.00 $384,128.00 170,859.38 8,392.00 2,546.80 45,620.67 142,762.50 $828,085.34 $451,434.90 $496,851.20 $1,129,054.05 May $58,656.00 $309,888.00 136,828.13 6,578.67 1,982.80 36,014.00 114,327.50 $664,275.09 $331,234.14 $398,565.05 $948,286.11 June $729,799.19 July 60,800 0.20 12,160 80,400 0.20 16,080 89,000 0.20 17,800 64,400 0.20 12,880 49,800 0.20 9,960 0.25 15,200 0.25 20,100 0.25 22,250 0.25 16,100 0.25 12,450 27,360 $14.00 $383,040.00 36,180 $14.00 $506,520.00 40,050 $14.00 $560,700.00 28,980 $14.00 $405,720.00 22,410 $14.00 $313,740.00 37.00 46 49.00 61 54.00 67 39.00 49 30.00 38 March April May June July 1,512.00 2,365.00 2,016.00 3,225.00 840.00 0.00 0.00 5 6 11 3 18 7 8 15 4 24 7 9 16 4 27 5 7 12 3 21 4 5 9 3 15 Costs Total $1.20 per board foot $1.60 per linier foot $0.94 per glider $1.20 $6.40 $2.81 $14.00 per hour $14.00 per hour $2.80 $3.50 per hour March April May June July March April May June July March April May June July March April May June July March April May June July March April May June July March April May June July August Septemger October November December August Septemger October November December 45,000 45000 50,000 50000 60,000 60000 45,000 45000 30,000 30000 Per Unit Per Unit Per Unit 16 8 22 235 $0.08 per Sheet $2.35 per carton August Septemger 167 167 167 167 October 167 167 167 ools Inc. can lease all or the area necessary (no limit on size, just costs) November 167 167 167 December 167 167 167 167 167 60 Months to Depreciate Straight-Line 60 Months to Depreciate Straight-Line 120 Months to Depreciate Straight-Line 120 Months to Depreciate Straight-Line August Septemger 0 October 250,000 250000 0 November 0 0 December 0 0 250,000 250000 ked with other cells. August Septemger 45,000 $28.00 1,260,000.00 50,000 $28.00 1,400,000.00 October 60,000 $28.00 1,680,000.00 November 45,000 $28.00 1,260,000.00 December 30,000 $28.00 840,000.00 1,120,000.00 252,000.00 1,372,000 August 1,008,000.00 280,000.00 1,288,000 Septemger 45,000 2,000 47,000 1,800 45,200 August 45,200 45,200 10,080 55,280 9,040 46,240 $1.20 $55,488.00 4 180,800 60,480 241,280 54,240 187,040 $1.60 $299,264.00 3 1,456,000 October 1,344,000.00 252,000.00 60,000 1,800 61,800 2,400 59,400 October December 59,400 44,400 1.00 1.00 50,400 11,880 62,280 10,080 52,200 $1.20 $62,640.00 59,400 8,880 68,280 11,880 56,400 $1.20 $67,680.00 44,400 5,760 50,160 8,880 41,280 $1.20 $49,536.00 201,600 71,280 272,880 60,480 212,400 $1.60 $339,840.00 3 4 237,600 53,280 290,880 71,280 219,600 $1.60 $351,360.00 3 30,000 0 30,000 1,200 28,800 December 1.00 4 1,176,000 45,000 1,200 46,200 1,800 44,400 November 50,400 1,008,000.00 168,000.00 1,596,000 November 50,000 2,400 52,400 2,000 50,400 Septemger 1.00 1,120,000.00 336,000.00 4 177,600 34,560 212,160 53,280 158,880 $1.60 $254,208.00 3 28,800 1.00 28,800 0 28,800 5,760 23,040 $1.20 $27,648.00 4 115,200 0 115,200 34,560 80,640 $1.60 $129,024.00 3 135,600 37,800 173,400 33,900 139,500 $0.94 $130,781.25 0.01 376.7 42.0 418.7 37.7 $381 $16.00 $6,096.00 0.5 22,600.0 1,260.0 23,860.0 1,130.0 22,730.0 $0.08 $1,818.40 0.033 1,506.7 252.0 1,758.7 226.0 1,532.7 $22.00 $33,718.67 1 45,200 12,600 57,800 11,300.0 46,500 $2.35 $109,275.00 August 151,200 44,550 195,750 37,800 157,950 $0.94 $148,078.13 0.01 178,200 33,300 211,500 44,550 166,950 $0.94 $156,515.63 0.01 133,200 21,600 154,800 33,300 121,500 $0.94 $113,906.25 0.01 420.0 49.5 469.5 42.0 $427 $16.00 $6,840.00 495.0 37.0 532.0 49.5 $482 $16.00 $7,720.00 0.5 25,200.0 1,485.0 26,685.0 1,260.0 25,425.0 $0.08 $2,034.00 0.5 29,700.0 1,110.0 30,810.0 1,485.0 29,325.0 $0.08 $2,346.00 0.5 0.033 1,680.0 297.0 1,977.0 252.0 1,725.0 $22.00 $37,950.00 0.033 1,980.0 222.0 2,202.0 297.0 1,905.0 $22.00 $41,910.00 0.033 1 50,400 14,850 65,250 12,600.0 52,650 $2.35 $123,727.50 Septemger 1 59,400 11,100 70,500 14,850.0 55,650 $2.35 $130,777.50 October 370.0 24.0 394.0 37.0 $357 $16.00 $5,712.00 22,200.0 720.0 22,920.0 1,110.0 21,810.0 $0.08 $1,744.80 1,480.0 144.0 1,624.0 222.0 1,402.0 $22.00 $30,844.00 1 44,400 7,200 51,600 11,100.0 40,500 $2.35 $95,175.00 November 86,400 0 86,400 21,600 64,800 $0.94 $60,750.00 0.01 240.0 0.0 240.0 24.0 $216 $16.00 $3,456.00 0.5 14,400.0 0.0 14,400.0 720.0 13,680.0 $0.08 $1,094.40 0.033 960.0 0.0 960.0 144.0 816.0 $22.00 $17,952.00 1 28,800 0 28,800 7,200.0 21,600 $2.35 $50,760.00 December $55,488.00 $299,264.00 130,781.25 6,096.00 1,818.40 33,718.67 109,275.00 $636,441.32 $265,710.04 $381,864.79 $647,574.83 August $62,640.00 $339,840.00 148,078.13 6,840.00 2,034.00 37,950.00 123,727.50 $721,109.62 $254,576.53 $432,665.77 $687,242.30 Septemger $67,680.00 $351,360.00 156,515.63 7,720.00 2,346.00 41,910.00 130,777.50 $758,309.12 $288,443.85 $454,985.47 $743,429.32 October $49,536.00 $254,208.00 113,906.25 5,712.00 1,744.80 30,844.00 95,175.00 $551,126.05 $303,323.65 $330,675.63 $633,999.28 November $27,648.00 $129,024.00 60,750.00 3,456.00 1,094.40 17,952.00 50,760.00 $290,684.40 $220,450.42 $174,410.64 $394,861.06 December 45,200 0.20 9,040 50,400 0.20 10,080 59,400 0.20 11,880 44,400 0.20 8,880 28,800 0.20 5,760 0.25 11,300 0.25 12,600 0.25 14,850 0.25 11,100 0.25 7,200 20,340 $14.00 $284,760.00 22,680 $14.00 $317,520.00 26,730 $14.00 $374,220.00 19,980 $14.00 $279,720.00 12,960 $14.00 $181,440.00 28.00 34 31.00 38 36.00 45 27.00 34 18.00 22 August Septemger October November December 0.00 0.00 0.00 0.00 0.00 4 5 9 3 15 4 5 9 3 15 5 6 11 3 18 4 5 9 3 15 3 3 6 2 9 August Septemger October November December August Septemger October November December August Septemger October November December August Septemger October November December August Septemger October November December August Septemger October November December August Septemger October November December First Quarter Second Quarter Third Quarter Fourth Quarter First Quarter Secon Quarter Third Quarter Forth Quarter Total 135,000 235,000 145,000 135,000 135000 235000 145000 135000 650,000 650000 650000 First Quarter 501 Secon Quarter 501 501 501 Third Quarter 501 501 501 Fourth Quarter 501 501 501 2004 501 501 2,004 2,004 Max Number Of Employees First Quarter Second Quarter Third Quarter Fourth Quarter Total 250,000 250,000 250,000 250,000 1,000,000 250000 250000 250000 250000 1000000 First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total 135,000 235,000 145,000 135,000 650,000 $28.00 $28.00 $28.00 $28.00 $28.00 3,780,000.00 6,580,000.00 4,060,000.00 3,780,000.00 18,200,000.00 $0.00 $840,000.00 $1,260,000.00 $336,000.00 1,344,000.00 $2,240,000.00 $2,520,000.00 $364,000.00 1,456,000.00 0.00 840,000.00 1,260,000.00 1,680,000.00 2,240,000.00 2,520,000.00 1,820,000.00 $1,400,000.00 $1,260,000.00 $280,000.00 4,228,000.00 1,400,000.00 1,260,000.00 1,400,000.00 1,680,000.00 1,260,000.00 168,000.00 2,436,000.00 6,468,000.00 4,396,000.00 4,228,000.00 4,228,000 17,528,000 1,120,000.00 $1,680,000.00 $1,260,000.00 $168,000.00 $2,436,000.00 $6,468,000.00 4,396,000.00 2,436,000 6,468,000 4,396,000 First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total 135,000 235,000 145,000 135,000 3,200 2,000 2,400 0 138,200 237,000 147,400 135,000 0 3,200 2,000 2,400 138,200 233,800 145,400 132,600 650,000 0 650,000 0 650,000 First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total 138,200 233,800 145,400 132,600 650,000 1.00 138,200 16,080 154,280 0 154,280 $1.20 $185,136.00 4 552,800 96,480 649,280 0 649,280 $1.60 $1,038,848.00 3 1.00 233,800 9,960 243,760 16,080 227,680 $1.20 $273,216.00 4 935,200 59,760 994,960 96,480 898,480 $1.60 $1,437,568.00 3 1.00 1.00 145,400 11,880 157,280 9,960 147,320 $1.20 $176,784.00 132,600 0 132,600 11,880 120,720 $1.20 $144,864.00 4 581,600 71,280 652,880 59,760 593,120 $1.60 $948,992.00 3 4 530,400 0 530,400 71,280 459,120 $1.60 $734,592.00 3 1.00 650,000 0 650,000 0 650,000 $1.20 $780,000.00 4 2,600,000 0 2,600,000 0 2,600,000 $1.60 $4,160,000.00 3 414,600 60,300 474,900 0 474,900 $0.94 $445,218.75 701,400 37,350 738,750 60,300 678,450 $0.94 $636,046.88 436,200 44,550 480,750 37,350 443,400 $0.94 $415,687.50 397,800 0 397,800 44,550 353,250 $0.94 $331,171.88 0.01 0.01 0.01 0.01 1,151.7 67 1,218.7 0.0 $1,219 $16.00 $19,498.67 1,948.3 41 1,989.8 67.0 $1,923 $16.00 $30,765.33 0.5 0.5 116,900.0 1,245 118,145.0 2,010.0 116,135.0 $0.08 $9,290.80 69,100.0 2,010 71,110.0 0.0 71,110.0 $0.08 $5,688.80 0.033 0.033 4,606.7 402 5,008.7 0.0 5,008.7 $22.00 $110,190.67 7,793.3 249 8,042.3 402.0 7,640.3 $22.00 $168,087.33 1 138,200 20,100 158,300 0.0 158,300 $2.35 $372,005.00 First Quarter 1 233,800 12,450 246,250 20,100.0 226,150 $2.35 $531,452.50 Secon Quarter 1,211.7 49 1,261.2 41.5 $1,220 $16.00 $19,514.67 0.5 72,700.0 1,485 74,185.0 1,245.0 72,940.0 $0.08 $5,835.20 0.033 4,846.7 297 5,143.7 249.0 4,894.7 $22.00 $107,682.67 1 145,400 14,850 160,250 12,450.0 147,800 $2.35 $347,330.00 Third Quarter 1,950,000 0 1,950,000 0 1,950,000 $0.94 $1,828,125.00 0.01 1,105.0 0 1,105.0 49.5 $1,055 $16.00 $16,888.00 0.5 5,416.7 0 5,416.7 0.0 $5,417 $16.00 $86,666.67 0.5 66,300.0 0 66,300.0 1,485.0 64,815.0 $0.08 $5,185.20 0.033 4,420.0 0 4,420.0 297.0 4,123.0 $22.00 $90,706.00 325,000.0 0 325,000.0 0.0 325,000.0 $0.08 $26,000.00 0.033 21,666.7 0 21,666.7 0.0 21,666.7 $22.00 $476,666.67 1 132,600 0 132,600 14,850.0 117,750 $2.35 $276,712.50 Fourth Quarter 1 650,000 0 650,000 0.0 650,000 $2.35 $1,527,500.00 2008 Total $185,136.00 $1,038,848.00 445,218.75 19,498.67 5,688.80 110,190.67 372,005.00 $2,176,585.88 $273,216.00 $1,437,568.00 636,046.88 30,765.33 9,290.80 168,087.33 531,452.50 $3,086,426.84 0 597,743 677,669 540,704 360,470 1,129,754 1,128,587 496,851 $176,784.00 $948,992.00 415,687.50 19,514.67 5,835.20 107,682.67 347,330.00 $2,021,826.03 331,234 664,275 636,441 432,666 $144,864.00 $734,592.00 331,171.88 16,888.00 5,185.20 90,706.00 276,712.50 $1,600,119.57 $780,000.00 $4,160,000.00 1,828,125.00 86,666.67 26,000.00 476,666.67 1,527,500.00 $8,884,958.33 $1,772,289.66 0 597,743 677,669 901,174 1,129,754 1,128,587 828,085 664,275 636,441 721,110 758,309 551,126 174,411 1,816,116 3,115,662 2,064,616 1,772,290 1,772,290 8,768,685 288,444 758,309 551,126 174,411 1,816,116 3,115,662 2,064,616 1,816,116 3,115,662 2,064,616 First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total 138,200 233,800 145,400 132,600 0.20 0.20 0.20 0.20 27,640 46,760 29,080 26,520 650,000 0.20 130,000 0.25 34,550 0.25 58,450 0.25 36,350 0.25 33,150 0.25 162,500 62,190 $14.00 $870,660.00 105,210 $14.00 $1,472,940.00 65,430 $14.00 $916,020.00 59,670 $14.00 $835,380.00 292,500 $14.00 $4,095,000.00 31.00 38 36.00 45 54.00 67 Maximum Number Needed 37.00 46 54.00 67 First Quarter Secon Quarter 6,216 Maximum Number Needed 5 6 11 3 18 Third Quarter Fourth Quarter 2008 Total 2,856 0 0 9,072 7 9 16 4 27 4 5 9 3 15 5 6 11 3 18 7 9 16 4 27 First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total Total Manufacturing Overhead Total Cost Driver Cost per unit of driver First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total First Quarter Secon Quarter Third Quarter Fourth Quarter 2008 Total First Quarter Secon Quarter Third Quarter Fourth Quarter 54166.6666666667 Ending Accounts Recievable 672,000.00 Ending Accounts Payable $116,273.76 SCHEDULE 8 Selling SCHEDULE 11 Statem OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK ~ ~ OK OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK ~ ~ OK OK ~ ~ OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK SCHEDULE 1 Sales Budget OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK SCHEDULE 2 Production Budget OK OK OK OK OK OK OK OK OK OK SCHEDULE 3 Direct Materials Budget OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK SCHEDULE 4 Direct Labor Budget OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK NO NO NO NO NO NO NO NO SCHEDULE 5 Capital Additions Budget OK OK NO NO NO OK OK NO NO NO OK OK NO NO NO OK OK NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO SCHEDULE 6 Ending Finished Goods Inventory Budget OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK NO NO NO NO SCHEDULE 7 Manufacturing Overhead NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO no NO NO NO no NO NO NO NO NO SCHEDULE 8 Selling & Administrative Expenses Budget NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO SCHEDULE 9 Cash Budget NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO SCHEDULE 10 Budgeted Income Statement NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO SCHEDULE 11 Statement of Budgeted Retained Earnings NO NO NO NO NO NO NO NO SCHEDULE 12 Cash Flow Budget NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO SCHEDULE 13 Budgeted Balance Sheet NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO OK OK OK OK OK OK OK OK OK OK OK OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK ~ ~ OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK NO NO NO NO NO NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK NO NO NO NO OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK OK NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO N