Manufacturing Financial Budgeting CLA2
hg13579
Pa2guide-2.xlsxSheet1
| First name | Last name | ||
| Amarnath | Audhimoolam | X | S |
| Chongwen | Xie | X | S |
| Huafeng | Zhang | X | S |
| Jasdeep | Kang | X | |
| Jieqiong | Tu | ||
| Kabi | Nurgaliyev | X | S |
| Nivas | Buvaneswaran | X | S |
| Nutthaporn (Nat) | Kotchinsut | X | S |
| Qimin | Wang | X | |
| Rana Muhammad | Awais | X | S |
| Ravikumar | Poshiya | X | |
| Ruiting | Xu | S | |
| Siddharth | Timiri Vijayakumar | X | S |
| Sree Lasya | Runjala | X | |
| Sriram | Kandukuri | X | S |
| Thao | Tran | X | S |
| Thejeswar Prasad | Oleti | ||
| Thy | Le Thi Diem | X | |
| Xun | Jin | X | S |
| Ying | Zhang | X | SS |
Sheet2
| Week 6 DQ #2 For this DQ, please provide general discussion on the pre-determined variable overhead, its possible dependence on the actitivties for which the use, provide in-text citation then provide an example similar to following explain your example in detail, example below for use by chongwen only | |||||||||
| Unit Price | $2,000 | Sales | $2,800,000 | ||||||
| 3 activities | Machining | Assembly | Inspection | Variable cost | Machining | Assembly | Inspection | Combined | |
| Unit Direct Material | $400 | (5:4:1) | Direct Material | $280,000 | $224,000 | $56,000 | $560,000 | ||
| Unit Direct Labor | $250 | (2:2:1) | Direct Labor | $140,000 | $140,000 | $70,000 | $350,000 | ||
| Unit Variable selling admin | $100 | Variable overhead | $140,000 | $112,000 | $14,000 | $266,000 | |||
| Fixed overhead | $200,000 | (12:5:2:1) | Variable selling admin | $140,000 | |||||
| Fixed sellling admin | $150,000 | Variable cost | $1,316,000 | ||||||
| V | 1400 | CM | $1,484,000 | ||||||
| Machining | Assembly | Inspection | Fixed cost | Machining | Assembly | Inspection | Common | Combined | |
| Base | Machine hr | Direct Material | Direct Labor | Fixed overhead | $120,000 | $50,000 | $20,000 | $10,000 | $200,000 |
| Variable Overhead rate | $50/hr | 0.5 | 0.2 | Fixed selling admin | $150,000 | ||||
| Each unit of the product requires 2 machining hrs | Fixed cost | $350,000 | |||||||
| Operating income | $1,134,000 |
Sheet3
| for this assignment please explain the initial problem and the initial assumptions, then provide a complete answer. Explain your work in detail atleast 5 references are required for this assignment. One should be the textbook as the source of data. | |||
| For this PA2 please explain the initial problem, then provide the solution, explain your work in detail and provide in text citations. Atleast 5 references are required for this assignment, among which one should be text book as the source of data | |||
| July | August | September | |
| Sales | $ 63,400 | $ 80,600 | $ 48,600 |
| Begin accounts receivable | $ 47,000 | $ 50,720 | $ 64,480 |
| Begin accounts payable | $ 5,100 | $ - 0 | $ - 0 |
| Begin loan balance | $ 2,600 | $ 7,386 | $ - 0 |
| Begin cash | $ 12,900 | $ 12,600 | $ 19,220 |
| Cash flow from operating activities | |||
| Receipt of previous month account receivable | $ 47,000 | $ 50,720 | $ 64,480 |
| Cash receipt from sales | $ 12,680 | $ 16,120 | $ 9,720 |
| Direct materials | $ (12,480) | $ (9,900) | $ (10,140) |
| Direct labor | $ (10,400) | $ (8,250) | $ (8,450) |
| Factory overhead | $ (18,720) | $ (14,850) | $ (15,210) |
| Accounts payable payoff | $ (5,100) | $ - 0 | $ - 0 |
| Sales comissions | $ (6,340) | $ (8,060) | $ (4,860) |
| Office salaries | $ (4,600) | $ (4,600) | $ (4,600) |
| Rent | $ (7,100) | $ (7,100) | $ (7,100) |
| Cashflow from operating activities | $ (5,060) | $ 14,080 | $ 23,840 |
| Cash flow from financing activities | |||
| Interest paid | $ (26) | $ (74) | $ - 0 |
| Ending cash before loan adjustment | $ 7,814 | $ 26,606 | $ 43,060 |
| Loan cashflow | $ 4,786 | $ (7,386) | $ - 0 |
| Ending cash | $ 12,600 | $ 19,220 | $ 43,060 |
| Ending loan balance | $ 7,386 | $ - 0 | $ - 0 |
