Total sales consist of the following: Cash sales: 5% Credit sales: 95% Credit collections are as follows: In the month following the month of sale: 75% In the second month following the month of sale: 25% The Company does not have any bad debts. The Company's policy is to produce during each month, enough units to meet the current month's sales as well as a desired inventory at the end of the month which should be equal to 23% of next month's estimated sales. On December 31, 2016, the finished goods inventory consisted of 1, 714 units at a cost of $50.40. Each month the Company purchases enough raw materials to meet that month's production requirements and an amount equal to 25% of the next month's estimated production requirements. Each unit of finished product requires 2.83 pounds of raw materials at a cost of $1.38 per pound. On December 31, 2016, the raw materials inventory consisted of 5, 213 lbs. at a cost of $1.38. Payments are made as follows: In the month of purchase: 80% In the following month the balance: 20% The accounts payable balance of $5, 755.15 as of December 31, 2016, represents 20% of purchases made in December 2016 to be paid in January 2017. Direct labor hours required per unit of finished product: 1.75 Average rate per direct labor hour: $ 12.25 The Company applies variable manufacturing overhead cost at the rate of 120% of direct labor cost and fixed factory overhead on the basis of the number of direct labor hours. The company has the following fixed overhead expenses per month: Factory supervisor's salary $ 54,000.00 Factory rent 6,000.00 Factory insurance 6, 500.00 Depreciation of factory equipment 600.00 All manufacturing overhead costs, except depreciation, are paid for in cash during the month in which they are incurred. Combined tax rate is 30% of Income before taxes computed at the end of the quarter ending March 31, 2017, payable in the second quarter. The Company expects to buy a new computer on January 31, 2017, for use in the sales and administrative offices at a cost of $180,000.00, which will be paid in cash. Monthly depreciation expense will be an additional $3,000.00. On March 31, 2017, the Company is scheduled to pay $300,000.00, of the long-term notes payable plus interest expense for the first quarter at a rate of 12% With respect to short-term borrowing, the Company's policy is to borrow at the beginning of a month with an anticipated cash deficiency. A minimum cash balance of $25,000.00 is required of the end of each month. The Company repays the principal of such short-term borrowing at the end of the first following month to the extent of anticipated excess cash. Interest must be paid the following month at a rate of 12%. Borrowing and principal repayments are made in multiples of $1,000.00. Investments earn interest of the rate of 6% per annum which is credited to our Checking account by the bank at the beginning of the following month. You may assume that the balance of Marketable Securities at December 31, 2016, was outstanding throughout the entire month. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. Prepare, in good form, a Master Budget which includes the following: Sales Budget Production Budget Direct Materials Budget Direct Labor Budget Manufacturing Overhead Budget Selling and Administrative Expense Budget Schedule of Expected Collections from Customers Schedule of Expected Payments to Vendors Cash Budget Total and Per Unit Cost of Goods Sold (break-down by DM/DL/MOH) Ending Inventory amounts (show calculations) All budgets should be tor the individual three months of the first quarter of 2017. Include a quarterly total column on the right side, (except for #10 and #11) Each budget/requirement should be in a separate notebook within one spreadsheet. All pages should be in portrait format using the same font type and size. Please staple the printed copy in the upper left corner. Do not put the sheets into plastic or a binder. Treat this as you would any other professional document you are presenting to a client or employer. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. Total sales consist of the following: Cash sales: 5% Credit sales: 95% Credit collections are as follows: In the month following the month of sale: 75% In the second month following the month of sale: 25% The Company does not have any bad debts. The Company's policy is to produce during each month, enough units to meet the current month's sales as well as a desired inventory at the end of the month which should be equal to 23% of next month's estimated sales. On December 31, 2016, the finished goods inventory consisted of 1, 714 units at a cost of $50.40. Each month the Company purchases enough raw materials to meet that month's production requirements and an amount equal to 25% of the next month's estimated production requirements. Each unit of finished product requires 2.83 pounds of raw materials at a cost of $1.38 per pound. On December 31, 2016, the raw materials inventory consisted of 5, 213 lbs. at a cost of $1.38. Payments are made as follows: In the month of purchase: 80% In the following month the balance: 20% The accounts payable balance of $5, 755.15 as of December 31, 2016, represents 20% of purchases made in December 2016 to be paid in January 2017. Direct labor hours required per unit of finished product: 1.75 Average rate per direct labor hour: $ 12.25 The Company applies variable manufacturing overhead cost at the rate of 120% of direct labor cost and fixed factory overhead on the basis of the number of direct labor hours. The company has the following fixed overhead expenses per month: Factory supervisor's salary $ 54,000.00 Factory rent 6,000.00 Factory insurance 6, 500.00 Depreciation of factory equipment 600.00 All manufacturing overhead costs, except depreciation, are paid for in cash during the month in which they are incurred. Combined tax rate is 30% of Income before taxes computed at the end of the quarter ending March 31, 2017, payable in the second quarter. The Company expects to buy a new computer on January 31, 2017, for use in the sales and administrative offices at a cost of $180,000.00, which will be paid in cash. Monthly depreciation expense will be an additional $3,000.00. On March 31, 2017, the Company is scheduled to pay $300,000.00, of the long-term notes payable plus interest expense for the first quarter at a rate of 12% With respect to short-term borrowing, the Company's policy is to borrow at the beginning of a month with an anticipated cash deficiency. A minimum cash balance of $25,000.00 is required of the end of each month. The Company repays the principal of such short-term borrowing at the end of the first following month to the extent of anticipated excess cash. Interest must be paid the following month at a rate of 12%. Borrowing and principal repayments are made in multiples of $1,000.00. Investments earn interest of the rate of 6% per annum which is credited to our Checking account by the bank at the beginning of the following month. You may assume that the balance of Marketable Securities at December 31, 2016, was outstanding throughout the entire month. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures. Prepare, in good form, a Master Budget which includes the following: Sales Budget Production Budget Direct Materials Budget Direct Labor Budget Manufacturing Overhead Budget Selling and Administrative Expense Budget Schedule of Expected Collections from Customers Schedule of Expected Payments to Vendors Cash Budget Total and Per Unit Cost of Goods Sold (break-down by DM/DL/MOH) Ending Inventory amounts (show calculations) All budgets should be tor the individual three months of the first quarter of 2017. Include a quarterly total column on the right side, (except for #10 and #11) Each budget/requirement should be in a separate notebook within one spreadsheet. All pages should be in portrait format using the same font type and size. Please staple the printed copy in the upper left corner. Do not put the sheets into plastic or a binder. Treat this as you would any other professional document you are presenting to a client or employer. Use proper rounding and show two (2) decimal places of accuracy on dollar amounts. Round up and show whole amounts on all other figures