MASTER BUDGET The company Alpha & Omega Manufacturing shares the following infor
ID: 2612307 • Letter: M
Question
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 =) ***********
Explanation / Answer
1)
Direct material budget is as follows:
Particulars
Q1
Q2
Q3
Q4
Sales
35000
37500
42200
50300
Add:
Closing inventory
5625
6330
7545
6791
Less:
Beginning inventory
3000
5625
6330
7545
Production units
37625
38205
43415
49546
Production cost @22
827750
840510
955130
1090012
Add:
Desired inventory
66220
67240.8
76410.4
87200.96
Direct material cost
893,970
907,751
1,031,540
1,177,213
Particulars
Q1
Q2
Q3
Q4
Sales
35000
37500
42200
50300
Add:
Closing inventory
5625
6330
7545
6791
Less:
Beginning inventory
3000
5625
6330
7545
Production units
37625
38205
43415
49546
Production cost @22
827750
840510
955130
1090012
Add:
Desired inventory
66220
67240.8
76410.4
87200.96
Direct material cost
893,970
907,751
1,031,540
1,177,213
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.