pls help asap, Requirements:

a.Schedule of Selling and Administration

b. Cash flow

Wood Parts-Musical Instruments Ltd Wood Parts-Musical Instruments LTD (WPMI) is a worldwide wooden musical part manufacturing firm based in North America. After many years in the market, the Peterborough division, which produces one product called Xylophone1BX reaches a spike on the sales level. The Management wants to have a significant investment to expand the facility and increase production, but it is requesting from the division to prepare a monthly 2021 budget. The fiscal year ends on Dec 31. The division manager forecast the following sales: For the year ended Dec 31, 2020: 95,000 units at $50.00 each * (*Expected sales for the year ended December 31, 2020 are based on actual sales to date and budgeted sales for the duration of the year) For the year ended Dec 31, 2021: 100,000 units at $50.00 each For the year ended Dec 31, 2022: 110,000 units at $50.00 each. 1. The management expect a distribution of sales for each month based on percentage of the total budgeted as follow: Jan, Feb & Mar 2% each; Apr, Aug and Sep 6% each; May, Jun & Jul 9% each; Oct 10%; Nov 17% & Dec 22%. 2. From previous experience, management has determined that an ending inventory equal to 20% of the next month's sales is required to fit the buyer's demands. 3. Because sales are seasonal, Wood Parts-Musical Instruments must rent an additional storage facility from October to December to house the additional inventory on hand. The only related cost is a flat $10,000 per month, payable at the beginning of the month. 4. The XylophonelbX requires three types of raw materials: . Plastic PR is a compact material that is purchased in powder form. Each Xylophone 1BX requires 0.5 kilograms of Plastic PR, at a cost of $25.00 per kilogram. The supplier of Plastic PR tends to be somewhat erratic so Wood Parts-Musical Instruments finds it necessary to maintain an inventory balance equal to 40% of the following month's production needs as a precaution against stock-outs. . A plastic wheel assembly is purchased in kit form, and is attached during the assembly process. For a small premium, Wood Parts-Musical Instruments has made a JIT agreement with the supplier which includes on-time and quality assurances. Each Xylophone1BX uses two kits, which cost $1.00 each. The supplier must be paid in cash The final component for the musical instrument is a length of cord which is used to pull the mobile XylophonelBX along the ground or floor. The cord supplier must be paid in cash. On the first day of every month she delivers exactly the right amount to manufacture the budgeted number of units for that month. It costs $2.00 per meter and Wood Parts-Musical Instruments uses one-half meter for each Xylophone1 BX. 3 10. Fixed manufacturing overhead costs are not separated between departments. The total costs for the entire year are as follows: Training and development Supervisor's salary Depreciation on equipment Insurance Other $ 43,620 269,400 178,800 96,000 117,600 $ 705.420 The annual insurance premium is paid at the beginning of September each year. There should be no change in the premium from last year. All other "cash-related" fixed manufacturing overhead costs are incurred evenly over the year and paid as incurred. Wood Parts-Musical Instruments Ltd uses the straight line method of Depreciation. 11. Selling and administrative expenses are known to be a mixed cost; however, there is a lot of uncertainty about the portion that is fixed. Previous year's experience has provided the following information (rounded): Lowest level of sales: 70,000 units Total Operating Expenses: $769,800 Highest level of sales: 110,000 units Total Operating Expenses: $1,009,800 The annual amount of Depreciation on office furniture and equipment is only $21,000 and this amount is already included in the fixed portion of the selling and administration expenses. Not included in the above expenses is bad debt expense. Payments for selling and administrative expenses occur in the month in which they are incurred. 12. Sales are on cash and on account (credit), 70% of the sales are collected during the month of sales, 20% the following month, 9.5% the month thereafter. 12 of 1% of sales are considered uncollectible (Bad debt expense) 13. Sales in November and December 2020 are expected to be $807,500 and $1,045,000 respectively. Based on the above collection pattern this will result in Accounts Receivable of $384,988 at December 31, 2020 which will be collected in January and February, 2021. 14. During the fiscal year ended December 31, 2021, Wood Parts-Musical Instruments will be required to make monthly income tax installment payments of $5,000. Outstanding income taxes from the year ended December 31, 2020 must be paid in April 2021. Income tax expense is estimated to be 30% of net income. Income taxes for the year ended December 31, 2021, in excess of installment payments, will be paid in April, 2022. 15. Wood Parts-Musical Instruments approved to purchase new equipment for $306,000 cash. Three equal payments to the suppliers will be in February 2021, March 2021 and April 2021. The equipment depreciation from this equipment, is already considered included) in the manufacturing overhead cost given. 16. The company wants to maintain at the end of each month, a minimum bank balance of $80,000. In case the company has a deficiency of money or it is not able to reach this minimum bank balance, the company can borrow from a line of credit at the same bank at the rate of 12% per annum. All borrowing is considered to happen on the first day of the month, repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of $1,000 and interest must be paid at the end of each month. Interest is calculated on the balance at the beginning of the month, which includes any amounts borrowed that month. 17. Wood Parts-Musical Instruments LTd pays dividends at the end of each quarter, and based on the last meetings, the company will continue paying $50,000 dividends per quarter. 18. A listing of the estimated balances in the company's ledger accounts as of December 31, 2020 is given below: Statement of Financial Position at Dec 31, 2020. Assets Cash Accounts receivable Inventory-raw materials (PlasticRP) Inventory-finished goods Prepaid Insurance Capital assets (net) Total assets S 83,365 384,988 10,000 14,200 64,000 724,000 $1.280.553 Liabilities and Shareholders' Equity Accounts payable S 101,278 Income taxes payable 22,500 Capital stock 1,000,000 Retained Earnings 156,775 Total liabilities and shareholders' equity $1.280.553 6 Wood Parts-Musical Instruments Ltd Wood Parts-Musical Instruments LTD (WPMI) is a worldwide wooden musical part manufacturing firm based in North America. After many years in the market, the Peterborough division, which produces one product called Xylophone1BX reaches a spike on the sales level. The Management wants to have a significant investment to expand the facility and increase production, but it is requesting from the division to prepare a monthly 2021 budget. The fiscal year ends on Dec 31. The division manager forecast the following sales: For the year ended Dec 31, 2020: 95,000 units at $50.00 each * (*Expected sales for the year ended December 31, 2020 are based on actual sales to date and budgeted sales for the duration of the year) For the year ended Dec 31, 2021: 100,000 units at $50.00 each For the year ended Dec 31, 2022: 110,000 units at $50.00 each. 1. The management expect a distribution of sales for each month based on percentage of the total budgeted as follow: Jan, Feb & Mar 2% each; Apr, Aug and Sep 6% each; May, Jun & Jul 9% each; Oct 10%; Nov 17% & Dec 22%. 2. From previous experience, management has determined that an ending inventory equal to 20% of the next month's sales is required to fit the buyer's demands. 3. Because sales are seasonal, Wood Parts-Musical Instruments must rent an additional storage facility from October to December to house the additional inventory on hand. The only related cost is a flat $10,000 per month, payable at the beginning of the month. 4. The XylophonelbX requires three types of raw materials: . Plastic PR is a compact material that is purchased in powder form. Each Xylophone 1BX requires 0.5 kilograms of Plastic PR, at a cost of $25.00 per kilogram. The supplier of Plastic PR tends to be somewhat erratic so Wood Parts-Musical Instruments finds it necessary to maintain an inventory balance equal to 40% of the following month's production needs as a precaution against stock-outs. . A plastic wheel assembly is purchased in kit form, and is attached during the assembly process. For a small premium, Wood Parts-Musical Instruments has made a JIT agreement with the supplier which includes on-time and quality assurances. Each Xylophone1BX uses two kits, which cost $1.00 each. The supplier must be paid in cash The final component for the musical instrument is a length of cord which is used to pull the mobile XylophonelBX along the ground or floor. The cord supplier must be paid in cash. On the first day of every month she delivers exactly the right amount to manufacture the budgeted number of units for that month. It costs $2.00 per meter and Wood Parts-Musical Instruments uses one-half meter for each Xylophone1 BX. 3 10. Fixed manufacturing overhead costs are not separated between departments. The total costs for the entire year are as follows: Training and development Supervisor's salary Depreciation on equipment Insurance Other $ 43,620 269,400 178,800 96,000 117,600 $ 705.420 The annual insurance premium is paid at the beginning of September each year. There should be no change in the premium from last year. All other "cash-related" fixed manufacturing overhead costs are incurred evenly over the year and paid as incurred. Wood Parts-Musical Instruments Ltd uses the straight line method of Depreciation. 11. Selling and administrative expenses are known to be a mixed cost; however, there is a lot of uncertainty about the portion that is fixed. Previous year's experience has provided the following information (rounded): Lowest level of sales: 70,000 units Total Operating Expenses: $769,800 Highest level of sales: 110,000 units Total Operating Expenses: $1,009,800 The annual amount of Depreciation on office furniture and equipment is only $21,000 and this amount is already included in the fixed portion of the selling and administration expenses. Not included in the above expenses is bad debt expense. Payments for selling and administrative expenses occur in the month in which they are incurred. 12. Sales are on cash and on account (credit), 70% of the sales are collected during the month of sales, 20% the following month, 9.5% the month thereafter. 12 of 1% of sales are considered uncollectible (Bad debt expense) 13. Sales in November and December 2020 are expected to be $807,500 and $1,045,000 respectively. Based on the above collection pattern this will result in Accounts Receivable of $384,988 at December 31, 2020 which will be collected in January and February, 2021. 14. During the fiscal year ended December 31, 2021, Wood Parts-Musical Instruments will be required to make monthly income tax installment payments of $5,000. Outstanding income taxes from the year ended December 31, 2020 must be paid in April 2021. Income tax expense is estimated to be 30% of net income. Income taxes for the year ended December 31, 2021, in excess of installment payments, will be paid in April, 2022. 15. Wood Parts-Musical Instruments approved to purchase new equipment for $306,000 cash. Three equal payments to the suppliers will be in February 2021, March 2021 and April 2021. The equipment depreciation from this equipment, is already considered included) in the manufacturing overhead cost given. 16. The company wants to maintain at the end of each month, a minimum bank balance of $80,000. In case the company has a deficiency of money or it is not able to reach this minimum bank balance, the company can borrow from a line of credit at the same bank at the rate of 12% per annum. All borrowing is considered to happen on the first day of the month, repayments are on the last day of the month. All borrowings and repayments from the bank should be in multiples of $1,000 and interest must be paid at the end of each month. Interest is calculated on the balance at the beginning of the month, which includes any amounts borrowed that month. 17. Wood Parts-Musical Instruments LTd pays dividends at the end of each quarter, and based on the last meetings, the company will continue paying $50,000 dividends per quarter. 18. A listing of the estimated balances in the company's ledger accounts as of December 31, 2020 is given below: Statement of Financial Position at Dec 31, 2020. Assets Cash Accounts receivable Inventory-raw materials (PlasticRP) Inventory-finished goods Prepaid Insurance Capital assets (net) Total assets S 83,365 384,988 10,000 14,200 64,000 724,000 $1.280.553 Liabilities and Shareholders' Equity Accounts payable S 101,278 Income taxes payable 22,500 Capital stock 1,000,000 Retained Earnings 156,775 Total liabilities and shareholders' equity $1.280.553 6