Hi!

I elwonder if anyone can help me with this problem. I am having trouble calculating for the problems selling and administrative budget, ending finished goods budget, cash budget, and income statement budget.

Your help is really appreciated.

Thank you in advance.

- A A A E 211 Albed De AaBbce Acc AaBb Atle $ 77,900 Mynor Company Balance Sheet As of December 31, 2019 Assets Liabilities & Owners' Equity Current Assets Current Liabilities Cash $ 31,400 A/P A/R 65,000 Raw Materials 19,500 Owners' Equity Finished Goods 128,820 Common Stock $125,000 Total Current Assets $244,720 Retained Earnings 520,000 Long Term Assets PP&E $922,180 Total Owners'Equity Accum Deprec (444,000) Net PPE 478,180 Total Assets $722,900 Total Liabs & Owners Equity 645,000 $722,900 1. Sales projections for the 2020 are: 1" Quarter 70,000 units 2-4 Quarter 6 0,000 units 3 Quartet 90,000 units 4th Quarter 120,000 units Each unit sells for $17 and is sold on account. Cash collections are 80% in the month of sale and 20% in the following month. 2. Production: The company desires a finished goods inventory at the end of each quarter equal to 20% of the budgeted sales for the next quarter. 1" quarter beginning finished goods inventory is 10,000 units and 4 quarter ending finished goods inventory is 25,000 units. Materials O Each unit requires 3 pounds of raw materials that cost $2.00 per pound. The company desires an ending materials inventory equal to 10% of the following quarter's production needs. (Beginning raw materials inventory equals 30,000 pounds and ending raw materials inventory equals 45,000 pounds). O Raw materials are purchased on account. The company pays 50% of the A/P in the period the materials are purchased and 50% in the following period. Labor Each unit of product requires 30 minutes 1.5 hours to produce and workers are C sale pui Lilaseu du JU I wie IUIUWIB perlu. Labor o Each unit of product requires 30 minutes (.5 hours) to produce and workers are paid $10 per hour. o o Variable MOH is $4 per direct labor hour and fixed MOH is $70,000 per quarter. Depreciation makes up $30,000 of each quarter's fixed overhead. Selling & Administrative Variable S&A is $2.00 per unit and fixed S&A is $20,000 per quarter. Depreciation included in Fixed S& A = $8,000. REQUIREMENTS ON NEXT PAGE Selling & Administrative Budget Ending Finished Goods Budget Cash Budget Budgeted Income Statement