The management of Zigby Manufacturing prepared the following balance sheet for March 31. Assets ZIGBY MANUFACTURING...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The management of Zigby Manufacturing prepared the following balance sheet for March 31. Assets ZIGBY MANUFACTURING Balance Sheet March 31 Liabilities and Equity $ 176,000 Liabilities Cash Accounts receivable Raw materials inventory Finished goods 1,515,360 Accounts payable 433,400 Loan payable Long-term note 1,432,376 inventory payable $ Equipment Equity 2,640,000 Less: Accumulated depreciation 660,000 1,980,000 Common stock Retained earnings $ 884,400 12,000 2,200,000 3,096,400 1,474,000 Total assets $ Total liabilities and 5,537,136 equity 966,736 2,440,736 To prepare a master budget for April, May, and June, management gathers the following information. 5,537,136 a. Sales for March total 90,200 units. Budgeted sales in units follow: April, 90,200; May, 85,800; June, 88,000; and July, 90,200. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company policy calls for a given month's ending materials inventory to equal 50% of the next month's direct materials requirements. The March 31 raw materials inventory is 21,670 pounds. The budgeted June 30 ending raw materials inventory is 17,600 pounds. Each finished unit requires 0.50 pound of direct materials. c. Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's budgeted unit sales. The March 31 finished goods inventory is 72,160 units. d. Each finished unit requires 0.50 hour of direct labor at a rate of $15 per hour. e. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $88,000 per month is the only fixed factory overhead item. f. Sales commissions of 8% of sales are paid in the month of the sales. The sales manager's monthly salary is $13,200. g. Monthly general and administrative expenses include $52,800 for administrative salaries and 0.9% monthly interest on the long-term note payable. h. The company budgets 30% of sales to be for cash and the remaining 70% on credit. Credit sales are collected in full in the month following the sale (no credit sales are collected in the month of sale). i. All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month (none are paid in the month of purchase). j. The minimum ending cash balance for all months is $176,000. If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of 1% at each month-end (before any repayment). If the month-end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans. k. Dividends of $44,000 are budgeted to be declared and paid in May. I. No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarter. m. Equipment purchases of $440,000 are budgeted for the last day of June. Required: 1. Sales budget. 2. Production budget. 3. Direct materials budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Selling expense budget. 7. General and administrative expense budget. 8. Schedule of cash receipts. 9. Schedule of cash payments for direct materials.. 10. Cash budget. 11. Budgeted income statement for entire second quarter (not monthly). 12. Budgeted balance sheet at June 30. The management of Zigby Manufacturing prepared the following balance sheet for March 31. Assets ZIGBY MANUFACTURING Balance Sheet March 31 Liabilities and Equity $ 176,000 Liabilities Cash Accounts receivable Raw materials inventory Finished goods 1,515,360 Accounts payable 433,400 Loan payable Long-term note 1,432,376 inventory payable $ Equipment Equity 2,640,000 Less: Accumulated depreciation 660,000 1,980,000 Common stock Retained earnings $ 884,400 12,000 2,200,000 3,096,400 1,474,000 Total assets $ Total liabilities and 5,537,136 equity 966,736 2,440,736 To prepare a master budget for April, May, and June, management gathers the following information. 5,537,136 a. Sales for March total 90,200 units. Budgeted sales in units follow: April, 90,200; May, 85,800; June, 88,000; and July, 90,200. The product's selling price is $24.00 per unit and its total product cost is $19.85 per unit. b. Raw materials inventory consists solely of direct materials that cost $20 per pound. Company policy calls for a given month's ending materials inventory to equal 50% of the next month's direct materials requirements. The March 31 raw materials inventory is 21,670 pounds. The budgeted June 30 ending raw materials inventory is 17,600 pounds. Each finished unit requires 0.50 pound of direct materials. c. Company policy calls for a given month's ending finished goods inventory to equal 80% of the next month's budgeted unit sales. The March 31 finished goods inventory is 72,160 units. d. Each finished unit requires 0.50 hour of direct labor at a rate of $15 per hour. e. The predetermined variable overhead rate is $2.70 per direct labor hour. Depreciation of $88,000 per month is the only fixed factory overhead item. f. Sales commissions of 8% of sales are paid in the month of the sales. The sales manager's monthly salary is $13,200. g. Monthly general and administrative expenses include $52,800 for administrative salaries and 0.9% monthly interest on the long-term note payable. h. The company budgets 30% of sales to be for cash and the remaining 70% on credit. Credit sales are collected in full in the month following the sale (no credit sales are collected in the month of sale). i. All raw materials purchases are on credit, and accounts payable are solely tied to raw materials purchases. Raw materials purchases are fully paid in the next month (none are paid in the month of purchase). j. The minimum ending cash balance for all months is $176,000. If necessary, the company borrows enough cash using a loan to reach the minimum. Loans require an interest payment of 1% at each month-end (before any repayment). If the month-end preliminary cash balance exceeds the minimum, the excess will be used to repay any loans. k. Dividends of $44,000 are budgeted to be declared and paid in May. I. No cash payments for income taxes are budgeted in the second calendar quarter. Income tax will be assessed at 35% in the quarter and budgeted to be paid in the third calendar quarter. m. Equipment purchases of $440,000 are budgeted for the last day of June. Required: 1. Sales budget. 2. Production budget. 3. Direct materials budget. 4. Direct labor budget. 5. Factory overhead budget. 6. Selling expense budget. 7. General and administrative expense budget. 8. Schedule of cash receipts. 9. Schedule of cash payments for direct materials.. 10. Cash budget. 11. Budgeted income statement for entire second quarter (not monthly). 12. Budgeted balance sheet at June 30.
Expert Answer:
Answer rating: 100% (QA)
Answer a Calculation of Weighted Average Cost of Capital WACC for Joncat plc To calculate the WACC we need to determine the cost of each source of capital and then weight them based on their respectiv... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Suppose that the following declarations are in effect: int a [] = {5, 15, 34, 54, 14, 2, 52, 72}; int *p = &a [1], *q = &a [5] ; (a) What is the value of * (p+3) ? (b) What is the value of * (q-3)?...
-
Nancy has active modified adjusted gross income before passive losses of $75,000. She has a loss of $5,000 on a rental property she actively manages. How much of the loss is she allowed to take...
-
The following information pertains to the physical inventory of Geo Furniture Company taken at December 31: Required: 1. Calculate the LCNRV for the: a. Inventory by major category b. Inventory,...
-
Calculate the electrical conductivity of a fiber-reinforced polyethylene part that is reinforced with 20 vol % of continuous, aligned nickel fibers.
-
Reliable Professionals Pty Ltd is a firm that offers a wide variety of professional services such as marketing, employment of professionals for other firms and accounting services. The firm has the...
-
Jacarda Company makes a composting bin that is subject to wide seasonal variations in demand. Unit product costs are computed on a quarterly basis by dividing each quarters manufacturing costs...
-
I would utilize the following steps below in simulation too switch from an B2C model to a B2B model: Locate potential B2B customers - Locate businesses that might be interested in purchasing goods or...
-
Answer the problem by formatting it the same. By filling out the highlighted yellow part please. The first image is the given data and the second image has to be filled out. A) LIQUIDITY Current...
-
Luzadis Company makes furniture using the latest automated technology. The company uses a job - order costing system and applies manufacturing overhead cost to products on the basis of machine -...
-
What organizational enablers and impediments shape the effectiveness and resilience of multifunctional teams, spanning factors such as leadership dynamics, resource allocation, performance...
-
A point charge q with charge q = 4 . 0 nC is at the point ~r 0 = ( 4 . 0 cm , 4 . 0 cm , 0 ) . Calculate the electric field at the point ~rP = ( 8 . 0 cm , 1 2 . 0 cm , 0 ) . A point charge q with...
-
Let S(0) 100, R = 0.05, U = 0.2, D = -0.2, and N = 3, and consider the payoff of following European butterfly spread: -30- -20- -10- 50 = 60 70 80 90 100 110 120 130 140 (a) You can construct this...
-
Evaluate the following 2 A [ (x 1) e + + x dr
-
Suppose that your boss has just given you an important, high priority assignment. The Fitbit Inc. Company core business product has shown steadily shrinking profitability and youve been asked to...
-
Compare and contrast debt financing and equity financing as ways of starting a new business. Does one have an overall advantage over the other? What situation is more favorable to the use of debt...
-
The following information relates to the operations of Emile Luxury Ltd. The profit was $2 750 000. The company distributed preference dividends of $50 000, and ordinary dividends of $300 000. Over...
-
Pedros Parts Ltds statement of financial position (extract only) on 30 June 2023 is set out below. Required (a) Calculate the current and quick ratios. (b) A loan agreement entered into by the...
-
You are provided with the following information from the statement of cash flows for Precedent Ltd. Required (a) Calculate the following cash sufficiency ratios for Precedent Ltd for 2025 and 2024:...
Study smarter with the SolutionInn App