The management of Zigby Manufacturing prepared the following estimated balance s
ID: 2602011 • Letter: T
Question
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 $ 40,000 342,248 98,500 325,540 806,288 600,000 150,000 450,000 $1,256,288 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 $ 200,500 12,000 212,500 500,000 712,500 335,000 208,788 543 788 $1,256,288 Total liabilities and equity To prepare a master budget for April, May, and June of 2017, management gathers the following information a. Sales for March total 20,500 units. Forecasted sales in units are as follows: April, 20,500; May, 19,500; June, 20,000; and July, 20,500. Sales of 240,000 units are forecasted for the entire year. The product's selling price is $23.85 per unit and its total product cost is $19.85 per unit. b. Company policy calls for a given month's ending raw materials inventory to equal 50% of the next month's materials requirements The March 31 raw materials inventory is 4,925 units, which complies with the policy. The expected June 30 ending raw materials inventory is 4,000 units. Raw materials cost $20 per unit. Each finished unit requires 0.50 units of raw materials Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's expected unit sales The March 31 finished goods inventory is 16,400 units, which complies with the policy. d. Each finished unit requires 0.50 hours of direct labor at a rate of $15 per hour e. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $20,000 per month is treated as fixed factory overheadExplanation / Answer
1 SALES BUDGET April May June A Unit sales 20500 19500 20000 B Sales price per unit $23.85 $23.85 $23.85 C=A*B Sales Revenue $488,925 $465,075 $477,000 2 PRODUCTION BUDGET April May June July A Sales in units 20500 19500 20000 20500 B Beginning finished goods inventory 16400 15600 16000 16400 C Ending finished goods inventory 15600 16000 16400 D=A+(C-B) Production during the month(units) 19700 19900 20400 E=D*19.85 Cost of production $ 391,045 $ 395,015 $ 404,940 3 RAW MATERIAL BUDGET April May June A Production in units 19700 19900 20400 B=0.5*A Raw materials required (units) 9850 9950 10200 C Beginning raw material inventory 4925 4975 5100 D Ending raw material inventory 4975 5100 4000 E=B+(D-C) Raw materials to be purchased(unit) 9900 10075 9100 F=E*20 Raw material purchase in dollars $ 198,000 $ 201,500 $ 182,000 4 DIRECT LABOR BUDGET April May June A Production in units 4975 5100 4000 B=0.5*A Direct labor hours required 2487.5 2550 2000 C=B*15 Direct labor cost $ 37,312.50 $ 38,250.00 $ 30,000.00 5 FACTORY OVERHEAD BUDGET April May June A Direct labor hours 2487.5 2550 2000 B=A*2.70 Variable Factory Overhead expenses $ 6,716.25 $ 6,885.00 $ 5,400.00 C Fixed Factory Overhead expenses $20,000 $20,000 $20,000 D=B+C Total Factory Overhead expenses $ 26,716.25 $ 26,885.00 $ 25,400.00 6 SELLING EXPENSE BUDGET April May June A Sales Revenue $488,925 $465,075 $477,000 B=0.08*A Sales Representatives'Commission $39,114 $37,206 $38,160 C Sales manager's salary $3,000 $3,000 $3,000 D=B+C Total Sales expenses $42,114 $40,206 $41,160 7 GENERAL AND ADMINISTRATIVE EXPENSE BUDGET April May June A Administrative Salaries $12,000 $12,000 $12,000 B=0.009*500000 Interest on long term notes payable $4,500 $4,500 $4,500 C=A+B Total General & Admin. expenses $16,500 $16,500 $16,500
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.