Please show clearly answer choice (MCQs) and your calculations

Please use EXCEL (if possible) for your answers

19. Individual budget schedules are prepared to develop an annual comprehensive or master budget. The budget schedule that provides the necessary input data for the direct labor budget is the A Sales forecast B. Raw materials purchases budget. C. Schedule of cash receipts and disbursem D. Production budget 6.7. Transfer Pricing 20. A limitation of transfer prices based on actual cost is that they A Charge inefficiencies to the department that is transferring the goods. B. Can lead to suboptimal decisions for the company as a whole C. Must be adjusted by some markup. D. Lack clarity and administrative convenience. 21. Division 2 of a company produces a component that it currently sells to outside customers for US $20 per unit. At its current level of production, which is 60% of capacity, Division Z's fixed cost of producing this component is US $5 per unit and its variable cost is US $12 per unit Division Y of the same company would like to purchase this component from Division Z for US $10. Division 2 has enough excess capacity to Division Y's requirements. The managers of both divisions are compensated based upon reported profes. Which of the following transfer prices will maximize total company profits and be most equitable to the managers of Division Y and Division 2? A US $12 per unit BUS $18 per unit C US $20 per unit D. US $22 per unit 6.9 Relevant Costs Questions 30 and 31 are based on the following information A company manufactures and sells a single product. It takes 2 machine hours to produce one unit Annual sales are expected to be 75.000 units Annual production capacity is 200,000 machine hours Expected selling price is US $10 per unt Cost data for manufacturing and selling the product are as follows: Variable costs (per unit) Direct materials Direct labor US $3.00 1.00 Variable manufacturing overhead 0.80 Variable selling 2.00 Fixed costs (per year) Fixed manufacturing overhead Fixed selling US $90,000 60,000 30. S The company receives a special order for 10,000 US $7.60 Variable selling cost for each of 10.000 units will be US $1.20 instead of the normal US $2.00 This special order will not affect regular sales of 75,000 units. If the company accepts this special order, its profit will A Increase by US $8,000 B. Increase by US $16.000 C. Decrease by US $4,000 D. Decrease by US $12,000 31. The company estimates that by reducing its selling price to US $9.30 per unit, it can increase sales to 90.000 units annually. Fixed costs per year and unit variable costs will remain unchanged if the company reduces its selling price to US $0.30 per unit, its profit will A Decrease by US $5,000 Decrease by US $15,000 CDecrease by US $45.000 D. Increase by US $15.000 32. When applying the cost-benefit approach to a decision, the primary criterion is how well management goals will be achieved in relation to costs Costs include all expected A Variable costs for the courses of action but not expected fixed costs because only the expected variable costs are relevant B. Incremental out-of-pocket costs as well as all expected continuing costs that are common to all the alternative courses of action C. Future costs that differ among the alternative courses of action plus all qualitative factors that cannot be measured in numerical terms D. Historical and future costs relative to the courses of action including all qualitative factors that cannot be measured in numerical