Note: As per HomeworkLib guidelines, I have answered first 4 parts of the question, including 1 extra. For remaining parts please post again. Thank you.
ANSWER:
Required 1) Sales Budget
Zigby Manufacturing
Sales Budget
April, May and June 2019
Budgeted Unit Sales | Budgeted Unit Price | Budgeted Sales Dollars | |
Apr 2019 | 19,500 | 30 | 585,000 |
May 2019 | 17,100 | 30 | 513,000 |
June 2019 | 21,300 | 30 | 639,000 |
Totals for the second quarter | 57,900 | 30 | 1,737,000 |
Required 2) Production Budget
Zigby Manufacturing
Production Budget
April, May and June 2019
April | May | June | |
Next month's budgeted sales (units) (A) | 17,100 | 21,300 | 19,500 |
Ratio of inventory to future sales (B) | 80% | 80% | 80% |
Desired ending inventory (C = A * B) | 13,680 | 17,040 | 15,600 |
Budgeted sales units (D) | 19,500 | 17,100 | 21,300 |
Required units of available production (E = C + D) | 33,180 | 34,140 | 36,900 |
Beginning inventory (F = D * 80%) | 15,600 | 13,680 | 17,040 |
Units to be produced (E - F) | 17,580 | 20,460 | 19,860 |
Required 3) Raw Materials Budget
Zigby Manufacturing
Raw Materials Budget
April, May and June 2019
April | May | June | |
Production Budget (units) (A) | 17,580 | 20,460 | 19,860 |
Raw material per unit (B) | 0.5 | 0.5 | 0.5 |
Materials needed for production (C = A * B) | 8,790 | 10,230 | 9,930 |
Desired ending raw material inventory (D) | 5,115 | 4,965 | 4,800 |
Total materials requirements (units) (E = C + D) | 13,905 | 15,195 | 14,730 |
Beginning raw material inventory (F) | 4,395 | 5,115 | 4,965 |
Materials to be purchased (G = E - F) | 9,510 | 10,080 | 9,765 |
Material price per unit (H) | $20 | $20 | $20 |
Budgeted raw material purchases (G * H) | 190,200 | 201,600 | 195,300 |
Required 4) Direct Labor Budget
Zigby Manufacturing
Direct Labor Budget
April, May and June 2019
April | May | June | Total | |
Budgeted production (units) (A) | 17,580 | 20,460 | 19,860 | 57,900 |
Direct labor hour per unit (B) | 0.5 | 0.5 | 0.5 | 0.5 |
Total labor hours needed (C = A * B) | 8,790 | 10,230 | 9,930 | 28,950 |
Direct labor rate per hour (D) | $23 | $23 | $23 | $23 |
Budgeted direct labor cost (C * D) | 202,170 | 235,290 | 228,390 | 665,850 |
Required 5) Factory Overhead Budget
Zigby Manufacturing
Factory Overhead Budget
April, May and June 2019
April | May | June | Total | |
Labor hours needed (A) | 8,790 | 10,230 | 9,930 | 28,950 |
Variable overhead rate per hour (B) | 3.40 | 3.40 | 3.40 | 3.40 |
Budgeted variable overhead (C = A * B) | 29,886 | 34,782 | 33,762 | 98,430 |
Budgeted fixed overhead (D) | 27,020 | 27,020 | 27,020 | 81,060 |
Budgeted total overhead (C + D) | 56,906 | 61,802 | 60,782 | 179,490 |
please help with all 10 required parts! Thank you! The management of Zigby Manufacturing prepared the...
please help with required 6-10. i have already completed 1-5 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity 65,000 437,760 90, 200 308, 028 900,988 630,000 (165,000) 465,000 $...
please help with required 8! The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 48,000 438,750 87,900 383, 760...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 44,000 500,000 90,200 444,000 1,078, 200 608,000 (154,000) 454,000 $1,532,200...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash 58,000 484,640 91,290 Accounts receivable Raw materials inventory Finished goods inventory 393,304 Total current assets 1,027,234 Equipment, gross Accumulated depreciation Equipment, net 636,000 168,000) 468,000 $1,495,234 Total assets Liabilities and Equity Accounts payable Short-term notes payable 206,390 30,000 Total current liabilities 236,390 Long-term note payable Total liabilities 525,000 761,390 Common stock 353,000 Retained earnings 380,844 Total...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets 43,ee0 432,900 Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets 86,198 387,168 949,266 606,000 (153,000) 453,000 Equipment Accumulated depreciation Equipment, net Total assets $1,402,266 Liabilities and Equity 194,798 15,000 Accounts payable Short-term notes payable 209,798 s00,e00 Total current liabilities Long-term note payable Total liabilities 709,798 Common stock 338, еее 354,468 692,468 Retained earnings...
Слеск The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 50,000 434,240 84,210 368,000 936,450 602,000 (151,000) 451,000 $1,387,450...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 42,000 Accounts receivable 364,000 Raw materials inventory 107,200 Finished goods inventory 349,440 Total current assets 862,640 Equipment 604,000 Accumulated depreciation (152,000 ) Equipment, net 452,000 Total assets $ 1,314,640 Liabilities and Equity Accounts payable $ 211,300 Short-term notes payable 14,000 Total current liabilities 225,300 Long-term note payable 510,000 Total liabilities 735,300 Common stock 337,000 Retained...
10 The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2019. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment Accumulated depreciation Equipment, net Total assets Liabilities and Equity Accounts payable Short-term notes payable Total current liabilities Long-term note payable Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 65,000 437, 760 90, 200 308,828 900,988 630, eee...
please organize exactly as seen, thank you The management of Zigby Manufacturing prepared the following estimated balance sheet for March, 2015: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2015 Assets Cash $ 50.000 Accounts receivable 434,240 Raw materials Inventory 84,210 Finished goods inventory 368,000 Total current assets 936,450 Equipment, gross 602.000 Accumulated depreciation (151,000) Equipment, net 451,000 Total assets $ 1387.450 Liabilities and Equity Accounts payable Short-term notes payable 196,610 12,000 Total current liabilities S 208.610 505,000 Long-term note payable...