Ans-2- Zigby Manufacturing
Production Budget
April,May and June
April | May | June | |
Next month budgeted sales (units) | 15,300 | 20,400 | 23,000 |
Ratio of inventory and future sales | 80% | 80% | 80% |
Required Ending Inventory | 12,240 | 16,320 | 18,400 |
Current month sales | 23,000 | 15,300 | 20,400 |
Total units required | 35,240 | 31,620 | 38,800 |
Less: beginning inventory | -18,400 | -12,240 | -16,320 |
Units required to be produced | 16,840 | 19,380 | 22,480 |
Ans-3- Zigby Manufacturing
Raw material budget
April , May and June
April | May | June | |
Production budget (units) | 16,840 | 19,380 | 22,480 |
Materials needed for production (50% of production budget) | 8,420 | 9,690 | 11,240 |
Add: Desired ending inventory | 4,845 | 5,620 | 4,100 |
Total | 13,265 | 15,310 | 15,340 |
Less:Beginning balance | 4,210 | 4,845 | 5,620 |
Raw material required to purchased | 9,055 | 10,465 | 9,720 |
Material price per unit | $20 | $20 | $20 |
Total cost of direct materials purchase | $181,100 | $209,300 | $194,400 |
4-
Direct Labor Budget
April, May and June
April | May | June | Total | |
Budgeted production (units) | 16,840 | 19,380 | 22,480 | 58,700 |
Total labor hours needed | 8,420 | 9,690 | 11,240 | 29,350 |
labor rate per hour | $15 | $15 | $15 | $15 |
Labor dollars | $126,300 | $145,350 | $168,600 | $440,250 |
5-Factory Overhead Budget
April, May and June
April | May | June | Total | |
Labor hours needed | 8,420 | 9,690 | 11,240 | 29,350 |
Predetermined overhead rate | $2.80 | $2.80 | $2.80 | $2.80 |
Budgeted variable overhead | 23,576 | 27,132 | 31,472 | 82,180 |
Budgeted fixed overhead | 21,520 | 21,520 | 21,520 | 64,560 |
Budgeted total overhead | $45,096 | $48,652 | $52,992 | $146,740 |
6- Selling Expenses Budget
April, May and June
April | May | June | Total | |
Budgeted Sales |
$542,800 (23,000*$23.60) |
$361,080 (15,300*$23.60) |
$481,440 (20,400*$23.60) |
$1,385,320 |
Sales commission | 10% | 10% | 10% | |
Variable Sales commission Dollars | 54,280 | 36,108 | 48,144 | $138,532 |
Fixed Sales Expenses | 3,100 | 3,100 | 3,100 | $9,300 |
Total sales expenses | $57,380 | $39,208 | $51,244 | $147,832 |
7- General and administrative expenses budget
April, May and June
April | May | June | Total | |
Administrative Expenses | $13,000 | $13,000 | $13,000 | $39,000 |
Monthly interest ($505,000*0.5%) | $2,525 | $2,525 | $2,525 | $7,575 |
Total general and administrative expenses | $15,525 | $15,525 | $15,525 | $46,575 |
8- Calculation of cash receipts from customers
April, May and June
April | May | June | ||
Total budgeted sales | $542,800 | $361,080 | $481,440 | |
Cash Sales | 20% | $108,560 | $72,216 | $96,288 |
Sales on credit | 80% | $434,240 | $288,864 | $385,152 |
Total Cash receipts from customers
April | May | June | |
Current months cash sales | $108,560 | $72,216 | $96,288 |
Collection of receivables | $434,240 | $434,240 | $288,864 |
Total | $542,800 | $506,456 | $385,152 |
9- Calculations of cash payments for purchase of raw materials
April, May and June
April | May | June | |
Cash Payment to suppliers | $196,610 | $181,100 | $209,300 |
10- Cash Budget
April | May | June | |
Beginning cash balance | $41,000 | $142,889 | $208,510 |
Cash Receipts | 542,800 | 506,456 | 385,152 |
Total Cash Available | $583,800 | $649,345 | $593,662 |
Cash disbursements:- | |||
Payment towards purchase of raw materials | 196,610 | 181,100 | 209,300 |
Direct Labor | 126,300 | 145,350 | 168,600 |
Overhead | 45,096 | 48,652 | 52,992 |
Sales Expenses | 57,380 | 39,208 | 51,244 |
General and administrative expenses | 15,525 | 15,525 | 15,525 |
Dividends | 11,000 | ||
Equipment purchases | 131,000 | ||
Total Cash disbursements | $440,911 | $440,835 | $628,661 |
Ending cash balance | $142,889 | $208,510 | -$34,999 |
Borrowing | $75,999 | ||
Ending Cash Balance | $142,880 | $208,510 | $41,000 |
Income Statement
For three months ended June 30,2017
Sales | $1,385,320 | |
Less: Cost of goods sold | $1,174,000 | |
Gross Profit | $211,320 | |
Operating expenses: | ||
General and administrative expenses | 39,000 | |
Sales expenses:- | ||
Sales commission | 138,532 | |
Salaries to sales representatives | 9,300 | 186,832 |
Net income before interest and tax | 24,488 | |
Less: interest on short term notes payable | -760 | |
Monthly interest | -7,575 | |
Net income before tax | 16,153 | |
Income tax (40%of $16,153) | 6,461 | |
Net Income | $9,692 |
I just need requirement 10 The management of Zigby Manufacturing prepared the following estimated balance sheet...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets 43,000 432,900 86,198 387,168 949,266 606,000 (153, 000) 453,000 $1,402,266 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 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 2017: ZIGBY MANUFACTURING Estimated Balance Sheet ch 31, 2017 Assets Cash S 58,000 484,640 91,290 393,304 Accounts receivable Raw materials inventory Finished goods inventory Total current assets 1,027,234 636,000 (168,000) Equipment, gross Accumulated depreciation Equipment, net 468,000 Total assets $1,495,234 Liabilities and Equity Accounts payable 206,390 30.000 payable -term no ities 236,390 525,000 otal Lonq-term note payable Total liabilities 761,390 353,000 380,844 733,844 Common stock Retained earnings...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash Accounts receivable Raw materials inventory Finished goods inventory Total current assets Equipment, gross Accumulated depreciation Equipment, net Total assets 43,000 432,900 86,198 387,168 949,266 606,000 (153, 000) 453,000 $1,402,266 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 194,798 15,000 209,798 500,000...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 53,000 Accounts receivable 392,400 Raw materials inventory 96,600 Finished goods inventory 313,920 Total current assets 855,920 Equipment, gross 626,000 Accumulated depreciation (163,000 ) Equipment, net 463,000 Total assets $ 1,318,920 Liabilities and Equity Accounts payable $ 204,800 Short-term notes payable 25,000 Total current liabilities 229,800 Long-term note payable 520,000 Total liabilities 749,800 Common stock 348,000...
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...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017 ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Accounts receivable Ravw materials inventory Finished goods inventory Total cument assets 438.750 Accumulated depreciation 158,000 Total assets Liabilities and Equity Short-tem notes pay able Total current liabilities Long-tem note payable Total stockholders' equity Total liabilities and equity To prepare a master budget for April, May, and June of 2017, management gathers the following information: a. Sales for...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash $ 48,000 Accounts receivable 438,750 Raw materials inventory 87,900 Finished goods inventory 383,760 Total current assets 958,410 Equipment, gross 616,000 Accumulated depreciation (158,000 ) Equipment, net 458,000 Total assets $ 1,416,410 Liabilities and Equity Accounts payable $ 187,200 Short-term notes payable 20,000 Total current liabilities 207,200 Long-term note payable 508,000 Total liabilities 715,200 Common stock 343,000...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 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 $ 1,387,450 Liabilities and Equity Accounts payable $ 196,610 Short-term notes payable 12,000 Total current liabilities 208,610 Long-term note payable 505,000 Total liabilities 713,610 Common stock 336,000...
The management of Zigby Manufacturing prepared the following estimated balance sheet for March, 2015: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2015 Assets Cash $ 30,000 Accounts receivable 464,100 Raw materials inventory 98,505 Finished goods inventory 450,840 Total current assets 1,043,445 Equipment, gross 620,000 Accumulated depreciation (160,000) Equipment, net 460,000 Total assets $ 1,503,445 Liabilities and Equity ...