MASTER BUDGET

The company Alpha & Omega Manufacturing shares the following information:

Cash ("Cash") as of 31 December 20X5 ......... $ 75,000 Unit sales for 20X5 per quarter were as follows:

They estimate that by 20x6 sales will be down 10%.

3. All sales are on credit. These 60% are charged the same quarter of generation and 40% in the following quarter. (Note: The sales in the fourth quarter of 20X5 were $ 900,000, 40% of these sales will be collected in the first quarter of 20X6.)

4. The selling price of manufactured product is $ 22.

5. The desired ending inventory for each quarter must be equal to 15% of sales in the next quarter.

6. The management ensures that the initial inventory of direct material of each quarter is 8% of the cost needed for production.

7. The initial inventory of production is 3,000 units. The final inventory in the fourth quarter of 20X6 is projected 6,791unidades.

8. The hours of direct labor are 0.60 per unit, paying $ 8.00 an hour to line employees. The total average hours worked is 480 per quarter.

9. Spending in variable and fixed manufacturing overhead is broken down as follows:

Variable cost per unit:

10.The administrative budget and sales by quarter is presented below:

11. During the first quarter of 20X6 equipment was purchased for $ 30,000.

12. During 20X6 expected to be paid $ 5,000 in dividends in each quarter.

13. The following accounts are projected for 20X6:

Requested:

Take a MASTER BUDGET showing the four quarters to Alpha & Omega Manufacturing for 20X6. This should include:

1- Direct Material Purchase Budget

2- Cash Budget

3- Budgeted Income Statement

4 -Budgeted Balance Sheet

******** Can you please write down on all the calculation process Thank =) ***********