Please find attached part 1, 2, 3
- sales budget
- production budget
- raw materials budget
*** NEEDED ASAP, thanks.
The management of Zigby Manufacturing prepared the following estimated balance sheet for March 2017: ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2017 Assets Cash 5 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 5 195,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 Retained earnings 337,840 Total stockholders' equity 673,840 Total liabilities and equity $1,387,450 To prepare a master budget for April, May, and June of 2017, management gathers the following information: a. Sales for March total 23,000 units. Fore-casted sales in units are as follows: April, 23,000; May, 15,300; June, 20,400; and July, 23,000. Sales of 241,000 units are forecasted for the entire year. The product's selling price is $23.60 per unit and its total product cost is $20.00 per unit. 1:. Company policy calls for a given month's ending raw materials inventory to equal 50% ofthe next month's materials requirements. The March 31 raw materials inventory is 4,210 units, which complies with the policy. The expected June 30 ending raw materials inventory is 4,100 units. Raw materials cost $20 per unit. Each nished unit requires 0.50 units of raw materials. c. Company policy calls for a given month's ending nished goods inventory to equal 80% of the next month's expected unit sales. The March 31 nished goods inventory is 18,400 units, which complies with the policy. 1 Required 1 Required 2 Required 3 Required 4 Required 5 Required 6 Sales budget. (Round Budgeted unit price to 2 decimal places.) -- - June 2017 --_ Totals for the second quarter _-_ | Required 1 H Required 2 E Required 3 || Required 4 H Required 5 || Required 6 || Required 7 H Requ Production budget. Next month's budgeted sales (units) m 20,400 m- Units to be produced | Required 1 H Required 2 E Required 3 E Required 4 H Required 5 H Required 6 || Required 7 H I Raw materials budget. (Round per unit values to 2 decimal places.) Production budget (units) Materials needed for production Total materials requirements {units} Materials to be purchased Material price per unit Budgeted raw material purchases