Please help me with this homework :))
Test BlankFormVersioanomplete Budgeting Test - Version 2 Ally Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Proiected sales in units for the coming five months follow: January February March April May The following data pertain to production policies and manufacturing specifications followed by Ally Maunfacturing: a. Finished goods inventory on January 1 is The desired ending inventory for each month is b. The data on materials used are as follows: Direct material Metal Components 42,000 52,000 59,000 60,000 62,000 32,000 units, each costing 80% of the next month's sales. Per-unit Usage DM Unit cost [5] 10 lbs. 8 6 5 Inventory policy dictates that sufficient materials be on hand at the end of the month to produce of the next month's production needs. This is exactly the amount of material on hand on December 31 of the prior year. c. The direct labor used per unit of output is per houris 14.25 5 hours. The average direct labor cost d. Overhead each month is estimated using a exible budget formula. (Note: Activity is measured in direct labor hours.) xed-Cost Component {$1 Supplies - Power - Maintenance 30,000 Supervision 16,000 Depreciation 200,000 Taxes 12,000 Other 80,000 Total 338,000 Variable-cost Component [Si 1.00 0.50 0.40 0.50 2.40 e. Monthly selling and administrative expenses are also estimated using a flexible budgeting formula (Note: Activity is measured in units sold.) Fixed Cost {5] Salaries 50,000 Commissions - Depreciation 40,000 Shipping - Other 20,000 Total 110,000 f. The unit selling price of the subassembly is g. All sales and purchases are for cash. The cash balance on January 1 equals The firm requires a minimum ending balance of $205.00 Variable Cost [5) 2.00 1.00 0.60 3.6 $400,000 50,000 5. If the firm develops a cash shortage by the end of the month, sufficient cash is borrowed to cover the shortage. Any cash borrowed is repaid at the end of month. as is the interest due {cash borrowed at the end of the month is repaid at end of the following month). The interest rate is 12% per annum. No money is own at the beginning of January. $165.95 50%